laragento
laragento copied to clipboard
Genaker
Laravel/Eloquent ORM for Magento that allows you to get data directly from a Magento 2 database tables bypassing slow and outdate core code.
SELECT `catalog_product_index_price`.`entity_id`, `catalog_product_index_price`.`customer_group_id`, `catalog_product_index_price`.`website_id`, `catalog_product_index_price`.`min_price` FROM `catalog_product_index_price` WHERE (entity_id IN ()) - > [] SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`sku` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_website` AS `website` ON website.product_id =...
SQL to select Gallery stuff for MAgento 2 SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`media_type`, `entity`.`row_id`, IFNULL(`value`.`label`, `default_value`.`label`) AS `label`, IFNULL(`value`.`position`, `default_value`.`position`) AS `position`, IFNULL(`value`.`disabled`, `default_value`.`disabled`) AS `disabled`, `default_value`.`label` AS `label_default`,...
SELECT `catalogrule_product_price`.`product_id`, `catalogrule_product_price`.`rule_price` FROM `catalogrule_product_price` WHERE (rule_date = '2021-10-12') AND (website_id = '1') AND (customer_group_id = 0) AND (product_id IN('25718')) Price Index SQL **catalog_product_index_price** ... SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`,...
SELECT `main_table`.*, `cp_table`.`type_id` FROM `cataloginventory_stock_item` AS `main_table` INNER JOIN `catalog_product_entity` AS `cp_table` ON main_table.product_id = cp_table.entity_id AND (cp_table.created_in '1630438980') WHERE (`main_table`.`product_id` IN('109340')) - > [] SELECT `main_table`.*, `cp_table`.`sku`, `cp_table`.`type_id` FROM...
SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id = 109340) - > [] SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE ((entity_id = :entity_id)) AND (catalog_category_entity.created_in '1630438980') - > [2] SQL time [0.00021600723266602] SELECT...
URL Rewrite: SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('cameradept/camera-equipment/l', 'cameradept/camera-equipment/')) AND (`store_id` IN ('1')) - > [] SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`request_path` IN ('cameradept/cameral', 'cameradept/camera-equipment//')) AND (`store_id` IN...
public function scopeEAVMonster($q, $ids){ $entity_id = 'row_id'; $ids = implode(',', $ids); $monster = with( ['catalog_product_entity_varchars' => function ($query){ $query->leftJoinRelationship('eav_attribute')->addSelect(['eav_attribute.attribute_code']) ->where('store_id', '=', $this->storeId); } ]); } public function scopeWithInt($query) { return...
SELECT p.entity_id, p.sku, ( SELECT COALESCE(v.value, gv.value) FROM catalog_product_entity_varchar AS v LEFT JOIN catalog_product_entity_varchar AS gv ON gv.entity_id = v.entity_id AND gv.attribute_id = 71 AND gv.store_id = 0 WHERE v.entity_id...