Lubrifiants parfumés
Il y a 17 produits.
Il y a 17 produits.
Load Time | 640.254 ms |
Querying Time | 139 ms |
Queries | 416 |
Memory Peak Usage | 26.2 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 | 4.904 ms | 4.904 ms | 8.55 Mb | 9.2 Mb |
__construct | 8.196 ms | 13.100 ms | 1.73 Mb | 11.9 Mb |
config | 24.072 ms | 37.172 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.016 ms | 37.188 ms | - Mb | 11.9 Mb |
init | 28.233 ms | 65.421 ms | 2.13 Mb | 14.8 Mb |
checkAccess | 0.001 ms | 65.422 ms | - Mb | 14.8 Mb |
setMedia | 2.497 ms | 67.919 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.001 ms | 67.920 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 67.921 ms | - Mb | 14.8 Mb |
initContent | 256.109 ms | 324.030 ms | 6.38 Mb | 21.2 Mb |
initFooter | 0.003 ms | 324.033 ms | - Mb | 21.2 Mb |
display | 316.221 ms | 640.254 ms | 5.26 Mb | 26.2 Mb |
Hook | Time | Memory Usage |
---|---|---|
displayProductListReviews | 39.484 ms | 1.32 Mb |
ActionDispatcherBefore | 34.703 ms | 3.09 Mb |
ActionOutputHTMLBefore | 34.447 ms | 0.14 Mb |
DisplayBeforeBodyClosingTag | 23.609 ms | 0.27 Mb |
displayLeftColumn | 20.307 ms | 0.74 Mb |
displayTop | 13.659 ms | 0.20 Mb |
ActionDispatcher | 9.485 ms | 0.71 Mb |
DisplayFooter | 9.324 ms | 0.11 Mb |
DisplayHeader | 3.344 ms | 0.06 Mb |
displayFooterRight | 2.843 ms | 0.07 Mb |
ActionFrontControllerSetVariables | 1.281 ms | 0.06 Mb |
DisplayLeftColumn | 1.220 ms | 0.02 Mb |
displayNav2 | 0.880 ms | 0.08 Mb |
DisplayOutsideMainPage | 0.797 ms | 0.03 Mb |
displayFooterLeft | 0.703 ms | 0.06 Mb |
ActionFrontControllerSetMedia | 0.643 ms | 0.01 Mb |
ProductSearchProvider | 0.527 ms | - Mb |
DisplayFooterLeft | 0.382 ms | 0.01 Mb |
DisplayFooterAfter | 0.318 ms | 0.01 Mb |
DisplayFooterRight | 0.316 ms | 0.01 Mb |
DisplaySidebarNavigation | 0.314 ms | - Mb |
DisplayNavFullWidth | 0.275 ms | 0.01 Mb |
DisplayNav1 | 0.273 ms | 0.01 Mb |
DisplayBanner | 0.268 ms | 0.01 Mb |
ActionObjectAddAfter | 0.067 ms | 0.06 Mb |
ActionFrontControllerInitAfter | 0.029 ms | - Mb |
ModuleRoutes | 0.016 ms | 0.02 Mb |
DisplayAfterBodyOpeningTag | 0.012 ms | - Mb |
DisplayFooterBefore | 0.008 ms | - Mb |
29 hook(s) | 199.533 ms | 7.12 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 4.548 ms | 0.54 Mb |
jprestaspeedpack | 79.759 ms | 4.06 Mb |
blockreassurance | 1.045 ms | 0.09 Mb |
blockwishlist | 9.673 ms | 0.13 Mb |
ps_emailsubscription | 2.991 ms | 0.10 Mb |
ps_socialfollow | 0.821 ms | 0.07 Mb |
ps_emailalerts | 0.219 ms | 0.09 Mb |
zonethememanager | 14.019 ms | 1.30 Mb |
ps_shoppingcart | 8.940 ms | 0.11 Mb |
ps_searchbar | 1.648 ms | 0.14 Mb |
productcomments | 39.749 ms | 1.36 Mb |
ps_googleanalytics | 16.779 ms | 0.05 Mb |
zonecolorsfonts | 1.364 ms | 0.06 Mb |
zonemegamenu | 1.829 ms | 0.06 Mb |
prestastripe | 4.009 ms | 0.02 Mb |
ps_facetedsearch | 2.127 ms | 0.10 Mb |
ps_languageselector | 0.651 ms | 0.06 Mb |
ps_currencyselector | 0.478 ms | 0.06 Mb |
ps_customersignin | 3.617 ms | 0.08 Mb |
ps_categorytree | 20.391 ms | 0.76 Mb |
zonecolumnblocks | 0.637 ms | 0.11 Mb |
zonepopupnewsletter | 0.519 ms | 0.03 Mb |
statsdata | 7.077 ms | 0.27 Mb |
23 module(s) | 222.890 ms | 9.64 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
414 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (476,803264849),(476,531227063),(476,714571165),(476,1289214159),(476,1785617407),(476,2936477779),(476,1727466530),(476,1432532875),(476,1025009294),(476,1804081323),(476,3479716883),(476,66301815),(476,537553573),(476,3045727500),(476,3231073010),(476,1825096520),(476,3225262556),(476,2645763144),(476,2027619899),(476,786864081),(476,1849360992),(476,294428854),(476,3774376179),(476,2880678980),(476,114155291),(476,2929321318),(476,2087307803),(476,2369020978),(476,1152186767),(476,4222788516),(476,2858566420),(476,848840972),(476,4147554351),(476,770698498),(476,2244011448),(476,477004582),(476,3610318732),(476,1070190107),(476,937307692),(476,25761885),(476,3366890060),(476,3483396593),(476,392306519),(476,909258745),(476,179865882),(476,3099645137),(476,3371246540),(476,2390640699),(476,501027234),(476,3032495894),(476,2100541971),(476,2793494280),(476,180908336),(476,1192985740),(476,1972034646),(476,2419117650),(476,3803768817),(476,4265874642),(476,67723771),(476,3423129237),(476,3399895114),(476,3221089548),(476,2990154896),(476,2728213885),(476,933991437),(476,2513627470),(476,468067826),(476,4137721533),(476,1552016987),(476,4080301755),(476,4245349388),(476,1973472416),(476,1839057912),(476,3745041382),(476,3035734567),(476,3719469943),(476,3466131047),(476,679558129),(476,462819688),(476,4267553191),(476,518809702),(476,3303811122),(476,2883778317),(476,1694893476),(476,3287268691),(476,3711637102),(476,698879415),(476,885817714),(476,125306139),(476,1634619674),(476,58280175),(476,3363778289),(476,1161663254),(476,201135304),(476,288600709),(476,1021330335),(476,2858809635),(476,2763627026),(476,3717400459),(476,4125370705),(476,3997906175),(476,4162316513),(476,3219397995),(476,2539165674),(476,1046234598),(476,787652129),(476,1595426297),(476,4184932827),(476,1985552396),(476,1944795689),(476,3799916950),(476,1827123668),(476,1447744642),(476,1636796806),(476,2645405926),(476,1474595477),(476,3375525138),(476,3902077767),(476,3507415422),(476,2781072282),(476,2002273313),(476,3164880625),(476,2490789905),(476,1000843653),(476,48947005),(476,3883347157),(476,3700474777),(476,4264269047),(476,2125390191),(476,4270481046),(476,1693150473),(476,343450730),(476,381351735),(476,2863449446),(476,3772294966),(476,3877457961),(476,1492116830),(476,4041511410),(476,828132466),(476,4090211224),(476,2185737194),(476,3517149926),(476,647687838),(476,733479784),(476,1440916471),(476,3262261204),(476,1872100372),(476,2092461357),(476,3357609169),(476,2365529006),(476,1263061406),(476,2296732656),(476,534196217),(476,482025419),(476,2811467352),(476,2488480532),(476,3501473861),(476,1917272649),(476,1878317490),(476,1789511633),(476,956713705),(476,89981727),(476,1143557322),(476,2749361789),(476,3857194488),(476,1024086260),(476,26040876),(476,1804243295),(476,2165251395),(476,1281618245),(476,2793993627),(476,426054238),(476,3398682121),(476,1025101115),(476,2974984653),(476,2214325187),(476,997821910),(476,2005463392),(476,3252396061),(476,942332382),(476,3816934055),(476,1661692647),(476,975758589),(476,3974931321),(476,2301364099),(476,855746680),(476,637832447),(476,3938675492),(476,508940865),(476,911480697),(476,1283363269),(476,3552869238),(476,2961923901),(476,3747234531),(476,3155646160),(476,3164668199),(476,2271068282),(476,84354396),(476,2915068863),(476,4064530110),(476,3216991891),(476,2045363644),(476,2664176477),(476,1076722390),(476,505410826),(476,3544422162),(476,2506779464),(476,2552384108),(476,876907216),(476,82980331),(476,3890150098),(476,3475437886),(476,2302280848),(476,1133144647),(476,801167173),(476,2059315716),(476,3139619822),(476,2937007520),(476,1589371182),(476,693370988),(476,2708427394),(476,1007456900),(476,610735313),(476,3846627131),(476,2031830639),(476,1908602231),(476,1401333655),(476,378101424),(476,996218346),(476,660881695),(476,2938384267),(476,4250264855),(476,1895305721),(476,502965417),(476,1982471117),(476,2524144246),(476,2774996218),(476,1068709096),(476,4077513867),(476,2900588200),(476,465472731),(476,4139839450),(476,2360011682),(476,4211248848),(476,283341417),(476,4165214622),(476,3508523596),(476,234404923),(476,2782693783),(476,3413880379),(476,3540168379),(476,861653603),(476,3160995915),(476,1391251310),(476,2106651858),(476,3572623339),(476,4629984),(476,2488722736),(476,3486510944),(476,2675016634),(476,2165907305),(476,136687257),(476,3540179561),(476,2792526429),(476,2220600372),(476,2914585448),(476,3882733113),(476,1688090355),(476,3534950496),(476,1182870252),(476,412601709),(476,574969182),(476,2970413814),(476,1487282505),(476,3228977345),(476,2023459642),(476,3291711134),(476,2792891444),(476,3335276918),(476,502111155),(476,1347492703),(476,2832080533),(476,1215320197),(476,2317239205),(476,1931846913),(476,1721014625),(476,738600257),(476,2998338424),(476,1207945902),(476,734241479),(476,3324570843),(476,4126771257),(476,1712456575),(476,3169253733),(476,1160958045),(476,1130949510),(476,3116084871),(476,269178051),(476,24773614),(476,3204450510),(476,3468662336),(476,1808444077),(476,4095410992),(476,1012520131),(476,2367920745),(476,2603361072),(476,2741539031),(476,607507456),(476,616165826),(476,2288576869),(476,4252798532),(476,2692385638),(476,4100315394),(476,3061254709),(476,1657292258),(476,2148967437),(476,1248236410),(476,2457219175),(476,1920985790),(476,1340703149),(476,1618471777),(476,4160689201),(476,1822364967),(476,479188821),(476,1661785323),(476,4137484009),(476,2636427258),(476,1499247737),(476,2061922205),(476,665830591),(476,916194615),(476,495595719),(476,3026469794),(476,1845449656),(476,4078122428),(476,2044505385),(476,3156749269),(476,3919036276),(476,204613135),(476,605377709),(476,766051911),(476,30400764),(476,4211022030),(476,715827285),(476,1092948871),(476,610201349),(476,1023110113),(476,3379323545),(476,2591028766),(476,1994095466),(476,33157726),(476,198243957),(476,94201498),(476,2540831776),(476,1707019604),(476,2730046909),(476,4101073252),(476,207761914),(476,2750534087),(476,980926717),(476,377071036),(476,2983490672),(476,584353846),(476,1743688562),(476,3223058413),(476,1665991311),(476,3093731065),(476,1095877807),(476,1085889875),(476,2059985562),(476,3618062925),(476,592374860),(476,4217863027),(476,3425247989),(476,1636391408),(476,1698766782),(476,2162739858),(476,1538367880),(476,3760626336),(476,1987713032),(476,2338874856),(476,4206689645),(476,1723372602),(476,2788329276),(476,2095305502),(476,3135330775),(476,2402748468),(476,24058172),(476,4000683245),(476,315670382),(476,2558276906),(476,1745365471),(476,2782569384),(476,3422117706),(476,552626444),(476,1506232339),(476,2933163456),(476,1483801350),(476,1400586123),(476,3746875726),(476,2604810181),(476,2905930158),(476,803588046),(476,1651400661),(476,1431243585),(476,1586185269),(476,4110009762),(476,3647374073),(476,4196158832),(476,644435096),(476,1862966990),(476,2098775956),(476,4045847707),(476,3122054119),(476,1971194991),(476,2149367276),(476,1888540635),(476,2660577125),(476,2508340497),(476,196341346),(476,1790101800),(476,1054130805),(476,2741947598),(476,1292400575),(476,545037028),(476,1516477184),(476,2706799993),(476,562470873),(476,2591346466),(476,613023703),(476,2725609989),(476,2082081559),(476,572560232),(476,2833489058),(476,1999611979),(476,1938789650),(476,2958717166),(476,1035708154),(476,2025067287),(476,3804047398),(476,248028803),(476,4243412966),(476,628124381),(476,1271215494),(476,2140466223),(476,1298495884),(476,3585931255),(476,532975694),(476,892763084),(476,203145038),(476,470924714),(476,1460516495),(476,2732318442),(476,3996868778),(476,862206445),(476,3193479021),(476,3382171736),(476,3362897893),(476,3598913121),(476,1342337107),(476,3202829344),(476,1335223071),(476,270790954),(476,1086966479),(476,484642328),(476,4274468042),(476,1740107684),(476,2117688527),(476,1393082718),(476,366510022),(476,341328174),(476,1469264429),(476,968691010),(476,3210232788),(476,809700252),(476,3705477223),(476,1639200307),(476,3585776886),(476,3305319229),(476,1052899681),(476,2176267881),(476,357387863),(476,451177334),(476,677589039),(476,1181390953),(476,898241702),(476,3480303789),(476,1736215096),(476,2511740146),(476,2560762429),(476,1570623991),(476,897080848),(476,891021207),(476,2807843172),(476,411231410),(476,2413680770),(476,519468981),(476,1898829954),(476,4274422817),(476,2781196321),(476,433695516),(476,1652336127),(476,4200438598),(476,3032893805),(476,1435170492),(476,341146430),(476,755973553),(476,2183774725),(476,3967614532),(476,1589097164),(476,2441764320),(476,745126750),(476,348450311),(476,2084175962),(476,3357611772),(476,1654631620),(476,3098454302),(476,2029227635),(476,1731761366),(476,2444253995),(476,2906032508),(476,872274856),(476,4282856364),(476,3328013593),(476,4184469063),(476,1074477927),(476,475878802),(476,1341972790),(476,2770374005),(476,4237489391),(476,2818813526),(476,3131100007),(476,4267621199),(476,1031922959),(476,1616292706),(476,630426110),(476,1846388513),(476,2239793094),(476,1660370824),(476,3321716633),(476,2551727033),(476,1836172154),(476,1870881122),(476,3324207484),(476,1065867023),(476,1459310880),(476,1395112921),(476,893552556),(476,1795813847),(476,2544364435),(476,4188602229),(476,1437064809),(476,922605498),(476,4180843510),(476,2554784265),(476,3798404205),(476,1216801552),(476,225525148),(476,274058040),(476,3206796234),(476,610255635),(476,3139895407),(476,3993594441),(476,2078652070),(476,3340749058),(476,2282248923),(476,3201099700),(476,3944887276),(476,887478137),(476,620965629),(476,53639561),(476,687854272),(476,4204526813),(476,3434636086),(476,3859247582),(476,2160451939),(476,419013317),(476,488655959),(476,2224381764),(476,857621694),(476,593880699),(476,1743569168),(476,747100668),(476,2627272664),(476,1477316791),(476,852002855),(476,3813191394),(476,3206482767),(476,2935275735),(476,825997452),(476,4128572079),(476,4149399208),(476,2432005645),(476,945310979),(476,206553734),(476,3381625344),(476,2613891474),(476,1285565060),(476,725086502),(476,2181279565),(476,2136294074),(476,3291030245),(476,3423892574),(476,1818418110),(476,1175554195),(476,231365613),(476,3071984169),(476,1510809703),(476,2304894647),(476,724387218),(476,3702122266),(476,3105745802),(476,3598888791),(476,40599425),(476,4256434691),(476,1198380170),(476,3549401556),(476,2300237909),(476,484124464),(476,3042798728),(476,767973032),(476,4146324303),(476,1493350341),(476,2166736334),(476,3061340275),(476,1468811388),(476,1958965990),(476,2146366302),(476,2212338847),(476,2088651590),(476,2684538463),(476,2292708505),(476,571001464),(476,608126571),(476,2736309071),(476,1479333754),(476,1794660366),(476,2319975337),(476,1093438481),(476,2975864804),(476,2504416172),(476,3531750290),(476,219666672),(476,4219072870),(476,1053258155),(476,2382983142),(476,1006288562),(476,1770263986),(476,3089735283),(476,3689334927),(476,2901629603),(476,2019277020),(476,2853333944),(476,1110695191),(476,3884283185),(476,4268093708),(476,159799075),(476,1715997742),(476,1009155269),(476,3922001006),(476,3916338789),(476,1085252167),(476,207705430),(476,1190601026),(476,1441004396),(476,1567147586),(476,964098054),(476,1385174189),(476,3607427007),(476,4065177061),(476,1552830538),(476,3778287701),(476,3986294473),(476,4127238085),(476,1865170325),(476,2161789419),(476,2889615117),(476,785261358),(476,3873733217),(476,2600209543),(476,3958092558),(476,4143434528),(476,3225228598),(476,3451063310),(476,810085901),(476,1502204888),(476,2931931582),(476,1339720903),(476,4093703382),(476,1016897830),(476,1186809094),(476,2269117600),(476,813555736),(476,733475850),(476,305814753),(476,2720553993),(476,212227262),(476,1328958432),(476,3903742053),(476,2617942920),(476,4254367326),(476,2895836413),(476,1090341105),(476,3174277595),(476,639084285),(476,4064195579),(476,2134315289),(476,608843276),(476,4190247440),(476,1090444753),(476,2554275840),(476,2758076506),(476,2518001916),(476,3620157415),(476,1195920681),(476,1822840633),(476,1087551238),(476,235508323),(476,1139244570),(476,810960133),(476,425550269),(476,1767940144),(476,1488780247),(476,1250541405),(476,1715845038),(476,3777612587),(476,2285237154),(476,802817926),(476,4280998710),(476,1108258121),(476,1107026853),(476,2913745362),(476,1129101120),(476,2454813183),(476,1690919006),(476,23973636),(476,293370743),(476,1041759778),(476,3142497267),(476,2920365983),(476,2300359472),(476,885232682),(476,1995817456),(476,3443377157),(476,863919144),(476,1324348692),(476,4019216150),(476,443752815),(476,4223293),(476,1182491637),(476,4257294915),(476,3629776934),(476,582958316),(476,3061655453),(476,1665355533),(476,1929899841),(476,1033949851),(476,2010879266),(476,1872304779),(476,1282102725),(476,3589651214),(476,4095654001),(476,2447713556),(476,2543494532),(476,2069898435),(476,3286503857),(476,2662939963),(476,93111834),(476,3160936308),(476,261262800),(476,141197408),(476,1904512268),(476,3001025754),(476,2247670246),(476,535154833),(476,3476002757),(476,3806439314),(476,1819793014),(476,3545273473),(476,3957652542),(476,3018295592),(476,1367893712),(476,1034338066),(476,3229510223),(476,4276953245),(476,3363858574),(476,2870596766),(476,648526699),(476,3627085975),(476,1585047995),(476,1960922033),(476,748737253),(476,1175066615),(476,1318322018),(476,260367662),(476,643741484),(476,1013706048),(476,1726352130),(476,2222354404),(476,1327031463),(476,1131865044),(476,839200087),(476,1407668396),(476,3548333318),(476,237845721),(476,3056051791),(476,747235328),(476,172675174),(476,2781705803),(476,2111348799),(476,3067187587),(476,618638032),(476,3369756381),(476,2232055662),(476,55113216),(476,3939915090),(476,2586983921),(476,3286008345),(476,1956055310),(476,740042513),(476,2282536358),(476,1863122946),(476,1296880981),(476,2589434346),(476,1621393368),(476,39250009),(476,72263924),(476,1587391050),(476,847186998),(476,2455499024),(476,859347884),(476,2244795234),(476,64890532),(476,4052874687),(476,4164311595),(476,3933068098),(476,1002949555),(476,4133431923),(476,2742246443),(476,1777443855),(476,1249637156),(476,3380995129),(476,1216124444),(476,3654494801),(476,3342174504),(476,103981159),(476,1499126787),(476,1961024836),(476,4102074963),(476,3836944673),(476,3924888977),(476,1697117306),(476,3406763364),(476,1129505049) ON DUPLICATE KEY UPDATE id=id |
9.261 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
378 | 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 |
6.997 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>=951 AND c.nright<=952 GROUP BY p.id_product) p INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 24 |
3.344 ms | 40254001956 | Yes | /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.104 ms | 1298 | /classes/Configuration.php:180 | ||
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>=951 AND c.nright<=952 GROUP BY p.id_product) p |
2.775 ms | 40254001956 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
51 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps21_hook_alias` ha INNER JOIN `ps21_hook` h ON ha.name = h.name |
2.278 ms | 0 | /classes/Hook.php:1292 | ||
15 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps21_module` m INNER JOIN ps21_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps21_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps21_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps21_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
2.074 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.919 ms | 386 | /classes/Hook.php:456 | ||
415 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache` WHERE ((id_controller=1 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=2 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=3 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=4 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=5 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=6 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=7 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=8 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR id_controller=9 OR (id_controller=10 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=11 AND last_gen < (NOW() - INTERVAL 691200 SECOND))) ORDER BY last_gen ASC LIMIT 2 |
1.613 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
411 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 3474574289, 'https://cadeaufou.com/610-lubrifiants-parfumes', 1, 2, 1, 610, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.418 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
402 | 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.337 ms | 1 | /classes/ObjectModel.php:622 | ||
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 (14237,14238,14341,28938,191678,191679,191680,191682,191683,191684,191685,191686,191687,191688,191689,191690,202177) |
1.286 ms | 17 | /classes/ProductAssembler.php:95 | ||
407 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('915910', '', 'cadeaufou.com/610-lubrifiants-parfumes', '', '2023-12-01 10:05:55') |
1.199 ms | 1 | /classes/ObjectModel.php:622 | ||
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.191 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
406 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('918201', '2448', '751134203', '', '1', '1', '2023-12-01 10:05:55') |
1.171 ms | 1 | /classes/ObjectModel.php:622 | ||
169 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("231219c80357bbe13799055e0427374b", "a:1:{s:7:\"filters\";a:0:{}}") |
1.032 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.942 ms | 880 | /classes/Hook.php:1332 | ||
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` < 951) AND (a0.`nright` > 952) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.883 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
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` = 610 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.859 ms | 1 | Yes | Yes | /classes/Category.php:921 |
154 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 951) AND (a0.`nright` > 952) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.848 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
379 | 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 (14237) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.773 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.727 ms | 880 | /classes/Hook.php:1292 | ||
382 | 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 (14238) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.719 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
353 | 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` = 191688) AND (b.`id_shop` = 1) LIMIT 1 |
0.625 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
410 | 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.618 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
332 | 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` = 191680) AND (b.`id_shop` = 1) LIMIT 1 |
0.611 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
391 | 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 (191685) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.554 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
396 | 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 (191690) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.547 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
397 | 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 (202177) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.547 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
205 | 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` = 28938 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` = 28938 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.543 ms | 0 | /classes/Cart.php:1410 | ||
356 | 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` = 191689) AND (b.`id_shop` = 1) LIMIT 1 |
0.540 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
344 | 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` = 191685) AND (b.`id_shop` = 1) LIMIT 1 |
0.534 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
320 | 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` = 14341) AND (b.`id_shop` = 1) LIMIT 1 |
0.530 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
359 | 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` = 191690) AND (b.`id_shop` = 1) LIMIT 1 |
0.530 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
338 | 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` = 191683) AND (b.`id_shop` = 1) LIMIT 1 |
0.527 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
354 | 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` = 191688 ORDER BY `position` |
0.526 ms | 2 | Yes | /classes/Product.php:3545 | |
347 | 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` = 191686) AND (b.`id_shop` = 1) LIMIT 1 |
0.515 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.511 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
394 | 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 (191688) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.507 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
287 | 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` = 191688 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` = 191688 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.503 ms | 0 | /classes/Cart.php:1410 | ||
405 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 610 LIMIT 1 |
0.494 ms | 1 | /classes/Page.php:83 | ||
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.492 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
387 | 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 (191680) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.492 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
341 | 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` = 191684) AND (b.`id_shop` = 1) LIMIT 1 |
0.489 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
140 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.488 ms | 81 | /classes/module/Module.php:345 | ||
263 | 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` = 191685 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` = 191685 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.488 ms | 0 | /classes/Cart.php:1410 | ||
329 | 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` = 191679) AND (b.`id_shop` = 1) LIMIT 1 |
0.484 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
350 | 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` = 191687) AND (b.`id_shop` = 1) LIMIT 1 |
0.484 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
388 | 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 (191682) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.483 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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.482 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
383 | 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 (14341) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.479 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
256 | 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 = 191684 ORDER BY f.position ASC |
0.476 ms | 1 | Yes | /classes/Product.php:5993 | |
314 | 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` = 14237) AND (b.`id_shop` = 1) LIMIT 1 |
0.475 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
384 | 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 (28938) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.475 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
393 | 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 (191687) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.472 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
385 | 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 (191678) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.469 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
271 | 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` = 191686 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` = 191686 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.466 ms | 0 | /classes/Cart.php:1410 | ||
395 | 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 (191689) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.466 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
181 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 14237 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` = 14237 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.461 ms | 0 | /classes/Cart.php:1410 | ||
386 | 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 (191679) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.459 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
403 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 918201 AND `date_add` > '2023-12-01 09:35:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.455 ms | 1 | Yes | /classes/Connection.php:168 | |
247 | 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` = 191683 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` = 191683 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.454 ms | 0 | /classes/Cart.php:1410 | ||
214 | 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` = 191678 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` = 191678 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.451 ms | 0 | /classes/Cart.php:1410 | ||
362 | 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` = 202177) AND (b.`id_shop` = 1) LIMIT 1 |
0.450 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
392 | 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 (191686) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.450 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
335 | 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` = 191682) AND (b.`id_shop` = 1) LIMIT 1 |
0.447 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
389 | 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 (191683) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.446 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
363 | 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` = 202177 ORDER BY `position` |
0.444 ms | 4 | Yes | /classes/Product.php:3545 | |
197 | 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` = 14341 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` = 14341 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.444 ms | 0 | /classes/Cart.php:1410 | ||
345 | 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` = 191685 ORDER BY `position` |
0.443 ms | 1 | Yes | /classes/Product.php:3545 | |
18 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.436 ms | 81 | /classes/module/Module.php:345 | ||
240 | 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 = 191682 ORDER BY f.position ASC |
0.436 ms | 1 | Yes | /classes/Product.php:5993 | |
317 | 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` = 14238) AND (b.`id_shop` = 1) LIMIT 1 |
0.436 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
323 | 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` = 28938) AND (b.`id_shop` = 1) LIMIT 1 |
0.434 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
255 | 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` = 191684 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` = 191684 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.433 ms | 0 | /classes/Cart.php:1410 | ||
230 | 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` = 191680 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` = 191680 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.430 ms | 0 | /classes/Cart.php:1410 | ||
326 | 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` = 191678) AND (b.`id_shop` = 1) LIMIT 1 |
0.427 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
312 | 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` = 202177 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` = 202177 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.426 ms | 0 | /classes/Cart.php:1410 | ||
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.425 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
248 | 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 = 191683 ORDER BY f.position ASC |
0.424 ms | 1 | Yes | /classes/Product.php:5993 | |
295 | 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` = 191689 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` = 191689 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.419 ms | 0 | /classes/Cart.php:1410 | ||
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.415 ms | 6 | /classes/CartRule.php:418 | ||
390 | 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 (191684) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.413 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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 = 14237 ORDER BY f.position ASC |
0.412 ms | 1 | Yes | /classes/Product.php:5993 | |
189 | 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` = 14238 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` = 14238 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.412 ms | 0 | /classes/Cart.php:1410 | ||
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.410 ms | 1 | /classes/CartRule.php:418 | ||
222 | 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` = 191679 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` = 191679 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.409 ms | 0 | /classes/Cart.php:1410 | ||
279 | 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` = 191687 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` = 191687 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.406 ms | 0 | /classes/Cart.php:1410 | ||
339 | 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` = 191683 ORDER BY `position` |
0.405 ms | 1 | Yes | /classes/Product.php:3545 | |
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.402 ms | 5 | /classes/CartRule.php:357 | ||
303 | 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` = 191690 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` = 191690 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.400 ms | 0 | /classes/Cart.php:1410 | ||
357 | 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` = 191689 ORDER BY `position` |
0.400 ms | 1 | Yes | /classes/Product.php:3545 | |
348 | 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` = 191686 ORDER BY `position` |
0.399 ms | 2 | Yes | /classes/Product.php:3545 | |
360 | 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` = 191690 ORDER BY `position` |
0.395 ms | 1 | Yes | /classes/Product.php:3545 | |
351 | 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` = 191687 ORDER BY `position` |
0.392 ms | 1 | Yes | /classes/Product.php:3545 | |
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` = 14237 AND image_shop.`cover` = 1 LIMIT 1 |
0.389 ms | 1 | /classes/Product.php:3570 | ||
239 | 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` = 191682 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` = 191682 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.388 ms | 0 | /classes/Cart.php:1410 | ||
313 | 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 = 202177 ORDER BY f.position ASC |
0.388 ms | 1 | Yes | /classes/Product.php:5993 | |
128 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 610) AND (b.`id_shop` = 1) LIMIT 1 |
0.384 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
315 | 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` = 14237 ORDER BY `position` |
0.383 ms | 1 | Yes | /classes/Product.php:3545 | |
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.380 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.377 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
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.375 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
280 | 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 = 191687 ORDER BY f.position ASC |
0.375 ms | 1 | Yes | /classes/Product.php:5993 | |
336 | 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` = 191682 ORDER BY `position` |
0.374 ms | 1 | Yes | /classes/Product.php:3545 | |
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.369 ms | 1 | /classes/Customer.php:503 | ||
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.367 ms | 81 | /classes/module/Module.php:345 | ||
231 | 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 = 191680 ORDER BY f.position ASC |
0.366 ms | 1 | Yes | /classes/Product.php:5993 | |
304 | 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 = 191690 ORDER BY f.position ASC |
0.365 ms | 1 | Yes | /classes/Product.php:5993 | |
330 | 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` = 191679 ORDER BY `position` |
0.363 ms | 2 | Yes | /classes/Product.php:3545 | |
342 | 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` = 191684 ORDER BY `position` |
0.363 ms | 2 | Yes | /classes/Product.php:3545 | |
272 | 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 = 191686 ORDER BY f.position ASC |
0.358 ms | 1 | Yes | /classes/Product.php:5993 | |
288 | 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 = 191688 ORDER BY f.position ASC |
0.358 ms | 1 | Yes | /classes/Product.php:5993 | |
162 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 610 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.356 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
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.351 ms | 1 | /classes/order/Order.php:881 | ||
324 | 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` = 28938 ORDER BY `position` |
0.349 ms | 2 | Yes | /classes/Product.php:3545 | |
264 | 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 = 191685 ORDER BY f.position ASC |
0.347 ms | 1 | Yes | /classes/Product.php:5993 | |
223 | 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 = 191679 ORDER BY f.position ASC |
0.346 ms | 1 | Yes | /classes/Product.php:5993 | |
198 | 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 = 14341 ORDER BY f.position ASC |
0.342 ms | 1 | Yes | /classes/Product.php:5993 | |
206 | 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 = 28938 ORDER BY f.position ASC |
0.340 ms | 1 | Yes | /classes/Product.php:5993 | |
296 | 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 = 191689 ORDER BY f.position ASC |
0.340 ms | 1 | Yes | /classes/Product.php:5993 | |
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.337 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
215 | 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 = 191678 ORDER BY f.position ASC |
0.325 ms | 1 | Yes | /classes/Product.php:5993 | |
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.320 ms | 1 | /classes/Customer.php:475 | ||
190 | 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 = 14238 ORDER BY f.position ASC |
0.319 ms | 1 | Yes | /classes/Product.php:5993 | |
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` = 14237) |
0.306 ms | 1 | /classes/Product.php:3857 | ||
343 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 191684 |
0.306 ms | 1 | /classes/Product.php:2902 | ||
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` = 610) LIMIT 1 |
0.299 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
235 | 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` = 191682) |
0.297 ms | 1 | /classes/Product.php:3857 | ||
318 | 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` = 14238 ORDER BY `position` |
0.292 ms | 1 | Yes | /classes/Product.php:3545 | |
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.291 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.291 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
327 | 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` = 191678 ORDER BY `position` |
0.291 ms | 1 | Yes | /classes/Product.php:3545 | |
321 | 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` = 14341 ORDER BY `position` |
0.291 ms | 1 | Yes | /classes/Product.php:3545 | |
13 | SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps21_lang` l JOIN ps21_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 |
0.289 ms | 1 | /classes/Language.php:1216 | ||
249 | 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` = 191684 AND image_shop.`cover` = 1 LIMIT 1 |
0.288 ms | 2 | /classes/Product.php:3570 | ||
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.287 ms | 5 | /classes/CartRule.php:357 | ||
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.285 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
333 | 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` = 191680 ORDER BY `position` |
0.285 ms | 2 | Yes | /classes/Product.php:3545 | |
56 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 2 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.284 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
6 | SELECT SQL_NO_CACHE * FROM `ps21_country` a LEFT JOIN `ps21_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps21_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1 |
0.283 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
243 | 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` = 191683) |
0.278 ms | 1 | /classes/Product.php:3857 | ||
218 | 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` = 191679) |
0.277 ms | 1 | /classes/Product.php:3857 | ||
259 | 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` = 191685) |
0.265 ms | 1 | /classes/Product.php:3857 | ||
377 | 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.264 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
299 | 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` = 191690) |
0.263 ms | 1 | /classes/Product.php:3857 | ||
365 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.263 ms | 1 | /classes/module/Module.php:2636 | ||
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.262 ms | 1 | /classes/Currency.php:1136 | ||
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.262 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
267 | 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` = 191686) |
0.262 ms | 1 | /classes/Product.php:3857 | ||
136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.261 ms | 1 | /classes/FeatureFlag.php:105 | ||
201 | 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` = 28938) |
0.260 ms | 1 | /classes/Product.php:3857 | ||
273 | 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` = 191687 AND image_shop.`cover` = 1 LIMIT 1 |
0.258 ms | 1 | /classes/Product.php:3570 | ||
371 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.258 ms | 1 | /classes/module/Module.php:2636 | ||
246 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 191683) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.257 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
283 | 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` = 191688) |
0.254 ms | 1 | /classes/Product.php:3857 | ||
226 | 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` = 191680) |
0.246 ms | 1 | /classes/Product.php:3857 | ||
164 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 610 AND `id_shop` = 1 |
0.245 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
180 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 14237) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.244 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
193 | 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` = 14341) |
0.242 ms | 1 | /classes/Product.php:3857 | ||
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.239 ms | 1 | /classes/Language.php:1080 | ||
168 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 610 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.239 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
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` = 14238 AND image_shop.`cover` = 1 LIMIT 1 |
0.238 ms | 1 | /classes/Product.php:3570 | ||
178 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_group` WHERE `id_group` = 1 LIMIT 1 |
0.236 ms | 1 | /classes/Group.php:154 | ||
207 | 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` = 191678 AND image_shop.`cover` = 1 LIMIT 1 |
0.236 ms | 1 | /classes/Product.php:3570 | ||
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.235 ms | 1 | /classes/Customer.php:503 | ||
66 | SELECT SQL_NO_CACHE id FROM `ps21_jm_pagecache_details` WHERE `details_md5`=MD5('{\"1\":{\"taxes\":{\"id_tax\":1},\"computation_method\":0},\"2\":{\"taxes\":{\"id_tax\":2},\"computation_method\":0},\"3\":{\"taxes\":{\"id_tax\":3},\"computation_method\":0},\"4\":{\"taxes\":{\"id_tax\":4},\"computation_method\":0},\"5\":{\"taxes\":{\"id_tax\":1},\"computation_method\":0}}'); |
0.235 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.234 ms | 10 | Yes | /classes/ImageType.php:109 | |
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.231 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
289 | 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` = 191689 AND image_shop.`cover` = 1 LIMIT 1 |
0.231 ms | 1 | /classes/Product.php:3570 | ||
185 | 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` = 14238) |
0.230 ms | 1 | /classes/Product.php:3857 | ||
409 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.229 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
305 | 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` = 202177 AND image_shop.`cover` = 1 LIMIT 1 |
0.228 ms | 4 | /classes/Product.php:3570 | ||
251 | 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` = 191684) |
0.226 ms | 1 | /classes/Product.php:3857 | ||
404 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.226 ms | 1 | /classes/Page.php:104 | ||
232 | 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` = 191682 AND image_shop.`cover` = 1 LIMIT 1 |
0.224 ms | 1 | /classes/Product.php:3570 | ||
297 | 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` = 191690 AND image_shop.`cover` = 1 LIMIT 1 |
0.224 ms | 1 | /classes/Product.php:3570 | ||
265 | 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` = 191686 AND image_shop.`cover` = 1 LIMIT 1 |
0.224 ms | 2 | /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.223 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.222 ms | 10 | Yes | /classes/ImageType.php:109 | |
210 | 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` = 191678) |
0.222 ms | 1 | /classes/Product.php:3857 | ||
408 | SELECT SQL_NO_CACHE data FROM `ps21_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.222 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43 | ||
199 | 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` = 28938 AND image_shop.`cover` = 1 LIMIT 1 |
0.221 ms | 2 | /classes/Product.php:3570 | ||
257 | 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` = 191685 AND image_shop.`cover` = 1 LIMIT 1 |
0.221 ms | 1 | /classes/Product.php:3570 | ||
291 | 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` = 191689) |
0.221 ms | 1 | /classes/Product.php:3857 | ||
16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.220 ms | 88 | /classes/Hook.php:287 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-12-01 10:05:00' AND date_from <= '2023-12-01 12:05:00') OR (date_to >= '2023-12-01 10:05:00' AND date_to <= '2023-12-01 12:05:00'); |
0.220 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
308 | 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` = 202177) |
0.220 ms | 1 | /classes/Product.php:3857 | ||
213 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 191678) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.218 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
275 | 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` = 191687) |
0.218 ms | 1 | /classes/Product.php:3857 | ||
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.216 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
358 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 191689 |
0.215 ms | 1 | /classes/Product.php:2902 | ||
54 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.214 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.213 ms | 1 | /classes/Customer.php:475 | ||
355 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 191688 |
0.213 ms | 1 | /classes/Product.php:2902 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 610 AND ctg.`id_group` = 1 LIMIT 1 |
0.213 ms | 1 | /classes/Category.php:1751 | ||
177 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 14237 AND `id_group` = 1 LIMIT 1 |
0.213 ms | 0 | /classes/GroupReduction.php:156 | ||
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.211 ms | 1 | /classes/shop/Shop.php:218 | ||
346 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 191685 |
0.211 ms | 1 | /classes/Product.php:2902 | ||
241 | 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` = 191683 AND image_shop.`cover` = 1 LIMIT 1 |
0.209 ms | 1 | /classes/Product.php:3570 | ||
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.209 ms | 1 | Yes | /classes/Currency.php:709 | |
216 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191679 AND image_shop.`cover` = 1 LIMIT 1 |
0.209 ms | 2 | /classes/Product.php:3570 | ||
238 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 191682) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.208 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
159 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "pm_advancedsearch4" LIMIT 1 |
0.207 ms | 0 | /classes/module/Module.php:2636 | ||
224 | 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` = 191680 AND image_shop.`cover` = 1 LIMIT 1 |
0.207 ms | 2 | /classes/Product.php:3570 | ||
152 | SELECT SQL_NO_CACHE * FROM `ps21_country_lang` WHERE `id_country` = 8 |
0.205 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
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.204 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
191 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 14341 AND image_shop.`cover` = 1 LIMIT 1 |
0.203 ms | 1 | /classes/Product.php:3570 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.202 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.201 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
133 | SELECT SQL_NO_CACHE * FROM `ps21_currency` a LEFT JOIN `ps21_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `ps21_curr |