Nettoyants
Il y a 14 produits.
13,28 €
Il y a 14 produits.
Load Time | 771.096 ms |
Querying Time | 182 ms |
Queries | 384 |
Memory Peak Usage | 25.4 Mb |
Included Files | 1262 files - 11.88 Mb |
PrestaShop Cache | - Mb |
Global vars | 0.19 Mb |
PrestaShop Version | 8.1.2 |
PHP Version | 8.1.25 |
MySQL Version | 10.6.16-MariaDB |
Memory Limit | 2048M |
Max Execution Time | 3600s |
Smarty Cache | enabled |
Smarty Compilation | force compile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 5.734 ms | 5.734 ms | 8.54 Mb | 9.2 Mb |
__construct | 9.196 ms | 14.930 ms | 1.73 Mb | 11.9 Mb |
config | 28.254 ms | 43.184 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.030 ms | 43.214 ms | - Mb | 11.9 Mb |
init | 32.190 ms | 75.404 ms | 2.13 Mb | 14.8 Mb |
checkAccess | 0.002 ms | 75.406 ms | - Mb | 14.8 Mb |
setMedia | 2.879 ms | 78.285 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.002 ms | 78.287 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 78.288 ms | - Mb | 14.8 Mb |
initContent | 304.547 ms | 382.835 ms | 5.84 Mb | 20.6 Mb |
initFooter | 0.002 ms | 382.837 ms | - Mb | 20.6 Mb |
display | 388.259 ms | 771.096 ms | 5.10 Mb | 25.4 Mb |
Hook | Time | Memory Usage |
---|---|---|
ActionOutputHTMLBefore | 48.915 ms | 0.14 Mb |
displayProductListReviews | 45.471 ms | 1.31 Mb |
ActionDispatcherBefore | 40.390 ms | 3.09 Mb |
displayLeftColumn | 28.825 ms | 0.74 Mb |
DisplayBeforeBodyClosingTag | 22.033 ms | 0.27 Mb |
displayTop | 17.677 ms | 0.20 Mb |
DisplayFooter | 12.480 ms | 0.11 Mb |
ActionDispatcher | 12.043 ms | 0.70 Mb |
DisplayHeader | 3.997 ms | 0.06 Mb |
displayFooterRight | 3.921 ms | 0.07 Mb |
ActionFrontControllerSetVariables | 1.975 ms | 0.06 Mb |
DisplayLeftColumn | 1.749 ms | 0.02 Mb |
displayNav2 | 1.410 ms | 0.08 Mb |
displayFooterLeft | 1.076 ms | 0.06 Mb |
DisplayOutsideMainPage | 0.915 ms | 0.03 Mb |
ActionFrontControllerSetMedia | 0.731 ms | 0.01 Mb |
DisplayNavFullWidth | 0.599 ms | 0.01 Mb |
DisplayFooterAfter | 0.458 ms | 0.01 Mb |
DisplayBanner | 0.395 ms | 0.01 Mb |
DisplayFooterLeft | 0.385 ms | 0.01 Mb |
ProductSearchProvider | 0.376 ms | - Mb |
DisplayFooterRight | 0.349 ms | 0.01 Mb |
DisplaySidebarNavigation | 0.281 ms | - Mb |
DisplayNav1 | 0.223 ms | 0.01 Mb |
ActionObjectAddAfter | 0.050 ms | - Mb |
ModuleRoutes | 0.023 ms | 0.02 Mb |
ActionFrontControllerInitAfter | 0.020 ms | - Mb |
DisplayAfterBodyOpeningTag | 0.014 ms | - Mb |
DisplayFooterBefore | 0.013 ms | - Mb |
29 hook(s) | 246.795 ms | 7.04 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 5.324 ms | 0.54 Mb |
jprestaspeedpack | 102.483 ms | 4.00 Mb |
blockreassurance | 1.300 ms | 0.09 Mb |
blockwishlist | 12.843 ms | 0.13 Mb |
ps_emailsubscription | 4.103 ms | 0.10 Mb |
ps_socialfollow | 1.218 ms | 0.07 Mb |
ps_emailalerts | 0.201 ms | 0.09 Mb |
zonethememanager | 18.975 ms | 1.30 Mb |
ps_shoppingcart | 12.263 ms | 0.11 Mb |
ps_searchbar | 2.183 ms | 0.14 Mb |
productcomments | 45.741 ms | 1.35 Mb |
ps_googleanalytics | 14.476 ms | 0.05 Mb |
zonecolorsfonts | 1.503 ms | 0.06 Mb |
zonemegamenu | 2.833 ms | 0.06 Mb |
prestastripe | 0.884 ms | 0.02 Mb |
ps_facetedsearch | 2.246 ms | 0.10 Mb |
ps_languageselector | 1.059 ms | 0.06 Mb |
ps_currencyselector | 0.681 ms | 0.06 Mb |
ps_customersignin | 3.885 ms | 0.08 Mb |
ps_categorytree | 29.024 ms | 0.75 Mb |
zonecolumnblocks | 0.694 ms | 0.11 Mb |
zonepopupnewsletter | 0.694 ms | 0.03 Mb |
statsdata | 7.922 ms | 0.27 Mb |
23 module(s) | 272.535 ms | 9.56 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
382 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (557,803264849),(557,531227063),(557,4268093708),(557,1289214159),(557,1785617407),(557,2936477779),(557,1727466530),(557,1432532875),(557,1025009294),(557,1804081323),(557,3479716883),(557,66301815),(557,537553573),(557,3045727500),(557,3231073010),(557,1825096520),(557,3225262556),(557,2645763144),(557,2027619899),(557,786864081),(557,1849360992),(557,294428854),(557,3774376179),(557,2880678980),(557,114155291),(557,2929321318),(557,2087307803),(557,2369020978),(557,1152186767),(557,4222788516),(557,2858566420),(557,848840972),(557,4147554351),(557,770698498),(557,2244011448),(557,477004582),(557,3610318732),(557,1070190107),(557,937307692),(557,25761885),(557,3366890060),(557,3483396593),(557,392306519),(557,909258745),(557,179865882),(557,3099645137),(557,3371246540),(557,2390640699),(557,501027234),(557,3032495894),(557,2100541971),(557,2793494280),(557,180908336),(557,1192985740),(557,1972034646),(557,2419117650),(557,3803768817),(557,4265874642),(557,67723771),(557,3423129237),(557,3399895114),(557,3221089548),(557,2990154896),(557,2728213885),(557,933991437),(557,2513627470),(557,468067826),(557,4137721533),(557,1552016987),(557,4080301755),(557,4245349388),(557,1973472416),(557,1839057912),(557,3745041382),(557,3035734567),(557,3719469943),(557,3466131047),(557,679558129),(557,462819688),(557,4267553191),(557,518809702),(557,3303811122),(557,2883778317),(557,1694893476),(557,3287268691),(557,3711637102),(557,698879415),(557,885817714),(557,125306139),(557,1634619674),(557,58280175),(557,3363778289),(557,1161663254),(557,201135304),(557,288600709),(557,1021330335),(557,2858809635),(557,2763627026),(557,3717400459),(557,4125370705),(557,3997906175),(557,4162316513),(557,3219397995),(557,2539165674),(557,1046234598),(557,787652129),(557,1595426297),(557,4184932827),(557,1985552396),(557,1944795689),(557,3799916950),(557,1827123668),(557,1447744642),(557,1636796806),(557,2645405926),(557,1474595477),(557,3375525138),(557,3902077767),(557,3507415422),(557,2781072282),(557,2002273313),(557,3164880625),(557,2490789905),(557,1000843653),(557,48947005),(557,3883347157),(557,3700474777),(557,4264269047),(557,2125390191),(557,4270481046),(557,1693150473),(557,343450730),(557,381351735),(557,2863449446),(557,3772294966),(557,3877457961),(557,1492116830),(557,4041511410),(557,828132466),(557,4090211224),(557,2185737194),(557,3517149926),(557,647687838),(557,733479784),(557,1440916471),(557,3262261204),(557,1872100372),(557,2092461357),(557,3357609169),(557,2365529006),(557,1263061406),(557,2296732656),(557,534196217),(557,482025419),(557,2811467352),(557,2488480532),(557,3501473861),(557,1917272649),(557,1878317490),(557,1789511633),(557,956713705),(557,89981727),(557,1143557322),(557,2749361789),(557,3857194488),(557,1024086260),(557,26040876),(557,1804243295),(557,2165251395),(557,1281618245),(557,2793993627),(557,426054238),(557,3398682121),(557,1025101115),(557,2974984653),(557,2214325187),(557,997821910),(557,2005463392),(557,3252396061),(557,942332382),(557,3816934055),(557,1661692647),(557,975758589),(557,3974931321),(557,2301364099),(557,855746680),(557,637832447),(557,3938675492),(557,508940865),(557,911480697),(557,1283363269),(557,3552869238),(557,2961923901),(557,3747234531),(557,3155646160),(557,3164668199),(557,2271068282),(557,84354396),(557,2915068863),(557,4064530110),(557,3216991891),(557,2045363644),(557,2664176477),(557,1076722390),(557,505410826),(557,3544422162),(557,2506779464),(557,2552384108),(557,876907216),(557,82980331),(557,3890150098),(557,3475437886),(557,2302280848),(557,1133144647),(557,801167173),(557,2059315716),(557,3139619822),(557,2937007520),(557,1589371182),(557,693370988),(557,2708427394),(557,1007456900),(557,610735313),(557,3846627131),(557,2031830639),(557,1908602231),(557,1401333655),(557,378101424),(557,996218346),(557,660881695),(557,2938384267),(557,4250264855),(557,1895305721),(557,502965417),(557,1982471117),(557,2524144246),(557,2774996218),(557,1068709096),(557,4077513867),(557,2900588200),(557,465472731),(557,4139839450),(557,2360011682),(557,4211248848),(557,283341417),(557,4165214622),(557,3508523596),(557,234404923),(557,2782693783),(557,3413880379),(557,3540168379),(557,861653603),(557,3160995915),(557,1391251310),(557,2106651858),(557,3572623339),(557,4629984),(557,2488722736),(557,3486510944),(557,2675016634),(557,2165907305),(557,136687257),(557,3540179561),(557,2792526429),(557,2220600372),(557,2914585448),(557,3882733113),(557,1688090355),(557,3534950496),(557,1182870252),(557,412601709),(557,574969182),(557,2970413814),(557,1487282505),(557,3228977345),(557,2023459642),(557,3291711134),(557,2792891444),(557,3335276918),(557,502111155),(557,1347492703),(557,2832080533),(557,1215320197),(557,2317239205),(557,1931846913),(557,1721014625),(557,738600257),(557,2998338424),(557,1207945902),(557,734241479),(557,3324570843),(557,4126771257),(557,1712456575),(557,3169253733),(557,1160958045),(557,1130949510),(557,3116084871),(557,269178051),(557,24773614),(557,3204450510),(557,3468662336),(557,1808444077),(557,4095410992),(557,1012520131),(557,2367920745),(557,2603361072),(557,2741539031),(557,607507456),(557,616165826),(557,2288576869),(557,4252798532),(557,2692385638),(557,4100315394),(557,3061254709),(557,1657292258),(557,2148967437),(557,1248236410),(557,2457219175),(557,1920985790),(557,1340703149),(557,1618471777),(557,4160689201),(557,1822364967),(557,479188821),(557,1661785323),(557,4137484009),(557,2636427258),(557,1499247737),(557,2061922205),(557,665830591),(557,916194615),(557,495595719),(557,3026469794),(557,1845449656),(557,4078122428),(557,2044505385),(557,3156749269),(557,3919036276),(557,204613135),(557,605377709),(557,766051911),(557,30400764),(557,4211022030),(557,715827285),(557,1092948871),(557,610201349),(557,1023110113),(557,3379323545),(557,2591028766),(557,1994095466),(557,33157726),(557,198243957),(557,94201498),(557,2540831776),(557,1707019604),(557,2730046909),(557,4101073252),(557,207761914),(557,2750534087),(557,980926717),(557,377071036),(557,2983490672),(557,584353846),(557,1743688562),(557,3223058413),(557,1665991311),(557,3093731065),(557,1095877807),(557,1085889875),(557,2059985562),(557,3618062925),(557,592374860),(557,4217863027),(557,3425247989),(557,1636391408),(557,1698766782),(557,2162739858),(557,1538367880),(557,3760626336),(557,1987713032),(557,2338874856),(557,4206689645),(557,1723372602),(557,2788329276),(557,2095305502),(557,3135330775),(557,2402748468),(557,24058172),(557,4000683245),(557,315670382),(557,2558276906),(557,1745365471),(557,2782569384),(557,3422117706),(557,552626444),(557,1506232339),(557,2933163456),(557,1483801350),(557,1400586123),(557,3746875726),(557,2604810181),(557,2905930158),(557,803588046),(557,1651400661),(557,1431243585),(557,1586185269),(557,4110009762),(557,3647374073),(557,4196158832),(557,644435096),(557,1862966990),(557,2098775956),(557,4045847707),(557,3122054119),(557,1971194991),(557,2149367276),(557,1888540635),(557,2660577125),(557,2508340497),(557,196341346),(557,1790101800),(557,1054130805),(557,2741947598),(557,1292400575),(557,545037028),(557,1516477184),(557,2706799993),(557,562470873),(557,2591346466),(557,613023703),(557,2725609989),(557,2082081559),(557,572560232),(557,2833489058),(557,1999611979),(557,1938789650),(557,2958717166),(557,1035708154),(557,2025067287),(557,3804047398),(557,248028803),(557,4243412966),(557,628124381),(557,1271215494),(557,2140466223),(557,1298495884),(557,3585931255),(557,532975694),(557,892763084),(557,203145038),(557,470924714),(557,1460516495),(557,2732318442),(557,3996868778),(557,862206445),(557,3193479021),(557,3382171736),(557,3362897893),(557,3598913121),(557,1342337107),(557,3202829344),(557,1335223071),(557,270790954),(557,1086966479),(557,484642328),(557,4274468042),(557,1740107684),(557,2117688527),(557,1393082718),(557,366510022),(557,341328174),(557,1469264429),(557,968691010),(557,3210232788),(557,809700252),(557,3705477223),(557,1639200307),(557,3585776886),(557,3305319229),(557,1052899681),(557,2176267881),(557,357387863),(557,451177334),(557,677589039),(557,1181390953),(557,898241702),(557,3480303789),(557,1736215096),(557,2511740146),(557,2560762429),(557,1570623991),(557,897080848),(557,891021207),(557,2807843172),(557,411231410),(557,2413680770),(557,519468981),(557,1898829954),(557,4274422817),(557,2781196321),(557,433695516),(557,1652336127),(557,4200438598),(557,3032893805),(557,1435170492),(557,341146430),(557,755973553),(557,2183774725),(557,3967614532),(557,1589097164),(557,2441764320),(557,745126750),(557,348450311),(557,2084175962),(557,3357611772),(557,1654631620),(557,3098454302),(557,2029227635),(557,1731761366),(557,2444253995),(557,2906032508),(557,872274856),(557,4282856364),(557,3328013593),(557,4184469063),(557,1074477927),(557,475878802),(557,1341972790),(557,2770374005),(557,4237489391),(557,2818813526),(557,3131100007),(557,4267621199),(557,1031922959),(557,1616292706),(557,630426110),(557,1846388513),(557,2239793094),(557,1660370824),(557,3321716633),(557,2551727033),(557,1836172154),(557,1870881122),(557,3324207484),(557,1065867023),(557,1459310880),(557,1395112921),(557,893552556),(557,1795813847),(557,2544364435),(557,4188602229),(557,1437064809),(557,922605498),(557,4180843510),(557,2554784265),(557,3798404205),(557,1216801552),(557,225525148),(557,274058040),(557,3206796234),(557,610255635),(557,3139895407),(557,3993594441),(557,2078652070),(557,3340749058),(557,2282248923),(557,3201099700),(557,3944887276),(557,887478137),(557,620965629),(557,53639561),(557,687854272),(557,4204526813),(557,3434636086),(557,3859247582),(557,2160451939),(557,419013317),(557,488655959),(557,2224381764),(557,857621694),(557,593880699),(557,1743569168),(557,747100668),(557,2627272664),(557,1477316791),(557,852002855),(557,3813191394),(557,3206482767),(557,2935275735),(557,825997452),(557,4128572079),(557,4149399208),(557,2432005645),(557,945310979),(557,206553734),(557,3381625344),(557,2613891474),(557,1285565060),(557,725086502),(557,2181279565),(557,2136294074),(557,3291030245),(557,3423892574),(557,1818418110),(557,1175554195),(557,231365613),(557,3071984169),(557,1510809703),(557,2304894647),(557,724387218),(557,3702122266),(557,3105745802),(557,3598888791),(557,40599425),(557,4256434691),(557,1198380170),(557,3549401556),(557,2300237909),(557,484124464),(557,3042798728),(557,767973032),(557,4146324303),(557,1493350341),(557,2166736334),(557,3061340275),(557,1468811388),(557,714571165),(557,1958965990),(557,2146366302),(557,2212338847),(557,2088651590),(557,2684538463),(557,2292708505),(557,571001464),(557,608126571),(557,2736309071),(557,1479333754),(557,1794660366),(557,2319975337),(557,1093438481),(557,2975864804),(557,2504416172),(557,3531750290),(557,219666672),(557,4219072870),(557,1053258155),(557,2382983142),(557,1006288562),(557,1770263986),(557,3089735283),(557,3689334927),(557,2901629603),(557,2019277020),(557,2853333944),(557,1110695191),(557,3884283185),(557,159799075),(557,1715997742),(557,1009155269),(557,3922001006),(557,3916338789),(557,1085252167),(557,207705430),(557,1190601026),(557,1441004396),(557,1567147586),(557,964098054),(557,1385174189),(557,3607427007),(557,4065177061),(557,1552830538),(557,3778287701),(557,3986294473),(557,4127238085),(557,1865170325),(557,2161789419),(557,2889615117),(557,785261358),(557,3873733217),(557,2600209543),(557,3958092558),(557,4143434528),(557,3225228598),(557,3451063310),(557,810085901),(557,1502204888),(557,2931931582),(557,1339720903),(557,4093703382),(557,1016897830),(557,1186809094),(557,2269117600),(557,813555736),(557,733475850),(557,305814753),(557,2720553993),(557,212227262),(557,1328958432),(557,3903742053),(557,2617942920),(557,4254367326),(557,2895836413),(557,1090341105),(557,3174277595),(557,639084285),(557,4064195579),(557,2134315289),(557,608843276),(557,4190247440),(557,1090444753),(557,2554275840),(557,2758076506),(557,2518001916),(557,3620157415),(557,1195920681),(557,1822840633),(557,1087551238),(557,235508323),(557,1139244570),(557,810960133),(557,425550269),(557,1767940144),(557,1488780247),(557,1250541405),(557,1715845038),(557,3777612587),(557,2285237154),(557,802817926),(557,4280998710),(557,1108258121),(557,1107026853),(557,2913745362),(557,1129101120),(557,2454813183),(557,1690919006),(557,23973636),(557,293370743),(557,1041759778),(557,3142497267),(557,2920365983),(557,2300359472),(557,885232682),(557,1995817456),(557,3443377157),(557,863919144),(557,1324348692),(557,4019216150),(557,443752815),(557,4223293),(557,1182491637),(557,4257294915),(557,3629776934),(557,582958316),(557,3061655453),(557,1665355533),(557,1929899841),(557,1033949851),(557,2010879266),(557,1872304779),(557,1282102725),(557,3589651214),(557,4095654001),(557,2447713556),(557,2543494532),(557,2069898435),(557,3286503857),(557,2662939963),(557,93111834),(557,3160936308),(557,261262800),(557,141197408),(557,1904512268),(557,3001025754),(557,2247670246),(557,535154833),(557,3476002757),(557,3806439314),(557,1819793014),(557,3545273473),(557,3957652542),(557,3018295592),(557,1367893712),(557,1034338066),(557,3229510223),(557,4276953245),(557,3363858574),(557,2870596766),(557,648526699),(557,3627085975),(557,1585047995),(557,1960922033),(557,748737253),(557,1175066615),(557,1318322018),(557,260367662),(557,643741484),(557,1013706048),(557,1726352130),(557,2222354404),(557,1327031463),(557,1131865044),(557,839200087),(557,1407668396),(557,3548333318),(557,237845721),(557,3056051791),(557,747235328),(557,172675174),(557,2781705803),(557,2111348799),(557,3067187587),(557,618638032),(557,3369756381),(557,2232055662),(557,55113216),(557,3939915090),(557,2586983921),(557,3286008345),(557,1956055310),(557,740042513),(557,2282536358),(557,1863122946),(557,1296880981),(557,2589434346),(557,1621393368),(557,39250009),(557,72263924),(557,1587391050),(557,847186998),(557,2455499024),(557,859347884),(557,2244795234),(557,64890532),(557,2976371373),(557,3379820198),(557,4268567377),(557,2253057588),(557,1409601011),(557,2341397215),(557,2970551021),(557,517458811),(557,1841453054),(557,3333970348),(557,3477419610),(557,2226929931),(557,719144181),(557,3094385299),(557,3924888977),(557,1697117306),(557,3406763364),(557,1129505049) ON DUPLICATE KEY UPDATE id=id |
16.708 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
349 | SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps21_category` c INNER JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps21_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 1669 AND c.id_category IN ( SELECT id_category FROM `ps21_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC |
9.068 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
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>=1007 AND c.nright<=1008 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 |
4.749 ms | 34187270404 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
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>=1007 AND c.nright<=1008 GROUP BY p.id_product) p |
3.690 ms | 34187270404 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
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.321 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.531 ms | 0 | /classes/Hook.php:1292 | ||
383 | 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.281 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
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.199 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
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.977 ms | 386 | /classes/Hook.php:456 | ||
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 (62111,190756,190757,190758,190760,190761,190762,190763,190765,201789,215848,215849,361722,361736) |
1.777 ms | 14 | /classes/ProductAssembler.php:95 | ||
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` < 1007) AND (a0.`nright` > 1008) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.575 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
374 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('919348', '7240', '751134203', '', '1', '1', '2023-12-01 11:08:03') |
1.500 ms | 1 | /classes/ObjectModel.php:622 | ||
379 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 4197668509, 'https://cadeaufou.com/706-nettoyants', 1, 2, 1, 706, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.454 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
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` < 1007) AND (a0.`nright` > 1008) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.445 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
370 | 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.277 ms | 1 | /classes/ObjectModel.php:622 | ||
375 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('917057', '', 'cadeaufou.com/706-nettoyants', '', '2023-12-01 11:08:03') |
1.188 ms | 1 | /classes/ObjectModel.php:622 | ||
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` = 706 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
1.143 ms | 1 | Yes | Yes | /classes/Category.php:921 |
353 | 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 (190756) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1.137 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.132 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
169 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("a3fc8b319e401a322c7cc0807407f463", "a:1:{s:7:\"filters\";a:0:{}}") |
1.105 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
350 | 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 (62111) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1.014 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.999 ms | 880 | /classes/Hook.php:1332 | ||
97 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "webpgenerator" LIMIT 1 |
0.938 ms | 0 | /classes/module/Module.php:2636 | ||
354 | 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 (190757) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.935 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
373 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 706 LIMIT 1 |
0.869 ms | 1 | /classes/Page.php:83 | ||
361 | 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 (201789) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.865 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.851 ms | 880 | /classes/Hook.php:1292 | ||
333 | 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` = 361736) AND (b.`id_shop` = 1) LIMIT 1 |
0.851 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
199 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 190757 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` = 190757 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.847 ms | 0 | /classes/Cart.php:1410 | ||
313 | 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` = 190762) AND (b.`id_shop` = 1) LIMIT 1 |
0.843 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
260 | 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` = 201789 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` = 201789 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.836 ms | 0 | /classes/Cart.php:1410 | ||
277 | 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` = 215849 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` = 215849 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.810 ms | 0 | /classes/Cart.php:1410 | ||
310 | 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` = 190761) AND (b.`id_shop` = 1) LIMIT 1 |
0.791 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
181 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 62111 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` = 62111 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.788 ms | 0 | /classes/Cart.php:1410 | ||
242 | 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` = 190763 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` = 190763 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.780 ms | 0 | /classes/Cart.php:1410 | ||
319 | 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` = 190765) AND (b.`id_shop` = 1) LIMIT 1 |
0.770 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
355 | 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 (190758) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.770 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
216 | 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` = 190760 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` = 190760 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.768 ms | 0 | /classes/Cart.php:1410 | ||
295 | 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` = 62111) AND (b.`id_shop` = 1) LIMIT 1 |
0.766 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
269 | 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` = 215848 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` = 215848 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.764 ms | 0 | /classes/Cart.php:1410 | ||
328 | 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` = 215849) AND (b.`id_shop` = 1) LIMIT 1 |
0.758 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
304 | 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` = 190758) AND (b.`id_shop` = 1) LIMIT 1 |
0.755 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
325 | 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` = 215848) AND (b.`id_shop` = 1) LIMIT 1 |
0.755 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
285 | 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` = 361722 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` = 361722 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.755 ms | 0 | /classes/Cart.php:1410 | ||
207 | 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` = 190758 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` = 190758 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.739 ms | 0 | /classes/Cart.php:1410 | ||
301 | 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` = 190757) AND (b.`id_shop` = 1) LIMIT 1 |
0.736 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
190 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 190756 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` = 190756 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.735 ms | 0 | /classes/Cart.php:1410 | ||
233 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 190762 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` = 190762 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.733 ms | 0 | /classes/Cart.php:1410 | ||
224 | 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` = 190761 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` = 190761 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.719 ms | 0 | /classes/Cart.php:1410 | ||
293 | 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` = 361736 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` = 361736 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.713 ms | 0 | /classes/Cart.php:1410 | ||
358 | 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 (190762) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.710 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
251 | 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` = 190765 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` = 190765 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.699 ms | 0 | /classes/Cart.php:1410 | ||
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.679 ms | 81 | /classes/module/Module.php:345 | ||
294 | 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 = 361736 ORDER BY f.position ASC |
0.678 ms | 1 | Yes | /classes/Product.php:5993 | |
360 | 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 (190765) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.671 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
298 | 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` = 190756) AND (b.`id_shop` = 1) LIMIT 1 |
0.671 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
182 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 62111 ORDER BY f.position ASC |
0.667 ms | 1 | Yes | /classes/Product.php:5993 | |
252 | 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 = 190765 ORDER BY f.position ASC |
0.662 ms | 1 | Yes | /classes/Product.php:5993 | |
365 | 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 (361736) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.660 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
225 | 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 = 190761 ORDER BY f.position ASC |
0.658 ms | 1 | Yes | /classes/Product.php:5993 | |
364 | 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 (361722) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.655 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
357 | 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 (190761) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.649 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.643 ms | 1 | /classes/CartRule.php:418 | ||
326 | 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` = 215848 ORDER BY `position` |
0.640 ms | 2 | Yes | /classes/Product.php:3545 | |
191 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 190756 ORDER BY f.position ASC |
0.639 ms | 1 | Yes | /classes/Product.php:5993 | |
142 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1 |
0.638 ms | 6 | /classes/CartRule.php:418 | ||
208 | 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 = 190758 ORDER BY f.position ASC |
0.634 ms | 1 | Yes | /classes/Product.php:5993 | |
200 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 190757 ORDER BY f.position ASC |
0.632 ms | 1 | Yes | /classes/Product.php:5993 | |
243 | 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 = 190763 ORDER BY f.position ASC |
0.631 ms | 1 | Yes | /classes/Product.php:5993 | |
296 | 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` = 62111 ORDER BY `position` |
0.628 ms | 1 | Yes | /classes/Product.php:3545 | |
378 | 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.622 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
330 | 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` = 361722) AND (b.`id_shop` = 1) LIMIT 1 |
0.622 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
217 | 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 = 190760 ORDER BY f.position ASC |
0.618 ms | 1 | Yes | /classes/Product.php:5993 | |
234 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 190762 ORDER BY f.position ASC |
0.612 ms | 1 | Yes | /classes/Product.php:5993 | |
286 | 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 = 361722 ORDER BY f.position ASC |
0.612 ms | 1 | Yes | /classes/Product.php:5993 | |
362 | 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 (215848) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.609 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
322 | 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` = 201789) AND (b.`id_shop` = 1) LIMIT 1 |
0.605 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
356 | 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 (190760) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.602 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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.600 ms | 5 | /classes/CartRule.php:357 | ||
278 | 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 = 215849 ORDER BY f.position ASC |
0.596 ms | 1 | Yes | /classes/Product.php:5993 | |
363 | 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 (215849) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.587 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
270 | 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 = 215848 ORDER BY f.position ASC |
0.584 ms | 1 | Yes | /classes/Product.php:5993 | |
314 | 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` = 190762 ORDER BY `position` |
0.577 ms | 1 | Yes | /classes/Product.php:3545 | |
261 | 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 = 201789 ORDER BY f.position ASC |
0.577 ms | 1 | Yes | /classes/Product.php:5993 | |
307 | 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` = 190760) AND (b.`id_shop` = 1) LIMIT 1 |
0.576 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
359 | 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 (190763) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.571 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
316 | 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` = 190763) AND (b.`id_shop` = 1) LIMIT 1 |
0.564 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
334 | 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` = 361736 ORDER BY `position` |
0.553 ms | 1 | Yes | /classes/Product.php:3545 | |
371 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 919348 AND `date_add` > '2023-12-01 10:38:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.543 ms | 1 | Yes | /classes/Connection.php:168 | |
229 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 190762) |
0.536 ms | 1 | /classes/Product.php:3857 | ||
162 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 706 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.533 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
311 | 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` = 190761 ORDER BY `position` |
0.519 ms | 1 | Yes | /classes/Product.php:3545 | |
302 | 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` = 190757 ORDER BY `position` |
0.512 ms | 1 | Yes | /classes/Product.php:3545 | |
377 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.511 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
329 | 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` = 215849 ORDER BY `position` |
0.506 ms | 1 | Yes | /classes/Product.php:3545 | |
320 | 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` = 190765 ORDER BY `position` |
0.493 ms | 1 | Yes | /classes/Product.php:3545 | |
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.489 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
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.486 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
305 | 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` = 190758 ORDER BY `position` |
0.485 ms | 1 | Yes | /classes/Product.php:3545 | |
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.482 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
238 | 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` = 190763) |
0.481 ms | 1 | /classes/Product.php:3857 | ||
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.474 ms | 81 | /classes/module/Module.php:345 | ||
273 | 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` = 215849) |
0.471 ms | 1 | /classes/Product.php:3857 | ||
323 | 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` = 201789 ORDER BY `position` |
0.471 ms | 1 | Yes | /classes/Product.php:3545 | |
235 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 190763 AND image_shop.`cover` = 1 LIMIT 1 |
0.469 ms | 1 | /classes/Product.php:3570 | ||
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.468 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
336 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.465 ms | 1 | /classes/module/Module.php:2636 | ||
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.463 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
220 | 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` = 190761) |
0.458 ms | 1 | /classes/Product.php:3857 | ||
253 | 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` = 201789 AND image_shop.`cover` = 1 LIMIT 1 |
0.458 ms | 1 | /classes/Product.php:3570 | ||
299 | 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` = 190756 ORDER BY `position` |
0.447 ms | 1 | Yes | /classes/Product.php:3545 | |
308 | 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` = 190760 ORDER BY `position` |
0.447 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` = 706) AND (b.`id_shop` = 1) LIMIT 1 |
0.443 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
281 | 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` = 361722) |
0.440 ms | 1 | /classes/Product.php:3857 | ||
331 | 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` = 361722 ORDER BY `position` |
0.431 ms | 1 | Yes | /classes/Product.php:3545 | |
209 | 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` = 190760 AND image_shop.`cover` = 1 LIMIT 1 |
0.430 ms | 2 | /classes/Product.php:3570 | ||
256 | 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` = 201789) |
0.430 ms | 1 | /classes/Product.php:3857 | ||
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.428 ms | 5 | /classes/CartRule.php:357 | ||
203 | 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` = 190758) |
0.421 ms | 1 | /classes/Product.php:3857 | ||
175 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 62111) |
0.420 ms | 1 | /classes/Product.php:3857 | ||
192 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 190757 AND image_shop.`cover` = 1 LIMIT 1 |
0.418 ms | 1 | /classes/Product.php:3570 | ||
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` = 62111 AND image_shop.`cover` = 1 LIMIT 1 |
0.413 ms | 1 | /classes/Product.php:3570 | ||
212 | 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` = 190760) |
0.413 ms | 1 | /classes/Product.php:3857 | ||
247 | 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` = 190765) |
0.413 ms | 1 | /classes/Product.php:3857 | ||
289 | 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` = 361736) |
0.412 ms | 1 | /classes/Product.php:3857 | ||
262 | 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` = 215848 AND image_shop.`cover` = 1 LIMIT 1 |
0.411 ms | 2 | /classes/Product.php:3570 | ||
265 | 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` = 215848) |
0.406 ms | 1 | /classes/Product.php:3857 | ||
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.404 ms | 1 | /classes/Currency.php:1136 | ||
218 | 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` = 190761 AND image_shop.`cover` = 1 LIMIT 1 |
0.401 ms | 1 | /classes/Product.php:3570 | ||
348 | 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.401 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
117 | SELECT SQL_NO_CACHE id FROM `ps21_jm_pagecache_contexts` WHERE `id_shop`=1 AND `id_lang`=1 AND `id_currency`=1 AND `id_fake_customer` IS NULL AND `id_device`=1 AND `id_country` IS NULL AND `id_tax_csz`=1 AND `id_specifics` IS NULL LIMIT 1 |
0.400 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
244 | 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` = 190765 AND image_shop.`cover` = 1 LIMIT 1 |
0.397 ms | 1 | /classes/Product.php:3570 | ||
317 | 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` = 190763 ORDER BY `position` |
0.393 ms | 1 | Yes | /classes/Product.php:3545 | |
123 | SELECT SQL_NO_CACHE c.`passwd` FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.391 ms | 1 | /classes/Customer.php:475 | ||
279 | 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` = 361722 AND image_shop.`cover` = 1 LIMIT 1 |
0.391 ms | 1 | /classes/Product.php:3570 | ||
287 | 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` = 361736 AND image_shop.`cover` = 1 LIMIT 1 |
0.389 ms | 1 | /classes/Product.php:3570 | ||
226 | 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` = 190762 AND image_shop.`cover` = 1 LIMIT 1 |
0.388 ms | 1 | /classes/Product.php:3570 | ||
168 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 706 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.387 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
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.386 ms | 1 | /classes/Customer.php:503 | ||
186 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 190756) |
0.383 ms | 1 | /classes/Product.php:3857 | ||
366 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.383 ms | 1 | /classes/module/Module.php:2636 | ||
201 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 190758 AND image_shop.`cover` = 1 LIMIT 1 |
0.379 ms | 1 | /classes/Product.php:3570 | ||
133 | SELECT SQL_NO_CACHE * FROM `ps21_currency` a LEFT JOIN `ps21_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `ps21_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.373 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.373 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
195 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 190757) |
0.371 ms | 1 | /classes/Product.php:3857 | ||
183 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 190756 AND image_shop.`cover` = 1 LIMIT 1 |
0.364 ms | 1 | /classes/Product.php:3570 | ||
12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.364 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
145 | SELECT SQL_NO_CACHE COUNT(*) FROM `ps21_orders` o LEFT JOIN `ps21_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`) WHERE o.`id_customer` = 0 AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 0 LIMIT 1 |
0.363 ms | 1 | /classes/order/Order.php:881 | ||
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.362 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.361 ms | 81 | /classes/module/Module.php:345 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 706 AND ctg.`id_group` = 1 LIMIT 1 |
0.359 ms | 1 | /classes/Category.php:1751 | ||
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.357 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
50 | SELECT SQL_NO_CACHE trgs.`id_tax_rules_group` FROM `ps21_tax_rules_group_shop` as trgs LEFT JOIN `ps21_tax_rules_group` as trg ON trgs.id_tax_rules_group=trg.id_tax_rules_group WHERE active=1 AND id_shop=1 AND deleted=0 |
0.356 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
179 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.353 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.350 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
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.340 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
271 | 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` = 215849 AND image_shop.`cover` = 1 LIMIT 1 |
0.340 ms | 1 | /classes/Product.php:3570 | ||
40 | SELECT SQL_NO_CACHE * FROM `ps21_currency` a LEFT JOIN `ps21_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.339 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.339 ms | 10 | Yes | /classes/ImageType.php:109 | |
56 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 2 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.332 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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.329 ms | 1 | /classes/Customer.php:503 | ||
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.326 ms | 1 | /classes/Language.php:1216 | ||
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.316 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.313 ms | 1 | /classes/Customer.php:475 | ||
164 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 706 AND `id_shop` = 1 |
0.312 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
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` = 706) LIMIT 1 |
0.308 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.300 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
297 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 62111 |
0.296 ms | 1 | /classes/Product.php:2902 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-12-01 11:08:00' AND date_from <= '2023-12-01 13:08:00') OR (date_to >= '2023-12-01 11:08:00' AND date_to <= '2023-12-01 13:08:00'); |
0.296 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
215 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 190760) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.295 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
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.289 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
342 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.289 ms | 1 | /classes/module/Module.php:2636 | ||
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.288 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
346 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.288 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.285 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
250 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 190765) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.284 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
232 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 190762) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.282 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.281 ms | 10 | Yes | /classes/ImageType.php:109 | |
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.280 ms | 1 | /classes/shop/Shop.php:218 | ||
41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.275 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
338 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.274 ms | 1 | /classes/module/Module.php:2636 | ||
5 | SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps21_lang` l LEFT JOIN `ps21_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.265 ms | 1 | /classes/Language.php:1080 | ||
184 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.263 ms | 1 | /classes/Product.php:5639 | ||
198 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 190757) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.262 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
372 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.260 ms | 1 | /classes/Page.php:104 | ||
131 | SELECT SQL_NO_CACHE value FROM `ps21_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.260 ms | 1 | /classes/shop/Shop.php:1183 | ||
223 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 190761) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.260 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
259 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 201789) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.258 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
276 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 215849) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.258 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
284 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 361722) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.258 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
300 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 190756 |
0.258 ms | 1 | /classes/Product.php:2902 | ||
221 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 190761 AND id_shop=1 LIMIT 1 |
0.255 ms | 1 | /classes/Product.php:6848 | ||
351 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.254 ms | 1 | /classes/module/Module.php:2636 | ||
274 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 215849 AND id_shop=1 LIMIT 1 |
0.254 ms | 1 | /classes/Product.php:6848 | ||
288 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.253 ms | 1 | /classes/Product.php:5639 | ||
61 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 3 |
0.252 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.252 ms | 1 | Yes | /classes/Currency.php:709 | |
152 | SELECT SQL_NO_CACHE * FROM `ps21_country_lang` WHERE `id_country` = 8 |
0.251 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
147 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.250 ms | 0 | /classes/module/Module.php:2109 | ||
282 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 361722 AND id_shop=1 LIMIT 1 |
0.250 ms | 1 | /classes/Product.php:6848 | ||
245 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.248 ms | 1 | /classes/Product.php:5639 | ||
47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-12-01 11:08:00' OR date_to<'2023-12-01 11:08:00'; |
0.246 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.245 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
156 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.245 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.244 ms | 1 | /classes/FeatureFlag.php:105 | ||
255 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 1237 AND `active` = 1 LIMIT 1 |
0.243 ms | 1 | /classes/Manufacturer.php:316 | ||
246 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 2042 AND `active` = 1 LIMIT 1 |
0.241 ms | 1 | /classes/Manufacturer.php:316 | ||
149 | SELECT SQL_NO_CACHE format FROM `ps21_address_format` WHERE `id_country` = 8 LIMIT 1 |
0.236 ms | 1 | /classes/AddressFormat.php:656 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.236 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
211 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 1227 AND `active` = 1 LIMIT 1 |
0.235 ms | 1 | /classes/Manufacturer.php:316 | ||
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` = 706 LIMIT 1 |
0.235 ms | 1 | /classes/Category.php:1375 | ||
202 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.234 ms | 1 | /classes/Product.php:5639 | ||
236 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.233 ms | 1 | /classes/Product.php:5639 | ||
134 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.232 ms | 1 | /classes/Language.php:883 | ||
219 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.231 ms | 1 | /classes/Product.php:5639 | ||
335 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 361736 |
0.230 ms | 1 | /classes/Product.php:2902 | ||
159 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "pm_advancedsearch4" LIMIT 1 |
0.230 ms | 0 | /classes/module/Module.php:2636 | ||
193 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.227 ms | 1 | /classes/Product.php:5639 | ||
150 | SELECT SQL_NO_CACHE `need_identification_number` FROM `ps21_country` WHERE `id_country` = 8 LIMIT 1 |
0.224 ms | 1 | /classes/Country.php:402 | ||
126 | SELECT SQL_NO_CACHE * FROM `ps21_group_lang` WHERE `id_group` = 1 |
0.224 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
292 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 361736) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.224 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
206 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 190758) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.223 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
227 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.222 ms | 1 | /classes/Product.php:5639 | ||
174 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 3108 AND `active` = 1 LIMIT 1 |
0.221 ms | 1 | /classes/Manufacturer.php:316 | ||
237 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 3038 AND `active` = 1 LIMIT 1 |
0.221 ms | 1 | /classes/Manufacturer.php:316 | ||
254 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 706 LIMIT 1 |
0.221 ms | 1 | /classes/Product.php:5639 | ||
240 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 190763 AND `id_group` = 1 LIMIT 1 |
0.221 ms |