9,61 €
Leggings et joggings
Il y a 5 produits.
45,86 €
11,29 €
Il y a 5 produits.
Load Time | 667.164 ms |
Querying Time | 125 ms |
Queries | 315 |
Memory Peak Usage | 24.7 Mb |
Included Files | 1263 files - 11.89 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.604 ms | 5.604 ms | 8.54 Mb | 9.2 Mb |
__construct | 9.294 ms | 14.898 ms | 1.73 Mb | 11.9 Mb |
config | 27.148 ms | 42.046 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.046 ms | 42.092 ms | - Mb | 11.9 Mb |
init | 43.928 ms | 86.020 ms | 2.13 Mb | 14.8 Mb |
checkAccess | 0.002 ms | 86.022 ms | - Mb | 14.8 Mb |
setMedia | 3.613 ms | 89.635 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.002 ms | 89.637 ms | - Mb | 14.8 Mb |
initHeader | 0.002 ms | 89.639 ms | - Mb | 14.8 Mb |
initContent | 214.275 ms | 303.914 ms | 4.49 Mb | 19.3 Mb |
initFooter | 0.004 ms | 303.918 ms | - Mb | 19.3 Mb |
display | 363.246 ms | 667.164 ms | 5.73 Mb | 24.7 Mb |
Hook | Time | Memory Usage |
---|---|---|
ActionOutputHTMLBefore | 42.047 ms | 0.14 Mb |
ActionDispatcherBefore | 39.037 ms | 3.09 Mb |
displayLeftColumn | 26.131 ms | 0.74 Mb |
displayProductListReviews | 25.244 ms | 1.29 Mb |
displayTop | 16.599 ms | 0.21 Mb |
ActionDispatcher | 16.315 ms | 0.70 Mb |
DisplayBeforeBodyClosingTag | 14.585 ms | 0.27 Mb |
DisplayFooter | 11.335 ms | 0.11 Mb |
displayFooterRight | 3.492 ms | 0.07 Mb |
DisplayHeader | 3.091 ms | 0.06 Mb |
DisplayLeftColumn | 1.598 ms | 0.02 Mb |
ActionFrontControllerSetVariables | 1.333 ms | 0.06 Mb |
displayNav2 | 1.108 ms | 0.08 Mb |
ActionFrontControllerSetMedia | 1.085 ms | 0.01 Mb |
displayFooterLeft | 0.746 ms | 0.06 Mb |
DisplayOutsideMainPage | 0.709 ms | 0.03 Mb |
DisplayFooterLeft | 0.408 ms | 0.01 Mb |
DisplayBanner | 0.333 ms | 0.01 Mb |
DisplayFooterRight | 0.333 ms | 0.01 Mb |
DisplayFooterAfter | 0.323 ms | 0.01 Mb |
DisplayNavFullWidth | 0.312 ms | 0.01 Mb |
DisplaySidebarNavigation | 0.290 ms | - Mb |
ProductSearchProvider | 0.280 ms | - Mb |
DisplayNav1 | 0.262 ms | 0.01 Mb |
ActionObjectAddAfter | 0.041 ms | - Mb |
ActionFrontControllerInitAfter | 0.039 ms | - Mb |
ModuleRoutes | 0.025 ms | 0.02 Mb |
DisplayAfterBodyOpeningTag | 0.013 ms | - Mb |
DisplayFooterBefore | 0.010 ms | - Mb |
29 hook(s) | 207.123 ms | 7.03 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 5.599 ms | 0.54 Mb |
jprestaspeedpack | 98.614 ms | 4.00 Mb |
blockreassurance | 1.366 ms | 0.09 Mb |
blockwishlist | 11.820 ms | 0.13 Mb |
ps_emailsubscription | 3.766 ms | 0.10 Mb |
ps_socialfollow | 0.927 ms | 0.07 Mb |
ps_emailalerts | 0.262 ms | 0.09 Mb |
zonethememanager | 14.195 ms | 1.30 Mb |
ps_shoppingcart | 11.409 ms | 0.12 Mb |
ps_searchbar | 1.939 ms | 0.14 Mb |
productcomments | 25.443 ms | 1.33 Mb |
ps_googleanalytics | 8.114 ms | 0.05 Mb |
zonecolorsfonts | 1.264 ms | 0.06 Mb |
zonemegamenu | 1.981 ms | 0.06 Mb |
prestastripe | 0.749 ms | 0.02 Mb |
ps_facetedsearch | 1.992 ms | 0.10 Mb |
ps_languageselector | 0.727 ms | 0.06 Mb |
ps_currencyselector | 0.623 ms | 0.06 Mb |
ps_customersignin | 3.753 ms | 0.08 Mb |
ps_categorytree | 26.288 ms | 0.75 Mb |
zonecolumnblocks | 0.749 ms | 0.11 Mb |
zonepopupnewsletter | 0.597 ms | 0.03 Mb |
statsdata | 6.685 ms | 0.27 Mb |
23 module(s) | 228.862 ms | 9.55 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
313 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (49,803264849),(49,1502204888),(49,3620157415),(49,1289214159),(49,1785617407),(49,2936477779),(49,1727466530),(49,1432532875),(49,1025009294),(49,1804081323),(49,3479716883),(49,66301815),(49,537553573),(49,3045727500),(49,3231073010),(49,1825096520),(49,3225262556),(49,2645763144),(49,2027619899),(49,786864081),(49,1849360992),(49,294428854),(49,3774376179),(49,2880678980),(49,114155291),(49,2929321318),(49,2087307803),(49,2369020978),(49,1152186767),(49,4222788516),(49,2858566420),(49,848840972),(49,4147554351),(49,770698498),(49,2244011448),(49,477004582),(49,3610318732),(49,1070190107),(49,937307692),(49,25761885),(49,3366890060),(49,3483396593),(49,392306519),(49,909258745),(49,179865882),(49,3099645137),(49,3371246540),(49,2390640699),(49,501027234),(49,3032495894),(49,2100541971),(49,2793494280),(49,180908336),(49,1192985740),(49,1972034646),(49,2419117650),(49,3803768817),(49,4265874642),(49,67723771),(49,3423129237),(49,3399895114),(49,3221089548),(49,2990154896),(49,2728213885),(49,933991437),(49,2513627470),(49,468067826),(49,4137721533),(49,1552016987),(49,4080301755),(49,4245349388),(49,1973472416),(49,1839057912),(49,3745041382),(49,3035734567),(49,3719469943),(49,3466131047),(49,679558129),(49,462819688),(49,4267553191),(49,518809702),(49,3303811122),(49,2883778317),(49,1694893476),(49,3287268691),(49,3711637102),(49,698879415),(49,885817714),(49,125306139),(49,1634619674),(49,58280175),(49,3363778289),(49,1161663254),(49,201135304),(49,288600709),(49,1021330335),(49,2858809635),(49,2763627026),(49,3717400459),(49,4125370705),(49,3997906175),(49,4162316513),(49,3219397995),(49,2539165674),(49,1046234598),(49,787652129),(49,1595426297),(49,4184932827),(49,1985552396),(49,1944795689),(49,3799916950),(49,1827123668),(49,1447744642),(49,1636796806),(49,2645405926),(49,1474595477),(49,3375525138),(49,3902077767),(49,3507415422),(49,2781072282),(49,2002273313),(49,3164880625),(49,2490789905),(49,1000843653),(49,48947005),(49,3883347157),(49,3700474777),(49,4264269047),(49,2125390191),(49,4270481046),(49,1693150473),(49,343450730),(49,381351735),(49,2863449446),(49,3772294966),(49,3877457961),(49,1492116830),(49,4041511410),(49,828132466),(49,4090211224),(49,2185737194),(49,3517149926),(49,647687838),(49,733479784),(49,1440916471),(49,3262261204),(49,1872100372),(49,2092461357),(49,3357609169),(49,2365529006),(49,1263061406),(49,2296732656),(49,534196217),(49,482025419),(49,2811467352),(49,2488480532),(49,3501473861),(49,1917272649),(49,1878317490),(49,1789511633),(49,956713705),(49,89981727),(49,1143557322),(49,2749361789),(49,3857194488),(49,1024086260),(49,26040876),(49,1804243295),(49,2165251395),(49,1281618245),(49,2793993627),(49,426054238),(49,3398682121),(49,1025101115),(49,2974984653),(49,2214325187),(49,997821910),(49,2005463392),(49,3252396061),(49,942332382),(49,3816934055),(49,1661692647),(49,975758589),(49,3974931321),(49,2301364099),(49,855746680),(49,637832447),(49,3938675492),(49,508940865),(49,911480697),(49,1283363269),(49,3552869238),(49,2961923901),(49,3747234531),(49,3155646160),(49,3164668199),(49,2271068282),(49,84354396),(49,2915068863),(49,4064530110),(49,3216991891),(49,2045363644),(49,2664176477),(49,1076722390),(49,505410826),(49,3544422162),(49,2506779464),(49,2552384108),(49,876907216),(49,82980331),(49,3890150098),(49,3475437886),(49,2302280848),(49,1133144647),(49,801167173),(49,2059315716),(49,3139619822),(49,2937007520),(49,1589371182),(49,693370988),(49,2708427394),(49,1007456900),(49,610735313),(49,3846627131),(49,2031830639),(49,1908602231),(49,1401333655),(49,378101424),(49,996218346),(49,660881695),(49,2938384267),(49,4250264855),(49,1895305721),(49,502965417),(49,1982471117),(49,2524144246),(49,2774996218),(49,1068709096),(49,4077513867),(49,2900588200),(49,465472731),(49,4139839450),(49,2360011682),(49,4211248848),(49,283341417),(49,4165214622),(49,3508523596),(49,234404923),(49,2782693783),(49,3413880379),(49,3540168379),(49,861653603),(49,3160995915),(49,1391251310),(49,2106651858),(49,3572623339),(49,4629984),(49,2488722736),(49,3486510944),(49,2675016634),(49,2165907305),(49,136687257),(49,3540179561),(49,2792526429),(49,2220600372),(49,2914585448),(49,3882733113),(49,1688090355),(49,3534950496),(49,1182870252),(49,412601709),(49,574969182),(49,2970413814),(49,1487282505),(49,3228977345),(49,2023459642),(49,3291711134),(49,2792891444),(49,3335276918),(49,502111155),(49,1347492703),(49,2832080533),(49,1215320197),(49,2317239205),(49,1931846913),(49,1721014625),(49,738600257),(49,2998338424),(49,1207945902),(49,734241479),(49,3324570843),(49,4126771257),(49,1712456575),(49,3169253733),(49,1160958045),(49,1130949510),(49,3116084871),(49,269178051),(49,24773614),(49,3204450510),(49,3468662336),(49,1808444077),(49,4095410992),(49,1012520131),(49,2367920745),(49,2603361072),(49,2741539031),(49,607507456),(49,616165826),(49,2288576869),(49,4252798532),(49,2692385638),(49,4100315394),(49,3061254709),(49,1657292258),(49,2148967437),(49,1248236410),(49,2457219175),(49,1920985790),(49,1340703149),(49,1618471777),(49,4160689201),(49,1822364967),(49,479188821),(49,1661785323),(49,4137484009),(49,2636427258),(49,1499247737),(49,2061922205),(49,665830591),(49,916194615),(49,495595719),(49,3026469794),(49,1845449656),(49,4078122428),(49,2044505385),(49,3156749269),(49,3919036276),(49,204613135),(49,605377709),(49,766051911),(49,30400764),(49,4211022030),(49,715827285),(49,1092948871),(49,610201349),(49,1023110113),(49,3379323545),(49,2591028766),(49,1994095466),(49,33157726),(49,198243957),(49,94201498),(49,2540831776),(49,1707019604),(49,2730046909),(49,4101073252),(49,207761914),(49,2750534087),(49,980926717),(49,377071036),(49,2983490672),(49,584353846),(49,1743688562),(49,3223058413),(49,1665991311),(49,3093731065),(49,1095877807),(49,1085889875),(49,2059985562),(49,3618062925),(49,592374860),(49,4217863027),(49,3425247989),(49,1636391408),(49,1698766782),(49,2162739858),(49,1538367880),(49,3760626336),(49,1987713032),(49,2338874856),(49,4206689645),(49,1723372602),(49,2788329276),(49,2095305502),(49,3135330775),(49,2402748468),(49,24058172),(49,4000683245),(49,315670382),(49,2558276906),(49,1745365471),(49,2782569384),(49,3422117706),(49,552626444),(49,1506232339),(49,2933163456),(49,1483801350),(49,1400586123),(49,3746875726),(49,2604810181),(49,2905930158),(49,803588046),(49,1651400661),(49,1431243585),(49,1586185269),(49,4110009762),(49,3647374073),(49,4196158832),(49,644435096),(49,1862966990),(49,2098775956),(49,4045847707),(49,3122054119),(49,1971194991),(49,2149367276),(49,1888540635),(49,2660577125),(49,2508340497),(49,196341346),(49,1790101800),(49,1054130805),(49,2741947598),(49,1292400575),(49,545037028),(49,1516477184),(49,2706799993),(49,562470873),(49,2591346466),(49,613023703),(49,2725609989),(49,2082081559),(49,572560232),(49,2833489058),(49,1999611979),(49,1938789650),(49,2958717166),(49,1035708154),(49,2025067287),(49,3804047398),(49,248028803),(49,4243412966),(49,628124381),(49,1271215494),(49,2140466223),(49,1298495884),(49,3585931255),(49,532975694),(49,892763084),(49,203145038),(49,470924714),(49,1460516495),(49,2732318442),(49,3996868778),(49,862206445),(49,3193479021),(49,3382171736),(49,3362897893),(49,3598913121),(49,1342337107),(49,3202829344),(49,1335223071),(49,270790954),(49,1086966479),(49,484642328),(49,4274468042),(49,1740107684),(49,2117688527),(49,1393082718),(49,366510022),(49,341328174),(49,1469264429),(49,968691010),(49,3210232788),(49,809700252),(49,3705477223),(49,1639200307),(49,3585776886),(49,3305319229),(49,1052899681),(49,2176267881),(49,357387863),(49,451177334),(49,677589039),(49,1181390953),(49,898241702),(49,3480303789),(49,1736215096),(49,2511740146),(49,2560762429),(49,1570623991),(49,897080848),(49,891021207),(49,2807843172),(49,411231410),(49,2413680770),(49,519468981),(49,1898829954),(49,4274422817),(49,2781196321),(49,433695516),(49,1652336127),(49,4200438598),(49,3032893805),(49,1435170492),(49,341146430),(49,755973553),(49,2183774725),(49,3967614532),(49,1589097164),(49,2441764320),(49,745126750),(49,348450311),(49,2084175962),(49,3357611772),(49,1654631620),(49,3098454302),(49,2029227635),(49,1731761366),(49,2444253995),(49,2906032508),(49,872274856),(49,4282856364),(49,3328013593),(49,4184469063),(49,1074477927),(49,475878802),(49,1341972790),(49,2770374005),(49,4237489391),(49,2818813526),(49,3131100007),(49,4267621199),(49,1031922959),(49,1616292706),(49,630426110),(49,1846388513),(49,2239793094),(49,1660370824),(49,3321716633),(49,2551727033),(49,1836172154),(49,1870881122),(49,3324207484),(49,1065867023),(49,1459310880),(49,1395112921),(49,893552556),(49,1795813847),(49,2544364435),(49,4188602229),(49,1437064809),(49,922605498),(49,4180843510),(49,2554784265),(49,3798404205),(49,1216801552),(49,225525148),(49,274058040),(49,3206796234),(49,610255635),(49,3139895407),(49,3993594441),(49,2078652070),(49,3340749058),(49,2282248923),(49,3201099700),(49,3944887276),(49,887478137),(49,620965629),(49,53639561),(49,687854272),(49,4204526813),(49,3434636086),(49,3859247582),(49,2160451939),(49,419013317),(49,488655959),(49,2224381764),(49,857621694),(49,593880699),(49,1743569168),(49,747100668),(49,2627272664),(49,1477316791),(49,852002855),(49,3813191394),(49,3206482767),(49,2935275735),(49,825997452),(49,4128572079),(49,4149399208),(49,2432005645),(49,945310979),(49,206553734),(49,3381625344),(49,2613891474),(49,1285565060),(49,725086502),(49,2181279565),(49,2136294074),(49,531227063),(49,3291030245),(49,3423892574),(49,1818418110),(49,1175554195),(49,231365613),(49,3071984169),(49,1510809703),(49,2304894647),(49,724387218),(49,3702122266),(49,3105745802),(49,3598888791),(49,40599425),(49,4256434691),(49,1198380170),(49,3549401556),(49,2300237909),(49,484124464),(49,3042798728),(49,767973032),(49,4146324303),(49,1493350341),(49,2166736334),(49,3061340275),(49,1468811388),(49,714571165),(49,1958965990),(49,2146366302),(49,2212338847),(49,2088651590),(49,2684538463),(49,2292708505),(49,571001464),(49,608126571),(49,2736309071),(49,1479333754),(49,1794660366),(49,2319975337),(49,1093438481),(49,2975864804),(49,2504416172),(49,3531750290),(49,219666672),(49,4219072870),(49,1053258155),(49,2382983142),(49,1006288562),(49,1770263986),(49,3089735283),(49,3689334927),(49,2901629603),(49,2019277020),(49,2853333944),(49,1110695191),(49,3884283185),(49,4268093708),(49,159799075),(49,1715997742),(49,1009155269),(49,3922001006),(49,3916338789),(49,1085252167),(49,207705430),(49,1190601026),(49,1441004396),(49,1567147586),(49,964098054),(49,1385174189),(49,3607427007),(49,4065177061),(49,1552830538),(49,3778287701),(49,3986294473),(49,4127238085),(49,1865170325),(49,2161789419),(49,2889615117),(49,785261358),(49,3873733217),(49,2600209543),(49,3958092558),(49,4143434528),(49,3225228598),(49,3451063310),(49,810085901),(49,2931931582),(49,1339720903),(49,4093703382),(49,1016897830),(49,1186809094),(49,2269117600),(49,813555736),(49,733475850),(49,305814753),(49,2720553993),(49,212227262),(49,1328958432),(49,3903742053),(49,2617942920),(49,4254367326),(49,2895836413),(49,1090341105),(49,3174277595),(49,639084285),(49,4064195579),(49,2134315289),(49,608843276),(49,4190247440),(49,1090444753),(49,2554275840),(49,2758076506),(49,2518001916),(49,1195920681),(49,1822840633),(49,1087551238),(49,235508323),(49,1139244570),(49,810960133),(49,425550269),(49,1767940144),(49,1488780247),(49,1250541405),(49,1715845038),(49,3777612587),(49,2285237154),(49,802817926),(49,4280998710),(49,1108258121),(49,1107026853),(49,2913745362),(49,1129101120),(49,2454813183),(49,1690919006),(49,23973636),(49,293370743),(49,1041759778),(49,3142497267),(49,2920365983),(49,2300359472),(49,885232682),(49,1995817456),(49,3443377157),(49,863919144),(49,1324348692),(49,4019216150),(49,443752815),(49,4223293),(49,1182491637),(49,4257294915),(49,3629776934),(49,582958316),(49,3061655453),(49,1665355533),(49,1929899841),(49,1033949851),(49,2010879266),(49,1872304779),(49,1282102725),(49,3589651214),(49,4095654001),(49,2447713556),(49,2543494532),(49,2069898435),(49,3286503857),(49,2662939963),(49,93111834),(49,3160936308),(49,261262800),(49,141197408),(49,1904512268),(49,3001025754),(49,2247670246),(49,535154833),(49,3476002757),(49,3806439314),(49,1819793014),(49,3545273473),(49,3957652542),(49,3018295592),(49,1367893712),(49,1034338066),(49,3229510223),(49,4276953245),(49,3363858574),(49,2870596766),(49,648526699),(49,3627085975),(49,1585047995),(49,1960922033),(49,748737253),(49,1175066615),(49,1318322018),(49,260367662),(49,643741484),(49,1013706048),(49,1726352130),(49,2222354404),(49,1327031463),(49,1131865044),(49,839200087),(49,1407668396),(49,3548333318),(49,237845721),(49,3056051791),(49,747235328),(49,172675174),(49,2781705803),(49,2111348799),(49,3067187587),(49,618638032),(49,3369756381),(49,2232055662),(49,55113216),(49,3939915090),(49,2586983921),(49,3286008345),(49,1956055310),(49,740042513),(49,2282536358),(49,1863122946),(49,1296880981),(49,2589434346),(49,1621393368),(49,39250009),(49,72263924),(49,1587391050),(49,847186998),(49,2455499024),(49,859347884),(49,2244795234),(49,64890532),(49,3542312395),(49,3404023338),(49,2771940256),(49,590961453),(49,429123690),(49,3924888977),(49,1697117306),(49,3406763364),(49,1129505049) ON DUPLICATE KEY UPDATE id=id |
11.004 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
261 | 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.389 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`) |
6.662 ms | 1298 | /classes/Configuration.php:180 | ||
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>=1437 AND c.nright<=1438 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.872 ms | 3586706480 | 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` |
2.399 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
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.353 ms | 0 | /classes/Hook.php:1292 | ||
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>=1437 AND c.nright<=1438 GROUP BY p.id_product) p |
2.225 ms | 3586706480 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
314 | 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 |
2.172 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 |
2.079 ms | 386 | /classes/Hook.php:456 | ||
306 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('916137', '', 'cadeaufou.com/255-leggings-et-joggings', '', '2023-12-01 10:18:11') |
1.500 ms | 1 | /classes/ObjectModel.php:622 | ||
310 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 1120781613, 'https://cadeaufou.com/255-leggings-et-joggings', 1, 2, 1, 255, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.385 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
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 (1062,132648,193548,260902,260930) |
1.365 ms | 5 | /classes/ProductAssembler.php:95 | ||
301 | 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.190 ms | 1 | /classes/ObjectModel.php:622 | ||
169 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("458c3d6b95f95ec03627d05bb6231d89", "a:1:{s:7:\"filters\";a:0:{}}") |
1.143 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
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` = 255 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
1.050 ms | 1 | Yes | Yes | /classes/Category.php:921 |
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
1.037 ms | 880 | /classes/Hook.php:1332 | ||
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` < 1437) AND (a0.`nright` > 1438) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.021 ms | 118 | Yes | /classes/PrestaShopCollection.php:383 | |
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.008 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
305 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('918428', '961', '751134203', '', '1', '1', '2023-12-01 10:18:11') |
1.004 ms | 1 | /classes/ObjectModel.php:622 | ||
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` < 1437) AND (a0.`nright` > 1438) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.979 ms | 118 | Yes | /classes/PrestaShopCollection.php:383 | |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.825 ms | 880 | /classes/Hook.php:1292 | ||
280 | 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 (132648) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.805 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
277 | 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 (1062) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.803 ms | 11 | Yes | Yes | /classes/Product.php:4504 |
266 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (195,196,197,198,199,200,201,202,203,204,205) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.738 ms | 22 | /classes/Product.php:2752 | ||
309 | 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.733 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
284 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (36432,36433,36434,36435,36436,36437,36438,36439,36440,36441) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.697 ms | 20 | /classes/Product.php:2752 | ||
245 | 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` = 260930) AND (b.`id_shop` = 1) LIMIT 1 |
0.688 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
174 | 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` = 1062) AND (b.`id_shop` = 1) LIMIT 1 |
0.621 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
144 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%" |
0.602 ms | 1 | /classes/CartRule.php:418 | ||
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.600 ms | 81 | /classes/module/Module.php:345 | ||
18 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.590 ms | 81 | /classes/module/Module.php:345 | ||
183 | 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` = 1062 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` = 1062 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.588 ms | 0 | /classes/Cart.php:1410 | ||
265 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* 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) WHERE pa.`id_product` = 1062 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.586 ms | 11 | Yes | /classes/Product.php:2734 | |
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.580 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
294 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (193548) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.579 ms | 10 | Yes | Yes | /classes/Product.php:4504 |
295 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (260902) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.562 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
262 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1062) LIMIT 1 |
0.560 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
0 | SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps21_shop_url su LEFT JOIN ps21_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'cadeaufou.com' OR su.domain_ssl = 'cadeaufou.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.558 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
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.550 ms | 6 | /classes/CartRule.php:418 | ||
198 | 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` = 132648 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` = 132648 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.547 ms | 0 | /classes/Cart.php:1410 | ||
188 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) 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) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 1062 AND pac.`id_product_attribute` = 195 AND agl.`id_lang` = 1 |
0.527 ms | 2 | /classes/Product.php:7506 | ||
242 | 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` = 260902) AND (b.`id_shop` = 1) LIMIT 1 |
0.523 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
296 | SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (260930) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.516 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
281 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 193548) LIMIT 1 |
0.515 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
246 | 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` = 260930 ORDER BY `position` |
0.496 ms | 1 | Yes | /classes/Product.php:3545 | |
236 | 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` = 132648) AND (b.`id_shop` = 1) LIMIT 1 |
0.486 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.481 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
304 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 255 LIMIT 1 |
0.471 ms | 1 | /classes/Page.php:83 | ||
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.469 ms | 5 | /classes/CartRule.php:357 | ||
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.466 ms | 5 | /classes/CartRule.php:357 | ||
231 | 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` = 260930 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` = 260930 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.466 ms | 0 | /classes/Cart.php:1410 | ||
283 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* 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) WHERE pa.`id_product` = 193548 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.463 ms | 10 | Yes | /classes/Product.php:2734 | |
202 | 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` = 193548) AND (b.`id_shop` = 1) LIMIT 1 |
0.461 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
199 | 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 = 132648 ORDER BY f.position ASC |
0.460 ms | 1 | Yes | /classes/Product.php:5993 | |
213 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) 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) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 193548 AND pac.`id_product_attribute` = 36432 AND agl.`id_lang` = 1 |
0.457 ms | 2 | /classes/Product.php:7506 | ||
162 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 255 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.453 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
224 | 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 = 260902 ORDER BY f.position ASC |
0.451 ms | 1 | Yes | /classes/Product.php:5993 | |
185 | 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` = 195 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1062 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` = 195 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1062 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.448 ms | 0 | /classes/Cart.php:1410 | ||
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` = 193548 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` = 193548 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.442 ms | 0 | /classes/Cart.php:1410 | ||
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.430 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
223 | 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` = 260902 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` = 260902 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.424 ms | 0 | /classes/Cart.php:1410 | ||
210 | 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` = 36432 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 193548 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` = 36432 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 193548 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.423 ms | 0 | /classes/Cart.php:1410 | ||
239 | 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` = 193548 ORDER BY `position` |
0.421 ms | 2 | Yes | /classes/Product.php:3545 | |
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` = 255) AND (b.`id_shop` = 1) LIMIT 1 |
0.419 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
187 | 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 = 1062 ORDER BY f.position ASC |
0.411 ms | 1 | Yes | /classes/Product.php:5993 | |
302 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 918428 AND `date_add` > '2023-12-01 09:48:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.411 ms | 1 | Yes | /classes/Connection.php:168 | |
212 | 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 = 193548 ORDER BY f.position ASC |
0.411 ms | 1 | Yes | /classes/Product.php:5993 | |
177 | 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` = 1062) |
0.393 ms | 11 | /classes/Product.php:3857 | ||
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 | ||
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.385 ms | 1 | /classes/order/Order.php:881 | ||
12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.384 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
194 | 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` = 132648) |
0.383 ms | 1 | /classes/Product.php:3857 | ||
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` = 193548) |
0.381 ms | 10 | /classes/Product.php:3857 | ||
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.378 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.372 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 255 AND ctg.`id_group` = 1 LIMIT 1 |
0.367 ms | 1 | /classes/Category.php:1751 | ||
260 | 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.367 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
232 | 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 = 260930 ORDER BY f.position ASC |
0.361 ms | 1 | Yes | /classes/Product.php:5993 | |
243 | 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` = 260902 ORDER BY `position` |
0.359 ms | 1 | Yes | /classes/Product.php:3545 | |
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.357 ms | 1 | /classes/Currency.php:1136 | ||
123 | SELECT SQL_NO_CACHE c.`passwd` FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.352 ms | 1 | /classes/Customer.php:475 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.352 ms | 10 | Yes | /classes/ImageType.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.351 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
233 | 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` = 1062 ORDER BY `position` |
0.351 ms | 5 | Yes | /classes/Product.php:3545 | |
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.348 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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.344 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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` = 1062 AND image_shop.`cover` = 1 LIMIT 1 |
0.342 ms | 5 | /classes/Product.php:3570 | ||
227 | 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` = 260930) |
0.336 ms | 1 | /classes/Product.php:3857 | ||
235 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps21_product_attribute_image` pai LEFT JOIN `ps21_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps21_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205) AND il.`id_lang` = 1 ORDER by i.`position` |
0.334 ms | 1 | Yes | /classes/Product.php:2921 | |
164 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 255 AND `id_shop` = 1 |
0.331 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
181 | 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.324 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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.321 ms | 1 | /classes/Language.php:1216 | ||
237 | 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` = 132648 ORDER BY `position` |
0.319 ms | 1 | Yes | /classes/Product.php:3545 | |
56 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 2 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.313 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
241 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps21_product_attribute_image` pai LEFT JOIN `ps21_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps21_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (36432, 36433, 36434, 36435, 36436, 36437, 36438, 36439, 36440, 36441) AND il.`id_lang` = 1 ORDER by i.`position` |
0.306 ms | 1 | Yes | /classes/Product.php:2921 | |
189 | SELECT SQL_NO_CACHE * FROM `ps21_product_attribute` a LEFT JOIN `ps21_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 195) LIMIT 1 |
0.306 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
168 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 255 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.300 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
263 | SELECT SQL_NO_CACHE * FROM `ps21_product_lang` WHERE `id_product` = 1062 AND `id_shop` = 1 |
0.299 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
176 | SELECT SQL_NO_CACHE product_attribute_shop.`price` 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) WHERE pa.`id_product_attribute` = 195 LIMIT 1 |
0.297 ms | 1 | /classes/Combination.php:564 | ||
186 | SELECT SQL_NO_CACHE pa.`available_date` FROM `ps21_product` p LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps21_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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) WHERE p.`id_product` = 1062 AND pa.`id_product` = 1062 AND pa.`id_product_attribute` = 195 LIMIT 1 |
0.291 ms | 1 | /classes/Product.php:1209 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-12-01 10:18:00' AND date_from <= '2023-12-01 12:18:00') OR (date_to >= '2023-12-01 10:18:00' AND date_to <= '2023-12-01 12:18:00'); |
0.289 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
308 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.288 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.285 ms | 1 | Yes | /classes/Currency.php:709 | |
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.284 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.281 ms | 10 | Yes | /classes/ImageType.php:109 | |
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.280 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.277 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.276 ms | 88 | /classes/Hook.php:339 | ||
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.275 ms | 1 | /classes/Customer.php:503 | ||
203 | SELECT SQL_NO_CACHE product_attribute_shop.`price` 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) WHERE pa.`id_product_attribute` = 36432 LIMIT 1 |
0.273 ms | 1 | /classes/Combination.php:564 | ||
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.272 ms | 1 | /classes/Language.php:1080 | ||
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.270 ms | 1 | /classes/Customer.php:475 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.268 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.268 ms | 1 | /classes/FeatureFlag.php:105 | ||
214 | SELECT SQL_NO_CACHE * FROM `ps21_product_attribute` a LEFT JOIN `ps21_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 36432) LIMIT 1 |
0.266 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
207 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 193548) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.263 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
211 | SELECT SQL_NO_CACHE pa.`available_date` FROM `ps21_product` p LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps21_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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) WHERE p.`id_product` = 193548 AND pa.`id_product` = 193548 AND pa.`id_product_attribute` = 36432 LIMIT 1 |
0.263 ms | 1 | /classes/Product.php:1209 | ||
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` = 255) LIMIT 1 |
0.257 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.254 ms | 1 | /classes/shop/Shop.php:218 | ||
16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.253 ms | 88 | /classes/Hook.php:287 | ||
282 | SELECT SQL_NO_CACHE * FROM `ps21_product_lang` WHERE `id_product` = 193548 AND `id_shop` = 1 |
0.252 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
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.251 ms | 1 | /classes/Customer.php:503 | ||
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.246 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-12-01 10:18:00' OR date_to<'2023-12-01 10:18:00'; |
0.245 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
147 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.245 ms | 0 | /classes/module/Module.php:2109 | ||
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.243 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
216 | 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` = 260902 AND image_shop.`cover` = 1 LIMIT 1 |
0.240 ms | 1 | /classes/Product.php:3570 | ||
200 | 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` = 193548 AND image_shop.`cover` = 1 LIMIT 1 |
0.239 ms | 2 | /classes/Product.php:3570 | ||
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.238 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
272 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 201) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.236 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
197 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 132648) 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 SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 199) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.232 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
167 | SELECT SQL_NO_CACHE data FROM ps21_layered_filter_block WHERE hash="458c3d6b95f95ec03627d05bb6231d89" LIMIT 1 |
0.231 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:186 | ||
178 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 1062 AND id_shop=1 LIMIT 1 |
0.229 ms | 1 | /classes/Product.php:6848 | ||
219 | 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` = 260902) |
0.227 ms | 1 | /classes/Product.php:3857 | ||
146 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_legalcompliance" LIMIT 1 |
0.225 ms | 0 | /classes/module/Module.php:2636 | ||
297 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.224 ms | 1 | /classes/module/Module.php:2636 | ||
191 | 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` = 132648 AND image_shop.`cover` = 1 LIMIT 1 |
0.224 ms | 1 | /classes/Product.php:3570 | ||
248 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.223 ms | 1 | /classes/module/Module.php:2636 | ||
285 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 193548) AND (id_product_attribute = 36433) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.221 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
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.220 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
153 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps21_required_field |
0.219 ms | 1 | /classes/ObjectModel.php:1592 | ||
131 | SELECT SQL_NO_CACHE value FROM `ps21_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.216 ms | 1 | /classes/shop/Shop.php:1183 | ||
138 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` |
0.216 ms | 10 | /classes/ImageType.php:161 | ||
225 | 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` = 260930 AND image_shop.`cover` = 1 LIMIT 1 |
0.214 ms | 1 | /classes/Product.php:3570 | ||
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.213 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
149 | SELECT SQL_NO_CACHE format FROM `ps21_address_format` WHERE `id_country` = 8 LIMIT 1 |
0.212 ms | 1 | /classes/AddressFormat.php:656 | ||
249 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.212 ms | 1 | /classes/module/Module.php:2109 | ||
286 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 193548) AND (id_product_attribute = 36434) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.211 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
21 | SELECT SQL_NO_CACHE * FROM `ps21_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.210 ms | 1 | /classes/module/Module.php:2018 | ||
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.210 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
271 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 200) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.209 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
234 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 1062 |
0.209 ms | 11 | /classes/Product.php:2902 | ||
258 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.205 ms | 1 | /classes/module/Module.php:2636 | ||
68 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.204 ms | 0 | /classes/module/Module.php:2109 | ||
269 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 198) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.204 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
250 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.203 ms | 1 | /classes/module/Module.php:2636 | ||
238 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 132648 |
0.202 ms | 1 | /classes/Product.php:2902 | ||
41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.202 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
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` = 255 LIMIT 1 |
0.200 ms | 1 | /classes/Category.php:1375 | ||
273 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 202) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.198 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
182 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.198 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
255 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.197 ms | 1 | /classes/module/Module.php:2109 | ||
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.195 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
240 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 193548 |
0.194 ms | 10 | /classes/Product.php:2902 | ||
10 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "jprestaspeedpack" LIMIT 1 |
0.193 ms | 1 | /classes/module/Module.php:2636 | ||
152 | SELECT SQL_NO_CACHE * FROM `ps21_country_lang` WHERE `id_country` = 8 |
0.192 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
256 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.191 ms | 1 | /classes/module/Module.php:2636 | ||
7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.191 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
267 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 196) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.190 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
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.189 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
230 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 260930) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.189 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
190 | SELECT SQL_NO_CACHE * FROM `ps21_product_attribute_lang` WHERE `id_product_attribute` = 195 |
0.186 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
209 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 193548) AND (id_product_attribute = 36432) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.184 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
251 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.181 ms | 1 | /classes/module/Module.php:2109 | ||
64 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 4 |
0.180 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
175 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 315 AND `active` = 1 LIMIT 1 |
0.178 ms | 1 | /classes/Manufacturer.php:316 | ||
257 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.177 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.176 ms | 1 | /classes/Country.php:402 | ||
9 | SELECT SQL_NO_CACHE id_shop FROM `ps21_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.176 ms | 1 | /classes/ObjectModel.php:1729 | ||
42 | SELECT SQL_NO_CACHE id_shop FROM `ps21_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.176 ms | 1 | /classes/ObjectModel.php:1729 | ||
126 | SELECT SQL_NO_CACHE * FROM `ps21_group_lang` WHERE `id_group` = 1 |
0.175 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
311 | DELETE FROM `ps21_jm_pagecache_mods` WHERE `id`=49; |
0.174 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
252 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.174 ms | 1 | /classes/module/Module.php:2636 | ||
201 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 255 LIMIT 1 |
0.173 ms | 1 | /classes/Product.php:5639 | ||
156 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.172 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
57 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 2) LIMIT 1 |
0.172 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
247 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 260930 |
0.172 ms | 1 | /classes/Product.php:2902 | ||
303 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.172 ms | 1 | /classes/Page.php:104 | ||
276 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 1062) AND (id_product_attribute = 205) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.170 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
290 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 193548) AND (id_product_attribute = 36438) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.169 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
289 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 193548) AND (id_product_attribute = 36437) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.168 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
222 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 260902) 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 | ||
98 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.165 ms | 0 | /classes/module/Module.php:2109 | ||
132 | SELECT SQL_NO_CACHE c.id_currency FROM `ps21_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.165 ms | 1 | /classes/Currency.php:893 |