Cagoules et masques
Il y a 8 produits.
9,20 €
9,20 €
Il y a 8 produits.
Load Time | 589.227 ms |
Querying Time | 133 ms |
Queries | 325 |
Memory Peak Usage | 24.5 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.235 ms | 5.235 ms | 8.53 Mb | 9.2 Mb |
__construct | 8.451 ms | 13.686 ms | 1.73 Mb | 11.9 Mb |
config | 30.672 ms | 44.358 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.023 ms | 44.381 ms | - Mb | 11.9 Mb |
init | 34.438 ms | 78.819 ms | 2.11 Mb | 14.8 Mb |
checkAccess | 0.002 ms | 78.821 ms | - Mb | 14.8 Mb |
setMedia | 2.563 ms | 81.384 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.002 ms | 81.386 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 81.387 ms | - Mb | 14.8 Mb |
initContent | 149.570 ms | 230.957 ms | 4.78 Mb | 18.7 Mb |
initFooter | 0.003 ms | 230.960 ms | - Mb | 18.7 Mb |
display | 358.267 ms | 589.227 ms | 5.29 Mb | 24.5 Mb |
Hook | Time | Memory Usage |
---|---|---|
ActionDispatcherBefore | 41.690 ms | 3.09 Mb |
ActionOutputHTMLBefore | 37.275 ms | 0.14 Mb |
displayProductListReviews | 29.767 ms | 1.28 Mb |
displayLeftColumn | 27.590 ms | 0.74 Mb |
displayTop | 16.321 ms | 0.20 Mb |
DisplayBeforeBodyClosingTag | 15.436 ms | 0.21 Mb |
DisplayHeader | 13.047 ms | 0.88 Mb |
ActionDispatcher | 12.474 ms | 0.70 Mb |
DisplayFooterRight | 11.937 ms | 0.24 Mb |
DisplayFooter | 10.884 ms | 0.11 Mb |
DisplayNavFullWidth | 5.722 ms | 0.07 Mb |
DisplayLeftColumn | 4.566 ms | 0.04 Mb |
DisplayOutsideMainPage | 4.318 ms | 0.06 Mb |
displayFooterRight | 4.079 ms | 0.07 Mb |
displayFooterLeft | 2.853 ms | 0.06 Mb |
DisplayFooterLeft | 2.402 ms | 0.03 Mb |
DisplayBanner | 2.130 ms | 0.06 Mb |
DisplayFooterAfter | 1.413 ms | 0.03 Mb |
ActionFrontControllerSetVariables | 1.413 ms | 0.06 Mb |
DisplayNav1 | 1.323 ms | 0.03 Mb |
displayNav2 | 1.029 ms | 0.08 Mb |
ActionFrontControllerSetMedia | 0.745 ms | 0.01 Mb |
DisplaySidebarNavigation | 0.673 ms | - Mb |
ProductSearchProvider | 0.317 ms | - Mb |
ActionObjectAddAfter | 0.042 ms | - Mb |
ModuleRoutes | 0.024 ms | 0.02 Mb |
DisplayAfterBodyOpeningTag | 0.023 ms | - Mb |
ActionFrontControllerInitAfter | 0.016 ms | - Mb |
DisplayFooterBefore | 0.011 ms | - Mb |
29 hook(s) | 249.520 ms | 8.22 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 5.054 ms | 0.54 Mb |
jprestaspeedpack | 92.508 ms | 3.99 Mb |
blockreassurance | 1.044 ms | 0.09 Mb |
blockwishlist | 11.219 ms | 0.13 Mb |
ps_emailsubscription | 4.240 ms | 0.10 Mb |
ps_socialfollow | 2.982 ms | 0.08 Mb |
ps_emailalerts | 0.185 ms | 0.09 Mb |
zonethememanager | 38.190 ms | 1.61 Mb |
ps_shoppingcart | 11.421 ms | 0.11 Mb |
ps_searchbar | 1.951 ms | 0.14 Mb |
productcomments | 29.976 ms | 1.32 Mb |
ps_googleanalytics | 7.821 ms | 0.05 Mb |
zonecolorsfonts | 10.656 ms | 0.87 Mb |
zonemegamenu | 7.421 ms | 0.12 Mb |
prestastripe | 1.374 ms | 0.02 Mb |
ps_facetedsearch | 1.708 ms | 0.10 Mb |
ps_languageselector | 0.764 ms | 0.06 Mb |
ps_currencyselector | 0.510 ms | 0.06 Mb |
ps_customersignin | 3.587 ms | 0.08 Mb |
ps_categorytree | 27.709 ms | 0.75 Mb |
zonecolumnblocks | 3.861 ms | 0.13 Mb |
zonepopupnewsletter | 1.745 ms | 0.05 Mb |
statsdata | 7.843 ms | 0.21 Mb |
23 module(s) | 273.767 ms | 10.70 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
323 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (126,803264849),(126,531227063),(126,2382983142),(126,1289214159),(126,1785617407),(126,2936477779),(126,1727466530),(126,1432532875),(126,1025009294),(126,1804081323),(126,3479716883),(126,66301815),(126,537553573),(126,3045727500),(126,3231073010),(126,1825096520),(126,3225262556),(126,2645763144),(126,2027619899),(126,786864081),(126,1849360992),(126,294428854),(126,3774376179),(126,2880678980),(126,114155291),(126,2929321318),(126,2087307803),(126,2369020978),(126,1152186767),(126,4222788516),(126,2858566420),(126,848840972),(126,4147554351),(126,770698498),(126,2244011448),(126,477004582),(126,3610318732),(126,1070190107),(126,937307692),(126,25761885),(126,3366890060),(126,3483396593),(126,392306519),(126,909258745),(126,179865882),(126,3099645137),(126,3371246540),(126,2390640699),(126,501027234),(126,3032495894),(126,2100541971),(126,2793494280),(126,180908336),(126,1192985740),(126,1972034646),(126,2419117650),(126,3803768817),(126,4265874642),(126,67723771),(126,3423129237),(126,3399895114),(126,3221089548),(126,2990154896),(126,2728213885),(126,933991437),(126,2513627470),(126,468067826),(126,4137721533),(126,1552016987),(126,4080301755),(126,4245349388),(126,1973472416),(126,1839057912),(126,3745041382),(126,3035734567),(126,3719469943),(126,3466131047),(126,679558129),(126,462819688),(126,4267553191),(126,518809702),(126,3303811122),(126,2883778317),(126,1694893476),(126,3287268691),(126,3711637102),(126,698879415),(126,885817714),(126,125306139),(126,1634619674),(126,58280175),(126,3363778289),(126,1161663254),(126,201135304),(126,288600709),(126,1021330335),(126,2858809635),(126,2763627026),(126,3717400459),(126,4125370705),(126,3997906175),(126,4162316513),(126,3219397995),(126,2539165674),(126,1046234598),(126,787652129),(126,1595426297),(126,4184932827),(126,1985552396),(126,1944795689),(126,3799916950),(126,1827123668),(126,1447744642),(126,1636796806),(126,2645405926),(126,1474595477),(126,3375525138),(126,3902077767),(126,3507415422),(126,2781072282),(126,2002273313),(126,3164880625),(126,2490789905),(126,1000843653),(126,48947005),(126,3883347157),(126,3700474777),(126,4264269047),(126,2125390191),(126,4270481046),(126,1693150473),(126,343450730),(126,381351735),(126,2863449446),(126,3772294966),(126,3877457961),(126,1492116830),(126,4041511410),(126,828132466),(126,4090211224),(126,2185737194),(126,3517149926),(126,647687838),(126,733479784),(126,1440916471),(126,3262261204),(126,1872100372),(126,2092461357),(126,3357609169),(126,2365529006),(126,1263061406),(126,2296732656),(126,534196217),(126,482025419),(126,2811467352),(126,2488480532),(126,3501473861),(126,1917272649),(126,1878317490),(126,1789511633),(126,956713705),(126,89981727),(126,1143557322),(126,2749361789),(126,3857194488),(126,1024086260),(126,26040876),(126,1804243295),(126,2165251395),(126,1281618245),(126,2793993627),(126,426054238),(126,3398682121),(126,1025101115),(126,2974984653),(126,2214325187),(126,997821910),(126,2005463392),(126,3252396061),(126,942332382),(126,3816934055),(126,1661692647),(126,975758589),(126,3974931321),(126,2301364099),(126,855746680),(126,637832447),(126,3938675492),(126,508940865),(126,911480697),(126,1283363269),(126,3552869238),(126,2961923901),(126,3747234531),(126,3155646160),(126,3164668199),(126,2271068282),(126,84354396),(126,2915068863),(126,4064530110),(126,3216991891),(126,2045363644),(126,2664176477),(126,1076722390),(126,505410826),(126,3544422162),(126,2506779464),(126,2552384108),(126,876907216),(126,82980331),(126,3890150098),(126,3475437886),(126,2302280848),(126,1133144647),(126,801167173),(126,2059315716),(126,3139619822),(126,2937007520),(126,1589371182),(126,693370988),(126,2708427394),(126,1007456900),(126,610735313),(126,3846627131),(126,2031830639),(126,1908602231),(126,1401333655),(126,378101424),(126,996218346),(126,660881695),(126,2938384267),(126,4250264855),(126,1895305721),(126,502965417),(126,1982471117),(126,2524144246),(126,2774996218),(126,1068709096),(126,4077513867),(126,2900588200),(126,465472731),(126,4139839450),(126,2360011682),(126,4211248848),(126,283341417),(126,4165214622),(126,3508523596),(126,234404923),(126,2782693783),(126,3413880379),(126,3540168379),(126,861653603),(126,3160995915),(126,1391251310),(126,2106651858),(126,3572623339),(126,4629984),(126,2488722736),(126,3486510944),(126,2675016634),(126,2165907305),(126,136687257),(126,3540179561),(126,2792526429),(126,2220600372),(126,2914585448),(126,3882733113),(126,1688090355),(126,3534950496),(126,1182870252),(126,412601709),(126,574969182),(126,2970413814),(126,1487282505),(126,3228977345),(126,2023459642),(126,3291711134),(126,2792891444),(126,3335276918),(126,502111155),(126,1347492703),(126,2832080533),(126,1215320197),(126,2317239205),(126,1931846913),(126,1721014625),(126,738600257),(126,2998338424),(126,1207945902),(126,734241479),(126,3324570843),(126,4126771257),(126,1712456575),(126,3169253733),(126,1160958045),(126,1130949510),(126,3116084871),(126,269178051),(126,24773614),(126,3204450510),(126,3468662336),(126,1808444077),(126,4095410992),(126,1012520131),(126,2367920745),(126,2603361072),(126,2741539031),(126,607507456),(126,616165826),(126,2288576869),(126,4252798532),(126,2692385638),(126,4100315394),(126,3061254709),(126,1657292258),(126,2148967437),(126,1248236410),(126,2457219175),(126,1920985790),(126,1340703149),(126,1618471777),(126,4160689201),(126,1822364967),(126,479188821),(126,1661785323),(126,4137484009),(126,2636427258),(126,1499247737),(126,2061922205),(126,665830591),(126,916194615),(126,495595719),(126,3026469794),(126,1845449656),(126,4078122428),(126,2044505385),(126,3156749269),(126,3919036276),(126,204613135),(126,605377709),(126,766051911),(126,30400764),(126,4211022030),(126,715827285),(126,1092948871),(126,610201349),(126,1023110113),(126,3379323545),(126,2591028766),(126,1994095466),(126,33157726),(126,198243957),(126,94201498),(126,2540831776),(126,1707019604),(126,2730046909),(126,4101073252),(126,207761914),(126,2750534087),(126,980926717),(126,377071036),(126,2983490672),(126,584353846),(126,1743688562),(126,3223058413),(126,1665991311),(126,3093731065),(126,1095877807),(126,1085889875),(126,2059985562),(126,3618062925),(126,592374860),(126,4217863027),(126,3425247989),(126,1636391408),(126,1698766782),(126,2162739858),(126,1538367880),(126,3760626336),(126,1987713032),(126,2338874856),(126,4206689645),(126,1723372602),(126,2788329276),(126,2095305502),(126,3135330775),(126,2402748468),(126,24058172),(126,4000683245),(126,315670382),(126,2558276906),(126,1745365471),(126,2782569384),(126,3422117706),(126,552626444),(126,1506232339),(126,2933163456),(126,1483801350),(126,1400586123),(126,3746875726),(126,2604810181),(126,2905930158),(126,803588046),(126,1651400661),(126,1431243585),(126,1586185269),(126,4110009762),(126,3647374073),(126,4196158832),(126,644435096),(126,1862966990),(126,2098775956),(126,4045847707),(126,3122054119),(126,1971194991),(126,2149367276),(126,1888540635),(126,2660577125),(126,2508340497),(126,196341346),(126,1790101800),(126,1054130805),(126,2741947598),(126,1292400575),(126,545037028),(126,1516477184),(126,2706799993),(126,562470873),(126,2591346466),(126,613023703),(126,2725609989),(126,2082081559),(126,572560232),(126,2833489058),(126,1999611979),(126,1938789650),(126,2958717166),(126,1035708154),(126,2025067287),(126,3804047398),(126,248028803),(126,4243412966),(126,628124381),(126,1271215494),(126,2140466223),(126,1298495884),(126,3585931255),(126,532975694),(126,892763084),(126,203145038),(126,470924714),(126,1460516495),(126,2732318442),(126,3996868778),(126,862206445),(126,3193479021),(126,3382171736),(126,3362897893),(126,3598913121),(126,1342337107),(126,3202829344),(126,1335223071),(126,270790954),(126,1086966479),(126,484642328),(126,4274468042),(126,1740107684),(126,2117688527),(126,1393082718),(126,366510022),(126,341328174),(126,1469264429),(126,968691010),(126,3210232788),(126,809700252),(126,3705477223),(126,1639200307),(126,3585776886),(126,3305319229),(126,1052899681),(126,2176267881),(126,357387863),(126,451177334),(126,677589039),(126,1181390953),(126,898241702),(126,3480303789),(126,1736215096),(126,2511740146),(126,2560762429),(126,1570623991),(126,897080848),(126,891021207),(126,2807843172),(126,411231410),(126,2413680770),(126,519468981),(126,1898829954),(126,4274422817),(126,2781196321),(126,433695516),(126,1652336127),(126,4200438598),(126,3032893805),(126,1435170492),(126,341146430),(126,755973553),(126,2183774725),(126,3967614532),(126,1589097164),(126,2441764320),(126,745126750),(126,348450311),(126,2084175962),(126,3357611772),(126,1654631620),(126,3098454302),(126,2029227635),(126,1731761366),(126,2444253995),(126,2906032508),(126,872274856),(126,4282856364),(126,3328013593),(126,4184469063),(126,1074477927),(126,475878802),(126,1341972790),(126,2770374005),(126,4237489391),(126,2818813526),(126,3131100007),(126,4267621199),(126,1031922959),(126,1616292706),(126,630426110),(126,1846388513),(126,2239793094),(126,1660370824),(126,3321716633),(126,2551727033),(126,1836172154),(126,1870881122),(126,3324207484),(126,1065867023),(126,1459310880),(126,1395112921),(126,893552556),(126,1795813847),(126,2544364435),(126,4188602229),(126,1437064809),(126,922605498),(126,4180843510),(126,2554784265),(126,3798404205),(126,1216801552),(126,225525148),(126,274058040),(126,3206796234),(126,610255635),(126,3139895407),(126,3993594441),(126,2078652070),(126,3340749058),(126,2282248923),(126,3201099700),(126,3944887276),(126,887478137),(126,620965629),(126,53639561),(126,687854272),(126,4204526813),(126,3434636086),(126,3859247582),(126,2160451939),(126,419013317),(126,488655959),(126,2224381764),(126,857621694),(126,593880699),(126,1743569168),(126,747100668),(126,2627272664),(126,1477316791),(126,852002855),(126,3813191394),(126,3206482767),(126,2935275735),(126,825997452),(126,4128572079),(126,4149399208),(126,2432005645),(126,945310979),(126,206553734),(126,3381625344),(126,2613891474),(126,1285565060),(126,725086502),(126,2181279565),(126,2136294074),(126,3291030245),(126,3423892574),(126,1818418110),(126,1175554195),(126,231365613),(126,3071984169),(126,1510809703),(126,2304894647),(126,724387218),(126,3702122266),(126,3105745802),(126,3598888791),(126,40599425),(126,4256434691),(126,1198380170),(126,3549401556),(126,2300237909),(126,484124464),(126,3042798728),(126,767973032),(126,4146324303),(126,1493350341),(126,2166736334),(126,3061340275),(126,1468811388),(126,714571165),(126,1958965990),(126,2146366302),(126,2212338847),(126,2088651590),(126,2684538463),(126,2292708505),(126,571001464),(126,608126571),(126,2736309071),(126,1479333754),(126,1794660366),(126,2319975337),(126,1093438481),(126,2975864804),(126,2504416172),(126,3531750290),(126,219666672),(126,4219072870),(126,1053258155),(126,1006288562),(126,1770263986),(126,3089735283),(126,3689334927),(126,2901629603),(126,2019277020),(126,2853333944),(126,1110695191),(126,3884283185),(126,4268093708),(126,159799075),(126,1715997742),(126,1009155269),(126,3922001006),(126,3916338789),(126,1085252167),(126,207705430),(126,1190601026),(126,1441004396),(126,1567147586),(126,964098054),(126,1385174189),(126,3607427007),(126,4065177061),(126,1552830538),(126,3778287701),(126,3986294473),(126,4127238085),(126,1865170325),(126,2161789419),(126,2889615117),(126,785261358),(126,3873733217),(126,2600209543),(126,3958092558),(126,4143434528),(126,3225228598),(126,3451063310),(126,810085901),(126,1502204888),(126,2931931582),(126,1339720903),(126,4093703382),(126,1016897830),(126,1186809094),(126,2269117600),(126,813555736),(126,733475850),(126,305814753),(126,2720553993),(126,212227262),(126,1328958432),(126,3903742053),(126,2617942920),(126,4254367326),(126,2895836413),(126,1090341105),(126,3174277595),(126,639084285),(126,4064195579),(126,2134315289),(126,608843276),(126,4190247440),(126,1090444753),(126,2554275840),(126,2758076506),(126,2518001916),(126,3620157415),(126,1195920681),(126,1822840633),(126,1087551238),(126,235508323),(126,1139244570),(126,810960133),(126,425550269),(126,1767940144),(126,1488780247),(126,1250541405),(126,1715845038),(126,3777612587),(126,2285237154),(126,802817926),(126,4280998710),(126,1108258121),(126,1107026853),(126,2913745362),(126,1129101120),(126,2454813183),(126,1690919006),(126,23973636),(126,293370743),(126,1041759778),(126,3142497267),(126,2920365983),(126,2300359472),(126,885232682),(126,1995817456),(126,3443377157),(126,863919144),(126,1324348692),(126,4019216150),(126,443752815),(126,4223293),(126,1182491637),(126,4257294915),(126,3629776934),(126,582958316),(126,3061655453),(126,1665355533),(126,1929899841),(126,1033949851),(126,2010879266),(126,1872304779),(126,1282102725),(126,3589651214),(126,4095654001),(126,2447713556),(126,2543494532),(126,2069898435),(126,3286503857),(126,2662939963),(126,93111834),(126,3160936308),(126,261262800),(126,141197408),(126,1904512268),(126,3001025754),(126,2247670246),(126,535154833),(126,3476002757),(126,3806439314),(126,1819793014),(126,3545273473),(126,3957652542),(126,3018295592),(126,1367893712),(126,1034338066),(126,3229510223),(126,4276953245),(126,3363858574),(126,2870596766),(126,648526699),(126,3627085975),(126,1585047995),(126,1960922033),(126,748737253),(126,1175066615),(126,1318322018),(126,260367662),(126,643741484),(126,1013706048),(126,1726352130),(126,2222354404),(126,1327031463),(126,1131865044),(126,839200087),(126,1407668396),(126,3548333318),(126,237845721),(126,3056051791),(126,747235328),(126,172675174),(126,2781705803),(126,2111348799),(126,3067187587),(126,618638032),(126,3369756381),(126,2232055662),(126,55113216),(126,3939915090),(126,2586983921),(126,3286008345),(126,1956055310),(126,740042513),(126,2282536358),(126,1863122946),(126,1296880981),(126,2589434346),(126,1621393368),(126,39250009),(126,72263924),(126,1587391050),(126,847186998),(126,2455499024),(126,859347884),(126,2244795234),(126,64890532),(126,3205264287),(126,3543922970),(126,4074251872),(126,1352059222),(126,3619463265),(126,875385393),(126,3421395586),(126,3044515296),(126,3924888977),(126,1697117306),(126,3406763364),(126,1129505049) ON DUPLICATE KEY UPDATE id=id |
9.861 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
285 | 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 |
9.361 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
7.454 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
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`) |
3.663 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>=991 AND c.nright<=992 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 |
3.234 ms | 35870087236 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
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>=991 AND c.nright<=992 GROUP BY p.id_product) p |
2.311 ms | 35870087236 | /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.298 ms | 0 | /classes/Hook.php:1292 | ||
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.140 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
311 | 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') |
2.105 ms | 1 | /classes/ObjectModel.php:622 | ||
324 | 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.855 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
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.834 ms | 386 | /classes/Hook.php:456 | ||
320 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 359566930, 'https://cadeaufou.com/698-cagoules-et-masques', 1, 2, 1, 698, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.508 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
315 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('897327', '7472', '752115218', '', '1', '1', '2023-11-30 12:04:35') |
1.481 ms | 1 | /classes/ObjectModel.php:622 | ||
171 | 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 (66398,66406,117734,130097,130385,130392,146451,238150) |
1.160 ms | 8 | /classes/ProductAssembler.php:95 | ||
316 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('895038', '', 'cadeaufou.com/698-cagoules-et-masques', '', '2023-11-30 12:04:35') |
1.116 ms | 1 | /classes/ObjectModel.php:622 | ||
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` < 991) AND (a0.`nright` > 992) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.043 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.965 ms | 880 | /classes/Hook.php:1332 | ||
287 | 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 (66398) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.961 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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` = 698 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.926 ms | 1 | Yes | Yes | /classes/Category.php:921 |
286 | 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.846 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` < 991) AND (a0.`nright` > 992) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.827 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
290 | 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 (66406) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.797 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.767 ms | 880 | /classes/Hook.php:1292 | ||
258 | 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` = 130392) AND (b.`id_shop` = 1) LIMIT 1 |
0.729 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
292 | 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 (130097) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.715 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
246 | 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` = 66406) AND (b.`id_shop` = 1) LIMIT 1 |
0.704 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
319 | 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.689 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
261 | 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` = 146451) AND (b.`id_shop` = 1) LIMIT 1 |
0.682 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
255 | 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` = 130385) AND (b.`id_shop` = 1) LIMIT 1 |
0.640 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
291 | 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 (117734) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.637 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
182 | 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` = 66398 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` = 66398 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.615 ms | 0 | /classes/Cart.php:1410 | ||
303 | 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.601 ms | 25 | Yes | Yes | /classes/CMS.php:184 |
295 | 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 (146451) 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 |
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` = 146451 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` = 146451 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.596 ms | 0 | /classes/Cart.php:1410 | ||
280 | 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.588 ms | 7 | Yes | Yes | /modules/zonemegamenu/classes/ZMenu.php:104 |
183 | 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 = 66398 ORDER BY f.position ASC |
0.586 ms | 1 | Yes | /classes/Product.php:5993 | |
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` = 130392 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` = 130392 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.580 ms | 0 | /classes/Cart.php:1410 | ||
259 | 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` = 130392 ORDER BY `position` |
0.578 ms | 2 | Yes | /classes/Product.php:3545 | |
243 | 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` = 66398) AND (b.`id_shop` = 1) LIMIT 1 |
0.571 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
252 | 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` = 130097) AND (b.`id_shop` = 1) LIMIT 1 |
0.566 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
247 | 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` = 66406 ORDER BY `position` |
0.557 ms | 3 | Yes | /classes/Product.php:3545 | |
293 | 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 (130385) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.553 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
296 | 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 (238150) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.550 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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.549 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
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.547 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
249 | 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` = 117734) AND (b.`id_shop` = 1) LIMIT 1 |
0.547 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
253 | 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` = 130097 ORDER BY `position` |
0.547 ms | 3 | Yes | /classes/Product.php:3545 | |
314 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 698 LIMIT 1 |
0.544 ms | 1 | /classes/Page.php:83 | ||
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.541 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
262 | 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` = 146451 ORDER BY `position` |
0.533 ms | 1 | Yes | /classes/Product.php:3545 | |
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.521 ms | 81 | /classes/module/Module.php:345 | ||
264 | 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` = 238150) AND (b.`id_shop` = 1) LIMIT 1 |
0.521 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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` = 238150 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` = 238150 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.511 ms | 0 | /classes/Cart.php:1410 | ||
294 | 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 (130392) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.509 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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 = 238150 ORDER BY f.position ASC |
0.499 ms | 1 | Yes | /classes/Product.php:5993 | |
201 | 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` = 117734 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` = 117734 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.496 ms | 0 | /classes/Cart.php:1410 | ||
202 | 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 = 117734 ORDER BY f.position ASC |
0.489 ms | 1 | Yes | /classes/Product.php:5993 | |
265 | 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` = 238150 ORDER BY `position` |
0.487 ms | 1 | Yes | /classes/Product.php:3545 | |
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` = 130385 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` = 130385 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.483 ms | 0 | /classes/Cart.php:1410 | ||
209 | 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` = 130097 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` = 130097 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.482 ms | 0 | /classes/Cart.php:1410 | ||
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 = 130392 ORDER BY f.position ASC |
0.481 ms | 1 | Yes | /classes/Product.php:5993 | |
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.479 ms | 81 | /classes/module/Module.php:345 | ||
250 | 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` = 117734 ORDER BY `position` |
0.473 ms | 3 | Yes | /classes/Product.php:3545 | |
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` = 66406 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` = 66406 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.472 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.469 ms | 5 | /classes/CartRule.php:357 | ||
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.463 ms | 1 | /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.456 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
210 | 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 = 130097 ORDER BY f.position ASC |
0.453 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 = 66406 ORDER BY f.position ASC |
0.446 ms | 1 | Yes | /classes/Product.php:5993 | |
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 = 130385 ORDER BY f.position ASC |
0.444 ms | 1 | Yes | /classes/Product.php:5993 | |
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 = 146451 ORDER BY f.position ASC |
0.442 ms | 1 | Yes | /classes/Product.php:5993 | |
244 | 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` = 66398 ORDER BY `position` |
0.441 ms | 1 | Yes | /classes/Product.php:3545 | |
256 | 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` = 130385 ORDER BY `position` |
0.440 ms | 2 | Yes | /classes/Product.php:3545 | |
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.402 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
306 | 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.402 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` = 238150) |
0.400 ms | 1 | /classes/Product.php:3857 | ||
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.395 ms | 6 | /classes/CartRule.php:418 | ||
312 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 897327 AND `date_add` > '2023-11-30 11:34:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.395 ms | 1 | Yes | /classes/Connection.php:168 | |
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.393 ms | 5 | /classes/CartRule.php:357 | ||
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.392 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
165 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 698 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.388 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
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.383 ms | 81 | /classes/module/Module.php:345 | ||
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.381 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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` = 238150 AND image_shop.`cover` = 1 LIMIT 1 |
0.381 ms | 1 | /classes/Product.php:3570 | ||
184 | 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` = 66406 AND image_shop.`cover` = 1 LIMIT 1 |
0.374 ms | 3 | /classes/Product.php:3570 | ||
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.368 ms | 1 | /classes/Currency.php:1136 | ||
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.366 ms | 1 | /classes/Customer.php:475 | ||
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.366 ms | 1 | /classes/Customer.php:503 | ||
284 | 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.362 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` = 698) AND (b.`id_shop` = 1) LIMIT 1 |
0.360 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
308 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.350 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
172 | 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` = 66398 AND image_shop.`cover` = 1 LIMIT 1 |
0.341 ms | 1 | /classes/Product.php:3570 | ||
304 | 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.335 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.330 ms | 1 | Yes | /classes/Currency.php:709 | |
176 | 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` = 66398) |
0.330 ms | 1 | /classes/Product.php:3857 | ||
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.321 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
305 | 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.318 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 698 AND ctg.`id_group` = 1 LIMIT 1 |
0.316 ms | 1 | /classes/Category.php:1751 | ||
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` = 146451 AND image_shop.`cover` = 1 LIMIT 1 |
0.314 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.312 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
211 | 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` = 130385 AND image_shop.`cover` = 1 LIMIT 1 |
0.312 ms | 2 | /classes/Product.php:3570 | ||
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.311 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.302 ms | 1 | /classes/Language.php:1216 | ||
203 | 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` = 130097 AND image_shop.`cover` = 1 LIMIT 1 |
0.302 ms | 3 | /classes/Product.php:3570 | ||
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.301 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
170 | SELECT SQL_NO_CACHE data FROM ps21_layered_filter_block WHERE hash="f7749d472cac5ce3b78f287271746279" LIMIT 1 |
0.301 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:186 | ||
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` = 117734 AND image_shop.`cover` = 1 LIMIT 1 |
0.300 ms | 3 | /classes/Product.php:3570 | ||
263 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 146451 |
0.296 ms | 1 | /classes/Product.php:2902 | ||
297 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.295 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
240 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 238150) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.291 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` = 66406) |
0.289 ms | 1 | /classes/Product.php:3857 | ||
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` = 130385) |
0.289 ms | 1 | /classes/Product.php:3857 | ||
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` = 146451) |
0.287 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.285 ms | 1 | /classes/Customer.php:503 | ||
254 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 130097 |
0.285 ms | 1 | /classes/Product.php:2902 | ||
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` = 130392 AND image_shop.`cover` = 1 LIMIT 1 |
0.284 ms | 2 | /classes/Product.php:3570 | ||
197 | 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` = 117734) |
0.282 ms | 1 | /classes/Product.php:3857 | ||
205 | 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` = 130097) |
0.279 ms | 1 | /classes/Product.php:3857 | ||
318 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.279 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.278 ms | 10 | Yes | /classes/ImageType.php:109 | |
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.278 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
307 | 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.276 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
232 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 146451) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.275 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
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` = 130392) |
0.274 ms | 1 | /classes/Product.php:3857 | ||
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.273 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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` = 698) LIMIT 1 |
0.268 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.264 ms | 1 | /classes/Language.php:1080 | ||
230 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 146451 AND id_shop=1 LIMIT 1 |
0.260 ms | 1 | /classes/Product.php:6848 | ||
224 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 130392) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.259 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.258 ms | 10 | Yes | /classes/ImageType.php:109 | |
268 | 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.256 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.255 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
298 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.254 ms | 1 | /classes/module/Module.php:2636 | ||
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.253 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.249 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
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.249 ms | 1 | /classes/order/Order.php:881 | ||
310 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.248 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
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.247 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
267 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.246 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
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.244 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
180 | 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.244 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
270 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.244 ms | 1 | /classes/module/Module.php:2636 | ||
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.241 ms | 1 | /classes/Customer.php:475 | ||
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.238 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
313 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.234 ms | 1 | /classes/Page.php:104 | ||
216 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 130385) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.234 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
161 | SELECT SQL_NO_CACHE id_zcolorsfonts FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.228 ms | 1 | /modules/zonecolorsfonts/classes/ZColorsFonts.php:118 | ||
302 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.221 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
300 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.220 ms | 1 | /classes/module/Module.php:2636 | ||
276 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.219 ms | 1 | /classes/module/Module.php:2636 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-11-30 12:04:00' AND date_from <= '2023-11-30 14:04:00') OR (date_to >= '2023-11-30 12:04:00' AND date_to <= '2023-11-30 14:04:00'); |
0.216 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.215 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:04:00' OR date_to<'2023-11-30 12:04:00'; |
0.214 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
200 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 117734) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.214 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.211 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
271 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.211 ms | 1 | /classes/module/Module.php:2109 | ||
277 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.208 ms | 1 | /classes/module/Module.php:2109 | ||
281 | 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.208 ms | 8 | Yes | /modules/zonemegamenu/classes/ZMenu.php:232 | |
126 | SELECT SQL_NO_CACHE * FROM `ps21_group_lang` WHERE `id_group` = 1 |
0.208 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
282 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.208 ms | 1 | /classes/module/Module.php:2636 | ||
301 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.208 ms | 1 | /classes/module/Module.php:2109 | ||
16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.207 ms | 88 | /classes/Hook.php:287 | ||
245 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 66398 |
0.207 ms | 1 | /classes/Product.php:2902 | ||
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.206 ms | 1 | /classes/shop/Shop.php:218 | ||
41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.205 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
167 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 698 AND `id_shop` = 1 |
0.205 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.204 ms | 88 | /classes/Hook.php:339 | ||
257 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 130385 |
0.204 ms | 1 | /classes/Product.php:2902 | ||
131 | SELECT SQL_NO_CACHE value FROM `ps21_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.204 ms | 1 | /classes/shop/Shop.php:1183 | ||
173 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps21_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 636 LIMIT 1 |
0.199 ms | 1 | /classes/Category.php:1375 | ||
269 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.199 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
162 | SELECT SQL_NO_CACHE * FROM `ps21_zcolorsfonts` a WHERE (a.`id_zcolorsfonts` = 1) LIMIT 1 |
0.196 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
309 | SELECT SQL_NO_CACHE `save_time` FROM `ps21_zpopupnewsletter` WHERE `id_shop` = 1 AND `active` = 1 LIMIT 1 |
0.195 ms | 1 | /modules/zonepopupnewsletter/classes/ZPopupNewsletter.php:78 | ||
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.194 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
208 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 130097) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.194 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
164 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.194 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
260 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 130392 |
0.192 ms | 1 | /classes/Product.php:2902 | ||
146 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_legalcompliance" LIMIT 1 |
0.191 ms | 0 | /classes/module/Module.php:2636 | ||
278 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.190 ms | 1 | /classes/module/Module.php:2636 | ||
251 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 117734 |
0.189 ms | 1 | /classes/Product.php:2902 | ||
130 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.188 ms | 1 | /classes/Language.php:883 | ||
274 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.188 ms | 1 | /classes/module/Module.php:2636 | ||
151 | SELECT SQL_NO_CACHE * FROM `ps21_country` a 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.185 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
181 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 66398) 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 | ||
7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.184 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.184 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
288 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.182 ms | 1 | /classes/module/Module.php:2636 | ||
21 | SELECT SQL_NO_CACHE * FROM `ps21_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.180 ms | 1 | /classes/module/Module.php:2018 | ||
248 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 66406 |
0.178 ms | 1 | /classes/Product.php:2902 | ||
150 | SELECT SQL_NO_CACHE `need_identification_number` FROM `ps21_country` WHERE `id_country` = 8 LIMIT 1 |
0.177 ms | 1 | /classes/Country.php:402 | ||
191 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 66406) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.177 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
138 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` |
0.176 ms | 10 | /classes/ImageType.php:161 | ||
272 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.175 ms | 1 | /classes/module/Module.php:2636 | ||
132 | SELECT SQL_NO_CACHE c.id_currency FROM `ps21_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.171 ms | 1 | /classes/Currency.php:893 | ||
266 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 238150 |
0.171 ms | 1 | /classes/Product.php:2902 | ||
299 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.170 ms | 1 | /classes/module/Module.php:2109 | ||
220 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 698 LIMIT 1 |
0.168 ms | 1 | /classes/Product.php:5639 | ||
64 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 4 |
0.167 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
156 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.167 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
195 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 698 LIMIT 1 |
0.166 ms | 1 | /classes/Product.php:5639 | ||
147 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.163 ms | 0 | /classes/module/Module.php:2109 | ||
212 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 698 LIMIT 1 |
0.162 ms | 1 | /classes/Product.php:5639 | ||
289 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.162 ms | 1 | /classes/module/Module.php:2109 | ||
54 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.161 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
198 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 117734 AND id_shop=1 LIMIT 1 |
0.161 ms | 1 | /classes/Product.php:6848 |