• Rupture de stock
DJ Ronsha & DJ Kefran ‎– Golgoth Tape - MUSIC AVENUE PARIS
search
  • DJ Ronsha & DJ Kefran ‎– Golgoth Tape - MUSIC AVENUE PARIS
  • DJ Ronsha & DJ Kefran ‎– Golgoth Tape - MUSIC AVENUE PARIS

DJ Ronsha & DJ Kefran ‎– Golgoth Tape

20,00 €
TTC

DJ Ronsha & DJ Kefran ‎– Golgoth Tape

Label:
La Meute ‎– none
Format:
Cassette, Mixed
Country:
France
Sortie:
1999
Genre:
Hip Hop
Quantité
Rupture de stock

Tracklist

Position Artists Title/Credits Duration
Astero Face
A1 No Artist Intro : DJ Des Temps Nouveaux
A2 Maudits Du Système Freestyle
A3 Constant Deviants Hustler's Prayer
A4 Polyrhythm Addicts Motion 2000
Featuring – Apani B.Fly Emcee*, Mr. Complex, Shabaam Sahdeeq
A5 Superrappin L Futge ... Dimmin The Life
A6 Big L / Mc Gruff* / I-Born / C.L. Smooth My Freestyle
A7 TMKamikaz* Freestyle
A8 Xperadó Watch Ya Step
Featuring – O.C.
A9 Superrappin Feat / & : No Body
Featuring – F.T., Mike Zoot, Shabaam Sahdeeq
A10 Flip Mode* Settin' It Off
A11 Truth Enola May Day
A12 Styles Of Beyond Part 2
Featuring – Simon James (11)
A13 Dontcha Plus D'Cash
A14 A+ : Watcha Weigh Me
A15 Chris Lowe (2) Never Heard It Like This
A16 Koma (3) La Peur Du Lendemain
A17 DJ Greg (6), DJ Ronsha & DJ Kefran Association De DJ
Fulguro Face
B1 No Artist Intro J'arrive De Nulle Part
B2 Common One Nine Nine Nine
Featuring – Sadat X
B3 The Originators (3) Platinium Plus
Featuring – Big L
B4 Scientifik / God Wize / L Da Headtoucha / K-Slaughta Hold The Key
B5 Defari Checkstand 3
B6 El Pato (4) Freestyle
B7 Choclair Fragant
B8 No Artist Interlude Big L : Rest In Peace
B9 Gang Starr Full Cup
B10 La Meute - Ted Lingot, Ronsha La Pierre Précieuse*, Gzon Le Joyaux* Freestyle
B11 Roey Marquis II & Kabuki / Tariq*, Probz* What ?
B12 Freddie Foxxx Devious Minds
B13 Lifka Freestyle
B14 Rahzel All I Know
B15 Mountain Brothers Dig It
B16 DJ K (9) & DJ Azy-A Freestyle Scratch
MAP00005
Commentaires (0)
Aucun avis n'a été publié pour le moment.
Load Time 702.178 ms
Querying Time 271 ms
Queries 217
Memory Peak Usage 13.6 Mb
Included Files 1263 files - 13.37 Mb
PrestaShop Cache - Mb
Global vars 0.48 Mb
PrestaShop Version 8.1.7
PHP Version 8.1.29
MySQL Version 8.0.40-31
Memory Limit 512M
Max Execution Time 165s
Smarty Cache disabled
Smarty Compilation force compile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 44.732 ms 44.732 ms 2.26 Mb 2.9 Mb
__construct 0.044 ms 44.776 ms - Mb 2.9 Mb
init 185.303 ms 230.079 ms 1.48 Mb 4.0 Mb
checkAccess 0.001 ms 230.080 ms - Mb 4.0 Mb
setMedia 2.327 ms 232.407 ms 0.02 Mb 4.0 Mb
postProcess 0.004 ms 232.411 ms - Mb 4.0 Mb
initHeader 0.000 ms 232.411 ms - Mb 4.0 Mb
initContent 158.787 ms 391.198 ms 1.53 Mb 5.5 Mb
initFooter 0.002 ms 391.200 ms - Mb 5.5 Mb
display 310.978 ms 702.178 ms 4.97 Mb 13.6 Mb
Hook Time Memory Usage
displayFooter 48.127 ms 0.86 Mb
displayTop 40.706 ms 1.49 Mb
DisplayFooterProduct 38.199 ms 0.33 Mb
FilterProductContent 33.892 ms 0.28 Mb
DisplayBeforeBodyClosingTag 23.700 ms 0.19 Mb
Header 11.269 ms 0.13 Mb
displayProductAdditionalInfo 10.186 ms 0.17 Mb
DisplayHeader 10.031 ms 0.04 Mb
displayNav2 7.560 ms 0.10 Mb
displayFooterProduct 5.280 ms 0.15 Mb
displayNav1 5.159 ms 0.08 Mb
displayFooterAfter 3.878 ms 0.03 Mb
DisplayGDPRConsent 3.698 ms 0.03 Mb
DisplayFooter 3.042 ms 0.01 Mb
DisplayAfterTitleTag 2.561 ms 0.01 Mb
DisplayProductActions 1.917 ms 0.03 Mb
ActionDispatcherBefore 1.814 ms 0.01 Mb
DisplayAfterProductThumbs 1.004 ms 0.05 Mb
ActionFrontControllerSetMedia 0.859 ms - Mb
DisplayReassurance 0.048 ms - Mb
DisplayTop 0.034 ms - Mb
ModuleRoutes 0.008 ms - Mb
ActionFrontControllerInitAfter 0.005 ms - Mb
DisplayProductAdditionalInfo 0.005 ms - Mb
ActionControllerInitBefore 0.004 ms - Mb
Top 0.002 ms - Mb
DisplayNavFullWidth 0.002 ms - Mb
27 hook(s) 252.991 ms 4.01 Mb
Module Time Memory Usage
klaviyopsautomation 3.573 ms - Mb
psxdesign 20.213 ms 0.04 Mb
ps_mbo 12.848 ms 0.05 Mb
ps_eventbus 5.788 ms 0.08 Mb
mailjet 5.560 ms 0.13 Mb
ps_socialfollow 4.889 ms 0.06 Mb
productcomments 72.263 ms 0.65 Mb
ps_shoppingcart 4.096 ms 0.06 Mb
ps_searchbar 5.035 ms 0.06 Mb
paypal 19.243 ms 0.34 Mb
ps_googleanalytics 14.330 ms 0.11 Mb
psxmarketingwithgoogle 4.406 ms - Mb
bongooglereviews 3.556 ms 0.02 Mb
ps_contactinfo 9.923 ms 0.13 Mb
ps_customersignin 4.054 ms 0.06 Mb
ps_mainmenu 37.171 ms 1.45 Mb
pagesnotfound 0.274 ms 0.01 Mb
sekeywords 0.595 ms 0.05 Mb
ps_sharebuttons 4.380 ms 0.07 Mb
ps_viewedproduct 6.607 ms 0.20 Mb
psgdpr 4.293 ms 0.05 Mb
ps_customeraccountlinks 7.181 ms 0.09 Mb
ps_linklist 49.496 ms 0.73 Mb
statsdata 19.794 ms 0.16 Mb
24 module(s) 319.568 ms 4.55 Mb

Stopwatch SQL - 217 queries

# Query Time (ms) Rows Filesort Group By Location
43
SELECT SQL_NO_CACHE *
FROM `mod923_product` a
LEFT JOIN `mod923_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `mod923_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 802) AND (b.`id_shop` = 1) LIMIT 1
9.115 ms 1 /src/Adapter/EntityMapper.php:71
14
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `mod923_module` m
INNER JOIN mod923_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 `mod923_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `mod923_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `mod923_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") 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`
8.109 ms 1440 Yes Yes /classes/Hook.php:1267
210
INSERT INTO `mod923_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', 'en', '0')
6.988 ms 1 /classes/ObjectModel.php:622
73
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `mod923_attribute` a
LEFT JOIN `mod923_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `mod923_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `mod923_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod923_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN mod923_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN mod923_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 802
6.843 ms 1 /classes/Product.php:7559
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 `mod923_configuration` c
LEFT JOIN `mod923_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
6.229 ms 1584 /classes/Configuration.php:180
87
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `mod923_product_attribute` pa
INNER JOIN mod923_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN mod923_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `mod923_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `mod923_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `mod923_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod923_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `mod923_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `mod923_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN mod923_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 802
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
6.226 ms 1 Yes Yes /classes/Product.php:4594
185
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM mod923_link_block lb
INNER JOIN mod923_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 28 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
5.649 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
80
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM mod923_feature_product pf
LEFT JOIN mod923_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN mod923_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN mod923_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN mod923_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 802
ORDER BY f.position ASC
5.588 ms 1 Yes /classes/Product.php:6017
74
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-19 00:00:00",
INTERVAL 10 DAY
)
) > 0 AS new
FROM `mod923_accessory`
LEFT JOIN `mod923_product` p ON p.`id_product` = `id_product_2`
INNER JOIN mod923_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod923_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `mod923_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `mod923_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `mod923_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `mod923_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `mod923_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN mod923_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 802 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
5.534 ms 1 Yes /classes/Product.php:4698
19
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `mod923_meta` m
LEFT JOIN `mod923_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
4.936 ms 86 Yes /classes/Dispatcher.php:654
86
SELECT SQL_NO_CACHE *
FROM `mod923_manufacturer` a
LEFT JOIN `mod923_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `mod923_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 1) LIMIT 1
4.658 ms 1 /src/Adapter/EntityMapper.php:71
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM mod923_shop_url su
LEFT JOIN mod923_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'musicavenueparis.com' OR su.domain_ssl = 'musicavenueparis.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
4.422 ms 1 Yes /classes/shop/Shop.php:1364
6
SELECT SQL_NO_CACHE *
FROM `mod923_country` a
LEFT JOIN `mod923_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `mod923_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
4.294 ms 1 /src/Adapter/EntityMapper.php:71
215
INSERT INTO `mod923_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('796110', '', 'musicavenueparis.com/fr/mixtape/802-dj-ronsha-dj-kefran-golgoth-tape.html', '', '2025-01-19 19:41:56')
4.100 ms 1 /classes/ObjectModel.php:622
191
SELECT SQL_NO_CACHE *
FROM mod923_meta m
LEFT JOIN mod923_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
3.870 ms 2 /classes/Meta.php:193
109
SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
FROM mod923_linksmenutop l
LEFT JOIN mod923_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 1 AND ll.id_shop=1)
LEFT JOIN mod923_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_linksmenutop = "1"
AND l.id_shop IN (0, 1)
3.420 ms 2 /modules/ps_mainmenu/ps_menutoplinks.class.php:37
175
SELECT SQL_NO_CACHE psgdpr.active FROM `mod923_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 135 LIMIT 1
3.355 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
33
SELECT SQL_NO_CACHE *
FROM `mod923_currency` a
LEFT JOIN `mod923_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `mod923_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
3.328 ms 1 /src/Adapter/EntityMapper.php:71
57
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM mod923_tag t
LEFT JOIN mod923_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=802
3.253 ms 1 /classes/Tag.php:244
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 mod923_shop_group gs
LEFT JOIN mod923_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN mod923_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
3.061 ms 1 Yes /classes/shop/Shop.php:715
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `mod923_lang` l
LEFT JOIN `mod923_lang_shop` ls ON (l.id_lang = ls.id_lang)
3.059 ms 2 /classes/Language.php:1080
48
SELECT SQL_NO_CACHE tr.*
FROM `mod923_tax_rule` tr
JOIN `mod923_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 7
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
3.036 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
76
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `mod923_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 802 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `mod923_cart_product` cp JOIN `mod923_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod923_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 802 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2.884 ms 0 /classes/Cart.php:1426
195
SELECT SQL_NO_CACHE *
FROM `mod923_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
2.861 ms 2 /src/Adapter/EntityMapper.php:79
40
SELECT SQL_NO_CACHE *
FROM `mod923_group` a
LEFT JOIN `mod923_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
2.694 ms 1 /src/Adapter/EntityMapper.php:71
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `mod923_hook` h
WHERE (h.active = 1)
2.602 ms 954 /classes/Hook.php:1366
52
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM mod923_product_attribute pa
INNER JOIN mod923_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 802 LIMIT 1
2.571 ms 1 /classes/Product.php:1106
66
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 6) AND (b.`id_shop` = 1) LIMIT 1
2.502 ms 1 /src/Adapter/EntityMapper.php:71
46
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `mod923_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `mod923_hook_alias` ha
INNER JOIN `mod923_hook` h ON ha.name = h.name
2.475 ms 0 /classes/Hook.php:1326
47
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `mod923_hook_module` hm
STRAIGHT_JOIN `mod923_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `mod923_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.408 ms 489 /classes/Hook.php:456
194
SELECT SQL_NO_CACHE *
FROM `mod923_cms` a
LEFT JOIN `mod923_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) LIMIT 1
2.400 ms 1 /src/Adapter/EntityMapper.php:71
93
SELECT SQL_NO_CACHE format
FROM `mod923_address_format`
WHERE `id_country` = 8 LIMIT 1
2.301 ms 1 /classes/AddressFormat.php:656
65
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `mod923_category_product` cp
INNER JOIN `mod923_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 802 AND ctg.`id_group` = 1 LIMIT 1
2.287 ms 1 /classes/Product.php:6736
97
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM mod923_required_field
2.240 ms 1 /classes/ObjectModel.php:1592
44
SELECT SQL_NO_CACHE `name`
FROM `mod923_manufacturer`
WHERE `id_manufacturer` = 1
AND `active` = 1 LIMIT 1
2.157 ms 1 /classes/Manufacturer.php:316
58
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod923_stock_available`
WHERE (id_product = 802) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.074 ms 1 /classes/stock/StockAvailable.php:453
29
SELECT SQL_NO_CACHE * FROM `mod923_currency` c ORDER BY `iso_code` ASC
2.050 ms 1 Yes /classes/Currency.php:709
211
SELECT SQL_NO_CACHE `id_guest`
FROM `mod923_connections`
WHERE `id_guest` = 947491
AND `date_add` > '2025-01-19 19:11:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
1.958 ms 1 Yes /classes/Connection.php:168
177
SELECT SQL_NO_CACHE p.id_product
FROM mod923_product p
WHERE p.active = 1
1.934 ms 938 /modules/ps_viewedproduct/ps_viewedproduct.php:317
45
SELECT SQL_NO_CACHE `name` FROM `mod923_supplier` WHERE `id_supplier` = 0 LIMIT 1
1.880 ms 0 /classes/Supplier.php:243
176
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `mod923_category_product` cp
LEFT JOIN `mod923_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `mod923_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` IN (802) AND cl.`id_lang` = 1
ORDER BY c.`level_depth` DESC
1.878 ms 1 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
187
SELECT SQL_NO_CACHE *
FROM `mod923_link_block_lang`
WHERE `id_link_block` = 1
1.834 ms 2 /src/Adapter/EntityMapper.php:79
214
INSERT INTO `mod923_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('947491', '903', '308350546', '', '1', '1', '2025-01-19 19:41:56')
1.822 ms 1 /classes/ObjectModel.php:622
55
SELECT SQL_NO_CACHE `reduction`
FROM `mod923_product_group_reduction_cache`
WHERE `id_product` = 802 AND `id_group` = 1 LIMIT 1
1.705 ms 0 /classes/GroupReduction.php:156
110
SELECT SQL_NO_CACHE c.*, cl.*
FROM `mod923_category` c
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `mod923_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `mod923_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `mod923_category` c2 ON c2.`id_category` = 3 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.704 ms 26 Yes Yes /classes/Category.php:799
77
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `mod923_image` i
INNER JOIN mod923_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 802
AND image_shop.`cover` = 1 LIMIT 1
1.659 ms 2 /classes/Product.php:3570
89
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
1.643 ms 0 /classes/module/Module.php:2636
49
SELECT SQL_NO_CACHE *
FROM `mod923_tax` a
WHERE (a.`id_tax` = 35) LIMIT 1
1.608 ms 1 /src/Adapter/EntityMapper.php:71
91
SELECT SQL_NO_CACHE *
FROM `mod923_product` a
LEFT JOIN `mod923_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `mod923_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 802) AND (b.`id_shop` = 1) LIMIT 1
1.549 ms 1 /src/Adapter/EntityMapper.php:71
212
SELECT SQL_NO_CACHE id_page_type
FROM mod923_page_type
WHERE name = 'product' LIMIT 1
1.543 ms 1 /classes/Page.php:104
83
SELECT SQL_NO_CACHE state FROM mod923_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
1.540 ms 1 /classes/FeatureFlag.php:105
213
SELECT SQL_NO_CACHE `id_page`
FROM `mod923_page`
WHERE `id_page_type` = 4 AND `id_object` = 802 LIMIT 1
1.458 ms 1 /classes/Page.php:83
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `mod923_hook_alias`
1.457 ms 88 /classes/Hook.php:287
216
SELECT SQL_NO_CACHE data
FROM `mod923_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
1.428 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
209
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM mod923_link_block lb
INNER JOIN mod923_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 162 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
1.409 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
84
SELECT SQL_NO_CACHE * FROM `mod923_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
1.395 ms 7 Yes /classes/ImageType.php:109
50
SELECT SQL_NO_CACHE *
FROM `mod923_tax_lang`
WHERE `id_tax` = 35
1.361 ms 2 /src/Adapter/EntityMapper.php:79
179
SELECT SQL_NO_CACHE p.id_product
FROM mod923_product p
WHERE p.active = 1
1.350 ms 938 /modules/ps_viewedproduct/ps_viewedproduct.php:317
41
SELECT SQL_NO_CACHE *
FROM `mod923_group_lang`
WHERE `id_group` = 1
1.340 ms 2 /src/Adapter/EntityMapper.php:79
20
SELECT SQL_NO_CACHE * FROM `mod923_hook_module_exceptions`
WHERE `id_shop` IN (1)
1.334 ms 1 /classes/module/Module.php:2018
21
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod923_module` m
LEFT JOIN `mod923_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1.324 ms 82 /classes/module/Module.php:345
62
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod923_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 6 LIMIT 1
1.321 ms 1 /classes/Category.php:1378
79
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `mod923_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 802 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `mod923_cart_product` cp JOIN `mod923_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod923_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 802 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.171 ms 0 /classes/Cart.php:1426
98
SELECT SQL_NO_CACHE *
FROM `mod923_category` a0
LEFT JOIN `mod923_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 47) AND (a0.`nright` > 48) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
1.148 ms 3 Yes /classes/PrestaShopCollection.php:383
81
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod923_image` i
INNER JOIN mod923_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod923_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 802
ORDER BY `position`
1.126 ms 2 Yes /classes/Product.php:3545
160
SELECT SQL_NO_CACHE c.*, cl.*
FROM `mod923_category` c
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `mod923_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `mod923_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `mod923_category` c2 ON c2.`id_category` = 6 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.105 ms 2 Yes Yes /classes/Category.php:799
22
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod923_module` m
LEFT JOIN `mod923_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1.086 ms 82 /classes/module/Module.php:345
35
SELECT SQL_NO_CACHE `id_country`
FROM `mod923_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
1.066 ms 1 /classes/Country.php:194
88
SELECT SQL_NO_CACHE 1 FROM mod923_cart_product cp INNER JOIN mod923_product p
ON (p.id_product = cp.id_product) INNER JOIN mod923_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
1.061 ms 1 /classes/Cart.php:4243
36
SELECT SQL_NO_CACHE *
FROM `mod923_country` a
LEFT JOIN `mod923_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `mod923_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
1.047 ms 1 /src/Adapter/EntityMapper.php:71
196
SELECT SQL_NO_CACHE *
FROM `mod923_cms` a
LEFT JOIN `mod923_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
1.042 ms 1 /src/Adapter/EntityMapper.php:71
53
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `mod923_product` p
INNER JOIN `mod923_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod923_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 802)
1.030 ms 1 /classes/Product.php:3860
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `mod923_hook`
0.993 ms 954 /classes/Hook.php:1326
17
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod923_module` m
LEFT JOIN `mod923_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.965 ms 82 /classes/module/Module.php:345
204
SELECT SQL_NO_CACHE *
FROM mod923_meta m
LEFT JOIN mod923_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.954 ms 1 /classes/Meta.php:193
127
SELECT SQL_NO_CACHE c.*, cl.*
FROM `mod923_category` c
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `mod923_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `mod923_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `mod923_category` c2 ON c2.`id_category` = 4 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.950 ms 26 Yes Yes /classes/Category.php:799
165
SELECT SQL_NO_CACHE `name`
FROM `mod923_hook`
WHERE `id_hook` = 849 LIMIT 1
0.947 ms 1 /classes/Hook.php:244
140
SELECT SQL_NO_CACHE c.*, cl.*
FROM `mod923_category` c
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `mod923_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `mod923_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `mod923_category` c2 ON c2.`id_category` = 5 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.946 ms 26 Yes Yes /classes/Category.php:799
157
SELECT SQL_NO_CACHE c.*, cl.*
FROM `mod923_category` c
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `mod923_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `mod923_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `mod923_category` c2 ON c2.`id_category` = 7 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.934 ms 1 Yes Yes /classes/Category.php:799
178
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `mod923_currency` c
LEFT JOIN mod923_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
0.931 ms 1 /classes/Currency.php:1136
95
SELECT SQL_NO_CACHE *
FROM `mod923_country` a
LEFT JOIN `mod923_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.911 ms 1 /src/Adapter/EntityMapper.php:71
70
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `mod923_category` c
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `mod923_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `mod923_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 6
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.888 ms 1 Yes Yes /classes/Category.php:924
56
SELECT SQL_NO_CACHE `reduction`
FROM `mod923_group`
WHERE `id_group` = 1 LIMIT 1
0.866 ms 1 /classes/Group.php:154
8
SELECT SQL_NO_CACHE *
FROM `mod923_lang` a
LEFT JOIN `mod923_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.866 ms 1 /src/Adapter/EntityMapper.php:71
72
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `mod923_product_attribute` pa INNER JOIN mod923_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 802
0.859 ms 1 /classes/Product.php:7492
75
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `mod923_product_attribute` pa INNER JOIN mod923_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 802
0.833 ms 1 /classes/Product.php:7492
94
SELECT SQL_NO_CACHE `need_identification_number`
FROM `mod923_country`
WHERE `id_country` = 8 LIMIT 1
0.822 ms 1 /classes/Country.php:405
96
SELECT SQL_NO_CACHE *
FROM `mod923_country_lang`
WHERE `id_country` = 8
0.821 ms 2 /src/Adapter/EntityMapper.php:79
168
SELECT SQL_NO_CACHE `iso_code`
FROM `mod923_country`
WHERE `id_country` = 8 LIMIT 1
0.811 ms 1 /classes/Country.php:275
28
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod923_module` m
LEFT JOIN `mod923_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.804 ms 82 /classes/module/Module.php:345
186
SELECT SQL_NO_CACHE *
FROM `mod923_link_block` a
LEFT JOIN `mod923_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 1) LIMIT 1
0.800 ms 1 /src/Adapter/EntityMapper.php:71
63
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `mod923_product_attribute` pa INNER JOIN mod923_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 802
0.788 ms 1 /classes/Product.php:7492
67
SELECT SQL_NO_CACHE tr.*
FROM `mod923_tax_rule` tr
JOIN `mod923_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
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
0.770 ms 0 /classes/tax/TaxRulesTaxManager.php:109
100
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_contactinfo" LIMIT 1
0.768 ms 1 /classes/module/Module.php:2636
51
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `mod923_product` p
INNER JOIN mod923_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 802
AND DATEDIFF("2025-01-19 00:00:00", product_shop.`date_add`) < 10 LIMIT 1
0.740 ms 0 /classes/Product.php:1732
180
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
0.724 ms 1 /classes/module/Module.php:2636
173
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_viewedproduct" LIMIT 1
0.695 ms 1 /classes/module/Module.php:2636
37
SELECT SQL_NO_CACHE *
FROM `mod923_currency` a
LEFT JOIN `mod923_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.693 ms 1 /src/Adapter/EntityMapper.php:71
207
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_socialfollow" LIMIT 1
0.690 ms 1 /classes/module/Module.php:2636
99
SELECT SQL_NO_CACHE `name`
FROM `mod923_hook`
WHERE `id_hook` = 9 LIMIT 1
0.684 ms 1 /classes/Hook.php:244
27
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod923_module` m
LEFT JOIN `mod923_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.672 ms 82 /classes/module/Module.php:345
190
SELECT SQL_NO_CACHE *
FROM `mod923_hook` a
WHERE (a.`id_hook` = 28) LIMIT 1
0.666 ms 1 /src/Adapter/EntityMapper.php:71
163
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_searchbar" LIMIT 1
0.662 ms 1 /classes/module/Module.php:2636
102
SELECT SQL_NO_CACHE `need_identification_number`
FROM `mod923_country`
WHERE `id_country` = 8 LIMIT 1
0.642 ms 1 /classes/Country.php:405
188
SELECT SQL_NO_CACHE *
FROM `mod923_link_block` a
LEFT JOIN `mod923_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 2) LIMIT 1
0.635 ms 1 /src/Adapter/EntityMapper.php:71
7
SELECT SQL_NO_CACHE *
FROM `mod923_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.625 ms 1 /src/Adapter/EntityMapper.php:71
71
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `mod923_category` c
LEFT JOIN `mod923_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN mod923_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.624 ms 26 Yes Yes /classes/Category.php:1151
11
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `mod923_lang` l
JOIN mod923_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.612 ms 2 /classes/Language.php:1216
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM mod923_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.611 ms 1 /classes/shop/ShopUrl.php:182
182
SELECT SQL_NO_CACHE `need_identification_number`
FROM `mod923_country`
WHERE `id_country` = 8 LIMIT 1
0.590 ms 1 /classes/Country.php:405
112
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 3 AND `id_shop` = 1
0.589 ms 2 /src/Adapter/EntityMapper.php:79
101
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
0.582 ms 1 /classes/module/Module.php:2109
31
SELECT SQL_NO_CACHE value FROM `mod923_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.580 ms 1 /classes/shop/Shop.php:1183
34
SELECT SQL_NO_CACHE `id_lang` FROM `mod923_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.576 ms 2 /classes/Language.php:883
82
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod923_product_attribute`
WHERE `id_product` = 802
0.571 ms 1 /classes/Product.php:2902
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM mod923_shop s
LEFT JOIN mod923_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.569 ms 1 /classes/shop/Shop.php:218
183
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_linklist" LIMIT 1
0.566 ms 1 /classes/module/Module.php:2636
90
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.562 ms 0 /classes/module/Module.php:2109
164
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 127 AND `id_shop` = 1 LIMIT 1
0.557 ms 1 /classes/module/Module.php:2109
38
SELECT SQL_NO_CACHE *
FROM `mod923_currency_lang`
WHERE `id_currency` = 1
0.555 ms 2 /src/Adapter/EntityMapper.php:79
199
SELECT SQL_NO_CACHE *
FROM `mod923_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
0.550 ms 2 /src/Adapter/EntityMapper.php:79
64
SELECT SQL_NO_CACHE id_shop
FROM `mod923_product_shop`
WHERE `id_product` = 802
AND id_shop = 1 LIMIT 1
0.540 ms 1 /classes/ObjectModel.php:1729
54
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod923_product_shop`
WHERE `id_product` = 802 AND id_shop=1 LIMIT 1
0.527 ms 1 /classes/Product.php:6872
205
SELECT SQL_NO_CACHE *
FROM mod923_meta m
LEFT JOIN mod923_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.525 ms 1 /classes/Meta.php:193
208
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
0.521 ms 1 /classes/module/Module.php:2109
3
SELECT SQL_NO_CACHE *
FROM `mod923_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.520 ms 1 /src/Adapter/EntityMapper.php:71
92
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod923_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 6 LIMIT 1
0.518 ms 1 /classes/Category.php:1378
30
SELECT SQL_NO_CACHE `id_lang` FROM `mod923_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.511 ms 2 /classes/Language.php:883
184
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 123 AND `id_shop` = 1 LIMIT 1
0.504 ms 1 /classes/module/Module.php:2109
131
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
0.489 ms 2 /src/Adapter/EntityMapper.php:79
203
SELECT SQL_NO_CACHE *
FROM `mod923_cms_lang`
WHERE `id_cms` = 5 AND `id_shop` = 1
0.489 ms 2 /src/Adapter/EntityMapper.php:79
166
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "braintreeofficial" LIMIT 1
0.486 ms 0 /classes/module/Module.php:2636
111
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 3) LIMIT 1
0.471 ms 1 /src/Adapter/EntityMapper.php:71
171
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "productcomments" LIMIT 1
0.465 ms 1 /classes/module/Module.php:2636
181
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 70 AND `id_shop` = 1 LIMIT 1
0.465 ms 1 /classes/module/Module.php:2109
25
SELECT SQL_NO_CACHE `active`
FROM `mod923_module`
WHERE `name` = "ps_mbo" LIMIT 1
0.462 ms 1 /modules/ps_mbo/ps_mbo.php:325
158
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 7) LIMIT 1
0.462 ms 1 /src/Adapter/EntityMapper.php:71
78
SELECT SQL_NO_CACHE name FROM mod923_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 6 LIMIT 1
0.461 ms 1 /classes/Product.php:5655
24
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `mod923_module` m
LEFT JOIN `mod923_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1
0.460 ms 1 /modules/ps_mbo/ps_mbo.php:335
118
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 10 AND `id_shop` = 1
0.457 ms 2 /src/Adapter/EntityMapper.php:79
167
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.453 ms 0 /classes/module/Module.php:2109
42
SELECT SQL_NO_CACHE id_shop
FROM `mod923_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.449 ms 1 /classes/ObjectModel.php:1729
113
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 8) LIMIT 1
0.449 ms 1 /src/Adapter/EntityMapper.php:71
162
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
0.447 ms 2 /src/Adapter/EntityMapper.php:79
114
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 8 AND `id_shop` = 1
0.446 ms 2 /src/Adapter/EntityMapper.php:79
132
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) LIMIT 1
0.442 ms 1 /src/Adapter/EntityMapper.php:71
154
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
0.442 ms 2 /src/Adapter/EntityMapper.php:79
103
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_customersignin" LIMIT 1
0.438 ms 1 /classes/module/Module.php:2636
193
SELECT SQL_NO_CACHE *
FROM mod923_meta m
LEFT JOIN mod923_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.438 ms 2 /classes/Meta.php:193
201
SELECT SQL_NO_CACHE *
FROM `mod923_cms_lang`
WHERE `id_cms` = 4 AND `id_shop` = 1
0.438 ms 2 /src/Adapter/EntityMapper.php:79
206
SELECT SQL_NO_CACHE *
FROM mod923_meta m
LEFT JOIN mod923_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "stores"
OR m.page = "stores"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.437 ms 1 /classes/Meta.php:193
115
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9) LIMIT 1
0.436 ms 1 /src/Adapter/EntityMapper.php:71
192
SELECT SQL_NO_CACHE *
FROM mod923_meta m
LEFT JOIN mod923_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.435 ms 2 /classes/Meta.php:193
69
SELECT SQL_NO_CACHE id_shop
FROM `mod923_category_shop`
WHERE `id_category` = 6
AND id_shop = 1 LIMIT 1
0.432 ms 1 /classes/ObjectModel.php:1729
137
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 18 AND `id_shop` = 1
0.428 ms 2 /src/Adapter/EntityMapper.php:79
159
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 7 AND `id_shop` = 1
0.425 ms 2 /src/Adapter/EntityMapper.php:79
169
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_sharebuttons" LIMIT 1
0.424 ms 1 /classes/module/Module.php:2636
130
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) LIMIT 1
0.423 ms 1 /src/Adapter/EntityMapper.php:71
161
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 6) LIMIT 1
0.421 ms 1 /src/Adapter/EntityMapper.php:71
18
SELECT SQL_NO_CACHE name, alias FROM `mod923_hook_alias`
0.418 ms 88 /classes/Hook.php:339
106
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
0.415 ms 1 /classes/module/Module.php:2109
139
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
0.414 ms 2 /src/Adapter/EntityMapper.php:79
145
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) LIMIT 1
0.414 ms 1 /src/Adapter/EntityMapper.php:71
156
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
0.414 ms 2 /src/Adapter/EntityMapper.php:79
144
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 20 AND `id_shop` = 1
0.410 ms 2 /src/Adapter/EntityMapper.php:79
136
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) LIMIT 1
0.409 ms 1 /src/Adapter/EntityMapper.php:71
116
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 9 AND `id_shop` = 1
0.405 ms 2 /src/Adapter/EntityMapper.php:79
172
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 135 AND `id_shop` = 1 LIMIT 1
0.403 ms 1 /classes/module/Module.php:2109
146
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 21 AND `id_shop` = 1
0.400 ms 2 /src/Adapter/EntityMapper.php:79
189
SELECT SQL_NO_CACHE *
FROM `mod923_link_block_lang`
WHERE `id_link_block` = 2
0.397 ms 2 /src/Adapter/EntityMapper.php:79
105
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
0.384 ms 1 /classes/module/Module.php:2636
104
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 81 AND `id_shop` = 1 LIMIT 1
0.384 ms 1 /classes/module/Module.php:2109
60
SELECT SQL_NO_CACHE depends_on_stock
FROM `mod923_stock_available`
WHERE (id_product = 802) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.382 ms 1 /classes/stock/StockAvailable.php:753
170
SELECT SQL_NO_CACHE `id_module` FROM `mod923_module_shop` WHERE `id_module` = 116 AND `id_shop` = 1 LIMIT 1
0.382 ms 1 /classes/module/Module.php:2109
26
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `mod923_module` m
LEFT JOIN `mod923_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_mbo" LIMIT 1
0.381 ms 1 /modules/ps_mbo/ps_mbo.php:335
119
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) LIMIT 1
0.381 ms 1 /src/Adapter/EntityMapper.php:71
121
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) LIMIT 1
0.381 ms 1 /src/Adapter/EntityMapper.php:71
151
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) LIMIT 1
0.381 ms 1 /src/Adapter/EntityMapper.php:71
155
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 26) LIMIT 1
0.377 ms 1 /src/Adapter/EntityMapper.php:71
23
SELECT SQL_NO_CACHE `active`
FROM `mod923_module`
WHERE `name` = "ps_mbo" LIMIT 1
0.375 ms 1 /modules/ps_mbo/ps_mbo.php:325
138
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) LIMIT 1
0.375 ms 1 /src/Adapter/EntityMapper.php:71
141
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 5) LIMIT 1
0.375 ms 1 /src/Adapter/EntityMapper.php:71
147
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) LIMIT 1
0.375 ms 1 /src/Adapter/EntityMapper.php:71
149
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 23) LIMIT 1
0.374 ms 1 /src/Adapter/EntityMapper.php:71
153
SELECT SQL_NO_CACHE *
FROM `mod923_category` a
LEFT JOIN `mod923_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) LIMIT 1
0.374 ms 1 /src/Adapter/EntityMapper.php:71
148
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1
0.373 ms 2 /src/Adapter/EntityMapper.php:79
150
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 23 AND `id_shop` = 1
0.372 ms 2 /src/Adapter/EntityMapper.php:79
124
SELECT SQL_NO_CACHE *
FROM `mod923_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
0.371 ms 2 /src/Adapter/EntityMapper.php:79
125