Cuiseurs de riz
Il y a 10 produits.
39,72 €
41,36 €
Il y a 10 produits.
Load Time | 861 ms |
Querying Time | 183 ms |
Queries | 356 |
Memory Peak Usage | 25.1 Mb |
Included Files | 1260 files - 11.87 Mb |
PrestaShop Cache | - Mb |
Global vars | 0.19 Mb |
PrestaShop Version | 8.1.2 |
PHP Version | 8.1.25 |
MySQL Version | 10.6.16-MariaDB |
Memory Limit | 2048M |
Max Execution Time | 3600s |
Smarty Cache | disabled |
Smarty Compilation | force compile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 5.613 ms | 5.613 ms | 8.53 Mb | 9.2 Mb |
__construct | 8.967 ms | 14.580 ms | 1.73 Mb | 11.9 Mb |
config | 26.506 ms | 41.086 ms | 1.21 Mb | 11.9 Mb |
__construct | 0.020 ms | 41.106 ms | - Mb | 11.9 Mb |
init | 30.792 ms | 71.898 ms | 2.11 Mb | 14.8 Mb |
checkAccess | 0.001 ms | 71.899 ms | - Mb | 14.8 Mb |
setMedia | 2.751 ms | 74.650 ms | 0.26 Mb | 14.8 Mb |
postProcess | 0.001 ms | 74.651 ms | - Mb | 14.8 Mb |
initHeader | 0.001 ms | 74.652 ms | - Mb | 14.8 Mb |
initContent | 341.151 ms | 415.803 ms | 5.22 Mb | 19.1 Mb |
initFooter | 0.003 ms | 415.806 ms | - Mb | 19.1 Mb |
display | 444.938 ms | 861 ms | 5.40 Mb | 25.1 Mb |
Hook | Time | Memory Usage |
---|---|---|
displayProductListReviews | 66.190 ms | 1.29 Mb |
DisplayHeader | 60.391 ms | 0.88 Mb |
ActionOutputHTMLBefore | 49.137 ms | 0.14 Mb |
ActionDispatcherBefore | 38.097 ms | 3.09 Mb |
displayLeftColumn | 35.008 ms | 0.74 Mb |
DisplayBeforeBodyClosingTag | 24.659 ms | 0.21 Mb |
displayTop | 17.637 ms | 0.20 Mb |
DisplayFooter | 11.645 ms | 0.11 Mb |
DisplayFooterRight | 11.524 ms | 0.24 Mb |
ActionDispatcher | 10.135 ms | 0.70 Mb |
DisplayNavFullWidth | 6.160 ms | 0.07 Mb |
DisplayLeftColumn | 5.340 ms | 0.04 Mb |
DisplayOutsideMainPage | 4.481 ms | 0.13 Mb |
displayFooterRight | 3.701 ms | 0.07 Mb |
displayFooterLeft | 2.603 ms | 0.06 Mb |
DisplayBanner | 2.386 ms | 0.06 Mb |
DisplayNav1 | 1.545 ms | 0.03 Mb |
DisplayFooterLeft | 1.476 ms | 0.03 Mb |
DisplayFooterAfter | 1.411 ms | 0.03 Mb |
ActionFrontControllerSetVariables | 1.171 ms | 0.06 Mb |
displayNav2 | 1.083 ms | 0.08 Mb |
DisplaySidebarNavigation | 0.697 ms | - Mb |
ActionFrontControllerSetMedia | 0.695 ms | 0.01 Mb |
ProductSearchProvider | 0.412 ms | - Mb |
ActionObjectAddAfter | 0.042 ms | - Mb |
ModuleRoutes | 0.019 ms | 0.02 Mb |
ActionFrontControllerInitAfter | 0.014 ms | - Mb |
DisplayAfterBodyOpeningTag | 0.009 ms | - Mb |
DisplayFooterBefore | 0.008 ms | - Mb |
29 hook(s) | 357.677 ms | 8.28 Mb |
Module | Time | Memory Usage |
---|---|---|
prestaadvanceloyaltyprogram | 5.004 ms | 0.54 Mb |
jprestaspeedpack | 98.532 ms | 3.99 Mb |
blockreassurance | 1.249 ms | 0.09 Mb |
blockwishlist | 11.963 ms | 0.13 Mb |
ps_emailsubscription | 3.905 ms | 0.10 Mb |
ps_socialfollow | 2.735 ms | 0.08 Mb |
ps_emailalerts | 0.214 ms | 0.09 Mb |
zonethememanager | 33.867 ms | 1.67 Mb |
ps_shoppingcart | 12.310 ms | 0.11 Mb |
ps_searchbar | 2.021 ms | 0.14 Mb |
productcomments | 66.392 ms | 1.32 Mb |
ps_googleanalytics | 11.091 ms | 0.05 Mb |
zonecolorsfonts | 56.878 ms | 0.87 Mb |
zonemegamenu | 8.751 ms | 0.12 Mb |
prestastripe | 3.460 ms | 0.02 Mb |
ps_facetedsearch | 2.176 ms | 0.10 Mb |
ps_languageselector | 0.832 ms | 0.06 Mb |
ps_currencyselector | 0.590 ms | 0.06 Mb |
ps_customersignin | 3.854 ms | 0.08 Mb |
ps_categorytree | 35.180 ms | 0.75 Mb |
zonecolumnblocks | 4.467 ms | 0.13 Mb |
zonepopupnewsletter | 1.832 ms | 0.05 Mb |
statsdata | 13.858 ms | 0.21 Mb |
23 module(s) | 381.162 ms | 10.77 Mb |
# | Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|---|
354 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (825,803264849),(825,2906032508),(825,1065867023),(825,1289214159),(825,1785617407),(825,2936477779),(825,1727466530),(825,1432532875),(825,1025009294),(825,1804081323),(825,3479716883),(825,66301815),(825,537553573),(825,3045727500),(825,3231073010),(825,1825096520),(825,3225262556),(825,2645763144),(825,2027619899),(825,786864081),(825,1849360992),(825,294428854),(825,3774376179),(825,2880678980),(825,114155291),(825,2929321318),(825,2087307803),(825,2369020978),(825,1152186767),(825,4222788516),(825,2858566420),(825,848840972),(825,4147554351),(825,770698498),(825,2244011448),(825,477004582),(825,3610318732),(825,1070190107),(825,937307692),(825,25761885),(825,3366890060),(825,3483396593),(825,392306519),(825,909258745),(825,179865882),(825,3099645137),(825,3371246540),(825,2390640699),(825,501027234),(825,3032495894),(825,2100541971),(825,2793494280),(825,180908336),(825,1192985740),(825,1972034646),(825,2419117650),(825,3803768817),(825,4265874642),(825,67723771),(825,3423129237),(825,3399895114),(825,3221089548),(825,2990154896),(825,2728213885),(825,933991437),(825,2513627470),(825,468067826),(825,4137721533),(825,1552016987),(825,4080301755),(825,4245349388),(825,1973472416),(825,1839057912),(825,3745041382),(825,3035734567),(825,3719469943),(825,3466131047),(825,679558129),(825,462819688),(825,4267553191),(825,518809702),(825,3303811122),(825,2883778317),(825,1694893476),(825,3287268691),(825,3711637102),(825,698879415),(825,885817714),(825,125306139),(825,1634619674),(825,58280175),(825,3363778289),(825,1161663254),(825,201135304),(825,288600709),(825,1021330335),(825,2858809635),(825,2763627026),(825,3717400459),(825,4125370705),(825,3997906175),(825,4162316513),(825,3219397995),(825,2539165674),(825,1046234598),(825,787652129),(825,1595426297),(825,4184932827),(825,1985552396),(825,1944795689),(825,3799916950),(825,1827123668),(825,1447744642),(825,1636796806),(825,2645405926),(825,1474595477),(825,3375525138),(825,3902077767),(825,3507415422),(825,2781072282),(825,2002273313),(825,3164880625),(825,2490789905),(825,1000843653),(825,48947005),(825,3883347157),(825,3700474777),(825,4264269047),(825,2125390191),(825,4270481046),(825,1693150473),(825,343450730),(825,381351735),(825,2863449446),(825,3772294966),(825,3877457961),(825,1492116830),(825,4041511410),(825,828132466),(825,4090211224),(825,2185737194),(825,3517149926),(825,647687838),(825,733479784),(825,1440916471),(825,3262261204),(825,1872100372),(825,2092461357),(825,3357609169),(825,2365529006),(825,1263061406),(825,2296732656),(825,534196217),(825,482025419),(825,2811467352),(825,2488480532),(825,3501473861),(825,1917272649),(825,1878317490),(825,1789511633),(825,956713705),(825,89981727),(825,1143557322),(825,2749361789),(825,3857194488),(825,1024086260),(825,26040876),(825,1804243295),(825,2165251395),(825,1281618245),(825,2793993627),(825,426054238),(825,3398682121),(825,1025101115),(825,2974984653),(825,2214325187),(825,997821910),(825,2005463392),(825,3252396061),(825,942332382),(825,3816934055),(825,1661692647),(825,975758589),(825,3974931321),(825,2301364099),(825,855746680),(825,637832447),(825,3938675492),(825,508940865),(825,911480697),(825,1283363269),(825,3552869238),(825,2961923901),(825,3747234531),(825,3155646160),(825,3164668199),(825,2271068282),(825,84354396),(825,2915068863),(825,4064530110),(825,3216991891),(825,2045363644),(825,2664176477),(825,1076722390),(825,505410826),(825,3544422162),(825,2506779464),(825,2552384108),(825,876907216),(825,82980331),(825,3890150098),(825,3475437886),(825,2302280848),(825,1133144647),(825,801167173),(825,2059315716),(825,3139619822),(825,2937007520),(825,1589371182),(825,693370988),(825,2708427394),(825,1007456900),(825,610735313),(825,3846627131),(825,2031830639),(825,1908602231),(825,1401333655),(825,378101424),(825,996218346),(825,660881695),(825,2938384267),(825,4250264855),(825,1895305721),(825,502965417),(825,1982471117),(825,2524144246),(825,2774996218),(825,1068709096),(825,4077513867),(825,2900588200),(825,465472731),(825,4139839450),(825,2360011682),(825,4211248848),(825,283341417),(825,4165214622),(825,3508523596),(825,234404923),(825,2782693783),(825,3413880379),(825,3540168379),(825,861653603),(825,3160995915),(825,1391251310),(825,2106651858),(825,3572623339),(825,4629984),(825,2488722736),(825,3486510944),(825,2675016634),(825,2165907305),(825,136687257),(825,3540179561),(825,2792526429),(825,2220600372),(825,2914585448),(825,3882733113),(825,1688090355),(825,3534950496),(825,1182870252),(825,412601709),(825,574969182),(825,2970413814),(825,1487282505),(825,3228977345),(825,2023459642),(825,3291711134),(825,2792891444),(825,3335276918),(825,502111155),(825,1347492703),(825,2832080533),(825,1215320197),(825,2317239205),(825,1931846913),(825,1721014625),(825,738600257),(825,2998338424),(825,1207945902),(825,734241479),(825,3324570843),(825,4126771257),(825,1712456575),(825,3169253733),(825,1160958045),(825,1130949510),(825,3116084871),(825,269178051),(825,24773614),(825,3204450510),(825,3468662336),(825,1808444077),(825,4095410992),(825,1012520131),(825,2367920745),(825,2603361072),(825,2741539031),(825,607507456),(825,616165826),(825,2288576869),(825,4252798532),(825,2692385638),(825,4100315394),(825,3061254709),(825,1657292258),(825,2148967437),(825,1248236410),(825,2457219175),(825,1920985790),(825,1340703149),(825,1618471777),(825,4160689201),(825,1822364967),(825,479188821),(825,1661785323),(825,4137484009),(825,2636427258),(825,1499247737),(825,2061922205),(825,665830591),(825,916194615),(825,495595719),(825,3026469794),(825,1845449656),(825,4078122428),(825,2044505385),(825,3156749269),(825,3919036276),(825,204613135),(825,605377709),(825,766051911),(825,30400764),(825,4211022030),(825,715827285),(825,1092948871),(825,610201349),(825,1023110113),(825,3379323545),(825,2591028766),(825,1994095466),(825,33157726),(825,198243957),(825,94201498),(825,2540831776),(825,1707019604),(825,2730046909),(825,4101073252),(825,207761914),(825,2750534087),(825,980926717),(825,377071036),(825,2983490672),(825,584353846),(825,1743688562),(825,3223058413),(825,1665991311),(825,3093731065),(825,1095877807),(825,1085889875),(825,2059985562),(825,3618062925),(825,592374860),(825,4217863027),(825,3425247989),(825,1636391408),(825,1698766782),(825,2162739858),(825,1538367880),(825,3760626336),(825,1987713032),(825,2338874856),(825,4206689645),(825,1723372602),(825,2788329276),(825,2095305502),(825,3135330775),(825,2402748468),(825,24058172),(825,4000683245),(825,315670382),(825,2558276906),(825,1745365471),(825,2782569384),(825,3422117706),(825,552626444),(825,1506232339),(825,2933163456),(825,1483801350),(825,1400586123),(825,3746875726),(825,2604810181),(825,2905930158),(825,803588046),(825,1651400661),(825,1431243585),(825,1586185269),(825,4110009762),(825,3647374073),(825,4196158832),(825,644435096),(825,1862966990),(825,2098775956),(825,4045847707),(825,3122054119),(825,1971194991),(825,2149367276),(825,1888540635),(825,2660577125),(825,2508340497),(825,196341346),(825,1790101800),(825,1054130805),(825,2741947598),(825,1292400575),(825,545037028),(825,1516477184),(825,2706799993),(825,562470873),(825,2591346466),(825,613023703),(825,2725609989),(825,2082081559),(825,572560232),(825,2833489058),(825,1999611979),(825,1938789650),(825,2958717166),(825,1035708154),(825,2025067287),(825,3804047398),(825,248028803),(825,4243412966),(825,628124381),(825,1271215494),(825,2140466223),(825,1298495884),(825,3585931255),(825,532975694),(825,892763084),(825,203145038),(825,470924714),(825,1460516495),(825,2732318442),(825,3996868778),(825,862206445),(825,3193479021),(825,3382171736),(825,3362897893),(825,3598913121),(825,1342337107),(825,3202829344),(825,1335223071),(825,270790954),(825,1086966479),(825,484642328),(825,4274468042),(825,1740107684),(825,2117688527),(825,1393082718),(825,366510022),(825,341328174),(825,1469264429),(825,968691010),(825,3210232788),(825,809700252),(825,3705477223),(825,1639200307),(825,3585776886),(825,3305319229),(825,1052899681),(825,2176267881),(825,357387863),(825,451177334),(825,677589039),(825,1181390953),(825,898241702),(825,3480303789),(825,1736215096),(825,2511740146),(825,2560762429),(825,1570623991),(825,897080848),(825,891021207),(825,2807843172),(825,411231410),(825,2413680770),(825,519468981),(825,1898829954),(825,4274422817),(825,2781196321),(825,433695516),(825,1652336127),(825,4200438598),(825,3032893805),(825,1435170492),(825,341146430),(825,755973553),(825,2183774725),(825,3967614532),(825,1589097164),(825,2441764320),(825,745126750),(825,348450311),(825,2084175962),(825,3357611772),(825,1654631620),(825,3098454302),(825,2029227635),(825,1731761366),(825,2444253995),(825,872274856),(825,4282856364),(825,3328013593),(825,4184469063),(825,1074477927),(825,475878802),(825,1341972790),(825,2770374005),(825,4237489391),(825,2818813526),(825,3131100007),(825,4267621199),(825,1031922959),(825,1616292706),(825,630426110),(825,1846388513),(825,2239793094),(825,1660370824),(825,3321716633),(825,2551727033),(825,1836172154),(825,1870881122),(825,3324207484),(825,1459310880),(825,1395112921),(825,893552556),(825,1795813847),(825,2544364435),(825,4188602229),(825,1437064809),(825,922605498),(825,4180843510),(825,2554784265),(825,3798404205),(825,1216801552),(825,225525148),(825,274058040),(825,3206796234),(825,610255635),(825,3139895407),(825,3993594441),(825,2078652070),(825,3340749058),(825,2282248923),(825,3201099700),(825,3944887276),(825,887478137),(825,620965629),(825,53639561),(825,687854272),(825,4204526813),(825,3434636086),(825,3859247582),(825,2160451939),(825,419013317),(825,488655959),(825,2224381764),(825,857621694),(825,593880699),(825,1743569168),(825,747100668),(825,2627272664),(825,1477316791),(825,852002855),(825,3813191394),(825,3206482767),(825,2935275735),(825,825997452),(825,4128572079),(825,4149399208),(825,2432005645),(825,945310979),(825,206553734),(825,3381625344),(825,2613891474),(825,1285565060),(825,725086502),(825,2181279565),(825,2136294074),(825,531227063),(825,3291030245),(825,3423892574),(825,1818418110),(825,1175554195),(825,231365613),(825,3071984169),(825,1510809703),(825,2304894647),(825,724387218),(825,3702122266),(825,3105745802),(825,3598888791),(825,40599425),(825,4256434691),(825,1198380170),(825,3549401556),(825,2300237909),(825,484124464),(825,3042798728),(825,767973032),(825,4146324303),(825,1493350341),(825,2166736334),(825,3061340275),(825,1468811388),(825,714571165),(825,1958965990),(825,2146366302),(825,2212338847),(825,2088651590),(825,2684538463),(825,2292708505),(825,571001464),(825,608126571),(825,2736309071),(825,1479333754),(825,1794660366),(825,2319975337),(825,1093438481),(825,2975864804),(825,2504416172),(825,3531750290),(825,219666672),(825,4219072870),(825,1053258155),(825,2382983142),(825,1006288562),(825,1770263986),(825,3089735283),(825,3689334927),(825,2901629603),(825,2019277020),(825,2853333944),(825,1110695191),(825,3884283185),(825,4268093708),(825,159799075),(825,1715997742),(825,1009155269),(825,3922001006),(825,3916338789),(825,1085252167),(825,207705430),(825,1190601026),(825,1441004396),(825,1567147586),(825,964098054),(825,1385174189),(825,3607427007),(825,4065177061),(825,1552830538),(825,3778287701),(825,3986294473),(825,4127238085),(825,1865170325),(825,2161789419),(825,2889615117),(825,785261358),(825,3873733217),(825,2600209543),(825,3958092558),(825,4143434528),(825,3225228598),(825,3451063310),(825,810085901),(825,1502204888),(825,2931931582),(825,1339720903),(825,4093703382),(825,1016897830),(825,1186809094),(825,2269117600),(825,813555736),(825,733475850),(825,305814753),(825,2720553993),(825,212227262),(825,1328958432),(825,3903742053),(825,2617942920),(825,4254367326),(825,2895836413),(825,1090341105),(825,3174277595),(825,639084285),(825,4064195579),(825,2134315289),(825,608843276),(825,4190247440),(825,1090444753),(825,2554275840),(825,2758076506),(825,2518001916),(825,3620157415),(825,1195920681),(825,1822840633),(825,1087551238),(825,235508323),(825,1139244570),(825,810960133),(825,425550269),(825,1767940144),(825,1488780247),(825,1250541405),(825,1715845038),(825,3777612587),(825,2285237154),(825,802817926),(825,4280998710),(825,1108258121),(825,1107026853),(825,2913745362),(825,1129101120),(825,2454813183),(825,1690919006),(825,23973636),(825,293370743),(825,1041759778),(825,3142497267),(825,2920365983),(825,2300359472),(825,885232682),(825,1995817456),(825,3443377157),(825,863919144),(825,1324348692),(825,4019216150),(825,443752815),(825,4223293),(825,1182491637),(825,4257294915),(825,3629776934),(825,582958316),(825,3061655453),(825,1665355533),(825,1929899841),(825,1033949851),(825,2010879266),(825,1872304779),(825,1282102725),(825,3589651214),(825,4095654001),(825,2447713556),(825,2543494532),(825,2069898435),(825,3286503857),(825,2662939963),(825,93111834),(825,3160936308),(825,261262800),(825,141197408),(825,1904512268),(825,3001025754),(825,2247670246),(825,535154833),(825,3476002757),(825,3806439314),(825,1819793014),(825,3545273473),(825,3957652542),(825,3018295592),(825,1367893712),(825,1034338066),(825,3229510223),(825,4276953245),(825,3363858574),(825,2870596766),(825,648526699),(825,3627085975),(825,1585047995),(825,1960922033),(825,748737253),(825,1175066615),(825,1318322018),(825,260367662),(825,643741484),(825,1013706048),(825,1726352130),(825,2222354404),(825,1327031463),(825,1131865044),(825,839200087),(825,1407668396),(825,3548333318),(825,237845721),(825,3056051791),(825,747235328),(825,172675174),(825,2781705803),(825,2111348799),(825,3067187587),(825,618638032),(825,3369756381),(825,2232055662),(825,55113216),(825,3939915090),(825,2586983921),(825,3286008345),(825,1956055310),(825,740042513),(825,2282536358),(825,1863122946),(825,1296880981),(825,2589434346),(825,1621393368),(825,39250009),(825,72263924),(825,1587391050),(825,847186998),(825,2455499024),(825,859347884),(825,2244795234),(825,64890532),(825,4153143031),(825,450539699),(825,151924088),(825,166332895),(825,2657838522),(825,4082352853),(825,3756588990),(825,2628415398),(825,3162212500),(825,607113485),(825,3924888977),(825,1697117306),(825,3406763364),(825,1129505049) ON DUPLICATE KEY UPDATE id=id |
17.874 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
314 | 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 |
16.793 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
342 | 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') |
7.540 ms | 1 | /classes/ObjectModel.php:622 | ||
168 | SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=841 AND c.nright<=842 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.992 ms | 53612623936 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
169 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=841 AND c.nright<=842 GROUP BY p.id_product) p |
3.760 ms | 53612623936 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
355 | 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 |
3.707 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
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.590 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.480 ms | 0 | /classes/Hook.php:1292 | ||
15 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps21_module` m INNER JOIN ps21_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps21_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps21_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps21_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
2.306 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
173 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-11-30 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (3851,81151,146438,146439,300103,335416,357966,358204,371498,373779) |
2.161 ms | 10 | /classes/ProductAssembler.php:95 | ||
52 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
2.065 ms | 386 | /classes/Hook.php:456 | ||
172 | REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("4fa774b9be3efb32a143010c1c6c77e0", "a:1:{s:7:\"filters\";a:0:{}}") |
1.969 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:211 | ||
119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.868 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
163 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 841) AND (a0.`nright` > 842) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.749 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
351 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 3473972358, 'https://cadeaufou.com/424-cuiseurs-de-riz', 1, 2, 1, 424, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.608 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
346 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('897790', '1801', '752115218', '', '1', '1', '2023-11-30 12:36:39') |
1.574 ms | 1 | /classes/ObjectModel.php:622 | ||
347 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('895501', '', 'cadeaufou.com/424-cuiseurs-de-riz', '', '2023-11-30 12:36:39') |
1.233 ms | 1 | /classes/ObjectModel.php:622 | ||
316 | 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 (3851) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1.123 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
319 | 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 (81151) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1.078 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
315 | SELECT SQL_NO_CACHE * FROM `ps21_zcolumnblock` b LEFT JOIN `ps21_zcolumnblock_lang` bl ON b.`id_zcolumnblock` = bl.`id_zcolumnblock` WHERE b.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY b.`id_zcolumnblock` ORDER BY b.`position` ASC |
1.076 ms | 16 | Yes | Yes | /modules/zonecolumnblocks/classes/ZColumnBlock.php:116 |
14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
1.043 ms | 880 | /classes/Hook.php:1332 | ||
323 | 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 (335416) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1.021 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
275 | 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` = 146439) AND (b.`id_shop` = 1) LIMIT 1 |
0.902 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
350 | 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.888 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
272 | 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` = 146438) AND (b.`id_shop` = 1) LIMIT 1 |
0.834 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
320 | 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 (146438) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.821 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
269 | 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` = 81151) AND (b.`id_shop` = 1) LIMIT 1 |
0.819 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
237 | 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` = 357966 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` = 357966 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.812 ms | 0 | /classes/Cart.php:1410 | ||
17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.805 ms | 880 | /classes/Hook.php:1292 | ||
279 | 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` = 300103 ORDER BY `position` |
0.799 ms | 7 | Yes | /classes/Product.php:3545 | |
184 | 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` = 3851 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` = 3851 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.798 ms | 0 | /classes/Cart.php:1410 | ||
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` = 424 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.794 ms | 1 | Yes | Yes | /classes/Category.php:921 |
290 | 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` = 371498) AND (b.`id_shop` = 1) LIMIT 1 |
0.794 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
284 | 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` = 357966) AND (b.`id_shop` = 1) LIMIT 1 |
0.792 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
293 | 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` = 373779) AND (b.`id_shop` = 1) LIMIT 1 |
0.791 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
202 | 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` = 146438 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` = 146438 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.784 ms | 0 | /classes/Cart.php:1410 | ||
193 | 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` = 81151 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` = 81151 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.781 ms | 0 | /classes/Cart.php:1410 | ||
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` < 841) AND (a0.`nright` > 842) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.774 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
327 | 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 (373779) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.774 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
228 | 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` = 335416 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` = 335416 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.773 ms | 0 | /classes/Cart.php:1410 | ||
321 | 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 (146439) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.768 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
210 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 146439 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` = 146439 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.765 ms | 0 | /classes/Cart.php:1410 | ||
324 | 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 (357966) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.753 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
285 | 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` = 357966 ORDER BY `position` |
0.747 ms | 3 | Yes | /classes/Product.php:3545 | |
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` = 358204 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` = 358204 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.734 ms | 0 | /classes/Cart.php:1410 | ||
264 | 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` = 373779 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` = 373779 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.734 ms | 0 | /classes/Cart.php:1410 | ||
278 | 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` = 300103) AND (b.`id_shop` = 1) LIMIT 1 |
0.727 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
255 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 371498 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` = 371498 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.721 ms | 0 | /classes/Cart.php:1410 | ||
322 | 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 (300103) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.718 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
334 | SELECT SQL_NO_CACHE c.id_cms, l.meta_title FROM ps21_cms c JOIN ps21_cms_lang l ON (c.id_cms = l.id_cms) INNER JOIN ps21_cms_shop cms_shop ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1) WHERE l.id_lang = 1 AND c.`active` = 1 GROUP BY c.id_cms ORDER BY c.`position` |
0.713 ms | 25 | Yes | Yes | /classes/CMS.php:184 |
326 | 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 (371498) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.710 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
219 | 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` = 300103 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` = 300103 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.708 ms | 0 | /classes/Cart.php:1410 | ||
229 | 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 = 335416 ORDER BY f.position ASC |
0.708 ms | 1 | Yes | /classes/Product.php:5993 | |
325 | 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 (358204) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.707 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
273 | 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` = 146438 ORDER BY `position` |
0.705 ms | 5 | Yes | /classes/Product.php:3545 | |
287 | 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` = 358204) AND (b.`id_shop` = 1) LIMIT 1 |
0.694 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
281 | 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` = 335416) AND (b.`id_shop` = 1) LIMIT 1 |
0.692 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
309 | SELECT SQL_NO_CACHE * FROM `ps21_zmenu` m LEFT JOIN `ps21_zmenu_lang` ml ON m.`id_zmenu` = ml.`id_zmenu` WHERE m.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY m.`id_zmenu` ORDER BY m.`position` ASC |
0.684 ms | 7 | Yes | Yes | /modules/zonemegamenu/classes/ZMenu.php:104 |
266 | 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` = 3851) AND (b.`id_shop` = 1) LIMIT 1 |
0.681 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.669 ms | 81 | /classes/module/Module.php:345 | ||
276 | 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` = 146439 ORDER BY `position` |
0.664 ms | 3 | Yes | /classes/Product.php:3545 | |
185 | 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 = 3851 ORDER BY f.position ASC |
0.649 ms | 1 | Yes | /classes/Product.php:5993 | |
238 | 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 = 357966 ORDER BY f.position ASC |
0.644 ms | 1 | Yes | /classes/Product.php:5993 | |
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 = 358204 ORDER BY f.position ASC |
0.640 ms | 1 | Yes | /classes/Product.php:5993 | |
294 | 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` = 373779 ORDER BY `position` |
0.630 ms | 5 | Yes | /classes/Product.php:3545 | |
288 | 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` = 358204 ORDER BY `position` |
0.628 ms | 3 | Yes | /classes/Product.php:3545 | |
270 | 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` = 81151 ORDER BY `position` |
0.625 ms | 1 | Yes | /classes/Product.php:3545 | |
345 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 424 LIMIT 1 |
0.614 ms | 1 | /classes/Page.php:83 | ||
256 | SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 371498 ORDER BY f.position ASC |
0.607 ms | 1 | Yes | /classes/Product.php:5993 | |
203 | 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 = 146438 ORDER BY f.position ASC |
0.598 ms | 1 | Yes | /classes/Product.php:5993 | |
265 | 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 = 373779 ORDER BY f.position ASC |
0.598 ms | 1 | Yes | /classes/Product.php:5993 | |
291 | 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` = 371498 ORDER BY `position` |
0.588 ms | 1 | Yes | /classes/Product.php:3545 | |
1 | SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps21_shop_group gs LEFT JOIN ps21_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps21_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name |
0.577 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
267 | 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` = 3851 ORDER BY `position` |
0.573 ms | 1 | Yes | /classes/Product.php:3545 | |
194 | 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 = 81151 ORDER BY f.position ASC |
0.569 ms | 1 | Yes | /classes/Product.php:5993 | |
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.559 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
211 | 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 = 146439 ORDER BY f.position ASC |
0.537 ms | 1 | Yes | /classes/Product.php:5993 | |
282 | 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` = 335416 ORDER BY `position` |
0.519 ms | 1 | Yes | /classes/Product.php:3545 | |
220 | 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 = 300103 ORDER BY f.position ASC |
0.517 ms | 1 | Yes | /classes/Product.php:5993 | |
128 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 424) AND (b.`id_shop` = 1) LIMIT 1 |
0.504 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
165 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 424 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.504 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
174 | 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` = 3851 AND image_shop.`cover` = 1 LIMIT 1 |
0.482 ms | 1 | /classes/Product.php:3570 | ||
206 | 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` = 146439) |
0.479 ms | 1 | /classes/Product.php:3857 | ||
186 | 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` = 81151 AND image_shop.`cover` = 1 LIMIT 1 |
0.474 ms | 1 | /classes/Product.php:3570 | ||
343 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 897790 AND `date_add` > '2023-11-30 12:06:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.473 ms | 1 | Yes | /classes/Connection.php:168 | |
313 | 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.469 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
189 | 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` = 81151) |
0.469 ms | 1 | /classes/Product.php:3857 | ||
18 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.467 ms | 81 | /classes/module/Module.php:345 | ||
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.455 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
204 | 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` = 146439 AND image_shop.`cover` = 1 LIMIT 1 |
0.449 ms | 3 | /classes/Product.php:3570 | ||
178 | 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` = 3851) |
0.448 ms | 1 | /classes/Product.php:3857 | ||
251 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 371498) |
0.447 ms | 1 | /classes/Product.php:3857 | ||
198 | 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` = 146438) |
0.438 ms | 1 | /classes/Product.php:3857 | ||
195 | 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` = 146438 AND image_shop.`cover` = 1 LIMIT 1 |
0.436 ms | 5 | /classes/Product.php:3570 | ||
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` = 371498 AND image_shop.`cover` = 1 LIMIT 1 |
0.434 ms | 1 | /classes/Product.php:3570 | ||
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.433 ms | 1 | /classes/CartRule.php:418 | ||
56 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 2 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.429 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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.428 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
260 | 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` = 373779) |
0.427 ms | 1 | /classes/Product.php:3857 | ||
239 | 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` = 358204 AND image_shop.`cover` = 1 LIMIT 1 |
0.425 ms | 3 | /classes/Product.php:3570 | ||
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.419 ms | 1 | /classes/Language.php:1216 | ||
224 | 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` = 335416) |
0.419 ms | 1 | /classes/Product.php:3857 | ||
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.418 ms | 6 | /classes/CartRule.php:418 | ||
141 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-11-30 00:00:00" AND date_to <= "2023-11-30 23:59:59") OR (date_from >= "2023-11-30 00:00:00" AND date_from <= "2023-11-30 23:59:59") OR (date_from < "2023-11-30 00:00:00" AND date_to > "2023-11-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.417 ms | 5 | /classes/CartRule.php:357 | ||
212 | 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` = 300103 AND image_shop.`cover` = 1 LIMIT 1 |
0.407 ms | 7 | /classes/Product.php:3570 | ||
182 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.405 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 424 AND ctg.`id_group` = 1 LIMIT 1 |
0.404 ms | 1 | /classes/Category.php:1751 | ||
215 | 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` = 300103) |
0.394 ms | 1 | /classes/Product.php:3857 | ||
297 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a LEFT JOIN `ps21_zthememanager_lang` `b` ON a.`id_zthememanager` = b.`id_zthememanager` AND b.`id_lang` = 1 WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.386 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.384 ms | 81 | /classes/module/Module.php:345 | ||
171 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 424 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.382 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
230 | 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` = 357966 AND image_shop.`cover` = 1 LIMIT 1 |
0.382 ms | 3 | /classes/Product.php:3570 | ||
233 | 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` = 357966) |
0.380 ms | 1 | /classes/Product.php:3857 | ||
160 | SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps21_currency` c LEFT JOIN ps21_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1 |
0.380 ms | 1 | /classes/Currency.php:1136 | ||
335 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1 |
0.378 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
257 | SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 373779 AND image_shop.`cover` = 1 LIMIT 1 |
0.376 ms | 5 | /classes/Product.php:3570 | ||
221 | 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` = 335416 AND image_shop.`cover` = 1 LIMIT 1 |
0.373 ms | 1 | /classes/Product.php:3570 | ||
242 | 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` = 358204) |
0.373 ms | 1 | /classes/Product.php:3857 | ||
337 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1 |
0.372 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
166 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 424) LIMIT 1 |
0.369 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
310 | SELECT SQL_NO_CACHE d.`id_zmenu`, COUNT(d.`id_zdropdown`) as total FROM `ps21_zdropdown` d WHERE `active` = 1 GROUP BY d.`id_zmenu` |
0.361 ms | 8 | Yes | /modules/zonemegamenu/classes/ZMenu.php:232 | |
59 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 3 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.360 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
143 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-11-30 00:00:00" AND date_to <= "2023-11-30 23:59:59") OR (date_from >= "2023-11-30 00:00:00" AND date_from <= "2023-11-30 23:59:59") OR (date_from < "2023-11-30 00:00:00" AND date_to > "2023-11-30 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.352 ms | 5 | /classes/CartRule.php:357 | ||
336 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.337 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
338 | SELECT SQL_NO_CACHE * FROM `ps21_cms` a LEFT JOIN `ps21_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps21_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 5) AND (b.`id_shop` = 1) LIMIT 1 |
0.335 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.324 ms | 1 | /classes/Customer.php:503 | ||
40 | SELECT SQL_NO_CACHE * FROM `ps21_currency` a LEFT JOIN `ps21_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.312 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
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.310 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
183 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 3851) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.307 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
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.303 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
349 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.303 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
49 | SELECT SQL_NO_CACHE c.* FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.300 ms | 1 | /classes/Customer.php:503 | ||
65 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 5 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.300 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.296 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
5 | SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps21_lang` l LEFT JOIN `ps21_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.295 ms | 1 | /classes/Language.php:1080 | ||
296 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.291 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
286 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 357966 |
0.290 ms | 1 | /classes/Product.php:2902 | ||
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.286 ms | 1 | /classes/Customer.php:475 | ||
12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.281 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.280 ms | 88 | /classes/Hook.php:287 | ||
167 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 424 AND `id_shop` = 1 |
0.279 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
311 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.277 ms | 1 | /classes/module/Module.php:2636 | ||
161 | SELECT SQL_NO_CACHE id_zcolorsfonts FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.272 ms | 1 | /modules/zonecolorsfonts/classes/ZColorsFonts.php:118 | ||
48 | SELECT SQL_NO_CACHE c.`passwd` FROM `ps21_customer` c WHERE (c.`email` = 'd1-f998aa5ae590639120d19c0a82f096ad@fakeemail.com') AND (c.`id_shop` IN (1)) AND (c.`is_guest` = 0) AND (c.`deleted` = 0) LIMIT 1 |
0.270 ms | 1 | /classes/Customer.php:475 | ||
120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.269 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
271 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 81151 |
0.268 ms | 1 | /classes/Product.php:2902 | ||
62 | SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 4 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.266 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-11-30 12:36:00' AND date_from <= '2023-11-30 14:36:00') OR (date_to >= '2023-11-30 12:36:00' AND date_to <= '2023-11-30 14:36:00'); |
0.259 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
133 | SELECT SQL_NO_CACHE * FROM `ps21_currency` a LEFT JOIN `ps21_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `ps21_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.259 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
344 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.258 ms | 1 | /classes/Page.php:104 | ||
295 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 373779 |
0.254 ms | 1 | /classes/Product.php:2902 | ||
292 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 371498 |
0.253 ms | 1 | /classes/Product.php:2902 | ||
280 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 300103 |
0.252 ms | 1 | /classes/Product.php:2902 | ||
283 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 335416 |
0.251 ms | 1 | /classes/Product.php:2902 | ||
339 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.251 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
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.250 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
4 | SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps21_shop s LEFT JOIN ps21_shop_url su ON (s.id_shop = su.id_shop) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 |
0.248 ms | 1 | /classes/shop/Shop.php:218 | ||
145 | SELECT SQL_NO_CACHE COUNT(*) FROM `ps21_orders` o LEFT JOIN `ps21_order_cart_rule` ocr ON (ocr.`id_order` = o.`id_order`) WHERE o.`id_customer` = 0 AND ocr.`deleted` = 0 AND ocr.`id_cart_rule` = 0 LIMIT 1 |
0.246 ms | 1 | /classes/order/Order.php:881 | ||
289 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 358204 |
0.245 ms | 1 | /classes/Product.php:2902 | ||
192 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 81151) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.244 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.243 ms | 10 | Yes | /classes/ImageType.php:109 | |
227 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 335416) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.242 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
164 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.241 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
305 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.240 ms | 1 | /classes/module/Module.php:2636 | ||
268 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 3851 |
0.240 ms | 1 | /classes/Product.php:2902 | ||
218 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 300103) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.238 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.235 ms | 1 | Yes | /classes/Currency.php:709 | |
41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.232 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
277 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 146439 |
0.232 ms | 1 | /classes/Product.php:2902 | ||
274 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 146438 |
0.231 ms | 1 | /classes/Product.php:2902 | ||
19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.230 ms | 88 | /classes/Hook.php:339 | ||
306 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.228 ms | 1 | /classes/module/Module.php:2109 | ||
155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.227 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
10 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "jprestaspeedpack" LIMIT 1 |
0.227 ms | 1 | /classes/module/Module.php:2636 | ||
216 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 300103 AND id_shop=1 LIMIT 1 |
0.226 ms | 1 | /classes/Product.php:6848 | ||
240 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 424 LIMIT 1 |
0.226 ms | 1 | /classes/Product.php:5639 | ||
328 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.224 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
50 | SELECT SQL_NO_CACHE trgs.`id_tax_rules_group` FROM `ps21_tax_rules_group_shop` as trgs LEFT JOIN `ps21_tax_rules_group` as trg ON trgs.id_tax_rules_group=trg.id_tax_rules_group WHERE active=1 AND id_shop=1 AND deleted=0 |
0.224 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
146 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_legalcompliance" LIMIT 1 |
0.222 ms | 0 | /classes/module/Module.php:2636 | ||
209 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 146439) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.222 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-11-30 12:36:00' OR date_to<'2023-11-30 12:36:00'; |
0.219 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
217 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 300103 AND `id_group` = 1 LIMIT 1 |
0.219 ms | 0 | /classes/GroupReduction.php:156 | ||
317 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.218 ms | 1 | /classes/module/Module.php:2636 | ||
3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.217 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
201 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 146438) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.217 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
261 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 373779 AND id_shop=1 LIMIT 1 |
0.217 ms | 1 | /classes/Product.php:6848 | ||
299 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.216 ms | 1 | /classes/module/Module.php:2636 | ||
241 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 358 AND `active` = 1 LIMIT 1 |
0.215 ms | 1 | /classes/Manufacturer.php:316 | ||
263 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 373779) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.214 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
213 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 424 LIMIT 1 |
0.213 ms | 1 | /classes/Product.php:5639 | ||
117 | SELECT SQL_NO_CACHE id FROM `ps21_jm_pagecache_contexts` WHERE `id_shop`=1 AND `id_lang`=1 AND `id_currency`=1 AND `id_fake_customer` IS NULL AND `id_device`=1 AND `id_country` IS NULL AND `id_tax_csz`=1 AND `id_specifics` IS NULL LIMIT 1 |
0.211 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
177 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 134 AND `active` = 1 LIMIT 1 |
0.211 ms | 1 | /classes/Manufacturer.php:316 | ||
236 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 357966) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.209 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
175 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps21_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 424 LIMIT 1 |
0.209 ms | 1 | /classes/Category.php:1375 | ||
245 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 358204) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.208 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
249 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 424 LIMIT 1 |
0.208 ms | 1 | /classes/Product.php:5639 | ||
258 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 424 LIMIT 1 |
0.208 ms | 1 | /classes/Product.php:5639 | ||
340 | SELECT SQL_NO_CACHE `save_time` FROM `ps21_zpopupnewsletter` WHERE `id_shop` = 1 AND `active` = 1 LIMIT 1 |
0.208 ms | 1 | /modules/zonepopupnewsletter/classes/ZPopupNewsletter.php:78 | ||
21 | SELECT SQL_NO_CACHE * FROM `ps21_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.207 ms | 1 | /classes/module/Module.php:2018 | ||
162 | SELECT SQL_NO_CACHE * FROM `ps21_zcolorsfonts` a WHERE (a.`id_zcolorsfonts` = 1) LIMIT 1 |
0.207 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
231 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 424 LIMIT 1 |
0.207 ms | 1 | /classes/Product.php:5639 | ||
234 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 357966 AND id_shop=1 LIMIT 1 |
0.207 ms | 1 | /classes/Product.php:6848 | ||
308 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.207 ms | 1 | /classes/module/Module.php:2109 | ||
348 | SELECT SQL_NO_CACHE data FROM `ps21_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.207 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43 | ||
197 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 80 AND `active` = 1 LIMIT 1 |
0.206 ms | 1 | /classes/Manufacturer.php:316 | ||
341 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.205 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
232 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 855 AND `active` = 1 LIMIT 1 |
0.203 ms | 1 | /classes/Manufacturer.php:316 | ||
170 | SELECT SQL_NO_CACHE data FROM ps21_layered_filter_block WHERE hash="4fa774b9be3efb32a143010c1c6c77e0" LIMIT 1 |
0.202 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:186 | ||
254 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 371498) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.202 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
329 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.201 ms | 1 | /classes/module/Module.php:2636 | ||
188 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 827 AND `active` = 1 LIMIT 1 |
0.199 ms | 1 | /classes/Manufacturer.php:316 | ||
225 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 335416 AND id_shop=1 LIMIT 1 |
0.199 ms | 1 | /classes/Product.php:6848 | ||
235 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 357966 AND `id_group` = 1 LIMIT 1 |
0.199 ms | 0 | /classes/GroupReduction.php:156 | ||
300 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.199 ms | 1 | /classes/module/Module.php:2109 |