Enregistreurs audio
Il y a 5 produits.
102,56 €
49,84 €
Il y a 5 produits.
Load Time | 541.868 ms |
Querying Time | 116 ms |
Queries | 289 |
Memory Peak Usage | 23.9 Mb |
Included Files | 1260 files - 11.87 Mb |
PrestaShop Cache | - Mb |
Global vars | 0.19 Mb |
PrestaShop Version | 8.1.2 |
PHP Version | 8.1.25 |
MySQL Version | 10.6.16-MariaDB |
Memory Limit | 2048M |
Max Execution Time | 3600s |
Smarty Cache | disabled |
Smarty Compilation | force compile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 6.489 ms | 6.489 ms | 8.53 Mb | 9.2 Mb |
__construct | 14.336 ms | 20.825 ms | 1.73 Mb | 11.9 Mb |
config | 37.990 ms | 58.815 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.027 ms | 58.842 ms | - Mb | 11.9 Mb |
init | 44.670 ms | 103.512 ms | 2.11 Mb | 14.8 Mb |
checkAccess | 0.002 ms | 103.514 ms | - Mb | 14.8 Mb |
setMedia | 3.592 ms | 107.106 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.002 ms | 107.108 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 107.109 ms | - Mb | 14.8 Mb |
initContent | 112.822 ms | 219.931 ms | 4.27 Mb | 18.2 Mb |
initFooter | 0.002 ms | 219.933 ms | - Mb | 18.2 Mb |
display | 321.935 ms | 541.868 ms | 5.15 Mb | 23.9 Mb |
Hook | Time | Memory Usage |
---|---|---|
ActionDispatcherBefore | 55.461 ms | 3.09 Mb |
ActionOutputHTMLBefore | 34.691 ms | 0.14 Mb |
displayProductListReviews | 25.073 ms | 1.29 Mb |
DisplayHeader | 24.845 ms | 0.88 Mb |
displayLeftColumn | 23.944 ms | 0.74 Mb |
displayTop | 15.774 ms | 0.20 Mb |
ActionDispatcher | 14.242 ms | 0.70 Mb |
DisplayBeforeBodyClosingTag | 11.400 ms | 0.21 Mb |
DisplayFooterRight | 9.790 ms | 0.24 Mb |
DisplayFooter | 9.736 ms | 0.11 Mb |
DisplayNavFullWidth | 5.285 ms | 0.07 Mb |
DisplayLeftColumn | 4.808 ms | 0.04 Mb |
DisplayOutsideMainPage | 3.907 ms | 0.06 Mb |
displayFooterRight | 3.119 ms | 0.07 Mb |
displayFooterLeft | 2.298 ms | 0.06 Mb |
DisplayBanner | 2.219 ms | 0.06 Mb |
DisplayFooterLeft | 1.428 ms | 0.03 Mb |
DisplayNav1 | 1.317 ms | 0.03 Mb |
ActionFrontControllerSetVariables | 1.232 ms | 0.06 Mb |
DisplayFooterAfter | 1.128 ms | 0.03 Mb |
ActionFrontControllerSetMedia | 1.072 ms | 0.01 Mb |
displayNav2 | 0.851 ms | 0.08 Mb |
DisplaySidebarNavigation | 0.577 ms | - Mb |
ProductSearchProvider | 0.296 ms | - Mb |
ModuleRoutes | 0.039 ms | 0.02 Mb |
ActionObjectAddAfter | 0.033 ms | - Mb |
ActionFrontControllerInitAfter | 0.025 ms | - Mb |
DisplayAfterBodyOpeningTag | 0.014 ms | - Mb |
DisplayFooterBefore | 0.008 ms | - Mb |
29 hook(s) | 254.612 ms | 8.22 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 7.702 ms | 0.54 Mb |
jprestaspeedpack | 105.650 ms | 3.99 Mb |
blockreassurance | 1.284 ms | 0.09 Mb |
blockwishlist | 10.250 ms | 0.13 Mb |
ps_emailsubscription | 3.393 ms | 0.10 Mb |
ps_socialfollow | 2.469 ms | 0.08 Mb |
ps_emailalerts | 0.339 ms | 0.09 Mb |
zonethememanager | 30.647 ms | 1.61 Mb |
ps_shoppingcart | 10.597 ms | 0.11 Mb |
ps_searchbar | 2.229 ms | 0.14 Mb |
productcomments | 25.244 ms | 1.32 Mb |
ps_googleanalytics | 5.387 ms | 0.05 Mb |
zonecolorsfonts | 22.274 ms | 0.87 Mb |
zonemegamenu | 7.156 ms | 0.12 Mb |
prestastripe | 3.112 ms | 0.02 Mb |
ps_facetedsearch | 1.890 ms | 0.10 Mb |
ps_languageselector | 0.639 ms | 0.06 Mb |
ps_currencyselector | 0.468 ms | 0.06 Mb |
ps_customersignin | 3.501 ms | 0.08 Mb |
ps_categorytree | 24.063 ms | 0.75 Mb |
zonecolumnblocks | 4.008 ms | 0.13 Mb |
zonepopupnewsletter | 1.583 ms | 0.05 Mb |
statsdata | 6.248 ms | 0.21 Mb |
23 module(s) | 280.133 ms | 10.70 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
287 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (475,803264849),(475,94201498),(475,809700252),(475,1289214159),(475,1785617407),(475,2936477779),(475,1727466530),(475,1432532875),(475,1025009294),(475,1804081323),(475,3479716883),(475,66301815),(475,537553573),(475,3045727500),(475,3231073010),(475,1825096520),(475,3225262556),(475,2645763144),(475,2027619899),(475,786864081),(475,1849360992),(475,294428854),(475,3774376179),(475,2880678980),(475,114155291),(475,2929321318),(475,2087307803),(475,2369020978),(475,1152186767),(475,4222788516),(475,2858566420),(475,848840972),(475,4147554351),(475,770698498),(475,2244011448),(475,477004582),(475,3610318732),(475,1070190107),(475,937307692),(475,25761885),(475,3366890060),(475,3483396593),(475,392306519),(475,909258745),(475,179865882),(475,3099645137),(475,3371246540),(475,2390640699),(475,501027234),(475,3032495894),(475,2100541971),(475,2793494280),(475,180908336),(475,1192985740),(475,1972034646),(475,2419117650),(475,3803768817),(475,4265874642),(475,67723771),(475,3423129237),(475,3399895114),(475,3221089548),(475,2990154896),(475,2728213885),(475,933991437),(475,2513627470),(475,468067826),(475,4137721533),(475,1552016987),(475,4080301755),(475,4245349388),(475,1973472416),(475,1839057912),(475,3745041382),(475,3035734567),(475,3719469943),(475,3466131047),(475,679558129),(475,462819688),(475,4267553191),(475,518809702),(475,3303811122),(475,2883778317),(475,1694893476),(475,3287268691),(475,3711637102),(475,698879415),(475,885817714),(475,125306139),(475,1634619674),(475,58280175),(475,3363778289),(475,1161663254),(475,201135304),(475,288600709),(475,1021330335),(475,2858809635),(475,2763627026),(475,3717400459),(475,4125370705),(475,3997906175),(475,4162316513),(475,3219397995),(475,2539165674),(475,1046234598),(475,787652129),(475,1595426297),(475,4184932827),(475,1985552396),(475,1944795689),(475,3799916950),(475,1827123668),(475,1447744642),(475,1636796806),(475,2645405926),(475,1474595477),(475,3375525138),(475,3902077767),(475,3507415422),(475,2781072282),(475,2002273313),(475,3164880625),(475,2490789905),(475,1000843653),(475,48947005),(475,3883347157),(475,3700474777),(475,4264269047),(475,2125390191),(475,4270481046),(475,1693150473),(475,343450730),(475,381351735),(475,2863449446),(475,3772294966),(475,3877457961),(475,1492116830),(475,4041511410),(475,828132466),(475,4090211224),(475,2185737194),(475,3517149926),(475,647687838),(475,733479784),(475,1440916471),(475,3262261204),(475,1872100372),(475,2092461357),(475,3357609169),(475,2365529006),(475,1263061406),(475,2296732656),(475,534196217),(475,482025419),(475,2811467352),(475,2488480532),(475,3501473861),(475,1917272649),(475,1878317490),(475,1789511633),(475,956713705),(475,89981727),(475,1143557322),(475,2749361789),(475,3857194488),(475,1024086260),(475,26040876),(475,1804243295),(475,2165251395),(475,1281618245),(475,2793993627),(475,426054238),(475,3398682121),(475,1025101115),(475,2974984653),(475,2214325187),(475,997821910),(475,2005463392),(475,3252396061),(475,942332382),(475,3816934055),(475,1661692647),(475,975758589),(475,3974931321),(475,2301364099),(475,855746680),(475,637832447),(475,3938675492),(475,508940865),(475,911480697),(475,1283363269),(475,3552869238),(475,2961923901),(475,3747234531),(475,3155646160),(475,3164668199),(475,2271068282),(475,84354396),(475,2915068863),(475,4064530110),(475,3216991891),(475,2045363644),(475,2664176477),(475,1076722390),(475,505410826),(475,3544422162),(475,2506779464),(475,2552384108),(475,876907216),(475,82980331),(475,3890150098),(475,3475437886),(475,2302280848),(475,1133144647),(475,801167173),(475,2059315716),(475,3139619822),(475,2937007520),(475,1589371182),(475,693370988),(475,2708427394),(475,1007456900),(475,610735313),(475,3846627131),(475,2031830639),(475,1908602231),(475,1401333655),(475,378101424),(475,996218346),(475,660881695),(475,2938384267),(475,4250264855),(475,1895305721),(475,502965417),(475,1982471117),(475,2524144246),(475,2774996218),(475,1068709096),(475,4077513867),(475,2900588200),(475,465472731),(475,4139839450),(475,2360011682),(475,4211248848),(475,283341417),(475,4165214622),(475,3508523596),(475,234404923),(475,2782693783),(475,3413880379),(475,3540168379),(475,861653603),(475,3160995915),(475,1391251310),(475,2106651858),(475,3572623339),(475,4629984),(475,2488722736),(475,3486510944),(475,2675016634),(475,2165907305),(475,136687257),(475,3540179561),(475,2792526429),(475,2220600372),(475,2914585448),(475,3882733113),(475,1688090355),(475,3534950496),(475,1182870252),(475,412601709),(475,574969182),(475,2970413814),(475,1487282505),(475,3228977345),(475,2023459642),(475,3291711134),(475,2792891444),(475,3335276918),(475,502111155),(475,1347492703),(475,2832080533),(475,1215320197),(475,2317239205),(475,1931846913),(475,1721014625),(475,738600257),(475,2998338424),(475,1207945902),(475,734241479),(475,3324570843),(475,4126771257),(475,1712456575),(475,3169253733),(475,1160958045),(475,1130949510),(475,3116084871),(475,269178051),(475,24773614),(475,3204450510),(475,3468662336),(475,1808444077),(475,4095410992),(475,1012520131),(475,2367920745),(475,2603361072),(475,2741539031),(475,607507456),(475,616165826),(475,2288576869),(475,4252798532),(475,2692385638),(475,4100315394),(475,3061254709),(475,1657292258),(475,2148967437),(475,1248236410),(475,2457219175),(475,1920985790),(475,1340703149),(475,1618471777),(475,4160689201),(475,1822364967),(475,479188821),(475,1661785323),(475,4137484009),(475,2636427258),(475,1499247737),(475,2061922205),(475,665830591),(475,916194615),(475,495595719),(475,3026469794),(475,1845449656),(475,4078122428),(475,2044505385),(475,3156749269),(475,3919036276),(475,204613135),(475,605377709),(475,766051911),(475,30400764),(475,4211022030),(475,715827285),(475,1092948871),(475,610201349),(475,1023110113),(475,3379323545),(475,2591028766),(475,1994095466),(475,33157726),(475,198243957),(475,2540831776),(475,1707019604),(475,2730046909),(475,4101073252),(475,207761914),(475,2750534087),(475,980926717),(475,377071036),(475,2983490672),(475,584353846),(475,1743688562),(475,3223058413),(475,1665991311),(475,3093731065),(475,1095877807),(475,1085889875),(475,2059985562),(475,3618062925),(475,592374860),(475,4217863027),(475,3425247989),(475,1636391408),(475,1698766782),(475,2162739858),(475,1538367880),(475,3760626336),(475,1987713032),(475,2338874856),(475,4206689645),(475,1723372602),(475,2788329276),(475,2095305502),(475,3135330775),(475,2402748468),(475,24058172),(475,4000683245),(475,315670382),(475,2558276906),(475,1745365471),(475,2782569384),(475,3422117706),(475,552626444),(475,1506232339),(475,2933163456),(475,1483801350),(475,1400586123),(475,3746875726),(475,2604810181),(475,2905930158),(475,803588046),(475,1651400661),(475,1431243585),(475,1586185269),(475,4110009762),(475,3647374073),(475,4196158832),(475,644435096),(475,1862966990),(475,2098775956),(475,4045847707),(475,3122054119),(475,1971194991),(475,2149367276),(475,1888540635),(475,2660577125),(475,2508340497),(475,196341346),(475,1790101800),(475,1054130805),(475,2741947598),(475,1292400575),(475,545037028),(475,1516477184),(475,2706799993),(475,562470873),(475,2591346466),(475,613023703),(475,2725609989),(475,2082081559),(475,572560232),(475,2833489058),(475,1999611979),(475,1938789650),(475,2958717166),(475,1035708154),(475,2025067287),(475,3804047398),(475,248028803),(475,4243412966),(475,628124381),(475,1271215494),(475,2140466223),(475,1298495884),(475,3585931255),(475,532975694),(475,892763084),(475,203145038),(475,470924714),(475,1460516495),(475,2732318442),(475,3996868778),(475,862206445),(475,3193479021),(475,3382171736),(475,3362897893),(475,3598913121),(475,1342337107),(475,3202829344),(475,1335223071),(475,270790954),(475,1086966479),(475,484642328),(475,4274468042),(475,1740107684),(475,2117688527),(475,1393082718),(475,366510022),(475,341328174),(475,1469264429),(475,968691010),(475,3210232788),(475,3705477223),(475,1639200307),(475,3585776886),(475,3305319229),(475,1052899681),(475,2176267881),(475,357387863),(475,451177334),(475,677589039),(475,1181390953),(475,898241702),(475,3480303789),(475,1736215096),(475,2511740146),(475,2560762429),(475,1570623991),(475,897080848),(475,891021207),(475,2807843172),(475,411231410),(475,2413680770),(475,519468981),(475,1898829954),(475,4274422817),(475,2781196321),(475,433695516),(475,1652336127),(475,4200438598),(475,3032893805),(475,1435170492),(475,341146430),(475,755973553),(475,2183774725),(475,3967614532),(475,1589097164),(475,2441764320),(475,745126750),(475,348450311),(475,2084175962),(475,3357611772),(475,1654631620),(475,3098454302),(475,2029227635),(475,1731761366),(475,2444253995),(475,2906032508),(475,872274856),(475,4282856364),(475,3328013593),(475,4184469063),(475,1074477927),(475,475878802),(475,1341972790),(475,2770374005),(475,4237489391),(475,2818813526),(475,3131100007),(475,4267621199),(475,1031922959),(475,1616292706),(475,630426110),(475,1846388513),(475,2239793094),(475,1660370824),(475,3321716633),(475,2551727033),(475,1836172154),(475,1870881122),(475,3324207484),(475,1065867023),(475,1459310880),(475,1395112921),(475,893552556),(475,1795813847),(475,2544364435),(475,4188602229),(475,1437064809),(475,922605498),(475,4180843510),(475,2554784265),(475,3798404205),(475,1216801552),(475,225525148),(475,274058040),(475,3206796234),(475,610255635),(475,3139895407),(475,3993594441),(475,2078652070),(475,3340749058),(475,2282248923),(475,3201099700),(475,3944887276),(475,887478137),(475,620965629),(475,53639561),(475,687854272),(475,4204526813),(475,3434636086),(475,3859247582),(475,2160451939),(475,419013317),(475,488655959),(475,2224381764),(475,857621694),(475,593880699),(475,1743569168),(475,747100668),(475,2627272664),(475,1477316791),(475,852002855),(475,3813191394),(475,3206482767),(475,2935275735),(475,825997452),(475,4128572079),(475,4149399208),(475,2432005645),(475,945310979),(475,206553734),(475,3381625344),(475,2613891474),(475,1285565060),(475,725086502),(475,2181279565),(475,2136294074),(475,531227063),(475,3291030245),(475,3423892574),(475,1818418110),(475,1175554195),(475,231365613),(475,3071984169),(475,1510809703),(475,2304894647),(475,724387218),(475,3702122266),(475,3105745802),(475,3598888791),(475,40599425),(475,4256434691),(475,1198380170),(475,3549401556),(475,2300237909),(475,484124464),(475,3042798728),(475,767973032),(475,4146324303),(475,1493350341),(475,2166736334),(475,3061340275),(475,1468811388),(475,714571165),(475,1958965990),(475,2146366302),(475,2212338847),(475,2088651590),(475,2684538463),(475,2292708505),(475,571001464),(475,608126571),(475,2736309071),(475,1479333754),(475,1794660366),(475,2319975337),(475,1093438481),(475,2975864804),(475,2504416172),(475,3531750290),(475,219666672),(475,4219072870),(475,1053258155),(475,2382983142),(475,1006288562),(475,1770263986),(475,3089735283),(475,3689334927),(475,2901629603),(475,2019277020),(475,2853333944),(475,1110695191),(475,3884283185),(475,4268093708),(475,159799075),(475,1715997742),(475,1009155269),(475,3922001006),(475,3916338789),(475,1085252167),(475,207705430),(475,1190601026),(475,1441004396),(475,1567147586),(475,964098054),(475,1385174189),(475,3607427007),(475,4065177061),(475,1552830538),(475,3778287701),(475,3986294473),(475,4127238085),(475,1865170325),(475,2161789419),(475,2889615117),(475,785261358),(475,3873733217),(475,2600209543),(475,3958092558),(475,4143434528),(475,3225228598),(475,3451063310),(475,810085901),(475,1502204888),(475,2931931582),(475,1339720903),(475,4093703382),(475,1016897830),(475,1186809094),(475,2269117600),(475,813555736),(475,733475850),(475,305814753),(475,2720553993),(475,212227262),(475,1328958432),(475,3903742053),(475,2617942920),(475,4254367326),(475,2895836413),(475,1090341105),(475,3174277595),(475,639084285),(475,4064195579),(475,2134315289),(475,608843276),(475,4190247440),(475,1090444753),(475,2554275840),(475,2758076506),(475,2518001916),(475,3620157415),(475,1195920681),(475,1822840633),(475,1087551238),(475,235508323),(475,1139244570),(475,810960133),(475,425550269),(475,1767940144),(475,1488780247),(475,1250541405),(475,1715845038),(475,3777612587),(475,2285237154),(475,802817926),(475,4280998710),(475,1108258121),(475,1107026853),(475,2913745362),(475,1129101120),(475,2454813183),(475,1690919006),(475,23973636),(475,293370743),(475,1041759778),(475,3142497267),(475,2920365983),(475,2300359472),(475,885232682),(475,1995817456),(475,3443377157),(475,863919144),(475,1324348692),(475,4019216150),(475,443752815),(475,4223293),(475,1182491637),(475,4257294915),(475,3629776934),(475,582958316),(475,3061655453),(475,1665355533),(475,1929899841),(475,1033949851),(475,2010879266),(475,1872304779),(475,1282102725),(475,3589651214),(475,4095654001),(475,2447713556),(475,2543494532),(475,2069898435),(475,3286503857),(475,2662939963),(475,93111834),(475,3160936308),(475,261262800),(475,141197408),(475,1904512268),(475,3001025754),(475,2247670246),(475,535154833),(475,3476002757),(475,3806439314),(475,1819793014),(475,3545273473),(475,3957652542),(475,3018295592),(475,1367893712),(475,1034338066),(475,3229510223),(475,4276953245),(475,3363858574),(475,2870596766),(475,648526699),(475,3627085975),(475,1585047995),(475,1960922033),(475,748737253),(475,1175066615),(475,1318322018),(475,260367662),(475,643741484),(475,1013706048),(475,1726352130),(475,2222354404),(475,1327031463),(475,1131865044),(475,839200087),(475,1407668396),(475,3548333318),(475,237845721),(475,3056051791),(475,747235328),(475,172675174),(475,2781705803),(475,2111348799),(475,3067187587),(475,618638032),(475,3369756381),(475,2232055662),(475,55113216),(475,3939915090),(475,2586983921),(475,3286008345),(475,1956055310),(475,740042513),(475,2282536358),(475,1863122946),(475,1296880981),(475,2589434346),(475,1621393368),(475,39250009),(475,72263924),(475,1587391050),(475,847186998),(475,2455499024),(475,859347884),(475,2244795234),(475,64890532),(475,3884228509),(475,2569390320),(475,1246738577),(475,4280008788),(475,1043484680),(475,3924888977),(475,1697117306),(475,3406763364),(475,1129505049) ON DUPLICATE KEY UPDATE id=id |
9.405 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
252 | 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.298 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
7.402 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
2 | SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
3.185 ms | 1298 | /classes/Configuration.php:180 | ||
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.344 ms | 0 | /classes/Hook.php:1292 | ||
15 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps21_module` m INNER JOIN ps21_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps21_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps21_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps21_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
2.120 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
168 | SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=721 AND c.nright<=722 GROUP BY p.id_product) p INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 24 |
2.083 ms | 40706290564 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
172 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("cd35c19165b54082851891d240e3a7ae", "a:1:{s:7:\"filters\";a:0:{}}") |
2.005 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
169 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=721 AND c.nright<=722 GROUP BY p.id_product) p |
1.792 ms | 40706290564 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
288 | 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.696 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
52 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.688 ms | 386 | /classes/Hook.php:456 | ||
280 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('895531', '', 'cadeaufou.com/538-enregistreurs-audio', '', '2023-11-30 12:38:25') |
1.510 ms | 1 | /classes/ObjectModel.php:622 | ||
284 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 4040868310, 'https://cadeaufou.com/538-enregistreurs-audio', 1, 2, 1, 538, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.366 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
275 | 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.297 ms | 1 | /classes/ObjectModel.php:622 | ||
173 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-11-30 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (28928,350524,362344,364099,367997) |
1.114 ms | 5 | /classes/ProductAssembler.php:95 | ||
163 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 721) AND (a0.`nright` > 722) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.097 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
1.049 ms | 880 | /classes/Hook.php:1332 | ||
279 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('897820', '1811', '752115218', '', '1', '1', '2023-11-30 12:38:25') |
0.995 ms | 1 | /classes/ObjectModel.php:622 | ||
254 | 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 (28928) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.993 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
139 | SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps21_category` c INNER JOIN ps21_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps21_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 538 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.944 ms | 1 | Yes | Yes | /classes/Category.php:921 |
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` < 721) AND (a0.`nright` > 722) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.838 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
253 | SELECT SQL_NO_CACHE * FROM `ps21_zcolumnblock` b LEFT JOIN `ps21_zcolumnblock_lang` bl ON b.`id_zcolumnblock` = bl.`id_zcolumnblock` WHERE b.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY b.`id_zcolumnblock` ORDER BY b.`position` ASC |
0.781 ms | 16 | Yes | Yes | /modules/zonecolumnblocks/classes/ZColumnBlock.php:116 |
257 | 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 (350524) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.749 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.696 ms | 880 | /classes/Hook.php:1292 | ||
258 | 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 (362344) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.634 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
283 | 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.633 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
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.611 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
259 | 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 (364099) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.594 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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.586 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.569 ms | 81 | /classes/module/Module.php:345 | ||
141 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-11-30 00:00:00" AND date_to <= "2023-11-30 23:59:59") OR (date_from >= "2023-11-30 00:00:00" AND date_from <= "2023-11-30 23:59:59") OR (date_from < "2023-11-30 00:00:00" AND date_to > "2023-11-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.564 ms | 5 | /classes/CartRule.php:357 | ||
231 | 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` = 367997) AND (b.`id_shop` = 1) LIMIT 1 |
0.560 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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` = 364099 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` = 364099 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.558 ms | 0 | /classes/Cart.php:1410 | ||
247 | SELECT SQL_NO_CACHE * FROM `ps21_zmenu` m LEFT JOIN `ps21_zmenu_lang` ml ON m.`id_zmenu` = ml.`id_zmenu` WHERE m.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY m.`id_zmenu` ORDER BY m.`position` ASC |
0.554 ms | 7 | Yes | Yes | /modules/zonemegamenu/classes/ZMenu.php:104 |
234 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.552 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
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.542 ms | 81 | /classes/module/Module.php:345 | ||
184 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 28928 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` = 28928 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.521 ms | 0 | /classes/Cart.php:1410 | ||
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` = 28928) AND (b.`id_shop` = 1) LIMIT 1 |
0.518 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
200 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 362344 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` = 362344 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.514 ms | 0 | /classes/Cart.php:1410 | ||
217 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 367997 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` = 367997 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.507 ms | 0 | /classes/Cart.php:1410 | ||
260 | 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 (367997) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.503 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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.502 ms | 1 | /classes/CartRule.php:418 | ||
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.502 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.498 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
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.492 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
228 | 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` = 364099) AND (b.`id_shop` = 1) LIMIT 1 |
0.489 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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` = 28928 ORDER BY `position` |
0.482 ms | 4 | Yes | /classes/Product.php:3545 | |
222 | 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` = 350524) AND (b.`id_shop` = 1) LIMIT 1 |
0.481 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 538 AND ctg.`id_group` = 1 LIMIT 1 |
0.479 ms | 1 | /classes/Category.php:1751 | ||
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.478 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
192 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 350524 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` = 350524 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.455 ms | 0 | /classes/Cart.php:1410 | ||
225 | 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` = 362344) AND (b.`id_shop` = 1) LIMIT 1 |
0.450 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
194 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 362344 AND image_shop.`cover` = 1 LIMIT 1 |
0.444 ms | 1 | /classes/Product.php:3570 | ||
165 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 538 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.434 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
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.431 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
201 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 362344 ORDER BY f.position ASC |
0.431 ms | 1 | Yes | /classes/Product.php:5993 | |
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` = 538) AND (b.`id_shop` = 1) LIMIT 1 |
0.427 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
193 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 350524 ORDER BY f.position ASC |
0.427 ms | 1 | Yes | /classes/Product.php:5993 | |
267 | SELECT SQL_NO_CACHE c.id_cms, l.meta_title FROM ps21_cms c JOIN ps21_cms_lang l ON (c.id_cms = l.id_cms) INNER JOIN ps21_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1) WHERE l.id_lang = 1 AND c.`active` = 1 GROUP BY c.id_cms ORDER BY c.`position` |
0.426 ms | 25 | Yes | Yes | /classes/CMS.php:184 |
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.423 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
174 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 28928 AND image_shop.`cover` = 1 LIMIT 1 |
0.423 ms | 4 | /classes/Product.php:3570 | ||
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.402 ms | 6 | /classes/CartRule.php:418 | ||
185 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28928 ORDER BY f.position ASC |
0.397 ms | 1 | Yes | /classes/Product.php:5993 | |
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.393 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.392 ms | 1 | /classes/Customer.php:503 | ||
226 | 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` = 362344 ORDER BY `position` |
0.392 ms | 1 | Yes | /classes/Product.php:3545 | |
232 | 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` = 367997 ORDER BY `position` |
0.392 ms | 1 | Yes | /classes/Product.php:3545 | |
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 = 364099 ORDER BY f.position ASC |
0.391 ms | 1 | Yes | /classes/Product.php:5993 | |
223 | 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` = 350524 ORDER BY `position` |
0.387 ms | 2 | Yes | /classes/Product.php:3545 | |
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.384 ms | 1 | /classes/Language.php:1216 | ||
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.377 ms | 1 | /classes/Currency.php:1136 | ||
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.376 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
218 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 367997 ORDER BY f.position ASC |
0.350 ms | 1 | Yes | /classes/Product.php:5993 | |
229 | 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` = 364099 ORDER BY `position` |
0.345 ms | 1 | Yes | /classes/Product.php:3545 | |
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.340 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.326 ms | 1 | Yes | /classes/Currency.php:709 | |
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.325 ms | 81 | /classes/module/Module.php:345 | ||
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.324 ms | 1 | /classes/Customer.php:503 | ||
54 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.321 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.317 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
143 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-11-30 00:00:00" AND date_to <= "2023-11-30 23:59:59") OR (date_from >= "2023-11-30 00:00:00" AND date_from <= "2023-11-30 23:59:59") OR (date_from < "2023-11-30 00:00:00" AND date_to > "2023-11-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.310 ms | 5 | /classes/CartRule.php:357 | ||
276 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 897820 AND `date_add` > '2023-11-30 12:08:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.308 ms | 1 | Yes | /classes/Connection.php:168 | |
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.305 ms | 1 | /classes/Customer.php:475 | ||
137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.304 ms | 10 | Yes | /classes/ImageType.php:109 | |
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.302 ms | 1 | /classes/Customer.php:475 | ||
62 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 4 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.300 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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 | ||
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.290 ms | 1 | /classes/shop/Shop.php:218 | ||
251 | 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.290 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
213 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 367997) |
0.284 ms | 1 | /classes/Product.php:3857 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.282 ms | 10 | Yes | /classes/ImageType.php:109 | |
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` = 364099) |
0.282 ms | 1 | /classes/Product.php:3857 | ||
186 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 350524 AND image_shop.`cover` = 1 LIMIT 1 |
0.280 ms | 2 | /classes/Product.php:3570 | ||
178 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28928) |
0.280 ms | 1 | /classes/Product.php:3857 | ||
16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.279 ms | 88 | /classes/Hook.php:287 | ||
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.279 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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.273 ms | 1 | /classes/Language.php:1080 | ||
268 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1 |
0.272 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.268 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-11-30 12:38:00' OR date_to<'2023-11-30 12:38:00'; |
0.267 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
171 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 538 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.266 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
177 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 116 AND `active` = 1 LIMIT 1 |
0.266 ms | 1 | /classes/Manufacturer.php:316 | ||
281 | SELECT SQL_NO_CACHE data FROM `ps21_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.266 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43 | ||
235 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a LEFT JOIN `ps21_zthememanager_lang` `b` ON a.`id_zthememanager` = b.`id_zthememanager` AND b.`id_lang` = 1 WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.255 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
166 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 538) LIMIT 1 |
0.253 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
237 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.252 ms | 1 | /classes/module/Module.php:2636 | ||
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.250 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.248 ms | 88 | /classes/Hook.php:339 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-11-30 12:38:00' AND date_from <= '2023-11-30 14:38:00') OR (date_to >= '2023-11-30 12:38:00' AND date_to <= '2023-11-30 14:38:00'); |
0.246 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
269 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.245 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
245 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.244 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.243 ms | 1 | /classes/shop/Shop.php:1183 | ||
188 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 350524) |
0.237 ms | 1 | /classes/Product.php:3857 | ||
282 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.237 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
273 | SELECT SQL_NO_CACHE `save_time` FROM `ps21_zpopupnewsletter` WHERE `id_shop` = 1 AND `active` = 1 LIMIT 1 |
0.236 ms | 1 | /modules/zonepopupnewsletter/classes/ZPopupNewsletter.php:78 | ||
271 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 5) AND (b.`id_shop` = 1) LIMIT 1 |
0.235 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
182 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.234 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
196 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 362344) |
0.234 ms | 1 | /classes/Product.php:3857 | ||
136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.233 ms | 1 | /classes/FeatureFlag.php:105 | ||
7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.232 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.232 ms | 1 | /classes/order/Order.php:881 | ||
199 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 362344) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.232 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
270 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1 |
0.232 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
149 | SELECT SQL_NO_CACHE format FROM `ps21_address_format` WHERE `id_country` = 8 LIMIT 1 |
0.231 ms | 1 | /classes/AddressFormat.php:656 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.227 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
126 | SELECT SQL_NO_CACHE * FROM `ps21_group_lang` WHERE `id_group` = 1 |
0.225 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
121 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key_mobile' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.218 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
249 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.217 ms | 1 | /classes/module/Module.php:2636 | ||
210 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 367997 AND image_shop.`cover` = 1 LIMIT 1 |
0.217 ms | 1 | /classes/Product.php:3570 | ||
202 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 364099 AND image_shop.`cover` = 1 LIMIT 1 |
0.214 ms | 1 | /classes/Product.php:3570 | ||
236 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.214 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
117 | SELECT SQL_NO_CACHE id FROM `ps21_jm_pagecache_contexts` WHERE `id_shop`=1 AND `id_lang`=1 AND `id_currency`=1 AND `id_fake_customer` IS NULL AND `id_device`=1 AND `id_country` IS NULL AND `id_tax_csz`=1 AND `id_specifics` IS NULL LIMIT 1 |
0.211 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
230 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 364099 |
0.210 ms | 1 | /classes/Product.php:2902 | ||
248 | SELECT SQL_NO_CACHE d.`id_zmenu`, COUNT(d.`id_zdropdown`) as total FROM `ps21_zdropdown` d WHERE `active` = 1 GROUP BY d.`id_zmenu` |
0.209 ms | 8 | Yes | /modules/zonemegamenu/classes/ZMenu.php:232 | |
21 | SELECT SQL_NO_CACHE * FROM `ps21_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.208 ms | 1 | /classes/module/Module.php:2018 | ||
262 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.207 ms | 1 | /classes/module/Module.php:2636 | ||
23 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "bvkseodispatcher" LIMIT 1 |
0.206 ms | 0 | /classes/module/Module.php:2636 | ||
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.206 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
183 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 28928) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.204 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
63 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 4) LIMIT 1 |
0.204 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
261 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.202 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
274 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.202 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
207 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 364099) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.201 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
170 | SELECT SQL_NO_CACHE data FROM ps21_layered_filter_block WHERE hash="cd35c19165b54082851891d240e3a7ae" LIMIT 1 |
0.200 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:186 | ||
157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.198 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
130 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.198 ms | 1 | /classes/Language.php:883 | ||
164 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.196 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
277 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.196 ms | 1 | /classes/Page.php:104 | ||
10 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "jprestaspeedpack" LIMIT 1 |
0.195 ms | 1 | /classes/module/Module.php:2636 | ||
134 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.193 ms | 1 | /classes/Language.php:883 | ||
167 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 538 AND `id_shop` = 1 |
0.192 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
24 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "superuser" LIMIT 1 |
0.191 ms | 0 | /classes/module/Module.php:2636 | ||
41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.188 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
233 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 367997 |
0.187 ms | 1 | /classes/Product.php:2902 | ||
243 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.185 ms | 1 | /classes/module/Module.php:2636 | ||
272 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.184 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
57 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 2) LIMIT 1 |
0.183 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
162 | SELECT SQL_NO_CACHE * FROM `ps21_zcolorsfonts` a WHERE (a.`id_zcolorsfonts` = 1) LIMIT 1 |
0.183 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
146 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_legalcompliance" LIMIT 1 |
0.178 ms | 0 | /classes/module/Module.php:2636 | ||
153 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps21_required_field |
0.177 ms | 1 | /classes/ObjectModel.php:1592 | ||
43 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ets_affiliatemarketing" LIMIT 1 |
0.174 ms | 0 | /classes/module/Module.php:2636 | ||
161 | SELECT SQL_NO_CACHE id_zcolorsfonts FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.174 ms | 1 | /modules/zonecolorsfonts/classes/ZColorsFonts.php:118 | ||
278 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 538 LIMIT 1 |
0.169 ms | 2 | /classes/Page.php:83 | ||
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.168 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
250 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.168 ms | 1 | /classes/module/Module.php:2109 | ||
221 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 28928 |
0.165 ms | 1 | /classes/Product.php:2902 | ||
55 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 1 |
0.165 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
11 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 91 AND `id_shop` = 1 LIMIT 1 |
0.164 ms | 1 | /classes/module/Module.php:2109 | ||
58 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 2 |
0.163 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
9 | SELECT SQL_NO_CACHE id_shop FROM `ps21_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.161 ms | 1 | /classes/ObjectModel.php:1729 | ||
187 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 538 LIMIT 1 |
0.160 ms | 1 | /classes/Product.php:5639 | ||
263 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.158 ms | 1 | /classes/module/Module.php:2109 | ||
256 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.157 ms | 1 | /classes/module/Module.php:2109 | ||
266 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.157 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
244 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.156 ms | 1 | /classes/module/Module.php:2109 | ||
150 | SELECT SQL_NO_CACHE `need_identification_number` FROM `ps21_country` WHERE `id_country` = 8 LIMIT 1 |
0.155 ms | 1 | /classes/Country.php:402 | ||
224 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 350524 |
0.154 ms | 1 | /classes/Product.php:2902 | ||
264 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.154 ms | 1 | /classes/module/Module.php:2636 | ||
227 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 362344 |
0.153 ms | 1 | /classes/Product.php:2902 | ||
115 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "iqitthemeeditor" LIMIT 1 |
0.152 ms | 0 | /classes/module/Module.php:2636 | ||
113 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "wkexitpopup" LIMIT 1 |
0.149 ms | 0 | /classes/module/Module.php:2636 | ||
255 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.149 ms | 1 | /classes/module/Module.php:2636 | ||
71 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ageverify" LIMIT 1 |
0.148 ms | 0 | /classes/module/Module.php:2636 | ||
108 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.147 ms | 0 | /classes/module/Module.php:2109 | ||
138 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` |
0.146 ms | 10 | /classes/ImageType.php:161 | ||
158 | SELECT SQL_NO_CACHE `content` FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.146 ms | 1 | /modules/zonethememanager/classes/ZManager.php:194 | ||
179 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 28928 AND id_shop=1 LIMIT 1 |
0.146 ms | 1 | /classes/Product.php:6848 | ||
286 | DELETE FROM `ps21_jm_pagecache_bl` WHERE `id`=475; |
0.145 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
77 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "uecookie" LIMIT 1 |
0.144 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.144 ms | 1 | /classes/Currency.php:893 | ||
285 | DELETE FROM `ps21_jm_pagecache_mods` WHERE `id`=475; |
0.143 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
152 | SELECT SQL_NO_CACHE * FROM `ps21_country_lang` WHERE `id_country` = 8 |
0.142 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
90 | 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 | ||
175 | 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` = 538 LIMIT 1 |
0.141 ms | 1 | /classes/Category.php:1375 | ||
195 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 538 LIMIT 1 |
0.140 ms | 1 | /classes/Product.php:5639 | ||
189 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 350524 AND id_shop=1 LIMIT 1 |
0.139 ms | 1 | /classes/Product.php:6848 | ||
216 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 367997) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.138 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
239 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2636 | ||
38 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "smartseourl" LIMIT 1 |
0.137 ms | 0 | /classes/module/Module.php:2636 | ||
156 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.136 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
191 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 350524) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.136 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
64 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 4 |
0.134 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
61 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 3 |
0.133 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
107 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "nxtalpricetaxswitcher" LIMIT 1 |
0.133 ms | 0 | /classes/module/Module.php:2636 | ||
190 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 350524 AND `id_group` = 1 LIMIT 1 |
0.133 ms | 0 | /classes/GroupReduction.php:156 | ||
238 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.133 ms | 1 | /classes/module/Module.php:2109 | ||
44 | 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 | ||
176 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 538 LIMIT 1 |
0.131 ms | 1 | /classes/Product.php:5639 | ||
42 | SELECT SQL_NO_CACHE id_shop FROM `ps21_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.130 ms | 1 | /classes/ObjectModel.php:1729 | ||
118 | SELECT SQL_NO_CACHE context_key FROM `ps21_jm_pagecache_contexts` WHERE id = 1 |
0.130 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
82 | 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 | ||
205 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 364099 AND id_shop=1 LIMIT 1 |
0.129 ms | 1 | /classes/Product.php:6848 | ||
206 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 364099 AND `id_group` = 1 LIMIT 1 |
0.129 ms | 0 | /classes/GroupReduction.php:156 | ||
25 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.128 ms | 0 | /classes/module/Module.php:2109 | ||
60 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 3) LIMIT 1 |
0.128 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
101 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "hicookielaw" LIMIT 1 |
0.128 ms | 0 | /classes/module/Module.php:2636 | ||
127 | SELECT SQL_NO_CACHE id_shop FROM `ps21_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.128 ms | 1 | /classes/ObjectModel.php:1729 | ||
88 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.126 ms | 0 | /classes/module/Module.php:2109 | ||
45 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "creativeelements" LIMIT 1 |
0.125 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.124 ms | 0 | /classes/module/Module.php:2109 | ||
28 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "wkadminloginascustomer" LIMIT 1 |
0.123 ms | 0 | /classes/module/Module.php:2636 | ||
67 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "gdprpro" LIMIT 1 |
0.122 ms | 0 | /classes/module/Module.php:2636 | ||
203 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 538 LIMIT 1 |
0.122 ms | 1 | /classes/Product.php:5639 | ||
265 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.122 ms | 1 | /classes/module/Module.php:2109 | ||
26 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "atssuperuser" LIMIT 1 |
0.121 ms | 0 | /classes/module/Module.php:2636 | ||
211 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 538 LIMIT 1 |
0.121 ms | 1 | /classes/Product.php:5639 | ||
246 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.121 ms | 1 | /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.120 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.120 ms | 0 | / |