Récapitulatif de la commande

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `lafrips_configuration` c
LEFT JOIN `lafrips_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
WHERE c.`name` NOT IN(
"AVG_MSG_RESPONSE_TIME",
"AVG_MSG_RESPONSE_TIME_EXPIRE",
"PENDING_MESSAGES_EXPIRE",
"8020_SALES_CATALOG",
"8020_SALES_CATALOG_EXPIRE",
"SALES_CATALOG", 
"SALES_CATALOG_EXPIRE", 
"ABANDONED_CARTS_EXPIRE", 
"AVG_CUSTOMER_AGE_EXPIRE", 
"AVG_ORDER_VALUE_EXPIRE", 
"CONVERSION_RATE_EXPIRE", 
"CUSTOMER_MAIN_GENDER_EXPIRE", 
"DISABLED_CATEGORIES_EXPIRE", 
"DISABLED_MODULES_EXPIRE", 
"DISABLED_PRODUCTS_EXPIRE", 
"EMPTY_CATEGORIES_EXPIRE", 
"NETPROFIT_VISIT_EXPIRE", 
"NEWSLETTER_REGISTRATIONS_EXPIRE", 
"ORDERS_PER_CUSTOMER_EXPIRE", 
"PERCENT_PRODUCT_OUT_OF_STOCK_EXPIRE", 
"PRODUCT_AVG_GROSS_MARGIN_EXPIRE", 
"PRODUCTS_PER_CATEGORY_EXPIRE", 
"TOP_CATEGORY_EXPIRE", 
"UPDATE_MODULES_EXPIRE", 
"ENABLED_LANGUAGES_EXPIRE", 
"FRONTOFFICE_TRANSLATIONS_EXPIRE", 
"INSTALLED_MODULES_EXPIRE", 
"MAIN_COUNTRY_EXPIRE", 
"ABANDONED_CARTS", 
"AVG_CUSTOMER_AGE", 
"AVG_ORDER_VALUE", 
"CONVERSION_RATE", 
"CUSTOMER_MAIN_GENDER", 
"DISABLED_CATEGORIES", 
"DISABLED_MODULES", 
"DISABLED_PRODUCTS", 
"EMPTY_CATEGORIES", 
"NETPROFIT_VISIT", 
"NEWSLETTER_REGISTRATIONS", 
"ORDERS_PER_CUSTOMER", 
"PERCENT_PRODUCT_OUT_OF_STOCK", 
"PRODUCT_AVG_GROSS_MARGIN", 
"PRODUCTS_PER_CATEGORY", 
"TOP_CATEGORY", 
"UPDATE_MODULES", 
"ENABLED_LANGUAGES", 
"FRONTOFFICE_TRANSLATIONS", 
"INSTALLED_MODULES", 
"MAIN_COUNTRY")

INSERT INTO `lafrips_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')

INSERT INTO `lafrips_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('53410052', '586', '2890205173', '', '1', '1', '2025-10-09 18:20:46')

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 4 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 16 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 5 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 6 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE * FROM `lafrips_state` ORDER BY `name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 130 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `lafrips_hook_module` hm
STRAIGHT_JOIN `lafrips_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `lafrips_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 7 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 58 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `lafrips_module` m
INNER JOIN lafrips_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `lafrips_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `lafrips_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `lafrips_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `lafrips_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 48 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 42 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2623 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 18 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2232 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `lafrips_country` c  INNER JOIN lafrips_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `lafrips_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 12)
LEFT JOIN `lafrips_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 37 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 87 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2278 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 140 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 22 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 90 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2786 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 2
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2310 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 319 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2156 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 1
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2800) LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 62 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 85) LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 64 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 1
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 1
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 2
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2569 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 4
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 4
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `lafrips_meta` m
LEFT JOIN `lafrips_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2565 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 2
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2807) LIMIT 1

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_cookie cc LEFT JOIN lafrips_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie`
WHERE
`id_cookiesplus_finality` = 4
AND ccl.`id_lang` = 12 AND cc.`active` = 1
ORDER BY cc.`name`;

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2624 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 63 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 61 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 40 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2625 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

UPDATE `lafrips_cart_product`
SET `id_address_delivery` = (
SELECT `id_address_delivery` FROM `lafrips_cart`
WHERE `id_cart` = 0 AND `id_shop` = 1
)
WHERE `id_cart` = 0

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 239 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2309 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2183 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2556 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM lafrips_iqitmegamenu_tabs_shop hs
LEFT JOIN lafrips_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN lafrips_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 12
ORDER BY hss.position

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2846 AND `id_shop` = 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 241 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2241) LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 242 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2255 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2622 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 8) LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2343 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE DISTINCT g.id_tax_rules_group, g.name, g.active
FROM `lafrips_tax_rules_group` g INNER JOIN lafrips_tax_rules_group_shop tax_rules_group_shop
ON (tax_rules_group_shop.id_tax_rules_group = g.id_tax_rules_group AND tax_rules_group_shop.id_shop = 1) WHERE deleted = 0 AND g.`active` = 1
ORDER BY name ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 202 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2884) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `lafrips_module` WHERE `name` = "bvkseodispatcher" LIMIT 1

UPDATE `lafrips_customization`
SET `id_address_delivery` = (
SELECT `id_address_delivery` FROM `lafrips_cart`
WHERE `id_cart` = 0
)
WHERE `id_cart` = 0

SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `lafrips_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `lafrips_hook_alias` ha
INNER JOIN `lafrips_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2753) LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2539 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 2567 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2320 AND `id_shop` = 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `lafrips_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `lafrips_module` m

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `lafrips_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `lafrips_module` m

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `lafrips_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `lafrips_module` m

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `lafrips_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `lafrips_module` m

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `lafrips_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `lafrips_module` m

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `lafrips_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `lafrips_module` m

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2544 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2799) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 79 AND `id_shop` = 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `lafrips_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `lafrips_module` m

SELECT SQL_NO_CACHE `width`, `height`
FROM lafrips_image_type
WHERE `name` = 'medium_default' LIMIT 1

SELECT SQL_NO_CACHE id FROM lafrips_gap_refund WHERE sent = "0" AND shop_id = 1

SELECT SQL_NO_CACHE *
FROM lafrips_cookiesplus_finality cf LEFT JOIN lafrips_cookiesplus_finality_lang cfl on cf.`id_cookiesplus_finality` = cfl.`id_cookiesplus_finality`
WHERE
cfl.`id_lang` = 12 AND cf.`active` = 1 AND cf.`id_shop` = 1
ORDER BY `position`;

SELECT SQL_NO_CACHE cc.iso_code from `lafrips_module_country` c 
LEFT JOIN  `lafrips_module` m on m.id_module=c.id_module
LEFT JOIN  `lafrips_country` cc on c.id_country=cc.id_country
WHERE m.name="sequracheckout" and c.id_shop=1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2653 AND `id_shop` = 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `lafrips_category` c
INNER JOIN lafrips_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `lafrips_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `lafrips_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `lafrips_category` c2 ON c2.`id_category` = 70 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 12
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2234 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2200 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2807 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2786 AND `id_shop` = 1

SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM lafrips_theme t
LEFT JOIN lafrips_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN lafrips_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "order" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 140 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2149) LIMIT 1

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 1 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "11"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2622 AND `id_shop` = 1

SELECT SQL_NO_CACHE pc.`id_carrier`, cc.`code`
FROM `lafrips_carrier` pc
INNER JOIN `lafrips_correos_carrier` cc ON pc.`id_reference` = cc.`id_reference`
WHERE pc.`active` = 1 AND pc.`deleted` = 0 AND pc.`id_reference` != 0

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 12 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "11"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM lafrips_cms c
LEFT JOIN lafrips_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 12)
INNER JOIN lafrips_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (51) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`

SELECT SQL_NO_CACHE tr.*
FROM `lafrips_tax_rule` tr
JOIN `lafrips_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 72
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 12
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 144) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM lafrips_shop_group gs
LEFT JOIN lafrips_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN lafrips_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 12 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "2"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE *
FROM `lafrips_currency` c
INNER JOIN lafrips_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 12
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2759 AND `id_shop` = 1

SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM lafrips_cms c
LEFT JOIN lafrips_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 12)
INNER JOIN lafrips_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (31) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`

SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM lafrips_cms c
LEFT JOIN lafrips_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 12)
INNER JOIN lafrips_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (36) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 63) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_currency` c
INNER JOIN lafrips_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC

SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM lafrips_shop_url su
LEFT JOIN lafrips_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'lafrikileria.com' OR su.domain_ssl = 'lafrikileria.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

SELECT SQL_NO_CACHE tr.*
FROM `lafrips_tax_rule` tr
JOIN `lafrips_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 79
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE tr.*
FROM `lafrips_tax_rule` tr
JOIN `lafrips_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 54
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE value FROM `lafrips_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 12 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "2"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 12 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "4"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 55 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2496 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2255) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2310 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1

SELECT SQL_NO_CACHE `id_guest`
FROM `lafrips_connections`
WHERE `id_guest` = 53410052
AND `date_add` > '2025-10-09 17:50:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 63 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2724) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2387 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 12
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 48 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2240) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 90) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 65) LIMIT 1

SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search`
FROM `lafrips_pm_advancedsearch` ads
JOIN `lafrips_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1)  WHERE 1  AND ads.`active`=1  ORDER BY ads.`position`

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2750) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 4 AND `id_shop` = 1

SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM lafrips_cms c
LEFT JOIN lafrips_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 12)
INNER JOIN lafrips_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (47) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2948) LIMIT 1

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 12 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "3"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2724 AND `id_shop` = 1

SELECT SQL_NO_CACHE cc.iso_code from `lafrips_module_country` c 
LEFT JOIN  `lafrips_module` m on m.id_module=c.id_module
LEFT JOIN  `lafrips_country` cc on c.id_country=cc.id_country
WHERE m.name="sequracheckout" and c.id_shop=1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 42 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2804 AND `id_shop` = 1

SELECT SQL_NO_CACHE * FROM `lafrips_image_type`

SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `lafrips_currency` c
LEFT JOIN lafrips_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2241 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 110 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 48) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 130) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2156 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 5) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 202) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2921) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2623) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2624 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 6) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_currency` a
LEFT JOIN `lafrips_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 85 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2624) LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `lafrips_lang` l
JOIN lafrips_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2320) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2331 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 130 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 299 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 65 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 244) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 12 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "5"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 66 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2232) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2156) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 18 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2432 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 87 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2884 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 58 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 235 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 238 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 90 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2310) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2881 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 314 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2906 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 284 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 64 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 12
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 130) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 216 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2623 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 248 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 319 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 231 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 302 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2944 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2940 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2377 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2240 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2585 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 234 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 299) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2867 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 231) LIMIT 1

SELECT SQL_NO_CACHE `id_page`
FROM `lafrips_page`
WHERE `id_page_type` = 5 AND `id_object` = 0 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 7 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2819 AND `id_shop` = 1

SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM lafrips_iqitmenulinks l
LEFT JOIN lafrips_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 12 AND ll.id_shop=1)
LEFT JOIN lafrips_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "2"
AND l.id_shop IN (0, 1)

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2786) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2599 AND `id_shop` = 1

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM lafrips_shop s
LEFT JOIN lafrips_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN lafrips_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2812 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 237 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 58) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 44 AND `id_shop` = 1

SELECT SQL_NO_CACHE * FROM `lafrips_hook_module_exceptions`
WHERE `id_shop` IN (1)

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2868 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `lafrips_module` WHERE `name` = "pm_advancedpack" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2589 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2232 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 42) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2180 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2257 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 37 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2753 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2939 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 49 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 140) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2783 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 247 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2234) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2800 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2149 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 87) LIMIT 1

SELECT SQL_NO_CACHE *
FROM lafrips_meta m
LEFT JOIN lafrips_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "order"
OR m.page = "order"
)
AND ml.id_lang = 12
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 244 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2750 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 12
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2808) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2261 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 37) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 112 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2805 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 2883 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category` a
LEFT JOIN `lafrips_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2805) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `lafrips_category_lang`
WHERE `id_category` = 61 AND `id_shop` = 1