Leggings de Sport pour Enfants John Smith Motavit G 005 Noir
Produit disponible avec d'autres options
12,54 €
Il y a 952 produits.
Load Time | 2154 ms |
Querying Time | 409 ms |
Queries | 880 |
Memory Peak Usage | 36.6 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 | disabled |
Smarty Compilation | force compile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 5.074 ms | 5.074 ms | 8.51 Mb | 9.2 Mb |
__construct | 8.178 ms | 13.252 ms | 1.73 Mb | 11.8 Mb |
config | 24.045 ms | 37.297 ms | 1.21 Mb | 11.8 Mb |
__construct | 0.018 ms | 37.315 ms | - Mb | 11.8 Mb |
init | 30.300 ms | 67.615 ms | 2.11 Mb | 14.8 Mb |
checkAccess | 0.001 ms | 67.616 ms | - Mb | 14.8 Mb |
setMedia | 2.471 ms | 70.087 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.001 ms | 70.088 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 70.089 ms | - Mb | 14.8 Mb |
initContent | 1579 ms | 1649 ms | 9.53 Mb | 23.4 Mb |
initFooter | 0.002 ms | 1649 ms | - Mb | 23.4 Mb |
display | 504.487 ms | 2154 ms | 12.54 Mb | 36.6 Mb |
Hook | Time | Memory Usage |
---|---|---|
displayProductListReviews | 54.441 ms | 1.32 Mb |
DisplayHeader | 45.663 ms | 0.88 Mb |
ActionOutputHTMLBefore | 37.734 ms | 0.14 Mb |
ActionDispatcherBefore | 34.691 ms | 3.09 Mb |
displayLeftColumn | 23.632 ms | 0.74 Mb |
displayTop | 15.261 ms | 0.20 Mb |
DisplayBeforeBodyClosingTag | 14.353 ms | 0.21 Mb |
DisplayFooter | 10.476 ms | 0.11 Mb |
ActionDispatcher | 10.349 ms | 0.70 Mb |
DisplayFooterRight | 10.027 ms | 0.24 Mb |
DisplayNavFullWidth | 5.093 ms | 0.07 Mb |
DisplayLeftColumn | 4.959 ms | 0.04 Mb |
DisplayOutsideMainPage | 4.292 ms | 0.06 Mb |
displayFooterRight | 3.307 ms | 0.07 Mb |
displayFooterLeft | 2.348 ms | 0.06 Mb |
DisplayBanner | 2.329 ms | 0.06 Mb |
DisplayFooterLeft | 1.354 ms | 0.03 Mb |
DisplayNav1 | 1.321 ms | 0.03 Mb |
ActionFrontControllerSetVariables | 1.319 ms | 0.06 Mb |
DisplayFooterAfter | 1.191 ms | 0.03 Mb |
displayNav2 | 0.896 ms | 0.08 Mb |
DisplaySidebarNavigation | 0.692 ms | - Mb |
ActionFrontControllerSetMedia | 0.683 ms | 0.01 Mb |
ProductSearchProvider | 0.350 ms | - Mb |
ActionObjectAddAfter | 0.038 ms | - Mb |
ModuleRoutes | 0.019 ms | 0.02 Mb |
ActionFrontControllerInitAfter | 0.014 ms | - Mb |
DisplayAfterBodyOpeningTag | 0.014 ms | - Mb |
DisplayFooterBefore | 0.008 ms | - Mb |
29 hook(s) | 286.853 ms | 8.25 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 5.100 ms | 0.53 Mb |
jprestaspeedpack | 83.797 ms | 3.99 Mb |
blockreassurance | 1.073 ms | 0.09 Mb |
blockwishlist | 10.782 ms | 0.13 Mb |
ps_emailsubscription | 3.499 ms | 0.10 Mb |
ps_socialfollow | 2.475 ms | 0.08 Mb |
ps_emailalerts | 0.183 ms | 0.09 Mb |
zonethememanager | 32.263 ms | 1.60 Mb |
ps_shoppingcart | 10.600 ms | 0.11 Mb |
ps_searchbar | 1.787 ms | 0.14 Mb |
productcomments | 54.751 ms | 1.36 Mb |
ps_googleanalytics | 6.605 ms | 0.05 Mb |
zonecolorsfonts | 43.565 ms | 0.87 Mb |
zonemegamenu | 6.438 ms | 0.12 Mb |
prestastripe | 2.776 ms | 0.02 Mb |
ps_facetedsearch | 1.924 ms | 0.10 Mb |
ps_languageselector | 0.718 ms | 0.06 Mb |
ps_currencyselector | 0.422 ms | 0.06 Mb |
ps_customersignin | 3.442 ms | 0.08 Mb |
ps_categorytree | 23.766 ms | 0.75 Mb |
zonecolumnblocks | 4.111 ms | 0.13 Mb |
zonepopupnewsletter | 2.180 ms | 0.11 Mb |
statsdata | 8.039 ms | 0.21 Mb |
23 module(s) | 310.295 ms | 10.78 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
169 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=1419 AND c.nright<=1420 GROUP BY p.id_product) p |
65.604 ms | 4117724544 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
168 | SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=1419 AND c.nright<=1420 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 |
61.793 ms | 4117724544 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
878 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (354,803264849),(354,1502204888),(354,1328958432),(354,1289214159),(354,1785617407),(354,2936477779),(354,1727466530),(354,1432532875),(354,1025009294),(354,1804081323),(354,3479716883),(354,66301815),(354,537553573),(354,3045727500),(354,3231073010),(354,1825096520),(354,3225262556),(354,2645763144),(354,2027619899),(354,786864081),(354,1849360992),(354,294428854),(354,3774376179),(354,2880678980),(354,114155291),(354,2929321318),(354,2087307803),(354,2369020978),(354,1152186767),(354,4222788516),(354,2858566420),(354,848840972),(354,4147554351),(354,770698498),(354,2244011448),(354,477004582),(354,3610318732),(354,1070190107),(354,937307692),(354,25761885),(354,3366890060),(354,3483396593),(354,392306519),(354,909258745),(354,179865882),(354,3099645137),(354,3371246540),(354,2390640699),(354,501027234),(354,3032495894),(354,2100541971),(354,2793494280),(354,180908336),(354,1192985740),(354,1972034646),(354,2419117650),(354,3803768817),(354,4265874642),(354,67723771),(354,3423129237),(354,3399895114),(354,3221089548),(354,2990154896),(354,2728213885),(354,933991437),(354,2513627470),(354,468067826),(354,4137721533),(354,1552016987),(354,4080301755),(354,4245349388),(354,1973472416),(354,1839057912),(354,3745041382),(354,3035734567),(354,3719469943),(354,3466131047),(354,679558129),(354,462819688),(354,4267553191),(354,518809702),(354,3303811122),(354,2883778317),(354,1694893476),(354,3287268691),(354,3711637102),(354,698879415),(354,885817714),(354,125306139),(354,1634619674),(354,58280175),(354,3363778289),(354,1161663254),(354,201135304),(354,288600709),(354,1021330335),(354,2858809635),(354,2763627026),(354,3717400459),(354,4125370705),(354,3997906175),(354,4162316513),(354,3219397995),(354,2539165674),(354,1046234598),(354,787652129),(354,1595426297),(354,4184932827),(354,1985552396),(354,1944795689),(354,3799916950),(354,1827123668),(354,1447744642),(354,1636796806),(354,2645405926),(354,1474595477),(354,3375525138),(354,3902077767),(354,3507415422),(354,2781072282),(354,2002273313),(354,3164880625),(354,2490789905),(354,1000843653),(354,48947005),(354,3883347157),(354,3700474777),(354,4264269047),(354,2125390191),(354,4270481046),(354,1693150473),(354,343450730),(354,381351735),(354,2863449446),(354,3772294966),(354,3877457961),(354,1492116830),(354,4041511410),(354,828132466),(354,4090211224),(354,2185737194),(354,3517149926),(354,647687838),(354,733479784),(354,1440916471),(354,3262261204),(354,1872100372),(354,2092461357),(354,3357609169),(354,2365529006),(354,1263061406),(354,2296732656),(354,534196217),(354,482025419),(354,2811467352),(354,2488480532),(354,3501473861),(354,1917272649),(354,1878317490),(354,1789511633),(354,956713705),(354,89981727),(354,1143557322),(354,2749361789),(354,3857194488),(354,1024086260),(354,26040876),(354,1804243295),(354,2165251395),(354,1281618245),(354,2793993627),(354,426054238),(354,3398682121),(354,1025101115),(354,2974984653),(354,2214325187),(354,997821910),(354,2005463392),(354,3252396061),(354,942332382),(354,3816934055),(354,1661692647),(354,975758589),(354,3974931321),(354,2301364099),(354,855746680),(354,637832447),(354,3938675492),(354,508940865),(354,911480697),(354,1283363269),(354,3552869238),(354,2961923901),(354,3747234531),(354,3155646160),(354,3164668199),(354,2271068282),(354,84354396),(354,2915068863),(354,4064530110),(354,3216991891),(354,2045363644),(354,2664176477),(354,1076722390),(354,505410826),(354,3544422162),(354,2506779464),(354,2552384108),(354,876907216),(354,82980331),(354,3890150098),(354,3475437886),(354,2302280848),(354,1133144647),(354,801167173),(354,2059315716),(354,3139619822),(354,2937007520),(354,1589371182),(354,693370988),(354,2708427394),(354,1007456900),(354,610735313),(354,3846627131),(354,2031830639),(354,1908602231),(354,1401333655),(354,378101424),(354,996218346),(354,660881695),(354,2938384267),(354,4250264855),(354,1895305721),(354,502965417),(354,1982471117),(354,2524144246),(354,2774996218),(354,1068709096),(354,4077513867),(354,2900588200),(354,465472731),(354,4139839450),(354,2360011682),(354,4211248848),(354,283341417),(354,4165214622),(354,3508523596),(354,234404923),(354,2782693783),(354,3413880379),(354,3540168379),(354,861653603),(354,3160995915),(354,1391251310),(354,2106651858),(354,3572623339),(354,4629984),(354,2488722736),(354,3486510944),(354,2675016634),(354,2165907305),(354,136687257),(354,3540179561),(354,2792526429),(354,2220600372),(354,2914585448),(354,3882733113),(354,1688090355),(354,3534950496),(354,1182870252),(354,412601709),(354,574969182),(354,2970413814),(354,1487282505),(354,3228977345),(354,2023459642),(354,3291711134),(354,2792891444),(354,3335276918),(354,502111155),(354,1347492703),(354,2832080533),(354,1215320197),(354,2317239205),(354,1931846913),(354,1721014625),(354,738600257),(354,2998338424),(354,1207945902),(354,734241479),(354,3324570843),(354,4126771257),(354,1712456575),(354,3169253733),(354,1160958045),(354,1130949510),(354,3116084871),(354,269178051),(354,24773614),(354,3204450510),(354,3468662336),(354,1808444077),(354,4095410992),(354,1012520131),(354,2367920745),(354,2603361072),(354,2741539031),(354,607507456),(354,616165826),(354,2288576869),(354,4252798532),(354,2692385638),(354,4100315394),(354,3061254709),(354,1657292258),(354,2148967437),(354,1248236410),(354,2457219175),(354,1920985790),(354,1340703149),(354,1618471777),(354,4160689201),(354,1822364967),(354,479188821),(354,1661785323),(354,4137484009),(354,2636427258),(354,1499247737),(354,2061922205),(354,665830591),(354,916194615),(354,495595719),(354,3026469794),(354,1845449656),(354,4078122428),(354,2044505385),(354,3156749269),(354,3919036276),(354,204613135),(354,605377709),(354,766051911),(354,30400764),(354,4211022030),(354,715827285),(354,1092948871),(354,610201349),(354,1023110113),(354,3379323545),(354,2591028766),(354,1994095466),(354,33157726),(354,198243957),(354,94201498),(354,2540831776),(354,1707019604),(354,2730046909),(354,4101073252),(354,207761914),(354,2750534087),(354,980926717),(354,377071036),(354,2983490672),(354,584353846),(354,1743688562),(354,3223058413),(354,1665991311),(354,3093731065),(354,1095877807),(354,1085889875),(354,2059985562),(354,3618062925),(354,592374860),(354,4217863027),(354,3425247989),(354,1636391408),(354,1698766782),(354,2162739858),(354,1538367880),(354,3760626336),(354,1987713032),(354,2338874856),(354,4206689645),(354,1723372602),(354,2788329276),(354,2095305502),(354,3135330775),(354,2402748468),(354,24058172),(354,4000683245),(354,315670382),(354,2558276906),(354,1745365471),(354,2782569384),(354,3422117706),(354,552626444),(354,1506232339),(354,2933163456),(354,1483801350),(354,1400586123),(354,3746875726),(354,2604810181),(354,2905930158),(354,803588046),(354,1651400661),(354,1431243585),(354,1586185269),(354,4110009762),(354,3647374073),(354,4196158832),(354,644435096),(354,1862966990),(354,2098775956),(354,4045847707),(354,3122054119),(354,1971194991),(354,2149367276),(354,1888540635),(354,2660577125),(354,2508340497),(354,196341346),(354,1790101800),(354,1054130805),(354,2741947598),(354,1292400575),(354,545037028),(354,1516477184),(354,2706799993),(354,562470873),(354,2591346466),(354,613023703),(354,2725609989),(354,2082081559),(354,572560232),(354,2833489058),(354,1999611979),(354,1938789650),(354,2958717166),(354,1035708154),(354,2025067287),(354,3804047398),(354,248028803),(354,4243412966),(354,628124381),(354,1271215494),(354,2140466223),(354,1298495884),(354,3585931255),(354,532975694),(354,892763084),(354,203145038),(354,470924714),(354,1460516495),(354,2732318442),(354,3996868778),(354,862206445),(354,3193479021),(354,3382171736),(354,3362897893),(354,3598913121),(354,1342337107),(354,3202829344),(354,1335223071),(354,270790954),(354,1086966479),(354,484642328),(354,4274468042),(354,1740107684),(354,2117688527),(354,1393082718),(354,366510022),(354,341328174),(354,1469264429),(354,968691010),(354,3210232788),(354,809700252),(354,3705477223),(354,1639200307),(354,3585776886),(354,3305319229),(354,1052899681),(354,2176267881),(354,357387863),(354,451177334),(354,677589039),(354,1181390953),(354,898241702),(354,3480303789),(354,1736215096),(354,2511740146),(354,2560762429),(354,1570623991),(354,897080848),(354,891021207),(354,2807843172),(354,411231410),(354,2413680770),(354,519468981),(354,1898829954),(354,4274422817),(354,2781196321),(354,433695516),(354,1652336127),(354,4200438598),(354,3032893805),(354,1435170492),(354,341146430),(354,755973553),(354,2183774725),(354,3967614532),(354,1589097164),(354,2441764320),(354,745126750),(354,348450311),(354,2084175962),(354,3357611772),(354,1654631620),(354,3098454302),(354,2029227635),(354,1731761366),(354,2444253995),(354,2906032508),(354,872274856),(354,4282856364),(354,3328013593),(354,4184469063),(354,1074477927),(354,475878802),(354,1341972790),(354,2770374005),(354,4237489391),(354,2818813526),(354,3131100007),(354,4267621199),(354,1031922959),(354,1616292706),(354,630426110),(354,1846388513),(354,2239793094),(354,1660370824),(354,3321716633),(354,2551727033),(354,1836172154),(354,1870881122),(354,3324207484),(354,1065867023),(354,1459310880),(354,1395112921),(354,893552556),(354,1795813847),(354,2544364435),(354,4188602229),(354,1437064809),(354,922605498),(354,4180843510),(354,2554784265),(354,3798404205),(354,1216801552),(354,225525148),(354,274058040),(354,3206796234),(354,610255635),(354,3139895407),(354,3993594441),(354,2078652070),(354,3340749058),(354,2282248923),(354,3201099700),(354,3944887276),(354,887478137),(354,620965629),(354,53639561),(354,687854272),(354,4204526813),(354,3434636086),(354,3859247582),(354,2160451939),(354,419013317),(354,488655959),(354,2224381764),(354,857621694),(354,593880699),(354,1743569168),(354,747100668),(354,2627272664),(354,1477316791),(354,852002855),(354,3813191394),(354,3206482767),(354,2935275735),(354,825997452),(354,4128572079),(354,4149399208),(354,2432005645),(354,945310979),(354,206553734),(354,3381625344),(354,2613891474),(354,1285565060),(354,725086502),(354,2181279565),(354,2136294074),(354,531227063),(354,3291030245),(354,3423892574),(354,1818418110),(354,1175554195),(354,231365613),(354,3071984169),(354,1510809703),(354,2304894647),(354,724387218),(354,3702122266),(354,3105745802),(354,3598888791),(354,40599425),(354,4256434691),(354,1198380170),(354,3549401556),(354,2300237909),(354,484124464),(354,3042798728),(354,767973032),(354,4146324303),(354,1493350341),(354,2166736334),(354,3061340275),(354,1468811388),(354,714571165),(354,1958965990),(354,2146366302),(354,2212338847),(354,2088651590),(354,2684538463),(354,2292708505),(354,571001464),(354,608126571),(354,2736309071),(354,1479333754),(354,1794660366),(354,2319975337),(354,1093438481),(354,2975864804),(354,2504416172),(354,3531750290),(354,219666672),(354,4219072870),(354,1053258155),(354,2382983142),(354,1006288562),(354,1770263986),(354,3089735283),(354,3689334927),(354,2901629603),(354,2019277020),(354,2853333944),(354,1110695191),(354,3884283185),(354,4268093708),(354,159799075),(354,1715997742),(354,1009155269),(354,3922001006),(354,3916338789),(354,1085252167),(354,207705430),(354,1190601026),(354,1441004396),(354,1567147586),(354,964098054),(354,1385174189),(354,3607427007),(354,4065177061),(354,1552830538),(354,3778287701),(354,3986294473),(354,4127238085),(354,1865170325),(354,2161789419),(354,2889615117),(354,785261358),(354,3873733217),(354,2600209543),(354,3958092558),(354,4143434528),(354,3225228598),(354,3451063310),(354,810085901),(354,2931931582),(354,1339720903),(354,4093703382),(354,1016897830),(354,1186809094),(354,2269117600),(354,813555736),(354,733475850),(354,305814753),(354,2720553993),(354,212227262),(354,3903742053),(354,2617942920),(354,4254367326),(354,2895836413),(354,1090341105),(354,3174277595),(354,639084285),(354,4064195579),(354,2134315289),(354,608843276),(354,4190247440),(354,1090444753),(354,2554275840),(354,2758076506),(354,2518001916),(354,3620157415),(354,1195920681),(354,1822840633),(354,1087551238),(354,235508323),(354,1139244570),(354,810960133),(354,425550269),(354,1767940144),(354,1488780247),(354,1250541405),(354,1715845038),(354,3777612587),(354,2285237154),(354,802817926),(354,4280998710),(354,1108258121),(354,1107026853),(354,2913745362),(354,1129101120),(354,2454813183),(354,1690919006),(354,23973636),(354,293370743),(354,1041759778),(354,3142497267),(354,2920365983),(354,2300359472),(354,885232682),(354,1995817456),(354,3443377157),(354,863919144),(354,1324348692),(354,4019216150),(354,443752815),(354,4223293),(354,1182491637),(354,4257294915),(354,3629776934),(354,582958316),(354,3061655453),(354,1665355533),(354,1929899841),(354,1033949851),(354,2010879266),(354,1872304779),(354,1282102725),(354,3589651214),(354,4095654001),(354,2447713556),(354,2543494532),(354,2069898435),(354,3286503857),(354,2662939963),(354,93111834),(354,3160936308),(354,261262800),(354,141197408),(354,1904512268),(354,3001025754),(354,2247670246),(354,535154833),(354,3476002757),(354,3806439314),(354,1819793014),(354,3545273473),(354,3957652542),(354,3018295592),(354,1367893712),(354,1034338066),(354,3229510223),(354,4276953245),(354,3363858574),(354,2870596766),(354,648526699),(354,3627085975),(354,1585047995),(354,1960922033),(354,748737253),(354,1175066615),(354,1318322018),(354,260367662),(354,643741484),(354,1013706048),(354,1726352130),(354,2222354404),(354,1327031463),(354,1131865044),(354,839200087),(354,1407668396),(354,3548333318),(354,237845721),(354,3056051791),(354,747235328),(354,172675174),(354,2781705803),(354,2111348799),(354,3067187587),(354,618638032),(354,3369756381),(354,2232055662),(354,55113216),(354,3939915090),(354,2586983921),(354,3286008345),(354,1956055310),(354,740042513),(354,2282536358),(354,1863122946),(354,1296880981),(354,2589434346),(354,1621393368),(354,39250009),(354,72263924),(354,1587391050),(354,847186998),(354,2455499024),(354,859347884),(354,2244795234),(354,64890532),(354,4242677194),(354,3912473049),(354,377977963),(354,2488195546),(354,3878573425),(354,3808280843),(354,2577772713),(354,755471037),(354,2006008610),(354,860157466),(354,889469136),(354,93238023),(354,1509103319),(354,3418307565),(354,2505580247),(354,4077705656),(354,676584654),(354,2158607628),(354,2212054835),(354,2771830938),(354,3389691328),(354,3653398551),(354,1049615342),(354,3465704351),(354,3924888977),(354,1697117306),(354,3406763364),(354,1129505049) ON DUPLICATE KEY UPDATE id=id |
10.242 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
660 | 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 |
7.636 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
2 | SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
3.352 ms | 1298 | /classes/Configuration.php:180 | ||
51 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps21_hook_alias` ha INNER JOIN `ps21_hook` h ON ha.name = h.name |
2.416 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.306 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
866 | 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') |
2.008 ms | 1 | /classes/ObjectModel.php:622 | ||
173 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-11-30 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (507,509,511,1968,1969,1975,1977,1978,1984,1987,1989,4365,6674,9586,10834,12174,12175,13425,13430,13449,13452,13456,16391,16424) |
1.845 ms | 24 | /classes/ProductAssembler.php:95 | ||
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.778 ms | 386 | /classes/Hook.php:456 | ||
172 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("e02e2bb67f4558eb8d100f140c3a1158", "a:1:{s:7:\"filters\";a:0:{}}") |
1.759 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
879 | 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.703 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
870 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('896557', '585', '752115218', '', '1', '1', '2023-11-30 11:11:22') |
1.576 ms | 1 | /classes/ObjectModel.php:622 | ||
871 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('894267', '', 'cadeaufou.com/211-pantalons-de-sport', '', '2023-11-30 11:11:22') |
1.258 ms | 1 | /classes/ObjectModel.php:622 | ||
875 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 3646586234, 'https://cadeaufou.com/211-pantalons-de-sport', 1, 2, 1, 211, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.227 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.024 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.988 ms | 880 | /classes/Hook.php:1332 | ||
627 | 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` = 13449 ORDER BY `position` |
0.970 ms | 19 | Yes | /classes/Product.php:3545 | |
630 | 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` = 13452 ORDER BY `position` |
0.927 ms | 15 | Yes | /classes/Product.php:3545 | |
672 | 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 (507) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.888 ms | 6 | Yes | Yes | /classes/Product.php:4504 |
633 | 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` = 13456 ORDER BY `position` |
0.861 ms | 16 | Yes | /classes/Product.php:3545 | |
722 | 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 (1978) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.831 ms | 3 | Yes | Yes | /classes/Product.php:4504 |
661 | SELECT SQL_NO_CACHE * FROM `ps21_zcolumnblock` b LEFT JOIN `ps21_zcolumnblock_lang` bl ON b.`id_zcolumnblock` = bl.`id_zcolumnblock` WHERE b.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY b.`id_zcolumnblock` ORDER BY b.`position` ASC |
0.817 ms | 16 | Yes | Yes | /modules/zonecolumnblocks/classes/ZColumnBlock.php:116 |
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` = 211 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.779 ms | 1 | Yes | Yes | /classes/Category.php:921 |
666 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (113,114,115,116,117,118) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.776 ms | 6 | /classes/Product.php:2752 | ||
163 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 1419) AND (a0.`nright` > 1420) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.762 ms | 127 | Yes | /classes/PrestaShopCollection.php:383 | |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.757 ms | 880 | /classes/Hook.php:1292 | ||
615 | 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` = 12174 ORDER BY `position` |
0.702 ms | 9 | Yes | /classes/Product.php:3545 | |
689 | 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 (511) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.690 ms | 5 | Yes | Yes | /classes/Product.php:4504 |
756 | 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 (4365) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.672 ms | 4 | Yes | Yes | /classes/Product.php:4504 |
639 | 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` = 16424 ORDER BY `position` |
0.662 ms | 6 | Yes | /classes/Product.php:3545 | |
624 | 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` = 13430 ORDER BY `position` |
0.646 ms | 12 | Yes | /classes/Product.php:3545 | |
749 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4365) LIMIT 1 |
0.636 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
769 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (2086,2087,2088,2089) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.621 ms | 4 | /classes/Product.php:2752 | ||
740 | 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 (1987) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.617 ms | 6 | Yes | Yes | /classes/Product.php:4504 |
765 | 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 (6674) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.613 ms | 5 | Yes | Yes | /classes/Product.php:4504 |
609 | 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` = 9586 ORDER BY `position` |
0.612 ms | 11 | Yes | /classes/Product.php:3545 | |
636 | 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` = 16391 ORDER BY `position` |
0.600 ms | 6 | Yes | /classes/Product.php:3545 | |
874 | 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.594 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
632 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps21_product_attribute_image` pai LEFT JOIN `ps21_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps21_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (3781, 3782, 3780) AND il.`id_lang` = 1 ORDER by i.`position` |
0.587 ms | 1 | Yes | /classes/Product.php:2921 | |
677 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 509 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.585 ms | 2 | Yes | Yes | /classes/Product.php:2734 |
465 | 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` = 13425 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` = 13425 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.585 ms | 0 | /classes/Cart.php:1410 | ||
789 | 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 (12174) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.584 ms | 4 | Yes | Yes | /classes/Product.php:4504 |
191 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 507 AND pac.`id_product_attribute` = 113 AND agl.`id_lang` = 1 |
0.584 ms | 1 | /classes/Product.php:7506 | ||
618 | 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` = 12175 ORDER BY `position` |
0.582 ms | 4 | Yes | /classes/Product.php:3545 | |
680 | 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 (509) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.580 ms | 2 | Yes | Yes | /classes/Product.php:4504 |
715 | 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 (1977) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.573 ms | 4 | Yes | Yes | /classes/Product.php:4504 |
752 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (1510,1511,1512,1513) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.573 ms | 4 | /classes/Product.php:2752 | ||
768 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 9586 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.573 ms | 4 | Yes | Yes | /classes/Product.php:2734 |
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` < 1419) AND (a0.`nright` > 1420) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.570 ms | 127 | Yes | /classes/PrestaShopCollection.php:383 | |
702 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1975) LIMIT 1 |
0.566 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
730 | 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 (1984) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.563 ms | 4 | Yes | Yes | /classes/Product.php:4504 |
416 | 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` = 10834 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` = 10834 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.560 ms | 0 | /classes/Cart.php:1410 | ||
450 | 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` = 3442 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 12175 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` = 3442 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 12175 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.560 ms | 0 | /classes/Cart.php:1410 | ||
545 | 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` = 16391 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` = 16391 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.558 ms | 0 | /classes/Cart.php:1410 | ||
547 | 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` = 4390 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 16391 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` = 4390 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 16391 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.556 ms | 0 | /classes/Cart.php:1410 | ||
705 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (1190,1191) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.551 ms | 2 | /classes/Product.php:2752 | ||
612 | 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` = 10834 ORDER BY `position` |
0.549 ms | 3 | Yes | /classes/Product.php:3545 | |
621 | 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` = 13425 ORDER BY `position` |
0.548 ms | 12 | Yes | /classes/Product.php:3545 | |
675 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 509) LIMIT 1 |
0.547 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.543 ms | 81 | /classes/module/Module.php:345 | ||
701 | 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 (1969) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.543 ms | 3 | Yes | Yes | /classes/Product.php:4504 |
467 | 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` = 3693 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 13425 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` = 3693 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 13425 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.538 ms | 0 | /classes/Cart.php:1410 | ||
497 | 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` = 13449 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` = 13449 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.538 ms | 0 | /classes/Cart.php:1410 | ||
734 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (1203,1204,1205,1206,1207,1208) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.537 ms | 6 | /classes/Product.php:2752 | ||
531 | 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` = 3793 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 13456 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` = 3793 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 13456 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.535 ms | 0 | /classes/Cart.php:1410 | ||
655 | SELECT SQL_NO_CACHE * FROM `ps21_zmenu` m LEFT JOIN `ps21_zmenu_lang` ml ON m.`id_zmenu` = ml.`id_zmenu` WHERE m.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY m.`id_zmenu` ORDER BY m.`position` ASC |
0.535 ms | 7 | Yes | Yes | /modules/zonemegamenu/classes/ZMenu.php:104 |
757 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6674) LIMIT 1 |
0.535 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.532 ms | 81 | /classes/module/Module.php:345 | ||
402 | 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` = 2086 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 9586 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` = 2086 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 9586 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.530 ms | 0 | /classes/Cart.php:1410 | ||
432 | 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` = 12174 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` = 12174 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.529 ms | 0 | /classes/Cart.php:1410 | ||
481 | 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` = 13430 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` = 13430 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.528 ms | 0 | /classes/Cart.php:1410 | ||
751 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 4365 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.527 ms | 4 | Yes | Yes | /classes/Product.php:2734 |
486 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 13430 AND pac.`id_product_attribute` = 3712 AND agl.`id_lang` = 1 |
0.526 ms | 1 | /classes/Product.php:7506 | ||
564 | 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` = 4403 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 16424 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` = 4403 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 16424 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.526 ms | 0 | /classes/Cart.php:1410 | ||
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` = 1187 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1969 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` = 1187 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1969 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.525 ms | 0 | /classes/Cart.php:1410 | ||
819 | 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 (13449) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.525 ms | 4 | Yes | Yes | /classes/Product.php:4504 |
186 | 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` = 507 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` = 507 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.524 ms | 0 | /classes/Cart.php:1410 | ||
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` = 1190 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1975 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` = 1190 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1975 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.523 ms | 0 | /classes/Cart.php:1410 | ||
317 | 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` = 1984 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` = 1984 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.523 ms | 0 | /classes/Cart.php:1410 | ||
351 | 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` = 1209 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1989 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` = 1209 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1989 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.519 ms | 0 | /classes/Cart.php:1410 | ||
843 | 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 (16391) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.518 ms | 5 | Yes | Yes | /classes/Product.php:4504 |
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.517 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
208 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 509 AND pac.`id_product_attribute` = 119 AND agl.`id_lang` = 1 |
0.515 ms | 1 | /classes/Product.php:7506 | ||
448 | 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` = 12175 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` = 12175 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.514 ms | 0 | /classes/Cart.php:1410 | ||
539 | 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` = 16391) AND (b.`id_shop` = 1) LIMIT 1 |
0.514 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
502 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 13449 AND pac.`id_product_attribute` = 3772 AND agl.`id_lang` = 1 |
0.513 ms | 1 | /classes/Product.php:7506 | ||
773 | 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 (9586) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.513 ms | 4 | Yes | Yes | /classes/Product.php:4504 |
603 | 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` = 4365 ORDER BY `position` |
0.512 ms | 5 | Yes | /classes/Product.php:3545 | |
400 | 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` = 9586 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` = 9586 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.511 ms | 0 | /classes/Cart.php:1410 | ||
393 | 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` = 9586) AND (b.`id_shop` = 1) LIMIT 1 |
0.508 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
760 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (1846,1847,1848,1849,1850) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.508 ms | 5 | /classes/Product.php:2752 | ||
725 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 1984 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.508 ms | 4 | Yes | Yes | /classes/Product.php:2734 |
203 | 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` = 509 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` = 509 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.507 ms | 0 | /classes/Cart.php:1410 | ||
434 | 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` = 3438 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 12174 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` = 3438 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 12174 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.505 ms | 0 | /classes/Cart.php:1410 | ||
704 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 1975 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.505 ms | 2 | Yes | Yes | /classes/Product.php:2734 |
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` = 1197 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1978 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` = 1197 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1978 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.504 ms | 0 | /classes/Cart.php:1410 | ||
529 | 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` = 13456 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` = 13456 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.504 ms | 0 | /classes/Cart.php:1410 | ||
470 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 13425 AND pac.`id_product_attribute` = 3693 AND agl.`id_lang` = 1 |
0.503 ms | 1 | /classes/Product.php:7506 | ||
410 | 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` = 10834) AND (b.`id_shop` = 1) LIMIT 1 |
0.502 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
723 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1984) LIMIT 1 |
0.502 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
804 | 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 (13425) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.502 ms | 3 | Yes | Yes | /classes/Product.php:4504 |
269 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1975 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` = 1975 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.501 ms | 0 | /classes/Cart.php:1410 | ||
777 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (2534,2535,2536,2537) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.501 ms | 4 | /classes/Product.php:2752 | ||
177 | 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` = 507) AND (b.`id_shop` = 1) LIMIT 1 |
0.500 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
253 | 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` = 1969 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` = 1969 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.499 ms | 0 | /classes/Cart.php:1410 | ||
681 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 511) LIMIT 1 |
0.499 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
585 | 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` = 1975 ORDER BY `position` |
0.497 ms | 4 | Yes | /classes/Product.php:3545 | |
405 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 9586 AND pac.`id_product_attribute` = 2086 AND agl.`id_lang` = 1 |
0.497 ms | 1 | /classes/Product.php:7506 | ||
366 | 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` = 4365 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` = 4365 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.494 ms | 0 | /classes/Cart.php:1410 | ||
371 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 4365 AND pac.`id_product_attribute` = 1510 AND agl.`id_lang` = 1 |
0.493 ms | 1 | /classes/Product.php:7506 | ||
600 | 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` = 1989 ORDER BY `position` |
0.493 ms | 4 | Yes | /classes/Product.php:3545 | |
319 | 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` = 1199 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1984 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` = 1199 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1984 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.492 ms | 0 | /classes/Cart.php:1410 | ||
707 | 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 (1975) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.492 ms | 2 | Yes | Yes | /classes/Product.php:4504 |
421 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 10834 AND pac.`id_product_attribute` = 2535 AND agl.`id_lang` = 1 |
0.491 ms | 1 | /classes/Product.php:7506 | ||
279 | 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` = 1977) AND (b.`id_shop` = 1) LIMIT 1 |
0.491 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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` = 1192 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1977 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` = 1192 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1977 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.491 ms | 0 | /classes/Cart.php:1410 | ||
426 | 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` = 12174) AND (b.`id_shop` = 1) LIMIT 1 |
0.489 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
418 | 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` = 2535 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 10834 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` = 2535 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 10834 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 |