SELECT SQL_NO_CACHE DISTINCT cp.`id_product`
FROM `psod_category_product` cp
INNER JOIN `psod_category_group` cg ON cp.`id_category` = cg.`id_category`
INNER JOIN `psod_category` c ON cp.`id_category` = c.`id_category`
INNER JOIN `psod_product` p ON cp.`id_product` = p.`id_product`
LEFT JOIN psod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE c.`active` = 1
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "search")
AND product_shop.indexed = 1
AND cg.`id_group` IN (1)

SELECT SQL_NO_CACHE DISTINCT cp.`id_product`
FROM `psod_category_product` cp
INNER JOIN `psod_category_group` cg ON cp.`id_category` = cg.`id_category`
INNER JOIN `psod_category` c ON cp.`id_category` = c.`id_category`
INNER JOIN `psod_product` p ON cp.`id_product` = p.`id_product`
LEFT JOIN psod_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE c.`active` = 1
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "search")
AND product_shop.indexed = 1
AND cg.`id_group` IN (1)

SELECT SQL_NO_CACHE MIN(`price`) as min, MAX(`price`) as max FROM `psod_product` p
INNER JOIN `psod_product_lang` pl ON (p.`id_product` = pl.`id_product`) 
WHERE p.`active` = 1 AND p.`id_shop_default` = 1 AND 
pl.`id_lang` = 2

SELECT SQL_NO_CACHE MIN(`price`) as min, MAX(`price`) as max FROM `psod_product` p
INNER JOIN `psod_product_lang` pl ON (p.`id_product` = pl.`id_product`) 
WHERE p.`active` = 1 AND p.`id_shop_default` = 1 AND 
pl.`id_lang` = 2

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 `psod_configuration` c
LEFT JOIN `psod_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

SELECT SQL_NO_CACHE c.*, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description, tmp_table.cntr
from psod_category c
join psod_category_lang cl ON (cl.`id_category` = c.`id_category`)
left join (
select id_category, count(*) as cntr
from `psod_category_product`
group by id_category
LIMIT 0, 100
) tmp_table ON (tmp_table.`id_category` = c.`id_category`)
where
(`name` like "%search%" or
`description` like "%search%")
AND c.`active` = 1 AND cl.`id_lang` = 2
order by cntr desc
LIMIT 0, 100

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

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `psod_module` m
INNER JOIN psod_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 `psod_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `psod_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `psod_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `psod_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") 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 `id_newsletter_pro_subscribers` FROM `psod_newsletter_pro_subscribers` WHERE `email` = "" and `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_newsletter_pro_subscribers` FROM `psod_newsletter_pro_subscribers` WHERE `email` = "" and `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE cl.*, c.`active`, c.`id_cms_category`, c.`indexation`, c.`position` 
from psod_cms c
join psod_cms_lang cl ON (cl.`id_cms` = c.`id_cms`)
where
(`meta_title` like "%search%"
or `meta_description` like "%search%"
or `meta_keywords` like "%search%"
or `content` like "%search%")
and `active` = 1 AND cl.`id_lang` = 2
ORDER BY c.`id_cms` DESC
LIMIT 0, 100

SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`, ml.`meta_title`, ml.`meta_keywords`, ml.`meta_description`, tmp_table.`cntr`
from psod_manufacturer m
join psod_manufacturer_lang ml ON (ml.`id_manufacturer` = m.`id_manufacturer`)
left join (
select id_manufacturer, count(*) as cntr
from `psod_product`
group by id_manufacturer
LIMIT 0, 100
) tmp_table ON (tmp_table.`id_manufacturer` = m.`id_manufacturer`)
where
(`name` like "%search%"
or `description` like "%search%"
or `short_description` like "%search%"
or `meta_title` like "%search%")
and `active` = 1 AND ml.`id_lang` = 2
order by cntr desc
LIMIT 0, 100

SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`, ml.`meta_title`, ml.`meta_keywords`, ml.`meta_description`, tmp_table.`cntr`
from psod_manufacturer m
join psod_manufacturer_lang ml ON (ml.`id_manufacturer` = m.`id_manufacturer`)
left join (
select id_manufacturer, count(*) as cntr
from `psod_product`
group by id_manufacturer
LIMIT 0, 100
) tmp_table ON (tmp_table.`id_manufacturer` = m.`id_manufacturer`)
where
(`name` like "%search%"
or `description` like "%search%"
or `short_description` like "%search%"
or `meta_title` like "%search%")
and `active` = 1 AND ml.`id_lang` = 2
order by cntr desc
LIMIT 0, 100

INSERT INTO `psod_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('50754627', 'https://tumayorferretero.miami/search?controller=search&orderby=position&orderway=desc&search_query=listing/jabonera-modelo-redondo-en-acero-inoxidable/13191&p=3', 'tumayorferretero.net/search?controller=search&orderby=position&orderway=desc&search_query=search', '', '2024-05-07 18:52:58')

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

INSERT INTO `psod_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('82089191', '40', '59858397', 'https://tumayorferretero.miami/search?controller=search&orderby=position&orderway=desc&search_query=listing/jabonera-modelo-redondo-en-acero-inoxidable/13191&p=3', '1', '1', '2024-05-07 18:52:58')

INSERT INTO `psod_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')

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

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `psod_meta` m
LEFT JOIN `psod_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 m.`id_module`, m.`name`, (
SELECT id_module
FROM `psod_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `psod_module` m

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

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

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

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

SELECT SQL_NO_CACHE * FROM `psod_store` s
INNER JOIN psod_store_shop store_shop
ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1)
WHERE s.`active` = 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psod_lang` l
JOIN psod_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 DISTINCT si.id_product
FROM psod_search_word sw
LEFT JOIN psod_search_index si ON sw.id_word = si.id_word
WHERE sw.id_lang = 2
AND sw.id_shop = 1
AND sw.word LIKE
'search%'

SELECT SQL_NO_CACHE DISTINCT si.id_product
FROM psod_search_word sw
LEFT JOIN psod_search_index si ON sw.id_word = si.id_word
WHERE sw.id_lang = 2
AND sw.id_shop = 1
AND sw.word LIKE
'search%'

SELECT SQL_NO_CACHE * FROM psod_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/search?controller=search&orderby=position&orderway=desc&search_query=search" OR CONCAT("", url_old) LIKE BINARY "/search?controller=search&orderby=position&orderway=desc&search_query=search#%") AND id_shop = "1" ORDER BY id DESC 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 psod_shop_group gs
LEFT JOIN psod_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN psod_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

INSERT INTO psod_referrer_cache (id_referrer, id_connections_source) (
SELECT id_referrer, id_connections_source
FROM psod_referrer r
LEFT JOIN psod_connections_source cs ON ((r.http_referer_like IS NULL OR r.http_referer_like = '' OR cs.http_referer LIKE r.http_referer_like)
AND (r.request_uri_like IS NULL OR r.request_uri_like = '' OR cs.request_uri LIKE r.request_uri_like)
AND (r.http_referer_like_not IS NULL OR r.http_referer_like_not = '' OR cs.http_referer NOT LIKE r.http_referer_like_not)
AND (r.request_uri_like_not IS NULL OR r.request_uri_like_not = '' OR cs.request_uri NOT LIKE r.request_uri_like_not)
AND (r.http_referer_regexp IS NULL OR r.http_referer_regexp = '' OR cs.http_referer REGEXP r.http_referer_regexp)
AND (r.request_uri_regexp IS NULL OR r.request_uri_regexp = '' OR cs.request_uri REGEXP r.request_uri_regexp)
AND (r.http_referer_regexp_not IS NULL OR r.http_referer_regexp_not = '' OR cs.http_referer NOT REGEXP r.http_referer_regexp_not)
AND (r.request_uri_regexp_not IS NULL OR r.request_uri_regexp_not = '' OR cs.request_uri NOT REGEXP r.request_uri_regexp_not))
WHERE id_connections_source = 1555769
)

SELECT SQL_NO_CACHE id_tab, class_name FROM `psod_tab`

SELECT SQL_NO_CACHE * FROM psod_lgseoredirect WHERE (CONCAT("", url_old) LIKE BINARY "/search?controller=search&orderby=position&orderway=desc&search_query=search" OR CONCAT("", url_old) LIKE BINARY "/search?controller=search&orderby=position&orderway=desc&search_query=search#%") AND id_shop = "1" ORDER BY id DESC LIMIT 1

SELECT SQL_NO_CACHE * FROM `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayHeader" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE i.`id_newsletter_pro_list_of_interest`, il.`name`, iss.`id_shop`, iss.`active`, iss.`position` 
FROM `psod_newsletter_pro_list_of_interest` i
LEFT JOIN `psod_newsletter_pro_list_of_interest_lang` il 
ON (i.`id_newsletter_pro_list_of_interest` = il.`id_newsletter_pro_list_of_interest`)
LEFT JOIN `psod_newsletter_pro_list_of_interest_shop` iss
ON (i.`id_newsletter_pro_list_of_interest` = iss.`id_newsletter_pro_list_of_interest`
AND il.`id_shop` = iss.`id_shop`)
WHERE il.`id_lang` = 2
AND il.`id_shop` = 1  AND iss.`active` = 1   ORDER BY iss.`position`

SELECT SQL_NO_CACHE *
FROM `psod_module_currency`
WHERE `id_module` = 948
AND `id_shop` = 1

SELECT SQL_NO_CACHE `version` FROM `psod_module` WHERE `name` = "newsletterpro" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_custom_payment_method` a
LEFT JOIN `psod_custom_payment_method_lang` `b` ON a.`id_custom_payment_method` = b.`id_custom_payment_method` AND b.`id_lang` = 2
LEFT JOIN `psod_custom_payment_method_shop` `c` ON a.`id_custom_payment_method` = c.`id_custom_payment_method` AND c.`id_shop` = 1
WHERE (a.`id_custom_payment_method` = 1) LIMIT 1

SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `psod_currency` c
LEFT JOIN psod_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 IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM psod_theme t
LEFT JOIN psod_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN psod_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =22 AND m.page = "search" LIMIT 1

SELECT SQL_NO_CACHE tm.*, tml.`title`, tml.`badge`
FROM `psod_tmmegamenu` tm
LEFT JOIN `psod_tmmegamenu_lang` tml
ON (tm.`id_item` = tml.`id_item`)
WHERE tm.`id_shop` = 1
AND tml.`id_lang` = 2
AND tm.`active` = 1
ORDER BY tm.`sort_order`

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "pagecache" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_currency` c
INNER JOIN psod_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 `id_module` FROM `psod_module` WHERE `name` = "onepagecheckoutps" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_newsletter_pro_subscription_tpl` a
LEFT JOIN `psod_newsletter_pro_subscription_tpl_shop` `c` ON a.`id_newsletter_pro_subscription_tpl` = c.`id_newsletter_pro_subscription_tpl` AND c.`id_shop` = 1
WHERE (a.`id_newsletter_pro_subscription_tpl` = 7) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "bestkit_advancedsearch" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 143) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "customeraccount" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE *
FROM `psod_cms` a
LEFT JOIN `psod_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `psod_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 174) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_whatsappchatblock_agent` LEFT JOIN `psod_whatsappchatblock_agent_lang` ON (`psod_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `psod_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `active` = 1 ORDER BY position

SELECT SQL_NO_CACHE *
FROM `psod_country_lang`
WHERE `id_country` = 221

SELECT SQL_NO_CACHE *
FROM `psod_custom_payment_method` a
LEFT JOIN `psod_custom_payment_method_lang` `b` ON a.`id_custom_payment_method` = b.`id_custom_payment_method` AND b.`id_lang` = 2
LEFT JOIN `psod_custom_payment_method_shop` `c` ON a.`id_custom_payment_method` = c.`id_custom_payment_method` AND c.`id_shop` = 1
WHERE (a.`id_custom_payment_method` = 6) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 180) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 341) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `psod_image_type`

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 953 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_custom_payment_method` a
LEFT JOIN `psod_custom_payment_method_lang` `b` ON a.`id_custom_payment_method` = b.`id_custom_payment_method` AND b.`id_lang` = 2
LEFT JOIN `psod_custom_payment_method_shop` `c` ON a.`id_custom_payment_method` = c.`id_custom_payment_method` AND c.`id_shop` = 1
WHERE (a.`id_custom_payment_method` = 3) LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `psod_smarty_last_flush` WHERE type='compile' LIMIT 1

SELECT SQL_NO_CACHE * FROM psod_lgseoredirect WHERE url_old = "/search?controller=search&orderby=position&orderway=desc&search_query=search" AND id_shop = "1" ORDER BY id DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_custom_payment_method` a
LEFT JOIN `psod_custom_payment_method_lang` `b` ON a.`id_custom_payment_method` = b.`id_custom_payment_method` AND b.`id_lang` = 2
LEFT JOIN `psod_custom_payment_method_shop` `c` ON a.`id_custom_payment_method` = c.`id_custom_payment_method` AND c.`id_shop` = 1
WHERE (a.`id_custom_payment_method` = 2) LIMIT 1

SELECT SQL_NO_CACHE *
FROM psod_meta m
LEFT JOIN psod_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "search"
OR m.page = "search"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `name`
FROM `psod_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 221 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 224) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE t.id_template, t.template_filters AS filters, t.additional_settings, tl.data AS lang
FROM psod_af_templates t
LEFT JOIN psod_af_templates_lang tl
ON tl.id_template = t.id_template AND tl.id_shop = t.id_shop AND tl.id_lang = 2
WHERE t.active = 1 AND t.template_controller = 'search'
AND t.id_shop = 1
ORDER BY  t.id_template DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_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 `id_guest`
FROM `psod_connections`
WHERE `id_guest` = 82089191
AND `date_add` > '2024-05-07 18:22:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_newsletter_pro_subscription_tpl_lang`
WHERE `id_newsletter_pro_subscription_tpl` = 7 AND `id_shop` = 1

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

SELECT SQL_NO_CACHE * FROM `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE s.`id_newsletter_pro_subscription_tpl`
FROM `psod_newsletter_pro_subscription_tpl` s
LEFT JOIN `psod_newsletter_pro_subscription_tpl_shop` ss
ON (s.`id_newsletter_pro_subscription_tpl` = ss.`id_newsletter_pro_subscription_tpl`)
WHERE ss.`active` = 1
AND ss.`id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_group` a
LEFT JOIN `psod_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE id_page_type
FROM psod_page_type
WHERE name = 'search' LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 181) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE * FROM `psod_hook_alias`

SELECT SQL_NO_CACHE *
FROM `psod_custom_payment_method` a
LEFT JOIN `psod_custom_payment_method_lang` `b` ON a.`id_custom_payment_method` = b.`id_custom_payment_method` AND b.`id_lang` = 2
LEFT JOIN `psod_custom_payment_method_shop` `c` ON a.`id_custom_payment_method` = c.`id_custom_payment_method` AND c.`id_shop` = 1
WHERE (a.`id_custom_payment_method` = 5) LIMIT 1

SELECT SQL_NO_CACHE * FROM `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE `server`, `getvar` FROM `psod_search_engine`

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 179) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE i.`id_newsletter_pro_list_of_interest`, il.`name`, iss.`id_shop`, iss.`active`, iss.`position` 
FROM `psod_newsletter_pro_list_of_interest` i
LEFT JOIN `psod_newsletter_pro_list_of_interest_lang` il 
ON (i.`id_newsletter_pro_list_of_interest` = il.`id_newsletter_pro_list_of_interest`)
LEFT JOIN `psod_newsletter_pro_list_of_interest_shop` iss
ON (i.`id_newsletter_pro_list_of_interest` = iss.`id_newsletter_pro_list_of_interest`
AND il.`id_shop` = iss.`id_shop`)
WHERE il.`id_lang` = 2
AND il.`id_shop` = 1  AND iss.`active` = 1   ORDER BY iss.`position`

SELECT SQL_NO_CACHE *
FROM `psod_tmhtmlcontent`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'top' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `width`, `height`
FROM psod_image_type
WHERE `name` = 'home_default' LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `psod_smarty_lazy_cache`
WHERE `template_hash`='fb67375680fd9f9247e4b7aefd12957a' AND cache_id="blockcategories|1|1|1|1|221|2|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_module_currency`
WHERE `id_module` = 948
AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "lgcanonicalurls" LIMIT 1

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM psod_shop s
LEFT JOIN psod_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN psod_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 `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "topWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "supertinymcepro" LIMIT 1

SELECT SQL_NO_CACHE * FROM `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE * FROM `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayFooter" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE *
FROM `psod_angarbanners`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'left' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "advancedeucompliance" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `psod_smarty_lazy_cache`
WHERE `template_hash`='bbcfd9f1ac0ba88540bd2e8a105e3cfc' AND cache_id="blockcms|2|1|1|1|1|221" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_preloader` a
WHERE (a.`id_preloader` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_gender` a0
LEFT JOIN `psod_gender_lang` `a1` ON (a0.`id_gender` = a1.`id_gender`)
WHERE (a1.`id_lang` = 2)

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` 
WHERE `name` = "custompaymentmethod_6" LIMIT 1

SELECT SQL_NO_CACHE * FROM `psod_whatsappchatblock` LEFT JOIN `psod_whatsappchatblock_lang` ON (`psod_whatsappchatblock`.`id_whatsappchatblock` = `psod_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "ets_onepagecheckout" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_country` a
LEFT JOIN `psod_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 221) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_tmhtmlcontent`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` 
WHERE `name` = "custompaymentmethod_1" LIMIT 1

SELECT SQL_NO_CACHE `iso_code`
FROM `psod_country`
WHERE `id_country` = 221 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `psod_smarty_lazy_cache`
WHERE `template_hash`='2c30077beed542fa1ac9713149020126' AND cache_id="blockcategories|1|1|1|1|221|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_whatsappchatblock_agent` LEFT JOIN `psod_whatsappchatblock_agent_lang` ON (`psod_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `psod_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `psod_whatsappchatblock_agent`.`id_whatsappchatblock` = 7 AND `active` = 1 ORDER BY position

SELECT SQL_NO_CACHE *
FROM `psod_module_currency`
WHERE `id_module` = 948
AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `psod_group_lang`
WHERE `id_group` = 1

SELECT SQL_NO_CACHE *
FROM `psod_category` a
LEFT JOIN `psod_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psod_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 724) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `id_page`
FROM `psod_page`
WHERE `id_page_type` = 13 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "superuser" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_gender` a0
LEFT JOIN `psod_gender_lang` `a1` ON (a0.`id_gender` = a1.`id_gender`)
WHERE (a1.`id_lang` = 2)

SELECT SQL_NO_CACHE *
FROM `psod_currency` a
LEFT JOIN `psod_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 `psod_module_currency`
WHERE `id_module` = 948
AND `id_shop` = 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "pagesnotfound" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 1124 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_module_currency`
WHERE `id_module` = 948
AND `id_shop` = 1

SELECT SQL_NO_CACHE i.id_product AS id, g,
c
FROM `psod_af_index` i
WHERE (i.id_shop = 1) AND (i.v <> 1) AND (i.id_product IN (0))

SELECT SQL_NO_CACHE `id_zone`
FROM `psod_country`
WHERE `id_country` = 221 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "shaim_gdpr" LIMIT 1

SELECT SQL_NO_CACHE `variable_name`
FROM `psod_newsletter_pro_subscribers_custom_field`

SELECT SQL_NO_CACHE *
FROM `psod_tmhtmlcontent`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'left' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM psod_theme t
LEFT JOIN psod_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN psod_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =22 AND m.page = "search" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_tmsocialfeed`
WHERE id_shop = 1 AND hook = "footer" AND active = 1 ORDER BY item_order ASC

SELECT SQL_NO_CACHE *
FROM `psod_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE *
FROM `psod_country` a
LEFT JOIN `psod_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `psod_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 221) LIMIT 1

SELECT SQL_NO_CACHE id_employee_post FROM `psod_ybc_blog_employee` WHERE id_employee=0 AND is_customer=1 AND status>0 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_state` a
WHERE (a.`id_state` = 313) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'left' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE *
FROM psod_tmmegamenu
WHERE `id_shop` =1
AND `id_item` = 3
AND `is_simple` = 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "steasycheckout" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "lgseoredirect" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "smartseourl" LIMIT 1

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

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 969 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE domain, domain_ssl
FROM psod_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `psod_smarty_lazy_cache`
WHERE `template_hash`='b350884ff70e81dc15e67717e376e933' AND cache_id="blocksocial|1|1|1|1|221" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `psod_lang` l
LEFT JOIN `psod_lang_shop` ls ON (l.id_lang = ls.id_lang)

SELECT SQL_NO_CACHE id_shop
FROM `psod_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_custom_payment_method` a
LEFT JOIN `psod_custom_payment_method_lang` `b` ON a.`id_custom_payment_method` = b.`id_custom_payment_method` AND b.`id_lang` = 2
LEFT JOIN `psod_custom_payment_method_shop` `c` ON a.`id_custom_payment_method` = c.`id_custom_payment_method` AND c.`id_shop` = 1
WHERE (a.`id_custom_payment_method` = 4) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_module_currency`
WHERE `id_module` = 948
AND `id_shop` = 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 1255 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "roja45quotationspro" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "autolanguagecurrency" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "elasticjetsearch" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` 
WHERE `name` = "custompaymentmethod_2" LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `psod_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` 
WHERE `name` = "custompaymentmethod_3" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` 
WHERE `name` = "custompaymentmethod_5" LIMIT 1

SELECT SQL_NO_CACHE *
FROM psod_tmmegamenu
WHERE `id_shop` =1
AND `id_item` = 4
AND `is_simple` = 1

SELECT SQL_NO_CACHE `variable_name`
FROM `psod_newsletter_pro_subscribers_custom_field`

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 702 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 721 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_module_currency`
WHERE `id_module` = 948
AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `psod_tmhtmlcontent`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'displayNav' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE a.id_alias, a.search, a.alias
FROM `psod_alias` a
WHERE `alias` = 'search' AND `active` = 1 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `psod_smarty_lazy_cache`
WHERE `template_hash`='1605338c07cf53cabf0bb3724be8dd9f' AND cache_id="tmproductlistgallery|1|1|1|1|221|0" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `psod_smarty_lazy_cache`
WHERE `template_hash`='b9e62aa80b9047f6397a6375af726b85' AND cache_id="tmproductlistgallery|1|1|1|1|221|0" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM psod_tmmegamenu
WHERE `id_shop` =1
AND `id_item` = 1
AND `is_simple` = 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "groupinc" LIMIT 1

SELECT SQL_NO_CACHE *
FROM psod_tmmegamenu
WHERE `id_shop` =1
AND `id_item` = 2
AND `is_simple` = 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `psod_smarty_last_flush` WHERE type='template' LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_lang` a
LEFT JOIN `psod_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 1000 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM psod_tmmegamenu
WHERE `id_shop` =1
AND `id_item` = 5
AND `is_simple` = 1

SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM psod_required_field

SELECT SQL_NO_CACHE id_employee_post FROM `psod_ybc_blog_employee` WHERE id_employee=0 AND is_customer=1 LIMIT 1

SELECT SQL_NO_CACHE `variable_name`
FROM `psod_newsletter_pro_subscribers_custom_field`

SELECT SQL_NO_CACHE * FROM psod_af_settings
WHERE id_shop = 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "af_seopages" LIMIT 1

SELECT SQL_NO_CACHE a.id_alias, a.search, a.alias
FROM `psod_alias` a
WHERE `alias` = 'search' AND `active` = 1 LIMIT 1

SELECT SQL_NO_CACHE `variable_name`
FROM `psod_newsletter_pro_subscribers_custom_field`

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "pkamp" LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `psod_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` WHERE `name` = "configb2b" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module` 
WHERE `name` = "custompaymentmethod_4" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `psod_theme` a
WHERE (a.`id_theme` = 22) LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `psod_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1