Lubrifiants Hybrides
Il y a 11 produits.
10,61 €
13,90 €
Il y a 11 produits.
Load Time | 661.987 ms |
Querying Time | 132 ms |
Queries | 361 |
Memory Peak Usage | 25.2 Mb |
Included Files | 1260 files - 11.87 Mb |
PrestaShop Cache | - Mb |
Global vars | 0.19 Mb |
PrestaShop Version | 8.1.2 |
PHP Version | 8.1.25 |
MySQL Version | 10.6.16-MariaDB |
Memory Limit | 2048M |
Max Execution Time | 3600s |
Smarty Cache | disabled |
Smarty Compilation | force compile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 5.465 ms | 5.465 ms | 8.53 Mb | 9.2 Mb |
__construct | 8.405 ms | 13.870 ms | 1.73 Mb | 11.9 Mb |
config | 23.460 ms | 37.330 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.016 ms | 37.346 ms | - Mb | 11.9 Mb |
init | 26.894 ms | 64.240 ms | 2.11 Mb | 14.8 Mb |
checkAccess | 0.001 ms | 64.241 ms | - Mb | 14.8 Mb |
setMedia | 2.264 ms | 66.505 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.002 ms | 66.507 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 66.508 ms | - Mb | 14.8 Mb |
initContent | 251.817 ms | 318.325 ms | 5.24 Mb | 19.1 Mb |
initFooter | 0.002 ms | 318.327 ms | - Mb | 19.1 Mb |
display | 343.660 ms | 661.987 ms | 5.45 Mb | 25.2 Mb |
Hook | Time | Memory Usage |
---|---|---|
displayProductListReviews | 35.128 ms | 1.29 Mb |
ActionDispatcherBefore | 34.525 ms | 3.09 Mb |
ActionOutputHTMLBefore | 34.483 ms | 0.14 Mb |
displayLeftColumn | 22.232 ms | 0.74 Mb |
DisplayBeforeBodyClosingTag | 16.871 ms | 0.21 Mb |
displayTop | 15.856 ms | 0.20 Mb |
DisplayHeader | 11.310 ms | 0.88 Mb |
DisplayFooterRight | 10.238 ms | 0.24 Mb |
DisplayFooter | 9.727 ms | 0.11 Mb |
ActionDispatcher | 9.002 ms | 0.70 Mb |
DisplayNavFullWidth | 5.135 ms | 0.07 Mb |
DisplayLeftColumn | 4.113 ms | 0.04 Mb |
DisplayOutsideMainPage | 3.919 ms | 0.13 Mb |
displayFooterRight | 3.440 ms | 0.07 Mb |
displayFooterLeft | 2.378 ms | 0.06 Mb |
DisplayBanner | 2.170 ms | 0.06 Mb |
DisplayNav1 | 1.495 ms | 0.03 Mb |
DisplayFooterLeft | 1.413 ms | 0.03 Mb |
DisplayFooterAfter | 1.202 ms | 0.03 Mb |
ActionFrontControllerSetVariables | 1.168 ms | 0.06 Mb |
displayNav2 | 1.030 ms | 0.08 Mb |
DisplaySidebarNavigation | 0.630 ms | - Mb |
ActionFrontControllerSetMedia | 0.629 ms | 0.01 Mb |
ProductSearchProvider | 0.262 ms | - Mb |
ActionObjectAddAfter | 0.037 ms | - Mb |
ModuleRoutes | 0.019 ms | 0.02 Mb |
DisplayAfterBodyOpeningTag | 0.012 ms | - Mb |
ActionFrontControllerInitAfter | 0.011 ms | - Mb |
DisplayFooterBefore | 0.009 ms | - Mb |
29 hook(s) | 228.444 ms | 8.29 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 5.331 ms | 0.54 Mb |
jprestaspeedpack | 79.136 ms | 3.99 Mb |
blockreassurance | 1.002 ms | 0.09 Mb |
blockwishlist | 10.028 ms | 0.13 Mb |
ps_emailsubscription | 3.623 ms | 0.10 Mb |
ps_socialfollow | 2.504 ms | 0.08 Mb |
ps_emailalerts | 0.146 ms | 0.09 Mb |
zonethememanager | 30.251 ms | 1.68 Mb |
ps_shoppingcart | 10.953 ms | 0.11 Mb |
ps_searchbar | 1.846 ms | 0.14 Mb |
productcomments | 35.315 ms | 1.33 Mb |
ps_googleanalytics | 9.517 ms | 0.05 Mb |
zonecolorsfonts | 9.672 ms | 0.87 Mb |
zonemegamenu | 6.356 ms | 0.12 Mb |
prestastripe | 1.250 ms | 0.02 Mb |
ps_facetedsearch | 1.456 ms | 0.10 Mb |
ps_languageselector | 0.692 ms | 0.06 Mb |
ps_currencyselector | 0.603 ms | 0.06 Mb |
ps_customersignin | 3.503 ms | 0.08 Mb |
ps_categorytree | 22.373 ms | 0.75 Mb |
zonecolumnblocks | 3.402 ms | 0.13 Mb |
zonepopupnewsletter | 1.671 ms | 0.05 Mb |
statsdata | 7.557 ms | 0.21 Mb |
23 module(s) | 248.187 ms | 10.78 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
359 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (322,803264849),(322,531227063),(322,714571165),(322,1289214159),(322,1785617407),(322,2936477779),(322,1727466530),(322,1432532875),(322,1025009294),(322,1804081323),(322,3479716883),(322,66301815),(322,537553573),(322,3045727500),(322,3231073010),(322,1825096520),(322,3225262556),(322,2645763144),(322,2027619899),(322,786864081),(322,1849360992),(322,294428854),(322,3774376179),(322,2880678980),(322,114155291),(322,2929321318),(322,2087307803),(322,2369020978),(322,1152186767),(322,4222788516),(322,2858566420),(322,848840972),(322,4147554351),(322,770698498),(322,2244011448),(322,477004582),(322,3610318732),(322,1070190107),(322,937307692),(322,25761885),(322,3366890060),(322,3483396593),(322,392306519),(322,909258745),(322,179865882),(322,3099645137),(322,3371246540),(322,2390640699),(322,501027234),(322,3032495894),(322,2100541971),(322,2793494280),(322,180908336),(322,1192985740),(322,1972034646),(322,2419117650),(322,3803768817),(322,4265874642),(322,67723771),(322,3423129237),(322,3399895114),(322,3221089548),(322,2990154896),(322,2728213885),(322,933991437),(322,2513627470),(322,468067826),(322,4137721533),(322,1552016987),(322,4080301755),(322,4245349388),(322,1973472416),(322,1839057912),(322,3745041382),(322,3035734567),(322,3719469943),(322,3466131047),(322,679558129),(322,462819688),(322,4267553191),(322,518809702),(322,3303811122),(322,2883778317),(322,1694893476),(322,3287268691),(322,3711637102),(322,698879415),(322,885817714),(322,125306139),(322,1634619674),(322,58280175),(322,3363778289),(322,1161663254),(322,201135304),(322,288600709),(322,1021330335),(322,2858809635),(322,2763627026),(322,3717400459),(322,4125370705),(322,3997906175),(322,4162316513),(322,3219397995),(322,2539165674),(322,1046234598),(322,787652129),(322,1595426297),(322,4184932827),(322,1985552396),(322,1944795689),(322,3799916950),(322,1827123668),(322,1447744642),(322,1636796806),(322,2645405926),(322,1474595477),(322,3375525138),(322,3902077767),(322,3507415422),(322,2781072282),(322,2002273313),(322,3164880625),(322,2490789905),(322,1000843653),(322,48947005),(322,3883347157),(322,3700474777),(322,4264269047),(322,2125390191),(322,4270481046),(322,1693150473),(322,343450730),(322,381351735),(322,2863449446),(322,3772294966),(322,3877457961),(322,1492116830),(322,4041511410),(322,828132466),(322,4090211224),(322,2185737194),(322,3517149926),(322,647687838),(322,733479784),(322,1440916471),(322,3262261204),(322,1872100372),(322,2092461357),(322,3357609169),(322,2365529006),(322,1263061406),(322,2296732656),(322,534196217),(322,482025419),(322,2811467352),(322,2488480532),(322,3501473861),(322,1917272649),(322,1878317490),(322,1789511633),(322,956713705),(322,89981727),(322,1143557322),(322,2749361789),(322,3857194488),(322,1024086260),(322,26040876),(322,1804243295),(322,2165251395),(322,1281618245),(322,2793993627),(322,426054238),(322,3398682121),(322,1025101115),(322,2974984653),(322,2214325187),(322,997821910),(322,2005463392),(322,3252396061),(322,942332382),(322,3816934055),(322,1661692647),(322,975758589),(322,3974931321),(322,2301364099),(322,855746680),(322,637832447),(322,3938675492),(322,508940865),(322,911480697),(322,1283363269),(322,3552869238),(322,2961923901),(322,3747234531),(322,3155646160),(322,3164668199),(322,2271068282),(322,84354396),(322,2915068863),(322,4064530110),(322,3216991891),(322,2045363644),(322,2664176477),(322,1076722390),(322,505410826),(322,3544422162),(322,2506779464),(322,2552384108),(322,876907216),(322,82980331),(322,3890150098),(322,3475437886),(322,2302280848),(322,1133144647),(322,801167173),(322,2059315716),(322,3139619822),(322,2937007520),(322,1589371182),(322,693370988),(322,2708427394),(322,1007456900),(322,610735313),(322,3846627131),(322,2031830639),(322,1908602231),(322,1401333655),(322,378101424),(322,996218346),(322,660881695),(322,2938384267),(322,4250264855),(322,1895305721),(322,502965417),(322,1982471117),(322,2524144246),(322,2774996218),(322,1068709096),(322,4077513867),(322,2900588200),(322,465472731),(322,4139839450),(322,2360011682),(322,4211248848),(322,283341417),(322,4165214622),(322,3508523596),(322,234404923),(322,2782693783),(322,3413880379),(322,3540168379),(322,861653603),(322,3160995915),(322,1391251310),(322,2106651858),(322,3572623339),(322,4629984),(322,2488722736),(322,3486510944),(322,2675016634),(322,2165907305),(322,136687257),(322,3540179561),(322,2792526429),(322,2220600372),(322,2914585448),(322,3882733113),(322,1688090355),(322,3534950496),(322,1182870252),(322,412601709),(322,574969182),(322,2970413814),(322,1487282505),(322,3228977345),(322,2023459642),(322,3291711134),(322,2792891444),(322,3335276918),(322,502111155),(322,1347492703),(322,2832080533),(322,1215320197),(322,2317239205),(322,1931846913),(322,1721014625),(322,738600257),(322,2998338424),(322,1207945902),(322,734241479),(322,3324570843),(322,4126771257),(322,1712456575),(322,3169253733),(322,1160958045),(322,1130949510),(322,3116084871),(322,269178051),(322,24773614),(322,3204450510),(322,3468662336),(322,1808444077),(322,4095410992),(322,1012520131),(322,2367920745),(322,2603361072),(322,2741539031),(322,607507456),(322,616165826),(322,2288576869),(322,4252798532),(322,2692385638),(322,4100315394),(322,3061254709),(322,1657292258),(322,2148967437),(322,1248236410),(322,2457219175),(322,1920985790),(322,1340703149),(322,1618471777),(322,4160689201),(322,1822364967),(322,479188821),(322,1661785323),(322,4137484009),(322,2636427258),(322,1499247737),(322,2061922205),(322,665830591),(322,916194615),(322,495595719),(322,3026469794),(322,1845449656),(322,4078122428),(322,2044505385),(322,3156749269),(322,3919036276),(322,204613135),(322,605377709),(322,766051911),(322,30400764),(322,4211022030),(322,715827285),(322,1092948871),(322,610201349),(322,1023110113),(322,3379323545),(322,2591028766),(322,1994095466),(322,33157726),(322,198243957),(322,94201498),(322,2540831776),(322,1707019604),(322,2730046909),(322,4101073252),(322,207761914),(322,2750534087),(322,980926717),(322,377071036),(322,2983490672),(322,584353846),(322,1743688562),(322,3223058413),(322,1665991311),(322,3093731065),(322,1095877807),(322,1085889875),(322,2059985562),(322,3618062925),(322,592374860),(322,4217863027),(322,3425247989),(322,1636391408),(322,1698766782),(322,2162739858),(322,1538367880),(322,3760626336),(322,1987713032),(322,2338874856),(322,4206689645),(322,1723372602),(322,2788329276),(322,2095305502),(322,3135330775),(322,2402748468),(322,24058172),(322,4000683245),(322,315670382),(322,2558276906),(322,1745365471),(322,2782569384),(322,3422117706),(322,552626444),(322,1506232339),(322,2933163456),(322,1483801350),(322,1400586123),(322,3746875726),(322,2604810181),(322,2905930158),(322,803588046),(322,1651400661),(322,1431243585),(322,1586185269),(322,4110009762),(322,3647374073),(322,4196158832),(322,644435096),(322,1862966990),(322,2098775956),(322,4045847707),(322,3122054119),(322,1971194991),(322,2149367276),(322,1888540635),(322,2660577125),(322,2508340497),(322,196341346),(322,1790101800),(322,1054130805),(322,2741947598),(322,1292400575),(322,545037028),(322,1516477184),(322,2706799993),(322,562470873),(322,2591346466),(322,613023703),(322,2725609989),(322,2082081559),(322,572560232),(322,2833489058),(322,1999611979),(322,1938789650),(322,2958717166),(322,1035708154),(322,2025067287),(322,3804047398),(322,248028803),(322,4243412966),(322,628124381),(322,1271215494),(322,2140466223),(322,1298495884),(322,3585931255),(322,532975694),(322,892763084),(322,203145038),(322,470924714),(322,1460516495),(322,2732318442),(322,3996868778),(322,862206445),(322,3193479021),(322,3382171736),(322,3362897893),(322,3598913121),(322,1342337107),(322,3202829344),(322,1335223071),(322,270790954),(322,1086966479),(322,484642328),(322,4274468042),(322,1740107684),(322,2117688527),(322,1393082718),(322,366510022),(322,341328174),(322,1469264429),(322,968691010),(322,3210232788),(322,809700252),(322,3705477223),(322,1639200307),(322,3585776886),(322,3305319229),(322,1052899681),(322,2176267881),(322,357387863),(322,451177334),(322,677589039),(322,1181390953),(322,898241702),(322,3480303789),(322,1736215096),(322,2511740146),(322,2560762429),(322,1570623991),(322,897080848),(322,891021207),(322,2807843172),(322,411231410),(322,2413680770),(322,519468981),(322,1898829954),(322,4274422817),(322,2781196321),(322,433695516),(322,1652336127),(322,4200438598),(322,3032893805),(322,1435170492),(322,341146430),(322,755973553),(322,2183774725),(322,3967614532),(322,1589097164),(322,2441764320),(322,745126750),(322,348450311),(322,2084175962),(322,3357611772),(322,1654631620),(322,3098454302),(322,2029227635),(322,1731761366),(322,2444253995),(322,2906032508),(322,872274856),(322,4282856364),(322,3328013593),(322,4184469063),(322,1074477927),(322,475878802),(322,1341972790),(322,2770374005),(322,4237489391),(322,2818813526),(322,3131100007),(322,4267621199),(322,1031922959),(322,1616292706),(322,630426110),(322,1846388513),(322,2239793094),(322,1660370824),(322,3321716633),(322,2551727033),(322,1836172154),(322,1870881122),(322,3324207484),(322,1065867023),(322,1459310880),(322,1395112921),(322,893552556),(322,1795813847),(322,2544364435),(322,4188602229),(322,1437064809),(322,922605498),(322,4180843510),(322,2554784265),(322,3798404205),(322,1216801552),(322,225525148),(322,274058040),(322,3206796234),(322,610255635),(322,3139895407),(322,3993594441),(322,2078652070),(322,3340749058),(322,2282248923),(322,3201099700),(322,3944887276),(322,887478137),(322,620965629),(322,53639561),(322,687854272),(322,4204526813),(322,3434636086),(322,3859247582),(322,2160451939),(322,419013317),(322,488655959),(322,2224381764),(322,857621694),(322,593880699),(322,1743569168),(322,747100668),(322,2627272664),(322,1477316791),(322,852002855),(322,3813191394),(322,3206482767),(322,2935275735),(322,825997452),(322,4128572079),(322,4149399208),(322,2432005645),(322,945310979),(322,206553734),(322,3381625344),(322,2613891474),(322,1285565060),(322,725086502),(322,2181279565),(322,2136294074),(322,3291030245),(322,3423892574),(322,1818418110),(322,1175554195),(322,231365613),(322,3071984169),(322,1510809703),(322,2304894647),(322,724387218),(322,3702122266),(322,3105745802),(322,3598888791),(322,40599425),(322,4256434691),(322,1198380170),(322,3549401556),(322,2300237909),(322,484124464),(322,3042798728),(322,767973032),(322,4146324303),(322,1493350341),(322,2166736334),(322,3061340275),(322,1468811388),(322,1958965990),(322,2146366302),(322,2212338847),(322,2088651590),(322,2684538463),(322,2292708505),(322,571001464),(322,608126571),(322,2736309071),(322,1479333754),(322,1794660366),(322,2319975337),(322,1093438481),(322,2975864804),(322,2504416172),(322,3531750290),(322,219666672),(322,4219072870),(322,1053258155),(322,2382983142),(322,1006288562),(322,1770263986),(322,3089735283),(322,3689334927),(322,2901629603),(322,2019277020),(322,2853333944),(322,1110695191),(322,3884283185),(322,4268093708),(322,159799075),(322,1715997742),(322,1009155269),(322,3922001006),(322,3916338789),(322,1085252167),(322,207705430),(322,1190601026),(322,1441004396),(322,1567147586),(322,964098054),(322,1385174189),(322,3607427007),(322,4065177061),(322,1552830538),(322,3778287701),(322,3986294473),(322,4127238085),(322,1865170325),(322,2161789419),(322,2889615117),(322,785261358),(322,3873733217),(322,2600209543),(322,3958092558),(322,4143434528),(322,3225228598),(322,3451063310),(322,810085901),(322,1502204888),(322,2931931582),(322,1339720903),(322,4093703382),(322,1016897830),(322,1186809094),(322,2269117600),(322,813555736),(322,733475850),(322,305814753),(322,2720553993),(322,212227262),(322,1328958432),(322,3903742053),(322,2617942920),(322,4254367326),(322,2895836413),(322,1090341105),(322,3174277595),(322,639084285),(322,4064195579),(322,2134315289),(322,608843276),(322,4190247440),(322,1090444753),(322,2554275840),(322,2758076506),(322,2518001916),(322,3620157415),(322,1195920681),(322,1822840633),(322,1087551238),(322,235508323),(322,1139244570),(322,810960133),(322,425550269),(322,1767940144),(322,1488780247),(322,1250541405),(322,1715845038),(322,3777612587),(322,2285237154),(322,802817926),(322,4280998710),(322,1108258121),(322,1107026853),(322,2913745362),(322,1129101120),(322,2454813183),(322,1690919006),(322,23973636),(322,293370743),(322,1041759778),(322,3142497267),(322,2920365983),(322,2300359472),(322,885232682),(322,1995817456),(322,3443377157),(322,863919144),(322,1324348692),(322,4019216150),(322,443752815),(322,4223293),(322,1182491637),(322,4257294915),(322,3629776934),(322,582958316),(322,3061655453),(322,1665355533),(322,1929899841),(322,1033949851),(322,2010879266),(322,1872304779),(322,1282102725),(322,3589651214),(322,4095654001),(322,2447713556),(322,2543494532),(322,2069898435),(322,3286503857),(322,2662939963),(322,93111834),(322,3160936308),(322,261262800),(322,141197408),(322,1904512268),(322,3001025754),(322,2247670246),(322,535154833),(322,3476002757),(322,3806439314),(322,1819793014),(322,3545273473),(322,3957652542),(322,3018295592),(322,1367893712),(322,1034338066),(322,3229510223),(322,4276953245),(322,3363858574),(322,2870596766),(322,648526699),(322,3627085975),(322,1585047995),(322,1960922033),(322,748737253),(322,1175066615),(322,1318322018),(322,260367662),(322,643741484),(322,1013706048),(322,1726352130),(322,2222354404),(322,1327031463),(322,1131865044),(322,839200087),(322,1407668396),(322,3548333318),(322,237845721),(322,3056051791),(322,747235328),(322,172675174),(322,2781705803),(322,2111348799),(322,3067187587),(322,618638032),(322,3369756381),(322,2232055662),(322,55113216),(322,3939915090),(322,2586983921),(322,3286008345),(322,1956055310),(322,740042513),(322,2282536358),(322,1863122946),(322,1296880981),(322,2589434346),(322,1621393368),(322,39250009),(322,72263924),(322,1587391050),(322,847186998),(322,2455499024),(322,859347884),(322,2244795234),(322,64890532),(322,2632397068),(322,3130603680),(322,2519704051),(322,236532132),(322,892869386),(322,2140262188),(322,3066438540),(322,1506843199),(322,3006122752),(322,2573798367),(322,2432518025),(322,3924888977),(322,1697117306),(322,3406763364),(322,1129505049) ON DUPLICATE KEY UPDATE id=id |
9.631 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
318 | SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps21_category` c INNER JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps21_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 1669 AND c.id_category IN ( SELECT id_category FROM `ps21_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC |
7.613 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
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 `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
4.515 ms | 1298 | /classes/Configuration.php:180 | ||
168 | SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=959 AND c.nright<=960 GROUP BY p.id_product) p INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 24 |
2.798 ms | 39357004996 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
51 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps21_hook_alias` ha INNER JOIN `ps21_hook` h ON ha.name = h.name |
2.312 ms | 0 | /classes/Hook.php:1292 | ||
169 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=959 AND c.nright<=960 GROUP BY p.id_product) p |
2.268 ms | 39357004996 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
15 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps21_module` m INNER JOIN ps21_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 `ps21_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps21_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps21_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` |
2.190 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
351 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('897312', '69591', '752115218', '', '1', '1', '2023-11-30 12:03:55') |
1.847 ms | 1 | /classes/ObjectModel.php:622 | ||
52 | 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 `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.739 ms | 386 | /classes/Hook.php:456 | ||
360 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache` WHERE ((id_controller=1 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=2 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=3 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=4 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=5 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=6 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=7 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=8 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR id_controller=9 OR (id_controller=10 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=11 AND last_gen < (NOW() - INTERVAL 691200 SECOND))) ORDER BY last_gen ASC LIMIT 2 |
1.690 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
356 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 1858903350, 'https://cadeaufou.com/866-lubrifiants-hybrides', 1, 2, 1, 866, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.500 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
352 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('895023', '', 'cadeaufou.com/866-lubrifiants-hybrides', '', '2023-11-30 12:03:55') |
1.259 ms | 1 | /classes/ObjectModel.php:622 | ||
347 | INSERT INTO `ps21_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') |
1.164 ms | 1 | /classes/ObjectModel.php:622 | ||
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.107 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
172 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("184e6744a41a33284d32ffad77263020", "a:1:{s:7:\"filters\";a:0:{}}") |
1.052 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
13 | SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps21_lang` l JOIN ps21_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.974 ms | 1 | /classes/Language.php:1216 | ||
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.951 ms | 880 | /classes/Hook.php:1332 | ||
139 | 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 `ps21_category` c INNER JOIN ps21_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps21_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 866 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.906 ms | 1 | Yes | Yes | /classes/Category.php:921 |
173 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-11-30 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (191778,191779,191780,191783,191782,191785,202152,361726,361727,361728,361729) |
0.897 ms | 11 | /classes/ProductAssembler.php:95 | ||
323 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (191779) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.878 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
160 | SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps21_currency` c LEFT JOIN ps21_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.841 ms | 1 | /classes/Currency.php:1136 | ||
319 | SELECT SQL_NO_CACHE * FROM `ps21_zcolumnblock` b LEFT JOIN `ps21_zcolumnblock_lang` bl ON b.`id_zcolumnblock` = bl.`id_zcolumnblock` WHERE b.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY b.`id_zcolumnblock` ORDER BY b.`position` ASC |
0.811 ms | 16 | Yes | Yes | /modules/zonecolumnblocks/classes/ZColumnBlock.php:116 |
154 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 959) AND (a0.`nright` > 960) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.811 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
320 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (191778) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.809 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
163 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 959) AND (a0.`nright` > 960) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.763 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.733 ms | 880 | /classes/Hook.php:1292 | ||
291 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 361727) AND (b.`id_shop` = 1) LIMIT 1 |
0.724 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
294 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 361728) AND (b.`id_shop` = 1) LIMIT 1 |
0.703 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
355 | SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps21_meta` m LEFT JOIN `ps21_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.668 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
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 ps21_shop_group gs LEFT JOIN ps21_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps21_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 |
0.626 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
324 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (191780) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.625 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
249 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 361727 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 361727 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.602 ms | 0 | /classes/Cart.php:1410 | ||
329 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (361726) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.600 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
20 | SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps21_meta` m LEFT JOIN `ps21_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.588 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
325 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (191783) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.585 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
292 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 361727 ORDER BY `position` |
0.584 ms | 1 | Yes | /classes/Product.php:3545 | |
332 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (361729) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.577 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
331 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (361728) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.569 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
313 | SELECT SQL_NO_CACHE * FROM `ps21_zmenu` m LEFT JOIN `ps21_zmenu_lang` ml ON m.`id_zmenu` = ml.`id_zmenu` WHERE m.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY m.`id_zmenu` ORDER BY m.`position` ASC |
0.562 ms | 7 | Yes | Yes | /modules/zonemegamenu/classes/ZMenu.php:104 |
350 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 866 LIMIT 1 |
0.560 ms | 1 | /classes/Page.php:83 | ||
276 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 191783) AND (b.`id_shop` = 1) LIMIT 1 |
0.555 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
285 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 202152) AND (b.`id_shop` = 1) LIMIT 1 |
0.553 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
327 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (191785) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.552 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
217 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191782 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 191782 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.546 ms | 0 | /classes/Cart.php:1410 | ||
298 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 361729 ORDER BY `position` |
0.546 ms | 1 | Yes | /classes/Product.php:3545 | |
184 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191778 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 191778 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.544 ms | 0 | /classes/Cart.php:1410 | ||
250 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 361727 ORDER BY f.position ASC |
0.543 ms | 1 | Yes | /classes/Product.php:5993 | |
330 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (361727) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.541 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
328 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (202152) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.540 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
297 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 361729) AND (b.`id_shop` = 1) LIMIT 1 |
0.525 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
282 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 191785) AND (b.`id_shop` = 1) LIMIT 1 |
0.509 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
288 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 361726) AND (b.`id_shop` = 1) LIMIT 1 |
0.509 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 ps21_shop_url su LEFT JOIN ps21_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'cadeaufou.com' OR su.domain_ssl = 'cadeaufou.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.502 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
326 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (191782) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.501 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.496 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
265 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 361729 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 361729 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.487 ms | 0 | /classes/Cart.php:1410 | ||
339 | SELECT SQL_NO_CACHE c.id_cms, l.meta_title FROM ps21_cms c JOIN ps21_cms_lang l ON (c.id_cms = l.id_cms) INNER JOIN ps21_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1) WHERE l.id_lang = 1 AND c.`active` = 1 GROUP BY c.id_cms ORDER BY c.`position` |
0.486 ms | 25 | Yes | Yes | /classes/CMS.php:184 |
140 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.485 ms | 81 | /classes/module/Module.php:345 | ||
18 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.483 ms | 81 | /classes/module/Module.php:345 | ||
225 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191785 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 191785 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.479 ms | 0 | /classes/Cart.php:1410 | ||
233 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 202152 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 202152 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.479 ms | 0 | /classes/Cart.php:1410 | ||
295 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 361728 ORDER BY `position` |
0.478 ms | 1 | Yes | /classes/Product.php:3545 | |
241 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 361726 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 361726 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.478 ms | 0 | /classes/Cart.php:1410 | ||
279 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 191782) AND (b.`id_shop` = 1) LIMIT 1 |
0.470 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
128 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 866) AND (b.`id_shop` = 1) LIMIT 1 |
0.470 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
267 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 191778) AND (b.`id_shop` = 1) LIMIT 1 |
0.465 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
257 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 361728 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 361728 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.462 ms | 0 | /classes/Cart.php:1410 | ||
271 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 191779 ORDER BY `position` |
0.461 ms | 1 | Yes | /classes/Product.php:3545 | |
348 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 897312 AND `date_add` > '2023-11-30 11:33:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.461 ms | 1 | Yes | /classes/Connection.php:168 | |
226 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191785 ORDER BY f.position ASC |
0.460 ms | 1 | Yes | /classes/Product.php:5993 | |
270 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 191779) AND (b.`id_shop` = 1) LIMIT 1 |
0.459 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
200 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191780 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 191780 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.441 ms | 0 | /classes/Cart.php:1410 | ||
201 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191780 ORDER BY f.position ASC |
0.436 ms | 1 | Yes | /classes/Product.php:5993 | |
208 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191783 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 191783 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.435 ms | 0 | /classes/Cart.php:1410 | ||
141 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-11-30 00:00:00" AND date_to <= "2023-11-30 23:59:59") OR (date_from >= "2023-11-30 00:00:00" AND date_from <= "2023-11-30 23:59:59") OR (date_from < "2023-11-30 00:00:00" AND date_to > "2023-11-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.434 ms | 5 | /classes/CartRule.php:357 | ||
192 | 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 cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191779 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_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` = 191779 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.430 ms | 0 | /classes/Cart.php:1410 | ||
22 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.423 ms | 81 | /classes/module/Module.php:345 | ||
273 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 191780) AND (b.`id_shop` = 1) LIMIT 1 |
0.419 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
261 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 361729) |
0.409 ms | 1 | /classes/Product.php:3857 | ||
185 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191778 ORDER BY f.position ASC |
0.395 ms | 1 | Yes | /classes/Product.php:5993 | |
266 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 361729 ORDER BY f.position ASC |
0.392 ms | 1 | Yes | /classes/Product.php:5993 | |
142 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1 |
0.391 ms | 6 | /classes/CartRule.php:418 | ||
53 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 1 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.389 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
268 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 191778 ORDER BY `position` |
0.389 ms | 1 | Yes | /classes/Product.php:3545 | |
280 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 191782 ORDER BY `position` |
0.387 ms | 2 | Yes | /classes/Product.php:3545 | |
6 | SELECT SQL_NO_CACHE * FROM `ps21_country` a LEFT JOIN `ps21_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps21_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1 |
0.384 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
144 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%" |
0.383 ms | 1 | /classes/CartRule.php:418 | ||
218 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191782 ORDER BY f.position ASC |
0.383 ms | 1 | Yes | /classes/Product.php:5993 | |
289 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 361726 ORDER BY `position` |
0.383 ms | 2 | Yes | /classes/Product.php:3545 | |
286 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 202152 ORDER BY `position` |
0.382 ms | 1 | Yes | /classes/Product.php:3545 | |
258 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 361728 ORDER BY f.position ASC |
0.370 ms | 1 | Yes | /classes/Product.php:5993 | |
235 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 361726 AND image_shop.`cover` = 1 LIMIT 1 |
0.360 ms | 2 | /classes/Product.php:3570 | ||
40 | SELECT SQL_NO_CACHE * FROM `ps21_currency` a LEFT JOIN `ps21_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.359 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
237 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 361726) |
0.357 ms | 1 | /classes/Product.php:3857 | ||
277 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 191783 ORDER BY `position` |
0.357 ms | 1 | Yes | /classes/Product.php:3545 | |
234 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 202152 ORDER BY f.position ASC |
0.356 ms | 1 | Yes | /classes/Product.php:5993 | |
300 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.353 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
242 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 361726 ORDER BY f.position ASC |
0.351 ms | 1 | Yes | /classes/Product.php:5993 | |
193 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191779 ORDER BY f.position ASC |
0.348 ms | 1 | Yes | /classes/Product.php:5993 | |
133 | SELECT SQL_NO_CACHE * FROM `ps21_currency` a LEFT JOIN `ps21_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `ps21_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.346 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
283 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 191785 ORDER BY `position` |
0.346 ms | 1 | Yes | /classes/Product.php:3545 | |
165 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 866 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.344 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
342 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_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 |
0.337 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
202 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191783 AND image_shop.`cover` = 1 LIMIT 1 |
0.336 ms | 1 | /classes/Product.php:3570 | ||
59 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 3 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.335 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
194 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191780 AND image_shop.`cover` = 1 LIMIT 1 |
0.322 ms | 1 | /classes/Product.php:3570 | ||
209 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191783 ORDER BY f.position ASC |
0.321 ms | 1 | Yes | /classes/Product.php:5993 | |
174 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191778 AND image_shop.`cover` = 1 LIMIT 1 |
0.308 ms | 1 | /classes/Product.php:3570 | ||
124 | SELECT SQL_NO_CACHE c.* FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.302 ms | 1 | /classes/Customer.php:503 | ||
5 | SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps21_lang` l LEFT JOIN `ps21_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.300 ms | 1 | /classes/Language.php:1080 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.299 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
125 | SELECT SQL_NO_CACHE * FROM `ps21_group` a LEFT JOIN `ps21_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.298 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
213 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 191782) |
0.297 ms | 1 | /classes/Product.php:3857 | ||
251 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 361728 AND image_shop.`cover` = 1 LIMIT 1 |
0.296 ms | 1 | /classes/Product.php:3570 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 866 AND ctg.`id_group` = 1 LIMIT 1 |
0.296 ms | 1 | /classes/Category.php:1751 | ||
123 | SELECT SQL_NO_CACHE c.`passwd` FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.295 ms | 1 | /classes/Customer.php:475 | ||
62 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 4 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.291 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
314 | SELECT SQL_NO_CACHE d.`id_zmenu`, COUNT(d.`id_zdropdown`) as total FROM `ps21_zdropdown` d WHERE `active` = 1 GROUP BY d.`id_zmenu` |
0.290 ms | 8 | Yes | /modules/zonemegamenu/classes/ZMenu.php:232 | |
341 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.286 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
117 | SELECT SQL_NO_CACHE id FROM `ps21_jm_pagecache_contexts` WHERE `id_shop`=1 AND `id_lang`=1 AND `id_currency`=1 AND `id_fake_customer` IS NULL AND `id_device`=1 AND `id_country` IS NULL AND `id_tax_csz`=1 AND `id_specifics` IS NULL LIMIT 1 |
0.283 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
274 | SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 191780 ORDER BY `position` |
0.283 ms | 1 | Yes | /classes/Product.php:3545 | |
343 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 5) AND (b.`id_shop` = 1) LIMIT 1 |
0.282 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
143 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-11-30 00:00:00" AND date_to <= "2023-11-30 23:59:59") OR (date_from >= "2023-11-30 00:00:00" AND date_from <= "2023-11-30 23:59:59") OR (date_from < "2023-11-30 00:00:00" AND date_to > "2023-11-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.281 ms | 5 | /classes/CartRule.php:357 | ||
317 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps21_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 |
0.279 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
253 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 361728) |
0.277 ms | 1 | /classes/Product.php:3857 | ||
49 | SELECT SQL_NO_CACHE c.* FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.272 ms | 1 | /classes/Customer.php:503 | ||
145 | SELECT SQL_NO_CACHE COUNT(*) FROM `ps21_orders` o LEFT JOIN `ps21_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`) WHERE o.`id_customer` = 0 AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 0 LIMIT 1 |
0.270 ms | 1 | /classes/order/Order.php:881 | ||
245 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 361727) |
0.268 ms | 1 | /classes/Product.php:3857 | ||
137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.265 ms | 10 | Yes | /classes/ImageType.php:109 | |
340 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1 |
0.264 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
259 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 361729 AND image_shop.`cover` = 1 LIMIT 1 |
0.262 ms | 1 | /classes/Product.php:3570 | ||
171 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 866 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.259 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
301 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a LEFT JOIN `ps21_zthememanager_lang` `b` ON a.`id_zthememanager` = b.`id_zthememanager` AND b.`id_lang` = 1 WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.259 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
227 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 202152 AND image_shop.`cover` = 1 LIMIT 1 |
0.257 ms | 1 | /classes/Product.php:3570 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.255 ms | 10 | Yes | /classes/ImageType.php:109 | |
56 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 2 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.255 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
50 | SELECT SQL_NO_CACHE trgs.`id_tax_rules_group` FROM `ps21_tax_rules_group_shop` as trgs LEFT JOIN `ps21_tax_rules_group` as trg ON trgs.id_tax_rules_group=trg.id_tax_rules_group WHERE active=1 AND id_shop=1 AND deleted=0 |
0.254 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.253 ms | 88 | /classes/Hook.php:339 | ||
4 | SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps21_shop s LEFT JOIN ps21_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.252 ms | 1 | /classes/shop/Shop.php:218 | ||
232 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 202152) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.249 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
65 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 5 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.247 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.246 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
196 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 191780) |
0.246 ms | 1 | /classes/Product.php:3857 | ||
299 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 361729 |
0.244 ms | 1 | /classes/Product.php:2902 | ||
204 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 191783) |
0.244 ms | 1 | /classes/Product.php:3857 | ||
302 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.239 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
311 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.239 ms | 1 | /classes/module/Module.php:2636 | ||
334 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.239 ms | 1 | /classes/module/Module.php:2636 | ||
178 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 191778) |
0.237 ms | 1 | /classes/Product.php:3857 | ||
309 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.237 ms | 1 | /classes/module/Module.php:2636 | ||
354 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.237 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.236 ms | 1 | Yes | /classes/Currency.php:709 | |
66 | SELECT SQL_NO_CACHE id FROM `ps21_jm_pagecache_details` WHERE `details_md5`=MD5('{\"1\":{\"taxes\":{\"id_tax\":1},\"computation_method\":0},\"2\":{\"taxes\":{\"id_tax\":2},\"computation_method\":0},\"3\":{\"taxes\":{\"id_tax\":3},\"computation_method\":0},\"4\":{\"taxes\":{\"id_tax\":4},\"computation_method\":0},\"5\":{\"taxes\":{\"id_tax\":1},\"computation_method\":0}}'); |
0.235 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
221 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 191785) |
0.235 ms | 1 | /classes/Product.php:3857 | ||
8 | SELECT SQL_NO_CACHE * FROM `ps21_lang` a LEFT JOIN `ps21_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.234 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
229 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 202152) |
0.231 ms | 1 | /classes/Product.php:3857 | ||
303 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.231 ms | 1 | /classes/module/Module.php:2636 | ||
10 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "jprestaspeedpack" LIMIT 1 |
0.229 ms | 1 | /classes/module/Module.php:2636 | ||
264 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 361729) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.228 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
186 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191779 AND image_shop.`cover` = 1 LIMIT 1 |
0.226 ms | 1 | /classes/Product.php:3570 | ||
216 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 191782) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.225 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
188 | 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 `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_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` = 191779) |
0.223 ms | 1 | /classes/Product.php:3857 | ||
164 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.222 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
236 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 866 LIMIT 1 |
0.221 ms | 1 | /classes/Product.php:5639 | ||
210 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191782 AND image_shop.`cover` = 1 LIMIT 1 |
0.219 ms | 2 | /classes/Product.php:3570 | ||
344 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.219 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
121 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key_mobile' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.218 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
166 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 866) LIMIT 1 |
0.218 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
219 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191785 AND image_shop.`cover` = 1 LIMIT 1 |
0.217 ms | 1 | /classes/Product.php:3570 | ||
243 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 361727 AND image_shop.`cover` = 1 LIMIT 1 |
0.216 ms | 1 | /classes/Product.php:3570 | ||
345 | SELECT SQL_NO_CACHE `save_time` FROM `ps21_zpopupnewsletter` WHERE `id_shop` = 1 AND `active` = 1 LIMIT 1 |
0.214 ms | 1 | /modules/zonepopupnewsletter/classes/ZPopupNewsletter.php:78 | ||
182 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 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.210 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
315 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.209 ms | 1 | /classes/module/Module.php:2636 | ||
349 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.209 ms | 1 | /classes/Page.php:104 | ||
16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.209 ms | 88 | /classes/Hook.php:287 | ||
48 | SELECT SQL_NO_CACHE c.`passwd` FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.208 ms | 1 | /classes/Customer.php:475 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-11-30 12:03:00' AND date_from <= '2023-11-30 14:03:00') OR (date_to >= '2023-11-30 12:03:00' AND date_to <= '2023-11-30 14:03:00'); |
0.206 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
290 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 361726 |
0.206 ms | 1 | /classes/Product.php:2902 | ||
55 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 1 |
0.205 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
275 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 191780 |
0.205 ms | 1 | /classes/Product.php:2902 | ||
132 | SELECT SQL_NO_CACHE c.id_currency FROM `ps21_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.204 ms | 1 | /classes/Currency.php:893 | ||
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.203 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
161 | SELECT SQL_NO_CACHE id_zcolorsfonts FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.200 ms | 1 | /modules/zonecolorsfonts/classes/ZColorsFonts.php:118 | ||
136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.198 ms | 1 | /classes/FeatureFlag.php:105 | ||
47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-11-30 12:03:00' OR date_to<'2023-11-30 12:03:00'; |
0.195 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.194 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
346 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.193 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
333 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.192 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
336 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.188 ms | 1 | /classes/module/Module.php:2636 | ||
131 | SELECT SQL_NO_CACHE value FROM `ps21_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.187 ms | 1 | /classes/shop/Shop.php:1183 | ||
262 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 361729 AND id_shop=1 LIMIT 1 |
0.186 ms | 1 | /classes/Product.php:6848 | ||
248 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 361727) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.185 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
305 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.183 ms | 1 | /classes/module/Module.php:2636 | ||
256 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 361728) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.183 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
321 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.182 ms | 1 | /classes/module/Module.php:2636 | ||
195 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 866 LIMIT 1 |
0.182 ms | 1 | /classes/Product.php:5639 | ||
153 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps21_required_field |
0.181 ms | 1 | /classes/ObjectModel.php:1592 | ||
293 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 361727 |
0.179 ms | 1 | /classes/Product.php:2902 | ||
157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.175 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
338 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.175 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 |