Cartes érotiques
Il y a 52 produits.
11,29 €
Il y a 52 produits.
Load Time | 658.671 ms |
Querying Time | 176 ms |
Queries | 498 |
Memory Peak Usage | 27.7 Mb |
Included Files | 1263 files - 11.89 Mb |
PrestaShop Cache | - Mb |
Global vars | 0.19 Mb |
PrestaShop Version | 8.1.2 |
PHP Version | 8.1.25 |
MySQL Version | 10.6.16-MariaDB |
Memory Limit | 2048M |
Max Execution Time | 3600s |
Smarty Cache | enabled |
Smarty Compilation | force compile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 5.408 ms | 5.408 ms | 8.54 Mb | 9.2 Mb |
__construct | 8.096 ms | 13.504 ms | 1.73 Mb | 11.9 Mb |
config | 23.142 ms | 36.646 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.020 ms | 36.666 ms | - Mb | 11.9 Mb |
init | 30.225 ms | 66.891 ms | 2.13 Mb | 14.8 Mb |
checkAccess | 0.001 ms | 66.892 ms | - Mb | 14.8 Mb |
setMedia | 2.547 ms | 69.439 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.002 ms | 69.441 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 69.442 ms | - Mb | 14.8 Mb |
initContent | 209.634 ms | 279.076 ms | 7.56 Mb | 22.4 Mb |
initFooter | 0.003 ms | 279.079 ms | - Mb | 22.4 Mb |
display | 379.592 ms | 658.671 ms | 5.59 Mb | 27.7 Mb |
Hook | Time | Memory Usage |
---|---|---|
displayProductListReviews | 66.432 ms | 1.33 Mb |
ActionOutputHTMLBefore | 40.367 ms | 0.14 Mb |
ActionDispatcherBefore | 33.744 ms | 3.09 Mb |
displayLeftColumn | 26.494 ms | 0.74 Mb |
displayTop | 15.877 ms | 0.20 Mb |
DisplayBeforeBodyClosingTag | 14.164 ms | 0.27 Mb |
DisplayFooter | 11.127 ms | 0.11 Mb |
ActionDispatcher | 9.948 ms | 0.70 Mb |
displayFooterRight | 3.468 ms | 0.07 Mb |
DisplayHeader | 3.117 ms | 0.06 Mb |
DisplayLeftColumn | 1.569 ms | 0.02 Mb |
ActionFrontControllerSetVariables | 1.343 ms | 0.06 Mb |
displayNav2 | 1.166 ms | 0.08 Mb |
displayFooterLeft | 0.850 ms | 0.06 Mb |
ActionFrontControllerSetMedia | 0.722 ms | 0.01 Mb |
DisplayOutsideMainPage | 0.698 ms | 0.03 Mb |
DisplayFooterLeft | 0.385 ms | 0.01 Mb |
DisplayFooterRight | 0.362 ms | 0.01 Mb |
DisplayBanner | 0.309 ms | 0.01 Mb |
DisplayNavFullWidth | 0.293 ms | 0.01 Mb |
DisplayFooterAfter | 0.279 ms | 0.01 Mb |
DisplaySidebarNavigation | 0.277 ms | - Mb |
DisplayNav1 | 0.266 ms | 0.01 Mb |
ProductSearchProvider | 0.231 ms | - Mb |
ActionObjectAddAfter | 0.032 ms | - Mb |
ModuleRoutes | 0.021 ms | 0.02 Mb |
ActionFrontControllerInitAfter | 0.016 ms | - Mb |
DisplayAfterBodyOpeningTag | 0.012 ms | - Mb |
DisplayFooterBefore | 0.010 ms | - Mb |
29 hook(s) | 233.579 ms | 7.07 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 4.692 ms | 0.54 Mb |
jprestaspeedpack | 85.275 ms | 4.00 Mb |
blockreassurance | 1.016 ms | 0.09 Mb |
blockwishlist | 11.543 ms | 0.13 Mb |
ps_emailsubscription | 3.641 ms | 0.10 Mb |
ps_socialfollow | 0.984 ms | 0.07 Mb |
ps_emailalerts | 0.187 ms | 0.09 Mb |
zonethememanager | 15.541 ms | 1.30 Mb |
ps_shoppingcart | 10.570 ms | 0.11 Mb |
ps_searchbar | 1.993 ms | 0.14 Mb |
productcomments | 66.701 ms | 1.37 Mb |
ps_googleanalytics | 7.010 ms | 0.05 Mb |
zonecolorsfonts | 1.350 ms | 0.06 Mb |
zonemegamenu | 1.772 ms | 0.06 Mb |
prestastripe | 0.996 ms | 0.02 Mb |
ps_facetedsearch | 1.706 ms | 0.10 Mb |
ps_languageselector | 0.849 ms | 0.06 Mb |
ps_currencyselector | 0.648 ms | 0.06 Mb |
ps_customersignin | 3.796 ms | 0.08 Mb |
ps_categorytree | 26.613 ms | 0.75 Mb |
zonecolumnblocks | 0.667 ms | 0.11 Mb |
zonepopupnewsletter | 0.491 ms | 0.03 Mb |
statsdata | 7.441 ms | 0.27 Mb |
23 module(s) | 255.482 ms | 9.59 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
496 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (708,803264849),(708,531227063),(708,3873733217),(708,1289214159),(708,1785617407),(708,2936477779),(708,1727466530),(708,1432532875),(708,1025009294),(708,1804081323),(708,3479716883),(708,66301815),(708,537553573),(708,3045727500),(708,3231073010),(708,1825096520),(708,3225262556),(708,2645763144),(708,2027619899),(708,786864081),(708,1849360992),(708,294428854),(708,3774376179),(708,2880678980),(708,114155291),(708,2929321318),(708,2087307803),(708,2369020978),(708,1152186767),(708,4222788516),(708,2858566420),(708,848840972),(708,4147554351),(708,770698498),(708,2244011448),(708,477004582),(708,3610318732),(708,1070190107),(708,937307692),(708,25761885),(708,3366890060),(708,3483396593),(708,392306519),(708,909258745),(708,179865882),(708,3099645137),(708,3371246540),(708,2390640699),(708,501027234),(708,3032495894),(708,2100541971),(708,2793494280),(708,180908336),(708,1192985740),(708,1972034646),(708,2419117650),(708,3803768817),(708,4265874642),(708,67723771),(708,3423129237),(708,3399895114),(708,3221089548),(708,2990154896),(708,2728213885),(708,933991437),(708,2513627470),(708,468067826),(708,4137721533),(708,1552016987),(708,4080301755),(708,4245349388),(708,1973472416),(708,1839057912),(708,3745041382),(708,3035734567),(708,3719469943),(708,3466131047),(708,679558129),(708,462819688),(708,4267553191),(708,518809702),(708,3303811122),(708,2883778317),(708,1694893476),(708,3287268691),(708,3711637102),(708,698879415),(708,885817714),(708,125306139),(708,1634619674),(708,58280175),(708,3363778289),(708,1161663254),(708,201135304),(708,288600709),(708,1021330335),(708,2858809635),(708,2763627026),(708,3717400459),(708,4125370705),(708,3997906175),(708,4162316513),(708,3219397995),(708,2539165674),(708,1046234598),(708,787652129),(708,1595426297),(708,4184932827),(708,1985552396),(708,1944795689),(708,3799916950),(708,1827123668),(708,1447744642),(708,1636796806),(708,2645405926),(708,1474595477),(708,3375525138),(708,3902077767),(708,3507415422),(708,2781072282),(708,2002273313),(708,3164880625),(708,2490789905),(708,1000843653),(708,48947005),(708,3883347157),(708,3700474777),(708,4264269047),(708,2125390191),(708,4270481046),(708,1693150473),(708,343450730),(708,381351735),(708,2863449446),(708,3772294966),(708,3877457961),(708,1492116830),(708,4041511410),(708,828132466),(708,4090211224),(708,2185737194),(708,3517149926),(708,647687838),(708,733479784),(708,1440916471),(708,3262261204),(708,1872100372),(708,2092461357),(708,3357609169),(708,2365529006),(708,1263061406),(708,2296732656),(708,534196217),(708,482025419),(708,2811467352),(708,2488480532),(708,3501473861),(708,1917272649),(708,1878317490),(708,1789511633),(708,956713705),(708,89981727),(708,1143557322),(708,2749361789),(708,3857194488),(708,1024086260),(708,26040876),(708,1804243295),(708,2165251395),(708,1281618245),(708,2793993627),(708,426054238),(708,3398682121),(708,1025101115),(708,2974984653),(708,2214325187),(708,997821910),(708,2005463392),(708,3252396061),(708,942332382),(708,3816934055),(708,1661692647),(708,975758589),(708,3974931321),(708,2301364099),(708,855746680),(708,637832447),(708,3938675492),(708,508940865),(708,911480697),(708,1283363269),(708,3552869238),(708,2961923901),(708,3747234531),(708,3155646160),(708,3164668199),(708,2271068282),(708,84354396),(708,2915068863),(708,4064530110),(708,3216991891),(708,2045363644),(708,2664176477),(708,1076722390),(708,505410826),(708,3544422162),(708,2506779464),(708,2552384108),(708,876907216),(708,82980331),(708,3890150098),(708,3475437886),(708,2302280848),(708,1133144647),(708,801167173),(708,2059315716),(708,3139619822),(708,2937007520),(708,1589371182),(708,693370988),(708,2708427394),(708,1007456900),(708,610735313),(708,3846627131),(708,2031830639),(708,1908602231),(708,1401333655),(708,378101424),(708,996218346),(708,660881695),(708,2938384267),(708,4250264855),(708,1895305721),(708,502965417),(708,1982471117),(708,2524144246),(708,2774996218),(708,1068709096),(708,4077513867),(708,2900588200),(708,465472731),(708,4139839450),(708,2360011682),(708,4211248848),(708,283341417),(708,4165214622),(708,3508523596),(708,234404923),(708,2782693783),(708,3413880379),(708,3540168379),(708,861653603),(708,3160995915),(708,1391251310),(708,2106651858),(708,3572623339),(708,4629984),(708,2488722736),(708,3486510944),(708,2675016634),(708,2165907305),(708,136687257),(708,3540179561),(708,2792526429),(708,2220600372),(708,2914585448),(708,3882733113),(708,1688090355),(708,3534950496),(708,1182870252),(708,412601709),(708,574969182),(708,2970413814),(708,1487282505),(708,3228977345),(708,2023459642),(708,3291711134),(708,2792891444),(708,3335276918),(708,502111155),(708,1347492703),(708,2832080533),(708,1215320197),(708,2317239205),(708,1931846913),(708,1721014625),(708,738600257),(708,2998338424),(708,1207945902),(708,734241479),(708,3324570843),(708,4126771257),(708,1712456575),(708,3169253733),(708,1160958045),(708,1130949510),(708,3116084871),(708,269178051),(708,24773614),(708,3204450510),(708,3468662336),(708,1808444077),(708,4095410992),(708,1012520131),(708,2367920745),(708,2603361072),(708,2741539031),(708,607507456),(708,616165826),(708,2288576869),(708,4252798532),(708,2692385638),(708,4100315394),(708,3061254709),(708,1657292258),(708,2148967437),(708,1248236410),(708,2457219175),(708,1920985790),(708,1340703149),(708,1618471777),(708,4160689201),(708,1822364967),(708,479188821),(708,1661785323),(708,4137484009),(708,2636427258),(708,1499247737),(708,2061922205),(708,665830591),(708,916194615),(708,495595719),(708,3026469794),(708,1845449656),(708,4078122428),(708,2044505385),(708,3156749269),(708,3919036276),(708,204613135),(708,605377709),(708,766051911),(708,30400764),(708,4211022030),(708,715827285),(708,1092948871),(708,610201349),(708,1023110113),(708,3379323545),(708,2591028766),(708,1994095466),(708,33157726),(708,198243957),(708,94201498),(708,2540831776),(708,1707019604),(708,2730046909),(708,4101073252),(708,207761914),(708,2750534087),(708,980926717),(708,377071036),(708,2983490672),(708,584353846),(708,1743688562),(708,3223058413),(708,1665991311),(708,3093731065),(708,1095877807),(708,1085889875),(708,2059985562),(708,3618062925),(708,592374860),(708,4217863027),(708,3425247989),(708,1636391408),(708,1698766782),(708,2162739858),(708,1538367880),(708,3760626336),(708,1987713032),(708,2338874856),(708,4206689645),(708,1723372602),(708,2788329276),(708,2095305502),(708,3135330775),(708,2402748468),(708,24058172),(708,4000683245),(708,315670382),(708,2558276906),(708,1745365471),(708,2782569384),(708,3422117706),(708,552626444),(708,1506232339),(708,2933163456),(708,1483801350),(708,1400586123),(708,3746875726),(708,2604810181),(708,2905930158),(708,803588046),(708,1651400661),(708,1431243585),(708,1586185269),(708,4110009762),(708,3647374073),(708,4196158832),(708,644435096),(708,1862966990),(708,2098775956),(708,4045847707),(708,3122054119),(708,1971194991),(708,2149367276),(708,1888540635),(708,2660577125),(708,2508340497),(708,196341346),(708,1790101800),(708,1054130805),(708,2741947598),(708,1292400575),(708,545037028),(708,1516477184),(708,2706799993),(708,562470873),(708,2591346466),(708,613023703),(708,2725609989),(708,2082081559),(708,572560232),(708,2833489058),(708,1999611979),(708,1938789650),(708,2958717166),(708,1035708154),(708,2025067287),(708,3804047398),(708,248028803),(708,4243412966),(708,628124381),(708,1271215494),(708,2140466223),(708,1298495884),(708,3585931255),(708,532975694),(708,892763084),(708,203145038),(708,470924714),(708,1460516495),(708,2732318442),(708,3996868778),(708,862206445),(708,3193479021),(708,3382171736),(708,3362897893),(708,3598913121),(708,1342337107),(708,3202829344),(708,1335223071),(708,270790954),(708,1086966479),(708,484642328),(708,4274468042),(708,1740107684),(708,2117688527),(708,1393082718),(708,366510022),(708,341328174),(708,1469264429),(708,968691010),(708,3210232788),(708,809700252),(708,3705477223),(708,1639200307),(708,3585776886),(708,3305319229),(708,1052899681),(708,2176267881),(708,357387863),(708,451177334),(708,677589039),(708,1181390953),(708,898241702),(708,3480303789),(708,1736215096),(708,2511740146),(708,2560762429),(708,1570623991),(708,897080848),(708,891021207),(708,2807843172),(708,411231410),(708,2413680770),(708,519468981),(708,1898829954),(708,4274422817),(708,2781196321),(708,433695516),(708,1652336127),(708,4200438598),(708,3032893805),(708,1435170492),(708,341146430),(708,755973553),(708,2183774725),(708,3967614532),(708,1589097164),(708,2441764320),(708,745126750),(708,348450311),(708,2084175962),(708,3357611772),(708,1654631620),(708,3098454302),(708,2029227635),(708,1731761366),(708,2444253995),(708,2906032508),(708,872274856),(708,4282856364),(708,3328013593),(708,4184469063),(708,1074477927),(708,475878802),(708,1341972790),(708,2770374005),(708,4237489391),(708,2818813526),(708,3131100007),(708,4267621199),(708,1031922959),(708,1616292706),(708,630426110),(708,1846388513),(708,2239793094),(708,1660370824),(708,3321716633),(708,2551727033),(708,1836172154),(708,1870881122),(708,3324207484),(708,1065867023),(708,1459310880),(708,1395112921),(708,893552556),(708,1795813847),(708,2544364435),(708,4188602229),(708,1437064809),(708,922605498),(708,4180843510),(708,2554784265),(708,3798404205),(708,1216801552),(708,225525148),(708,274058040),(708,3206796234),(708,610255635),(708,3139895407),(708,3993594441),(708,2078652070),(708,3340749058),(708,2282248923),(708,3201099700),(708,3944887276),(708,887478137),(708,620965629),(708,53639561),(708,687854272),(708,4204526813),(708,3434636086),(708,3859247582),(708,2160451939),(708,419013317),(708,488655959),(708,2224381764),(708,857621694),(708,593880699),(708,1743569168),(708,747100668),(708,2627272664),(708,1477316791),(708,852002855),(708,3813191394),(708,3206482767),(708,2935275735),(708,825997452),(708,4128572079),(708,4149399208),(708,2432005645),(708,945310979),(708,206553734),(708,3381625344),(708,2613891474),(708,1285565060),(708,725086502),(708,2181279565),(708,2136294074),(708,3291030245),(708,3423892574),(708,1818418110),(708,1175554195),(708,231365613),(708,3071984169),(708,1510809703),(708,2304894647),(708,724387218),(708,3702122266),(708,3105745802),(708,3598888791),(708,40599425),(708,4256434691),(708,1198380170),(708,3549401556),(708,2300237909),(708,484124464),(708,3042798728),(708,767973032),(708,4146324303),(708,1493350341),(708,2166736334),(708,3061340275),(708,1468811388),(708,714571165),(708,1958965990),(708,2146366302),(708,2212338847),(708,2088651590),(708,2684538463),(708,2292708505),(708,571001464),(708,608126571),(708,2736309071),(708,1479333754),(708,1794660366),(708,2319975337),(708,1093438481),(708,2975864804),(708,2504416172),(708,3531750290),(708,219666672),(708,4219072870),(708,1053258155),(708,2382983142),(708,1006288562),(708,1770263986),(708,3089735283),(708,3689334927),(708,2901629603),(708,2019277020),(708,2853333944),(708,1110695191),(708,3884283185),(708,4268093708),(708,159799075),(708,1715997742),(708,1009155269),(708,3922001006),(708,3916338789),(708,1085252167),(708,207705430),(708,1190601026),(708,1441004396),(708,1567147586),(708,964098054),(708,1385174189),(708,3607427007),(708,4065177061),(708,1552830538),(708,3778287701),(708,3986294473),(708,4127238085),(708,1865170325),(708,2161789419),(708,2889615117),(708,785261358),(708,2600209543),(708,3958092558),(708,4143434528),(708,3225228598),(708,3451063310),(708,810085901),(708,1502204888),(708,2931931582),(708,1339720903),(708,4093703382),(708,1016897830),(708,1186809094),(708,2269117600),(708,813555736),(708,733475850),(708,305814753),(708,2720553993),(708,212227262),(708,1328958432),(708,3903742053),(708,2617942920),(708,4254367326),(708,2895836413),(708,1090341105),(708,3174277595),(708,639084285),(708,4064195579),(708,2134315289),(708,608843276),(708,4190247440),(708,1090444753),(708,2554275840),(708,2758076506),(708,2518001916),(708,3620157415),(708,1195920681),(708,1822840633),(708,1087551238),(708,235508323),(708,1139244570),(708,810960133),(708,425550269),(708,1767940144),(708,1488780247),(708,1250541405),(708,1715845038),(708,3777612587),(708,2285237154),(708,802817926),(708,4280998710),(708,1108258121),(708,1107026853),(708,2913745362),(708,1129101120),(708,2454813183),(708,1690919006),(708,23973636),(708,293370743),(708,1041759778),(708,3142497267),(708,2920365983),(708,2300359472),(708,885232682),(708,1995817456),(708,3443377157),(708,863919144),(708,1324348692),(708,4019216150),(708,443752815),(708,4223293),(708,1182491637),(708,4257294915),(708,3629776934),(708,582958316),(708,3061655453),(708,1665355533),(708,1929899841),(708,1033949851),(708,2010879266),(708,1872304779),(708,1282102725),(708,3589651214),(708,4095654001),(708,2447713556),(708,2543494532),(708,2069898435),(708,3286503857),(708,2662939963),(708,93111834),(708,3160936308),(708,261262800),(708,141197408),(708,1904512268),(708,3001025754),(708,2247670246),(708,535154833),(708,3476002757),(708,3806439314),(708,1819793014),(708,3545273473),(708,3957652542),(708,3018295592),(708,1367893712),(708,1034338066),(708,3229510223),(708,4276953245),(708,3363858574),(708,2870596766),(708,648526699),(708,3627085975),(708,1585047995),(708,1960922033),(708,748737253),(708,1175066615),(708,1318322018),(708,260367662),(708,643741484),(708,1013706048),(708,1726352130),(708,2222354404),(708,1327031463),(708,1131865044),(708,839200087),(708,1407668396),(708,3548333318),(708,237845721),(708,3056051791),(708,747235328),(708,172675174),(708,2781705803),(708,2111348799),(708,3067187587),(708,618638032),(708,3369756381),(708,2232055662),(708,55113216),(708,3939915090),(708,2586983921),(708,3286008345),(708,1956055310),(708,740042513),(708,2282536358),(708,1863122946),(708,1296880981),(708,2589434346),(708,1621393368),(708,39250009),(708,72263924),(708,1587391050),(708,847186998),(708,2455499024),(708,859347884),(708,2244795234),(708,64890532),(708,2600706522),(708,3677134532),(708,390855202),(708,640860713),(708,927377650),(708,2496619037),(708,99698625),(708,1026458600),(708,1758759516),(708,1846956338),(708,4180905515),(708,1347698019),(708,1766599021),(708,665373656),(708,3008266813),(708,1107145187),(708,2317323904),(708,731208878),(708,879652065),(708,3920956217),(708,2642497630),(708,1063104513),(708,4167026522),(708,3878407249),(708,3924888977),(708,1697117306),(708,3406763364),(708,1129505049) ON DUPLICATE KEY UPDATE id=id |
9.824 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
453 | SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps21_category` c INNER JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps21_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 1669 AND c.id_category IN ( SELECT id_category FROM `ps21_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC |
8.662 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
165 | SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=1103 AND c.nright<=1104 GROUP BY p.id_product) p INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 24 |
4.523 ms | 24939358084 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
166 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=1103 AND c.nright<=1104 GROUP BY p.id_product) p |
4.048 ms | 24939358084 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
2 | SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
3.574 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.372 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.299 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
484 | INSERT INTO `ps21_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0') |
1.962 ms | 1 | /classes/ObjectModel.php:622 | ||
497 | 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.686 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
52 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.669 ms | 386 | /classes/Hook.php:456 | ||
170 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-12-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (6604,58856,66688,191204,191205,191206,191207,191208,191209,191210,191211,191212,191213,191214,191215,191216,191217,191218,191219,191220,191221,191222,191223,191224) |
1.517 ms | 24 | /classes/ProductAssembler.php:95 | ||
493 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 443687955, 'https://cadeaufou.com/527-cartes-erotiques', 1, 2, 1, 527, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.325 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
489 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('917065', '', 'cadeaufou.com/527-cartes-erotiques', '', '2023-12-01 11:08:35') |
1.220 ms | 1 | /classes/ObjectModel.php:622 | ||
488 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('919356', '1872', '751134203', '', '1', '1', '2023-12-01 11:08:35') |
1.112 ms | 1 | /classes/ObjectModel.php:622 | ||
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.094 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
161 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 1103) AND (a0.`nright` > 1104) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.969 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.957 ms | 880 | /classes/Hook.php:1332 | ||
169 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("dc37473c1e40cf37986392de88df06e4", "a:1:{s:7:\"filters\";a:0:{}}") |
0.940 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
139 | SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps21_category` c INNER JOIN ps21_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps21_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 527 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.892 ms | 1 | Yes | Yes | /classes/Category.php:921 |
154 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 1103) AND (a0.`nright` > 1104) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.792 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.770 ms | 880 | /classes/Hook.php:1292 | ||
457 | 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 (58856) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.744 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
454 | 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 (6604) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.737 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
246 | 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` = 191209 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` = 191209 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.698 ms | 0 | /classes/Cart.php:1410 | ||
437 | 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` = 191224) AND (b.`id_shop` = 1) LIMIT 1 |
0.686 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
0 | SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps21_shop_url su LEFT JOIN ps21_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'cadeaufou.com' OR su.domain_ssl = 'cadeaufou.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.627 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
465 | 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 (191210) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.623 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
214 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191205 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` = 191205 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.619 ms | 0 | /classes/Cart.php:1410 | ||
466 | 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 (191211) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.606 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
467 | 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 (191212) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.601 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
469 | 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 (191214) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.599 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
458 | 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 (66688) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.589 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
478 | 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 (191223) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.588 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
472 | 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 (191217) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.582 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
462 | 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 (191207) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.581 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
460 | 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 (191205) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.578 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
181 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 6604 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` = 6604 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.576 ms | 0 | /classes/Cart.php:1410 | ||
492 | 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.568 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
326 | 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` = 191219 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` = 191219 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.559 ms | 0 | /classes/Cart.php:1410 | ||
389 | 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` = 191208) AND (b.`id_shop` = 1) LIMIT 1 |
0.557 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
383 | 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` = 191206) AND (b.`id_shop` = 1) LIMIT 1 |
0.550 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
459 | 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 (191204) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.548 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
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` = 191215) AND (b.`id_shop` = 1) LIMIT 1 |
0.545 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
470 | 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 (191215) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.545 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
254 | 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` = 191210 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` = 191210 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.544 ms | 0 | /classes/Cart.php:1410 | ||
477 | 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 (191222) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.541 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
464 | 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 (191209) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.539 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
238 | 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` = 191208 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` = 191208 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.534 ms | 0 | /classes/Cart.php:1410 | ||
479 | 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 (191224) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.531 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
386 | 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` = 191207) AND (b.`id_shop` = 1) LIMIT 1 |
0.528 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
20 | SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps21_meta` m LEFT JOIN `ps21_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.528 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
374 | 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` = 66688) AND (b.`id_shop` = 1) LIMIT 1 |
0.522 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
474 | 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 (191219) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.519 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
461 | 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 (191206) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.518 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
475 | 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 (191220) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.517 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
230 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191207 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` = 191207 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.517 ms | 0 | /classes/Cart.php:1410 | ||
473 | 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 (191218) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.516 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
278 | 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` = 191213 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` = 191213 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.512 ms | 0 | /classes/Cart.php:1410 | ||
463 | 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 (191208) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.512 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
399 | 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` = 191211 ORDER BY `position` |
0.511 ms | 1 | Yes | /classes/Product.php:3545 | |
302 | 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` = 191216 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` = 191216 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.506 ms | 0 | /classes/Cart.php:1410 | ||
368 | 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` = 6604) AND (b.`id_shop` = 1) LIMIT 1 |
0.506 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
380 | 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` = 191205) AND (b.`id_shop` = 1) LIMIT 1 |
0.505 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
487 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 527 LIMIT 1 |
0.504 ms | 1 | /classes/Page.php:83 | ||
182 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 6604 ORDER BY f.position ASC |
0.500 ms | 1 | Yes | /classes/Product.php:5993 | |
471 | 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 (191216) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.500 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
401 | 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` = 191212) AND (b.`id_shop` = 1) LIMIT 1 |
0.495 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.490 ms | 81 | /classes/module/Module.php:345 | ||
468 | 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 (191213) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.490 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
402 | 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` = 191212 ORDER BY `position` |
0.487 ms | 1 | Yes | /classes/Product.php:3545 | |
416 | 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` = 191217) AND (b.`id_shop` = 1) LIMIT 1 |
0.487 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
426 | 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` = 191220 ORDER BY `position` |
0.480 ms | 7 | Yes | /classes/Product.php:3545 | |
350 | 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` = 191222 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` = 191222 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.480 ms | 0 | /classes/Cart.php:1410 | ||
438 | 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` = 191224 ORDER BY `position` |
0.478 ms | 2 | Yes | /classes/Product.php:3545 | |
392 | 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` = 191209) AND (b.`id_shop` = 1) LIMIT 1 |
0.478 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
476 | 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 (191221) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.477 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
318 | 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` = 191218 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` = 191218 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.475 ms | 0 | /classes/Cart.php:1410 | ||
270 | 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` = 191212 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` = 191212 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.474 ms | 0 | /classes/Cart.php:1410 | ||
18 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.474 ms | 81 | /classes/module/Module.php:345 | ||
395 | 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` = 191210) AND (b.`id_shop` = 1) LIMIT 1 |
0.473 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
190 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 58856 ORDER BY f.position ASC |
0.470 ms | 1 | Yes | /classes/Product.php:5993 | |
189 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 58856 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` = 58856 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.467 ms | 0 | /classes/Cart.php:1410 | ||
222 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 191206 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` = 191206 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.466 ms | 0 | /classes/Cart.php:1410 | ||
271 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191212 ORDER BY f.position ASC |
0.465 ms | 1 | Yes | /classes/Product.php:5993 | |
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.464 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
431 | 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` = 191222) AND (b.`id_shop` = 1) LIMIT 1 |
0.461 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
419 | 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` = 191218) AND (b.`id_shop` = 1) LIMIT 1 |
0.460 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
425 | 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` = 191220) AND (b.`id_shop` = 1) LIMIT 1 |
0.457 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
369 | 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` = 6604 ORDER BY `position` |
0.453 ms | 1 | Yes | /classes/Product.php:3545 | |
404 | 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` = 191213) AND (b.`id_shop` = 1) LIMIT 1 |
0.452 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
428 | 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` = 191221) AND (b.`id_shop` = 1) LIMIT 1 |
0.452 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
378 | 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` = 191204 ORDER BY `position` |
0.451 ms | 2 | Yes | /classes/Product.php:3545 | |
334 | 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` = 191220 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` = 191220 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.450 ms | 0 | /classes/Cart.php:1410 | ||
287 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191214 ORDER BY f.position ASC |
0.449 ms | 1 | Yes | /classes/Product.php:5993 | |
262 | 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` = 191211 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` = 191211 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.449 ms | 0 | /classes/Cart.php:1410 | ||
398 | 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` = 191211) AND (b.`id_shop` = 1) LIMIT 1 |
0.449 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
294 | 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` = 191215 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` = 191215 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.448 ms | 0 | /classes/Cart.php:1410 | ||
255 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191210 ORDER BY f.position ASC |
0.447 ms | 1 | Yes | /classes/Product.php:5993 | |
206 | 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` = 191204 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` = 191204 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.445 ms | 0 | /classes/Cart.php:1410 | ||
286 | 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` = 191214 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` = 191214 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.444 ms | 0 | /classes/Cart.php:1410 | ||
434 | 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` = 191223) AND (b.`id_shop` = 1) LIMIT 1 |
0.443 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
8 | SELECT SQL_NO_CACHE * FROM `ps21_lang` a LEFT JOIN `ps21_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.442 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
358 | 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` = 191223 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` = 191223 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.441 ms | 0 | /classes/Cart.php:1410 | ||
144 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%" |
0.441 ms | 1 | /classes/CartRule.php:418 | ||
310 | 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` = 191217 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` = 191217 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.439 ms | 0 | /classes/Cart.php:1410 | ||
485 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 919356 AND `date_add` > '2023-12-01 10:38:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.438 ms | 1 | Yes | /classes/Connection.php:168 | |
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` = 191224 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` = 191224 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.437 ms | 0 | /classes/Cart.php:1410 | ||
371 | 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` = 58856) AND (b.`id_shop` = 1) LIMIT 1 |
0.436 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
396 | 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` = 191210 ORDER BY `position` |
0.432 ms | 1 | Yes | /classes/Product.php:3545 | |
342 | 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` = 191221 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` = 191221 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.431 ms | 0 | /classes/Cart.php:1410 | ||
387 | 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` = 191207 ORDER BY `position` |
0.430 ms | 2 | Yes | /classes/Product.php:3545 | |
197 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 66688 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` = 66688 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.428 ms | 0 | /classes/Cart.php:1410 | ||
384 | 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` = 191206 ORDER BY `position` |
0.428 ms | 3 | Yes | /classes/Product.php:3545 | |
279 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191213 ORDER BY f.position ASC |
0.427 ms | 1 | Yes | /classes/Product.php:5993 | |
311 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191217 ORDER BY f.position ASC |
0.426 ms | 1 | Yes | /classes/Product.php:5993 | |
359 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191223 ORDER BY f.position ASC |
0.425 ms | 1 | Yes | /classes/Product.php:5993 | |
377 | 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` = 191204) AND (b.`id_shop` = 1) LIMIT 1 |
0.425 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
141 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-12-01 00:00:00" AND date_to <= "2023-12-01 23:59:59") OR (date_from >= "2023-12-01 00:00:00" AND date_from <= "2023-12-01 23:59:59") OR (date_from < "2023-12-01 00:00:00" AND date_to > "2023-12-01 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.422 ms | 5 | /classes/CartRule.php:357 | ||
417 | 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` = 191217 ORDER BY `position` |
0.422 ms | 2 | Yes | /classes/Product.php:3545 | |
375 | 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` = 66688 ORDER BY `position` |
0.417 ms | 1 | Yes | /classes/Product.php:3545 | |
422 | 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` = 191219) AND (b.`id_shop` = 1) LIMIT 1 |
0.417 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
247 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191209 ORDER BY f.position ASC |
0.415 ms | 1 | Yes | /classes/Product.php:5993 | |
162 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 527 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.413 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
414 | 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` = 191216 ORDER BY `position` |
0.411 ms | 2 | Yes | /classes/Product.php:3545 | |
407 | 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` = 191214) AND (b.`id_shop` = 1) LIMIT 1 |
0.411 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
413 | 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` = 191216) AND (b.`id_shop` = 1) LIMIT 1 |
0.409 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
231 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191207 ORDER BY f.position ASC |
0.406 ms | 1 | Yes | /classes/Product.php:5993 | |
429 | 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` = 191221 ORDER BY `position` |
0.404 ms | 2 | Yes | /classes/Product.php:3545 | |
124 | SELECT SQL_NO_CACHE c.* FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.402 ms | 1 | /classes/Customer.php:503 | ||
393 | 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` = 191209 ORDER BY `position` |
0.399 ms | 2 | Yes | /classes/Product.php:3545 | |
405 | 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` = 191213 ORDER BY `position` |
0.399 ms | 1 | Yes | /classes/Product.php:3545 | |
128 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 527) AND (b.`id_shop` = 1) LIMIT 1 |
0.398 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
142 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1 |
0.398 ms | 6 | /classes/CartRule.php:418 | ||
171 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 6604 AND image_shop.`cover` = 1 LIMIT 1 |
0.398 ms | 1 | /classes/Product.php:3570 | ||
53 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.396 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
22 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.395 ms | 81 | /classes/module/Module.php:345 | ||
223 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191206 ORDER BY f.position ASC |
0.395 ms | 1 | Yes | /classes/Product.php:5993 | |
248 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191210 AND image_shop.`cover` = 1 LIMIT 1 |
0.392 ms | 1 | /classes/Product.php:3570 | ||
198 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 66688 ORDER BY f.position ASC |
0.387 ms | 1 | Yes | /classes/Product.php:5993 | |
423 | 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` = 191219 ORDER BY `position` |
0.385 ms | 2 | Yes | /classes/Product.php:3545 | |
432 | 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` = 191222 ORDER BY `position` |
0.385 ms | 2 | Yes | /classes/Product.php:3545 | |
215 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191205 ORDER BY f.position ASC |
0.382 ms | 1 | Yes | /classes/Product.php:5993 | |
263 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191211 ORDER BY f.position ASC |
0.382 ms | 1 | Yes | /classes/Product.php:5993 | |
372 | 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` = 58856 ORDER BY `position` |
0.381 ms | 2 | Yes | /classes/Product.php:3545 | |
390 | 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` = 191208 ORDER BY `position` |
0.370 ms | 1 | Yes | /classes/Product.php:3545 | |
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.369 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
367 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191224 ORDER BY f.position ASC |
0.369 ms | 1 | Yes | /classes/Product.php:5993 | |
4 | SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps21_shop s LEFT JOIN ps21_shop_url su ON (s.id_shop = su.id_shop) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 |
0.368 ms | 1 | /classes/shop/Shop.php:218 | ||
303 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191216 ORDER BY f.position ASC |
0.362 ms | 1 | Yes | /classes/Product.php:5993 | |
351 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191222 ORDER BY f.position ASC |
0.359 ms | 1 | Yes | /classes/Product.php:5993 | |
452 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.356 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
207 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191204 ORDER BY f.position ASC |
0.353 ms | 1 | Yes | /classes/Product.php:5993 | |
13 | SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps21_lang` l JOIN ps21_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 |
0.352 ms | 1 | /classes/Language.php:1216 | ||
295 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191215 ORDER BY f.position ASC |
0.350 ms | 1 | Yes | /classes/Product.php:5993 | |
319 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191218 ORDER BY f.position ASC |
0.349 ms | 1 | Yes | /classes/Product.php:5993 | |
335 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191220 ORDER BY f.position ASC |
0.349 ms | 1 | Yes | /classes/Product.php:5993 | |
343 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191221 ORDER BY f.position ASC |
0.347 ms | 1 | Yes | /classes/Product.php:5993 | |
160 | SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps21_currency` c LEFT JOIN ps21_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1 |
0.346 ms | 1 | /classes/Currency.php:1136 | ||
381 | 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` = 191205 ORDER BY `position` |
0.341 ms | 1 | Yes | /classes/Product.php:3545 | |
123 | SELECT SQL_NO_CACHE c.`passwd` FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.334 ms | 1 | /classes/Customer.php:475 | ||
239 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191208 ORDER BY f.position ASC |
0.331 ms | 1 | Yes | /classes/Product.php:5993 | |
6 | SELECT SQL_NO_CACHE * FROM `ps21_country` a LEFT JOIN `ps21_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps21_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1 |
0.329 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
327 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 191219 ORDER BY f.position ASC |
0.329 ms | 1 | Yes | /classes/Product.php:5993 | |
408 | 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` = 191214 ORDER BY `position` |
0.323 ms | 1 | Yes | /classes/Product.php:3545 | |
125 | SELECT SQL_NO_CACHE * FROM `ps21_group` a LEFT JOIN `ps21_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.322 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
346 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 191222) |
0.321 ms | 1 | /classes/Product.php:3857 | ||
250 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 191210) |
0.318 ms | 1 | /classes/Product.php:3857 | ||
352 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 191223 AND image_shop.`cover` = 1 LIMIT 1 |
0.318 ms | 2 |