21,88 €
Chargeurs Gaming
Il y a 4 produits.
Il y a 4 produits.
Load Time | 512.550 ms |
Querying Time | 116 ms |
Queries | 264 |
Memory Peak Usage | 23.3 Mb |
Included Files | 1262 files - 11.88 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 | enabled |
Smarty Compilation | force compile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 5.695 ms | 5.695 ms | 8.54 Mb | 9.2 Mb |
__construct | 9.284 ms | 14.979 ms | 1.73 Mb | 11.9 Mb |
config | 30.700 ms | 45.679 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.030 ms | 45.709 ms | - Mb | 11.9 Mb |
init | 27.668 ms | 73.377 ms | 2.13 Mb | 14.8 Mb |
checkAccess | 0.001 ms | 73.378 ms | - Mb | 14.8 Mb |
setMedia | 2.413 ms | 75.791 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.001 ms | 75.792 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 75.793 ms | - Mb | 14.8 Mb |
initContent | 130.678 ms | 206.471 ms | 4.20 Mb | 19.0 Mb |
initFooter | 0.003 ms | 206.474 ms | - Mb | 19.0 Mb |
display | 306.076 ms | 512.550 ms | 4.63 Mb | 23.3 Mb |
Hook | Time | Memory Usage |
---|---|---|
ActionDispatcherBefore | 43.125 ms | 3.09 Mb |
ActionOutputHTMLBefore | 36.638 ms | 0.17 Mb |
displayProductListReviews | 26.633 ms | 1.29 Mb |
displayLeftColumn | 25.228 ms | 0.74 Mb |
displayTop | 14.755 ms | 0.20 Mb |
DisplayFooter | 11.404 ms | 0.11 Mb |
DisplayBeforeBodyClosingTag | 11.041 ms | 0.27 Mb |
ActionDispatcher | 10.012 ms | 0.70 Mb |
displayFooterRight | 3.954 ms | 0.07 Mb |
DisplayHeader | 3.228 ms | 0.06 Mb |
DisplayLeftColumn | 1.616 ms | 0.02 Mb |
ActionFrontControllerSetVariables | 1.219 ms | 0.06 Mb |
displayNav2 | 1.098 ms | 0.08 Mb |
displayFooterLeft | 1.027 ms | 0.06 Mb |
DisplayOutsideMainPage | 0.746 ms | 0.03 Mb |
ActionFrontControllerSetMedia | 0.619 ms | 0.01 Mb |
DisplayFooterLeft | 0.415 ms | 0.01 Mb |
DisplayFooterAfter | 0.394 ms | 0.01 Mb |
DisplayFooterRight | 0.376 ms | 0.01 Mb |
ProductSearchProvider | 0.371 ms | - Mb |
DisplaySidebarNavigation | 0.317 ms | - Mb |
DisplayNavFullWidth | 0.309 ms | 0.01 Mb |
DisplayBanner | 0.293 ms | 0.01 Mb |
DisplayNav1 | 0.204 ms | 0.01 Mb |
ActionObjectAddAfter | 0.068 ms | - Mb |
ModuleRoutes | 0.020 ms | 0.02 Mb |
DisplayFooterBefore | 0.014 ms | - Mb |
DisplayAfterBodyOpeningTag | 0.013 ms | - Mb |
ActionFrontControllerInitAfter | 0.013 ms | - Mb |
29 hook(s) | 195.150 ms | 7.05 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 5.142 ms | 0.54 Mb |
jprestaspeedpack | 90.899 ms | 4.03 Mb |
blockreassurance | 1.102 ms | 0.09 Mb |
blockwishlist | 11.736 ms | 0.13 Mb |
ps_emailsubscription | 4.108 ms | 0.10 Mb |
ps_socialfollow | 1.143 ms | 0.07 Mb |
ps_emailalerts | 0.163 ms | 0.09 Mb |
zonethememanager | 13.191 ms | 1.30 Mb |
ps_shoppingcart | 10.152 ms | 0.11 Mb |
ps_searchbar | 1.760 ms | 0.14 Mb |
productcomments | 26.874 ms | 1.32 Mb |
ps_googleanalytics | 4.396 ms | 0.05 Mb |
zonecolorsfonts | 1.249 ms | 0.06 Mb |
zonemegamenu | 1.988 ms | 0.06 Mb |
prestastripe | 0.773 ms | 0.02 Mb |
ps_facetedsearch | 2.085 ms | 0.10 Mb |
ps_languageselector | 0.873 ms | 0.06 Mb |
ps_currencyselector | 0.466 ms | 0.06 Mb |
ps_customersignin | 3.351 ms | 0.08 Mb |
ps_categorytree | 25.387 ms | 0.75 Mb |
zonecolumnblocks | 0.692 ms | 0.11 Mb |
zonepopupnewsletter | 0.532 ms | 0.03 Mb |
statsdata | 6.908 ms | 0.27 Mb |
23 module(s) | 214.971 ms | 9.57 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
258 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (251,803264849),(251,94201498),(251,1435170492),(251,1289214159),(251,1785617407),(251,2936477779),(251,1727466530),(251,1432532875),(251,1025009294),(251,1804081323),(251,3479716883),(251,66301815),(251,537553573),(251,3045727500),(251,3231073010),(251,1825096520),(251,3225262556),(251,2645763144),(251,2027619899),(251,786864081),(251,1849360992),(251,294428854),(251,3774376179),(251,2880678980),(251,114155291),(251,2929321318),(251,2087307803),(251,2369020978),(251,1152186767),(251,4222788516),(251,2858566420),(251,848840972),(251,4147554351),(251,770698498),(251,2244011448),(251,477004582),(251,3610318732),(251,1070190107),(251,937307692),(251,25761885),(251,3366890060),(251,3483396593),(251,392306519),(251,909258745),(251,179865882),(251,3099645137),(251,3371246540),(251,2390640699),(251,501027234),(251,3032495894),(251,2100541971),(251,2793494280),(251,180908336),(251,1192985740),(251,1972034646),(251,2419117650),(251,3803768817),(251,4265874642),(251,67723771),(251,3423129237),(251,3399895114),(251,3221089548),(251,2990154896),(251,2728213885),(251,933991437),(251,2513627470),(251,468067826),(251,4137721533),(251,1552016987),(251,4080301755),(251,4245349388),(251,1973472416),(251,1839057912),(251,3745041382),(251,3035734567),(251,3719469943),(251,3466131047),(251,679558129),(251,462819688),(251,4267553191),(251,518809702),(251,3303811122),(251,2883778317),(251,1694893476),(251,3287268691),(251,3711637102),(251,698879415),(251,885817714),(251,125306139),(251,1634619674),(251,58280175),(251,3363778289),(251,1161663254),(251,201135304),(251,288600709),(251,1021330335),(251,2858809635),(251,2763627026),(251,3717400459),(251,4125370705),(251,3997906175),(251,4162316513),(251,3219397995),(251,2539165674),(251,1046234598),(251,787652129),(251,1595426297),(251,4184932827),(251,1985552396),(251,1944795689),(251,3799916950),(251,1827123668),(251,1447744642),(251,1636796806),(251,2645405926),(251,1474595477),(251,3375525138),(251,3902077767),(251,3507415422),(251,2781072282),(251,2002273313),(251,3164880625),(251,2490789905),(251,1000843653),(251,48947005),(251,3883347157),(251,3700474777),(251,4264269047),(251,2125390191),(251,4270481046),(251,1693150473),(251,343450730),(251,381351735),(251,2863449446),(251,3772294966),(251,3877457961),(251,1492116830),(251,4041511410),(251,828132466),(251,4090211224),(251,2185737194),(251,3517149926),(251,647687838),(251,733479784),(251,1440916471),(251,3262261204),(251,1872100372),(251,2092461357),(251,3357609169),(251,2365529006),(251,1263061406),(251,2296732656),(251,534196217),(251,482025419),(251,2811467352),(251,2488480532),(251,3501473861),(251,1917272649),(251,1878317490),(251,1789511633),(251,956713705),(251,89981727),(251,1143557322),(251,2749361789),(251,3857194488),(251,1024086260),(251,26040876),(251,1804243295),(251,2165251395),(251,1281618245),(251,2793993627),(251,426054238),(251,3398682121),(251,1025101115),(251,2974984653),(251,2214325187),(251,997821910),(251,2005463392),(251,3252396061),(251,942332382),(251,3816934055),(251,1661692647),(251,975758589),(251,3974931321),(251,2301364099),(251,855746680),(251,637832447),(251,3938675492),(251,508940865),(251,911480697),(251,1283363269),(251,3552869238),(251,2961923901),(251,3747234531),(251,3155646160),(251,3164668199),(251,2271068282),(251,84354396),(251,2915068863),(251,4064530110),(251,3216991891),(251,2045363644),(251,2664176477),(251,1076722390),(251,505410826),(251,3544422162),(251,2506779464),(251,2552384108),(251,876907216),(251,82980331),(251,3890150098),(251,3475437886),(251,2302280848),(251,1133144647),(251,801167173),(251,2059315716),(251,3139619822),(251,2937007520),(251,1589371182),(251,693370988),(251,2708427394),(251,1007456900),(251,610735313),(251,3846627131),(251,2031830639),(251,1908602231),(251,1401333655),(251,378101424),(251,996218346),(251,660881695),(251,2938384267),(251,4250264855),(251,1895305721),(251,502965417),(251,1982471117),(251,2524144246),(251,2774996218),(251,1068709096),(251,4077513867),(251,2900588200),(251,465472731),(251,4139839450),(251,2360011682),(251,4211248848),(251,283341417),(251,4165214622),(251,3508523596),(251,234404923),(251,2782693783),(251,3413880379),(251,3540168379),(251,861653603),(251,3160995915),(251,1391251310),(251,2106651858),(251,3572623339),(251,4629984),(251,2488722736),(251,3486510944),(251,2675016634),(251,2165907305),(251,136687257),(251,3540179561),(251,2792526429),(251,2220600372),(251,2914585448),(251,3882733113),(251,1688090355),(251,3534950496),(251,1182870252),(251,412601709),(251,574969182),(251,2970413814),(251,1487282505),(251,3228977345),(251,2023459642),(251,3291711134),(251,2792891444),(251,3335276918),(251,502111155),(251,1347492703),(251,2832080533),(251,1215320197),(251,2317239205),(251,1931846913),(251,1721014625),(251,738600257),(251,2998338424),(251,1207945902),(251,734241479),(251,3324570843),(251,4126771257),(251,1712456575),(251,3169253733),(251,1160958045),(251,1130949510),(251,3116084871),(251,269178051),(251,24773614),(251,3204450510),(251,3468662336),(251,1808444077),(251,4095410992),(251,1012520131),(251,2367920745),(251,2603361072),(251,2741539031),(251,607507456),(251,616165826),(251,2288576869),(251,4252798532),(251,2692385638),(251,4100315394),(251,3061254709),(251,1657292258),(251,2148967437),(251,1248236410),(251,2457219175),(251,1920985790),(251,1340703149),(251,1618471777),(251,4160689201),(251,1822364967),(251,479188821),(251,1661785323),(251,4137484009),(251,2636427258),(251,1499247737),(251,2061922205),(251,665830591),(251,916194615),(251,495595719),(251,3026469794),(251,1845449656),(251,4078122428),(251,2044505385),(251,3156749269),(251,3919036276),(251,204613135),(251,605377709),(251,766051911),(251,30400764),(251,4211022030),(251,715827285),(251,1092948871),(251,610201349),(251,1023110113),(251,3379323545),(251,2591028766),(251,1994095466),(251,33157726),(251,198243957),(251,2540831776),(251,1707019604),(251,2730046909),(251,4101073252),(251,207761914),(251,2750534087),(251,980926717),(251,377071036),(251,2983490672),(251,584353846),(251,1743688562),(251,3223058413),(251,1665991311),(251,3093731065),(251,1095877807),(251,1085889875),(251,2059985562),(251,3618062925),(251,592374860),(251,4217863027),(251,3425247989),(251,1636391408),(251,1698766782),(251,2162739858),(251,1538367880),(251,3760626336),(251,1987713032),(251,2338874856),(251,4206689645),(251,1723372602),(251,2788329276),(251,2095305502),(251,3135330775),(251,2402748468),(251,24058172),(251,4000683245),(251,315670382),(251,2558276906),(251,1745365471),(251,2782569384),(251,3422117706),(251,552626444),(251,1506232339),(251,2933163456),(251,1483801350),(251,1400586123),(251,3746875726),(251,2604810181),(251,2905930158),(251,803588046),(251,1651400661),(251,1431243585),(251,1586185269),(251,4110009762),(251,3647374073),(251,4196158832),(251,644435096),(251,1862966990),(251,2098775956),(251,4045847707),(251,3122054119),(251,1971194991),(251,2149367276),(251,1888540635),(251,2660577125),(251,2508340497),(251,196341346),(251,1790101800),(251,1054130805),(251,2741947598),(251,1292400575),(251,545037028),(251,1516477184),(251,2706799993),(251,562470873),(251,2591346466),(251,613023703),(251,2725609989),(251,2082081559),(251,572560232),(251,2833489058),(251,1999611979),(251,1938789650),(251,2958717166),(251,1035708154),(251,2025067287),(251,3804047398),(251,248028803),(251,4243412966),(251,628124381),(251,1271215494),(251,2140466223),(251,1298495884),(251,3585931255),(251,532975694),(251,892763084),(251,203145038),(251,470924714),(251,1460516495),(251,2732318442),(251,3996868778),(251,862206445),(251,3193479021),(251,3382171736),(251,3362897893),(251,3598913121),(251,1342337107),(251,3202829344),(251,1335223071),(251,270790954),(251,1086966479),(251,484642328),(251,4274468042),(251,1740107684),(251,2117688527),(251,1393082718),(251,366510022),(251,341328174),(251,1469264429),(251,968691010),(251,3210232788),(251,809700252),(251,3705477223),(251,1639200307),(251,3585776886),(251,3305319229),(251,1052899681),(251,2176267881),(251,357387863),(251,451177334),(251,677589039),(251,1181390953),(251,898241702),(251,3480303789),(251,1736215096),(251,2511740146),(251,2560762429),(251,1570623991),(251,897080848),(251,891021207),(251,2807843172),(251,411231410),(251,2413680770),(251,519468981),(251,1898829954),(251,4274422817),(251,2781196321),(251,433695516),(251,1652336127),(251,4200438598),(251,3032893805),(251,341146430),(251,755973553),(251,2183774725),(251,3967614532),(251,1589097164),(251,2441764320),(251,745126750),(251,348450311),(251,2084175962),(251,3357611772),(251,1654631620),(251,3098454302),(251,2029227635),(251,1731761366),(251,2444253995),(251,2906032508),(251,872274856),(251,4282856364),(251,3328013593),(251,4184469063),(251,1074477927),(251,475878802),(251,1341972790),(251,2770374005),(251,4237489391),(251,2818813526),(251,3131100007),(251,4267621199),(251,1031922959),(251,1616292706),(251,630426110),(251,1846388513),(251,2239793094),(251,1660370824),(251,3321716633),(251,2551727033),(251,1836172154),(251,1870881122),(251,3324207484),(251,1065867023),(251,1459310880),(251,1395112921),(251,893552556),(251,1795813847),(251,2544364435),(251,4188602229),(251,1437064809),(251,922605498),(251,4180843510),(251,2554784265),(251,3798404205),(251,1216801552),(251,225525148),(251,274058040),(251,3206796234),(251,610255635),(251,3139895407),(251,3993594441),(251,2078652070),(251,3340749058),(251,2282248923),(251,3201099700),(251,3944887276),(251,887478137),(251,620965629),(251,53639561),(251,687854272),(251,4204526813),(251,3434636086),(251,3859247582),(251,2160451939),(251,419013317),(251,488655959),(251,2224381764),(251,857621694),(251,593880699),(251,1743569168),(251,747100668),(251,2627272664),(251,1477316791),(251,852002855),(251,3813191394),(251,3206482767),(251,2935275735),(251,825997452),(251,4128572079),(251,4149399208),(251,2432005645),(251,945310979),(251,206553734),(251,3381625344),(251,2613891474),(251,1285565060),(251,725086502),(251,2181279565),(251,2136294074),(251,531227063),(251,3291030245),(251,3423892574),(251,1818418110),(251,1175554195),(251,231365613),(251,3071984169),(251,1510809703),(251,2304894647),(251,724387218),(251,3702122266),(251,3105745802),(251,3598888791),(251,40599425),(251,4256434691),(251,1198380170),(251,3549401556),(251,2300237909),(251,484124464),(251,3042798728),(251,767973032),(251,4146324303),(251,1493350341),(251,2166736334),(251,3061340275),(251,1468811388),(251,714571165),(251,1958965990),(251,2146366302),(251,2212338847),(251,2088651590),(251,2684538463),(251,2292708505),(251,571001464),(251,608126571),(251,2736309071),(251,1479333754),(251,1794660366),(251,2319975337),(251,1093438481),(251,2975864804),(251,2504416172),(251,3531750290),(251,219666672),(251,4219072870),(251,1053258155),(251,2382983142),(251,1006288562),(251,1770263986),(251,3089735283),(251,3689334927),(251,2901629603),(251,2019277020),(251,2853333944),(251,1110695191),(251,3884283185),(251,4268093708),(251,159799075),(251,1715997742),(251,1009155269),(251,3922001006),(251,3916338789),(251,1085252167),(251,207705430),(251,1190601026),(251,1441004396),(251,1567147586),(251,964098054),(251,1385174189),(251,3607427007),(251,4065177061),(251,1552830538),(251,3778287701),(251,3986294473),(251,4127238085),(251,1865170325),(251,2161789419),(251,2889615117),(251,785261358),(251,3873733217),(251,2600209543),(251,3958092558),(251,4143434528),(251,3225228598),(251,3451063310),(251,810085901),(251,1502204888),(251,2931931582),(251,1339720903),(251,4093703382),(251,1016897830),(251,1186809094),(251,2269117600),(251,813555736),(251,733475850),(251,305814753),(251,2720553993),(251,212227262),(251,1328958432),(251,3903742053),(251,2617942920),(251,4254367326),(251,2895836413),(251,1090341105),(251,3174277595),(251,639084285),(251,4064195579),(251,2134315289),(251,608843276),(251,4190247440),(251,1090444753),(251,2554275840),(251,2758076506),(251,2518001916),(251,3620157415),(251,1195920681),(251,1822840633),(251,1087551238),(251,235508323),(251,1139244570),(251,810960133),(251,425550269),(251,1767940144),(251,1488780247),(251,1250541405),(251,1715845038),(251,3777612587),(251,2285237154),(251,802817926),(251,4280998710),(251,1108258121),(251,1107026853),(251,2913745362),(251,1129101120),(251,2454813183),(251,1690919006),(251,23973636),(251,293370743),(251,1041759778),(251,3142497267),(251,2920365983),(251,2300359472),(251,885232682),(251,1995817456),(251,3443377157),(251,863919144),(251,1324348692),(251,4019216150),(251,443752815),(251,4223293),(251,1182491637),(251,4257294915),(251,3629776934),(251,582958316),(251,3061655453),(251,1665355533),(251,1929899841),(251,1033949851),(251,2010879266),(251,1872304779),(251,1282102725),(251,3589651214),(251,4095654001),(251,2447713556),(251,2543494532),(251,2069898435),(251,3286503857),(251,2662939963),(251,93111834),(251,3160936308),(251,261262800),(251,141197408),(251,1904512268),(251,3001025754),(251,2247670246),(251,535154833),(251,3476002757),(251,3806439314),(251,1819793014),(251,3545273473),(251,3957652542),(251,3018295592),(251,1367893712),(251,1034338066),(251,3229510223),(251,4276953245),(251,3363858574),(251,2870596766),(251,648526699),(251,3627085975),(251,1585047995),(251,1960922033),(251,748737253),(251,1175066615),(251,1318322018),(251,260367662),(251,643741484),(251,1013706048),(251,1726352130),(251,2222354404),(251,1327031463),(251,1131865044),(251,839200087),(251,1407668396),(251,3548333318),(251,237845721),(251,3056051791),(251,747235328),(251,172675174),(251,2781705803),(251,2111348799),(251,3067187587),(251,618638032),(251,3369756381),(251,2232055662),(251,55113216),(251,3939915090),(251,2586983921),(251,3286008345),(251,1956055310),(251,740042513),(251,2282536358),(251,1863122946),(251,1296880981),(251,2589434346),(251,1621393368),(251,39250009),(251,72263924),(251,1587391050),(251,847186998),(251,2455499024),(251,859347884),(251,2244795234),(251,64890532),(251,1058634223),(251,2350596910),(251,3376513262),(251,884861680),(251,3924888977),(251,1697117306),(251,3406763364),(251,1129505049) ON DUPLICATE KEY UPDATE id=id |
9.174 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
235 | 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 |
8.112 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`) |
3.306 ms | 1298 | /classes/Configuration.php:180 | ||
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 |
3.298 ms | 386 | /classes/Hook.php:456 | ||
165 | 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>=769 AND c.nright<=770 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.249 ms | 46330840516 | Yes | /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` |
3.215 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
166 | 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>=769 AND c.nright<=770 GROUP BY p.id_product) p |
2.963 ms | 46330840516 | /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.590 ms | 0 | /classes/Hook.php:1292 | ||
259 | 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.716 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
170 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-12-01 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 (77796,78384,212471,268587) |
1.456 ms | 4 | /classes/ProductAssembler.php:95 | ||
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
1.382 ms | 880 | /classes/Hook.php:1332 | ||
250 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('920124', '3396', '751134203', '', '1', '1', '2023-12-01 11:50:51') |
1.328 ms | 1 | /classes/ObjectModel.php:622 | ||
255 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 1219444328, 'https://cadeaufou.com/670-chargeurs-gaming', 1, 2, 1, 670, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.288 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
246 | 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.267 ms | 1 | /classes/ObjectModel.php:622 | ||
251 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('917833', '', 'cadeaufou.com/670-chargeurs-gaming', '', '2023-12-01 11:50:51') |
1.260 ms | 1 | /classes/ObjectModel.php:622 | ||
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` < 769) AND (a0.`nright` > 770) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.219 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
169 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("51d1e0c322ebcffb63b8da7df99a687b", "a:1:{s:7:\"filters\";a:0:{}}") |
1.200 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
161 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 769) AND (a0.`nright` > 770) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.165 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.070 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
261 | DELETE FROM `ps21_jm_pagecache` WHERE id IN (102882) |
1.015 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
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` = 670 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.989 ms | 1 | Yes | Yes | /classes/Category.php:921 |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.954 ms | 880 | /classes/Hook.php:1292 | ||
219 | 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` = 268587) AND (b.`id_shop` = 1) LIMIT 1 |
0.943 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
239 | 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 (78384) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.812 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
236 | 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 (77796) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.788 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
181 | 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` = 77796 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` = 77796 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.756 ms | 0 | /classes/Cart.php:1410 | ||
182 | 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 = 77796 ORDER BY f.position ASC |
0.752 ms | 1 | Yes | /classes/Product.php:5993 | |
216 | 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` = 212471) AND (b.`id_shop` = 1) LIMIT 1 |
0.702 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
199 | 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` = 212471 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` = 212471 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.697 ms | 0 | /classes/Cart.php:1410 | ||
241 | 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 (268587) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.685 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
220 | 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` = 268587 ORDER BY `position` |
0.680 ms | 3 | Yes | /classes/Product.php:3545 | |
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.647 ms | 81 | /classes/module/Module.php:345 | ||
211 | 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` = 77796 ORDER BY `position` |
0.642 ms | 3 | Yes | /classes/Product.php:3545 | |
213 | 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` = 78384) AND (b.`id_shop` = 1) LIMIT 1 |
0.641 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
190 | 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` = 78384 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` = 78384 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.628 ms | 0 | /classes/Cart.php:1410 | ||
240 | 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 (212471) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.628 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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` = 268587 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` = 268587 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.597 ms | 0 | /classes/Cart.php:1410 | ||
200 | 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 = 212471 ORDER BY f.position ASC |
0.565 ms | 1 | Yes | /classes/Product.php:5993 | |
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 = 268587 ORDER BY f.position ASC |
0.546 ms | 1 | Yes | /classes/Product.php:5993 | |
254 | 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.537 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
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.535 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.530 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
217 | 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` = 212471 ORDER BY `position` |
0.530 ms | 1 | Yes | /classes/Product.php:3545 | |
214 | 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` = 78384 ORDER BY `position` |
0.527 ms | 3 | 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.516 ms | 81 | /classes/module/Module.php:345 | ||
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.513 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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.512 ms | 6 | /classes/CartRule.php:418 | ||
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.504 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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.500 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
141 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-12-01 00:00:00" AND date_to <= "2023-12-01 23:59:59") OR (date_from >= "2023-12-01 00:00:00" AND date_from <= "2023-12-01 23:59:59") OR (date_from < "2023-12-01 00:00:00" AND date_to > "2023-12-01 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.486 ms | 5 | /classes/CartRule.php:357 | ||
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.484 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
210 | 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` = 77796) AND (b.`id_shop` = 1) LIMIT 1 |
0.475 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
201 | 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` = 268587 AND image_shop.`cover` = 1 LIMIT 1 |
0.464 ms | 3 | /classes/Product.php:3570 | ||
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.455 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
175 | 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` = 77796) |
0.455 ms | 1 | /classes/Product.php:3857 | ||
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.452 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
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` = 670) AND (b.`id_shop` = 1) LIMIT 1 |
0.450 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
195 | 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` = 212471) |
0.446 ms | 1 | /classes/Product.php:3857 | ||
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.445 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
222 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.440 ms | 1 | /classes/module/Module.php:2636 | ||
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` = 268587) |
0.439 ms | 1 | /classes/Product.php:3857 | ||
249 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 670 LIMIT 1 |
0.435 ms | 1 | /classes/Page.php:83 | ||
171 | 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` = 77796 AND image_shop.`cover` = 1 LIMIT 1 |
0.433 ms | 3 | /classes/Product.php:3570 | ||
191 | 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 = 78384 ORDER BY f.position ASC |
0.429 ms | 1 | Yes | /classes/Product.php:5993 | |
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.425 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
186 | 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` = 78384) |
0.416 ms | 1 | /classes/Product.php:3857 | ||
247 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 920124 AND `date_add` > '2023-12-01 11:20:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.416 ms | 1 | Yes | /classes/Connection.php:168 | |
242 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.407 ms | 1 | /classes/module/Module.php:2636 | ||
179 | 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.400 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
192 | 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` = 212471 AND image_shop.`cover` = 1 LIMIT 1 |
0.400 ms | 1 | /classes/Product.php:3570 | ||
168 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 670 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.395 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.392 ms | 81 | /classes/module/Module.php:345 | ||
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.391 ms | 1 | /classes/Customer.php:475 | ||
143 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-12-01 00:00:00" AND date_to <= "2023-12-01 23:59:59") OR (date_from >= "2023-12-01 00:00:00" AND date_from <= "2023-12-01 23:59:59") OR (date_from < "2023-12-01 00:00:00" AND date_to > "2023-12-01 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.383 ms | 5 | /classes/CartRule.php:357 | ||
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.382 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.381 ms | 1 | /classes/Customer.php:503 | ||
162 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 670 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.377 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
163 | 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` = 670) LIMIT 1 |
0.361 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
234 | 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.359 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
183 | 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` = 78384 AND image_shop.`cover` = 1 LIMIT 1 |
0.352 ms | 3 | /classes/Product.php:3570 | ||
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.332 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.328 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.322 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.322 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.311 ms | 1 | /classes/Customer.php:475 | ||
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.303 ms | 1 | /classes/order/Order.php:881 | ||
253 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.303 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
198 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 212471) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.295 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
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.294 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.276 ms | 1 | /classes/Currency.php:1136 | ||
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.276 ms | 1 | /classes/Language.php:1216 | ||
221 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 268587 |
0.275 ms | 1 | /classes/Product.php:2902 | ||
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.270 ms | 1 | /classes/Customer.php:503 | ||
207 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 268587) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.270 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
215 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 78384 |
0.270 ms | 1 | /classes/Product.php:2902 | ||
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.263 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 670 AND ctg.`id_group` = 1 LIMIT 1 |
0.263 ms | 1 | /classes/Category.php:1751 | ||
232 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.262 ms | 1 | /classes/module/Module.php:2636 | ||
228 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.258 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.255 ms | 1 | /classes/shop/Shop.php:1183 | ||
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.255 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.255 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.254 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
138 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` |
0.243 ms | 10 | /classes/ImageType.php:161 | ||
137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.242 ms | 10 | Yes | /classes/ImageType.php:109 | |
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.241 ms | 1 | Yes | /classes/Currency.php:709 | |
252 | SELECT SQL_NO_CACHE data FROM `ps21_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.238 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43 | ||
237 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.237 ms | 1 | /classes/module/Module.php:2636 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-12-01 11:50:00' AND date_from <= '2023-12-01 13:50:00') OR (date_to >= '2023-12-01 11:50:00' AND date_to <= '2023-12-01 13:50:00'); |
0.234 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
54 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.233 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.232 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.226 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.225 ms | 88 | /classes/Hook.php:339 | ||
167 | SELECT SQL_NO_CACHE data FROM ps21_layered_filter_block WHERE hash="51d1e0c322ebcffb63b8da7df99a687b" LIMIT 1 |
0.224 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:186 | ||
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.223 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
130 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.223 ms | 1 | /classes/Language.php:883 | ||
218 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 212471 |
0.222 ms | 1 | /classes/Product.php:2902 | ||
164 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 670 AND `id_shop` = 1 |
0.219 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
134 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.219 ms | 1 | /classes/Language.php:883 | ||
184 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 670 LIMIT 1 |
0.218 ms | 1 | /classes/Product.php:5639 | ||
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.218 ms | 1 | /classes/shop/Shop.php:218 | ||
47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-12-01 11:50:00' OR date_to<'2023-12-01 11:50:00'; |
0.216 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.216 ms | 10 | Yes | /classes/ImageType.php:109 | |
212 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 77796 |
0.216 ms | 1 | /classes/Product.php:2902 | ||
126 | SELECT SQL_NO_CACHE * FROM `ps21_group_lang` WHERE `id_group` = 1 |
0.213 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
177 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 77796 AND `id_group` = 1 LIMIT 1 |
0.210 ms | 0 | /classes/GroupReduction.php:156 | ||
74 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.205 ms | 0 | /classes/module/Module.php:2109 | ||
243 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.205 ms | 1 | /classes/module/Module.php:2109 | ||
16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.204 ms | 88 | /classes/Hook.php:287 | ||
230 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.203 ms | 1 | /classes/module/Module.php:2636 | ||
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.200 ms | 1 | /classes/Language.php:1080 | ||
55 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 1 |
0.195 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.195 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
248 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.193 ms | 1 | /classes/Page.php:104 | ||
118 | SELECT SQL_NO_CACHE context_key FROM `ps21_jm_pagecache_contexts` WHERE id = 1 |
0.193 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
91 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "systemina_employeefilter" LIMIT 1 |
0.192 ms | 0 | /classes/module/Module.php:2636 | ||
180 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 77796) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.192 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
172 | 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` = 670 LIMIT 1 |
0.191 ms | 1 | /classes/Category.php:1375 | ||
96 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.190 ms | 0 | /classes/module/Module.php:2109 | ||
77 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "uecookie" LIMIT 1 |
0.189 ms | 0 | /classes/module/Module.php:2636 | ||
185 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 3240 AND `active` = 1 LIMIT 1 |
0.189 ms | 1 | /classes/Manufacturer.php:316 | ||
106 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.187 ms | 0 | /classes/module/Module.php:2109 | ||
174 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 1949 AND `active` = 1 LIMIT 1 |
0.187 ms | 1 | /classes/Manufacturer.php:316 | ||
7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.186 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.185 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
58 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 2 |
0.184 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
61 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 3 |
0.182 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
102 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.180 ms | 0 | /classes/module/Module.php:2109 | ||
64 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 4 |
0.179 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
67 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "gdprpro" LIMIT 1 |
0.179 ms | 0 | /classes/module/Module.php:2636 | ||
136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.177 ms | 1 | /classes/FeatureFlag.php:105 | ||
95 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "cookiebanner" LIMIT 1 |
0.176 ms | 0 | /classes/module/Module.php:2636 | ||
27 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.175 ms | 0 | /classes/module/Module.php:2109 | ||
150 | SELECT SQL_NO_CACHE `need_identification_number` FROM `ps21_country` WHERE `id_country` = 8 LIMIT 1 |
0.175 ms | 1 | /classes/Country.php:402 | ||
108 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.173 ms | 0 | /classes/module/Module.php:2109 | ||
114 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.173 ms | 0 | /classes/module/Module.php:2109 | ||
68 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.173 ms | 0 | /classes/module/Module.php:2109 | ||
101 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "hicookielaw" LIMIT 1 |
0.173 ms | 0 | /classes/module/Module.php:2636 | ||
132 | SELECT SQL_NO_CACHE c.id_currency FROM `ps21_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.172 ms | 1 | /classes/Currency.php:893 | ||
187 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 78384 AND id_shop=1 LIMIT 1 |
0.172 ms | 1 | /classes/Product.php:6848 | ||
57 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 2) LIMIT 1 |
0.171 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
83 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "deluxecookies" LIMIT 1 |
0.168 ms | 0 | /classes/module/Module.php:2636 | ||
63 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 4) LIMIT 1 |
0.168 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
202 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 670 LIMIT 1 |
0.168 ms | 1 | /classes/Product.php:5639 | ||
60 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 3) LIMIT 1 |
0.167 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
189 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 78384) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.167 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
79 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "idxcookies" LIMIT 1 |
0.166 ms | 0 | /classes/module/Module.php:2636 | ||
85 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "tnzcookie" LIMIT 1 |
0.164 ms | 0 | /classes/module/Module.php:2636 | ||
31 | 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 | ||
158 | SELECT SQL_NO_CACHE `content` FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.163 ms | 1 | /modules/zonethememanager/classes/ZManager.php:194 | ||
89 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "cookiesplus" LIMIT 1 |
0.161 ms | 0 | /classes/module/Module.php:2636 | ||
153 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps21_required_field |
0.161 ms | 1 | /classes/ObjectModel.php:1592 | ||
43 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ets_affiliatemarketing" LIMIT 1 |
0.160 ms | 0 | /classes/module/Module.php:2636 | ||
73 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ageverifyer" LIMIT 1 |
0.160 ms | 0 | /classes/module/Module.php:2636 | ||
152 | SELECT SQL_NO_CACHE * FROM `ps21_country_lang` WHERE `id_country` = 8 |
0.160 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
176 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 77796 AND id_shop=1 LIMIT 1 |
0.159 ms | 1 | /classes/Product.php:6848 | ||
244 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.159 ms | 1 | /classes/module/Module.php:2636 | ||
188 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 78384 AND `id_group` = 1 LIMIT 1 |
0.158 ms | 0 | /classes/GroupReduction.php:156 | ||
193 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 670 LIMIT 1 |
0.158 ms | 1 | /classes/Product.php:5639 | ||
196 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 212471 AND id_shop=1 LIMIT 1 |
0.158 ms | 1 | /classes/Product.php:6848 | ||
24 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "superuser" LIMIT 1 |
0.155 ms | 0 | /classes/module/Module.php:2636 | ||
75 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "kbgdpr" LIMIT 1 |
0.155 ms | 0 | /classes/module/Module.php:2636 | ||
76 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.155 ms | 0 | /classes/module/Module.php:2109 | ||
127 | SELECT SQL_NO_CACHE id_shop FROM `ps21_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.155 ms | 1 | /classes/ObjectModel.php:1729 | ||
156 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.155 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
205 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 268587 AND id_shop=1 LIMIT 1 |
0.155 ms | 1 | /classes/Product.php:6848 | ||
37 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.152 ms | 0 | /classes/module/Module.php:2109 | ||
112 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.152 ms | 0 | /classes/module/Module.php:2109 | ||
245 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.152 ms | 1 | /classes/module/Module.php:2109 | ||
78 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.151 ms | 0 | /classes/module/Module.php:2109 | ||
21 | SELECT SQL_NO_CACHE * FROM `ps21_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.151 ms | 1 | /classes/module/Module.php:2018 | ||
23 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "bvkseodispatcher" LIMIT 1 |
0.150 ms | 0 | /classes/module/Module.php:2636 | ||
25 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.150 ms | 0 | /classes/module/Module.php:2109 | ||
35 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.150 ms | 0 | /classes/module/Module.php:2109 | ||
84 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.150 ms | 0 | /classes/module/Module.php:2109 | ||
238 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.150 ms | 1 | /classes/module/Module.php:2109 | ||
38 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "smartseourl" LIMIT 1 |
0.148 ms | 0 | /classes/module/Module.php:2636 | ||
159 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "pm_advancedsearch4" LIMIT 1 |
0.148 ms | 0 | /classes/module/Module.php:2636 | ||
173 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 670 LIMIT 1 |
0.148 ms | 1 | /classes/Product.php:5639 | ||
256 | DELETE FROM `ps21_jm_pagecache_mods` WHERE `id`=251; |
0.148 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
149 | SELECT SQL_NO_CACHE format FROM `ps21_address_format` WHERE `id_country` = 8 LIMIT 1 |
0.147 ms | 1 | /classes/AddressFormat.php:656 | ||
203 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 180 AND `active` = 1 LIMIT 1 |
0.147 ms | 1 | /classes/Manufacturer.php:316 | ||
90 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.146 ms | 0 | /classes/module/Module.php:2109 | ||
28 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "wkadminloginascustomer" LIMIT 1 |
0.145 ms | 0 | /classes/module/Module.php:2636 | ||
87 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "lgcookieslaw" LIMIT 1 |
0.144 ms | 0 | /classes/module/Module.php:2636 | ||
93 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "pm_advancedcookiebanner" LIMIT 1 |
0.144 ms | 0 | /classes/module/Module.php:2636 | ||
146 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_legalcompliance" LIMIT 1 |
0.144 ms | 0 | /classes/module/Module.php:2636 | ||
229 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.144 ms | 1 | /classes/module/Module.php:2109 | ||
233 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.143 ms | 1 | /classes/module/Module.php:2109 | ||
103 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "iubenda" LIMIT 1 |
0.142 ms | 0 | /classes/module/Module.php:2636 | ||
70 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.142 ms | 0 | /classes/module/Module.php:2109 | ||
33 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.141 ms | 0 | /classes/module/Module.php:2109 | ||
107 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "nxtalpricetaxswitcher" LIMIT 1 |
0.141 ms | 0 | /classes/module/Module.php:2636 | ||
260 | SELECT SQL_NO_CACHE context_key FROM `ps21_jm_pagecache_contexts` WHERE id = 2 |
0.141 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
72 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.140 ms | 0 | /classes/module/Module.php:2109 | ||
113 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "wkexitpopup" LIMIT 1 |
0.140 ms | 0 | /classes/module/Module.php:2636 | ||
69 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "generaldataprotectionregulation" LIMIT 1 |
0.139 ms | 0 | /classes/module/Module.php:2636 | ||
10 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "jprestaspeedpack" LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2636 | ||
225 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.137 ms | 1 | /classes/module/Module.php:2109 | ||
29 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.137 ms | 0 | /classes/module/Module.php:2109 | ||
223 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.137 ms | 1 | /classes/module/Module.php:2109 | ||
92 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.135 ms | 0 | /classes/module/Module.php:2109 | ||
11 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 91 AND `id_shop` = 1 LIMIT 1 |
0.134 ms | 1 | /classes/module/Module.php:2109 | ||
30 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "groupinc" LIMIT 1 |
0.134 ms | 0 | /classes/module/Module.php:2636 | ||
80 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.133 ms | 0 | /classes/module/Module.php:2109 | ||
104 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.133 ms | 0 | /classes/module/Module.php:2109 | ||
32 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "shaim_gdpr" LIMIT 1 |
0.132 ms | 0 | /classes/module/Module.php:2636 | ||
82 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.132 ms | 0 | /classes/module/Module.php:2109 | ||
71 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ageverify" LIMIT 1 |
0.131 ms | 0 | /classes/module/Module.php:2636 | ||
100 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.131 ms | 0 | /classes/module/Module.php:2109 | ||
116 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.130 ms | 0 | /classes/module/Module.php:2109 | ||
86 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.130 ms | 0 | /classes/module/Module.php:2109 | ||
98 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.130 ms | 0 | /classes/module/Module.php:2109 | ||
147 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.130 ms | 0 | /classes/module/Module.php:2109 | ||
178 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_group` WHERE `id_group` = 1 LIMIT 1 |
0.130 ms | 1 | /classes/Group.php:154 | ||
206 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 268587 AND `id_group` = 1 LIMIT 1 |
0.130 ms | 0 | /classes/GroupReduction.php:156 | ||
88 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 0 | /classes/module/Module.php:2109 | ||
94 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 0 | /classes/module/Module.php:2109 | ||
110 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 0 | /classes/module/Module.php:2109 | ||
197 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 212471 AND `id_group` = 1 LIMIT 1 |
0.129 ms | 0 | /classes/GroupReduction.php:156 | ||
42 | SELECT SQL_NO_CACHE id_shop FROM `ps21_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.128 ms | 1 | /classes/ObjectModel.php:1729 | ||
81 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "validatevatnumber" LIMIT 1 |
0.128 ms | 0 | /classes/module/Module.php:2636 | ||
105 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "dm_cookies" LIMIT 1 |
0.128 ms | 0 | /classes/module/Module.php:2636 | ||
194 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 115 AND `active` = 1 LIMIT 1 |
0.128 ms | 1 | /classes/Manufacturer.php:316 | ||
231 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.127 ms | 1 | /classes/module/Module.php:2109 | ||
226 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.127 ms | 1 | /classes/module/Module.php:2636 | ||
115 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "iqitthemeeditor" LIMIT 1 |
0.126 ms | 0 | /classes/module/Module.php:2636 | ||
34 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "autolanguagecurrency" LIMIT 1 |
0.125 ms | 0 | /classes/module/Module.php:2636 | ||
99 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ultimateimagetool" LIMIT 1 |
0.124 ms | 0 | /classes/module/Module.php:2636 | ||
109 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "pm_applepay" LIMIT 1 |
0.124 ms | 0 | /classes/module/Module.php:2636 | ||
97 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "webpgenerator" LIMIT 1 |
0.123 ms | 0 | /classes/module/Module.php:2636 | ||
257 | DELETE FROM `ps21_jm_pagecache_bl` WHERE `id`=251; |
0.123 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
9 | SELECT SQL_NO_CACHE id_shop FROM `ps21_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.122 ms | 1 | /classes/ObjectModel.php:1729 | ||
111 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "eugeneraldatapro" LIMIT 1 |
0.122 ms | 0 | /classes/module/Module.php:2636 | ||
36 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "configb2b" LIMIT 1 |
0.121 ms | 0 | /classes/module/Module.php:2636 | ||
262 | DELETE FROM `ps21_jm_pagecache_bl` WHERE id IN (102882) |
0.121 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
46 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.120 ms | 0 | /classes/module/Module.php:2109 | ||
224 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.116 ms | 1 | /classes/module/Module.php:2636 | ||
44 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.115 ms | 0 | /classes/module/Module.php:2109 | ||
26 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "atssuperuser" LIMIT 1 |
0.114 ms | 0 | /classes/module/Module.php:2636 | ||
227 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.104 ms | 1 | /classes/module/Module.php:2109 | ||
39 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.103 ms | 0 | /classes/module/Module.php:2109 | ||
45 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "creativeelements" LIMIT 1 |
0.102 ms | 0 | /classes/module/Module.php:2636 | ||
263 | DELETE FROM `ps21_jm_pagecache_mods` WHERE id IN (102882) |
0.096 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 |
46 queries |
SELECT `id_module` FROM `psXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX |
6 queries |
SELECT tr.* FROM `psXX_tax_rule` tr JOIN `psXX_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
4 queries |
SELECT * FROM `psXX_tax` a WHERE (a.`id_tax` = XX) LIMIT XX |
4 queries |
SELECT * FROM `psXX_tax_lang` WHERE `id_tax` = XX |
4 queries |
SELECT image_shop.`id_image` FROM `psXX_image` i INNER JOIN psXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX |
4 queries |
SELECT name FROM psXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX |
4 queries |
SELECT `name` FROM `psXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX |
4 queries |
SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `psXX_product` p INNER JOIN `psXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `psXX_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX) |
4 queries |
SELECT `id_tax_rules_group` FROM `psXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX |
4 queries |
SELECT `reduction` FROM `psXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
4 queries |
SELECT SUM(quantity) FROM `psXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX |
4 queries |
SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `psXX_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `psXX_cart_product` cp JOIN `psXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psXX_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX |
4 queries |
SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM psXX_feature_product pf LEFT JOIN psXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN psXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN psXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN psXX_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC |
4 queries |
SELECT * FROM `psXX_product` a LEFT JOIN `psXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `psXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX |
4 queries |
SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `psXX_image` i INNER JOIN psXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `psXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position` |
4 queries |
SELECT `id_product_attribute` FROM `psXX_product_attribute` WHERE `id_product` = XX |
4 queries |
SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `psXX_product_attribute` pa INNER JOIN psXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `psXX_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `psXX_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `psXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `psXX_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
3 queries |
SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `psXX_module` m LEFT JOIN `psXX_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX |
2 queries |
SELECT m.page, ml.url_rewrite, ml.id_lang FROM `psXX_meta` m LEFT JOIN `psXX_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = XX ) ORDER BY LENGTH(ml.url_rewrite) DESC |
2 queries |
SELECT c.`passwd` FROM `psXX_customer` c WHERE (c.`email` = 'dXX-fXXaaXXaeXXdXXcXXaXXfXXad@fakeemail.com') AND (c.`id_shop` IN (XX)) AND (c.`is_guest` = XX) AND (c.`deleted` = XX) LIMIT XX |
2 queries |
SELECT c.* FROM `psXX_customer` c WHERE (c.`email` = 'dXX-fXXaaXXaeXXdXXcXXaXXfXXad@fakeemail.com') AND (c.`id_shop` IN (XX)) AND (c.`is_guest` = XX) AND (c.`deleted` = XX) LIMIT XX |
2 queries |
SELECT context_key FROM `psXX_jm_pagecache_contexts` WHERE id = XX |
2 queries |
SELECT * FROM `psXX_category` a LEFT JOIN `psXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `psXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX |
2 queries |
SELECT `id_lang` FROM `psXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX |
2 queries |
SELECT XX FROM `psXX_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX |
2 queries |
SELECT * FROM `psXX_category` aXX LEFT JOIN `psXX_category_lang` `aXX` ON (aXX.`id_category` = aXX.`id_category`) WHERE (aXX.`nleft` < XX) AND (aXX.`nright` > XX) AND (aXX.`id_lang` = XX) AND (aXX.`id_shop` = XX) ORDER BY aXX.`nleft` asc |
2 queries |
SELECT type, id_value, filter_show_limit, filter_type FROM psXX_layered_category WHERE controller = 'category' AND id_category = XX AND id_shop = XX GROUP BY `type`, id_value ORDER BY position ASC |
53 module |
50 module_shop |
15 product |
15 product_shop |
12 category_lang |
10 product_attribute |
9 category |
8 image |
8 image_shop |
8 product_attribute_shop |
8 cart_product |
7 tax_rules_group |
7 stock_available |
6 hook |
6 tax_rule |
6 product_attribute_combination |
5 shop_url |
5 lang |
5 currency |
5 category_shop |
5 category_group |
5 product_lang |
4 shop |
4 configuration |
4 lang_shop |
4 currency_shop |
4 customer |
4 tax |
4 tax_lang |
4 cart_rule |
4 manufacturer |
4 product_group_reduction_cache |
4 pack |
4 feature_product |
4 feature_lang |
4 feature_value_lang |
4 feature |
4 feature_shop |
4 image_lang |
4 attribute |
4 attribute_lang |
4 attribute_group |
3 country |
3 hook_alias |
3 jm_pagecache_contexts |
3 image_type |
3 category_product |
2 shop_group |
2 country_lang |
2 country_shop |
2 hook_module |
2 meta |
2 meta_lang |
2 currency_lang |
2 jm_pagecache_sp |
2 group |
2 group_shop |
2 cart_rule_lang |
2 zthememanager |
2 layered_category |
2 product_sale |
2 jm_pagecache_mods |
2 jm_pagecache_bl |
2 jm_pagecache |
1 configuration_lang |
1 module_group |
1 hook_module_exceptions |
1 tax_rules_group_shop |
1 jm_pagecache_details |
1 group_lang |
1 feature_flag |
1 orders |
1 order_cart_rule |
1 address_format |
1 required_field |
1 zthememanager_lang |
1 zcolorsfonts |
1 layered_filter_block |
1 connections |
1 page_type |
1 page |
1 ganalytics_data |
Name | Instances | Source |
---|---|---|
Category | 12 |
/controllers/front/listing/CategoryController.php:78 (__construct) [id: 670]
/classes/Meta.php:380 (__construct) [id: 670] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 670] /modules/ps_categorytree/ps_categorytree.php:340 (__construct) [id: 2] |
Tax | 5 |
/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 2] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 3] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 4] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] |
Language | 4 |
/config/config.inc.php:211 (__construct) [id: 1]
/classes/Tools.php:559 (__construct) [id: 1] /classes/Tools.php:559 (__construct) [id: 1] /classes/Tools.php:559 (__construct) [id: 1] |
Address | 4 |
/modules/jprestaspeedpack/jprestaspeedpack.php:1630 (initialize) [id: ]
/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3801 (__construct) [id: ] /classes/Product.php:5936 (__construct) [id: ] |
Product | 4 |
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 77796]
/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 78384] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 212471] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 268587] |