Accueil
Il y a 7 produits.
| Load Time | 520.698 ms |
| Querying Time | 111 ms |
| Queries | 314 |
| Memory Peak Usage | 24.5 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.329 ms | 5.329 ms | 8.53 Mb | 9.2 Mb |
| __construct | 8.944 ms | 14.273 ms | 1.73 Mb | 11.9 Mb |
| config | 24.061 ms | 38.334 ms | 1.21 Mb | 11.9 Mb |
| __construct | 0.019 ms | 38.353 ms | - Mb | 11.9 Mb |
| init | 29.318 ms | 67.671 ms | 2.11 Mb | 14.8 Mb |
| checkAccess | 0.001 ms | 67.672 ms | - Mb | 14.8 Mb |
| setMedia | 2.481 ms | 70.153 ms | 0.26 Mb | 14.8 Mb |
| postProcess | 0.002 ms | 70.155 ms | - Mb | 14.8 Mb |
| initHeader | 0.001 ms | 70.156 ms | - Mb | 14.8 Mb |
| initContent | 125.255 ms | 195.411 ms | 4.75 Mb | 18.7 Mb |
| initFooter | 0.002 ms | 195.413 ms | - Mb | 18.7 Mb |
| display | 325.285 ms | 520.698 ms | 5.24 Mb | 24.5 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| ActionDispatcherBefore | 35.682 ms | 3.09 Mb |
| DisplayHeader | 35.469 ms | 0.88 Mb |
| ActionOutputHTMLBefore | 34.540 ms | 0.14 Mb |
| displayProductListReviews | 28.698 ms | 1.28 Mb |
| displayLeftColumn | 22.977 ms | 0.74 Mb |
| displayTop | 13.809 ms | 0.20 Mb |
| DisplayBeforeBodyClosingTag | 13.479 ms | 0.21 Mb |
| DisplayFooter | 10.661 ms | 0.11 Mb |
| DisplayFooterRight | 10.490 ms | 0.24 Mb |
| ActionDispatcher | 9.358 ms | 0.70 Mb |
| DisplayNavFullWidth | 6.778 ms | 0.07 Mb |
| DisplayLeftColumn | 4.159 ms | 0.04 Mb |
| DisplayOutsideMainPage | 4.115 ms | 0.06 Mb |
| displayFooterRight | 3.414 ms | 0.07 Mb |
| displayFooterLeft | 2.367 ms | 0.06 Mb |
| DisplayBanner | 2.013 ms | 0.06 Mb |
| DisplayFooterLeft | 1.385 ms | 0.03 Mb |
| ActionFrontControllerSetVariables | 1.284 ms | 0.06 Mb |
| DisplayNav1 | 1.239 ms | 0.03 Mb |
| DisplayFooterAfter | 1.219 ms | 0.03 Mb |
| displayNav2 | 0.741 ms | 0.08 Mb |
| ActionFrontControllerSetMedia | 0.728 ms | 0.01 Mb |
| DisplaySidebarNavigation | 0.603 ms | - Mb |
| ProductSearchProvider | 0.403 ms | - Mb |
| ActionObjectAddAfter | 0.032 ms | - Mb |
| ModuleRoutes | 0.020 ms | 0.02 Mb |
| ActionFrontControllerInitAfter | 0.012 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.009 ms | - Mb |
| DisplayFooterBefore | 0.008 ms | - Mb |
| 29 hook(s) | 245.692 ms | 8.21 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| prestaadvanceloyaltyprogram | 5.275 ms | 0.54 Mb |
| jprestaspeedpack | 80.785 ms | 3.99 Mb |
| blockreassurance | 0.930 ms | 0.09 Mb |
| blockwishlist | 10.993 ms | 0.13 Mb |
| ps_emailsubscription | 3.611 ms | 0.10 Mb |
| ps_socialfollow | 2.552 ms | 0.08 Mb |
| ps_emailalerts | 0.192 ms | 0.09 Mb |
| zonethememanager | 31.680 ms | 1.61 Mb |
| ps_shoppingcart | 9.580 ms | 0.11 Mb |
| ps_searchbar | 1.696 ms | 0.14 Mb |
| productcomments | 28.965 ms | 1.32 Mb |
| ps_googleanalytics | 6.914 ms | 0.05 Mb |
| zonecolorsfonts | 33.172 ms | 0.87 Mb |
| zonemegamenu | 8.307 ms | 0.12 Mb |
| prestastripe | 3.344 ms | 0.02 Mb |
| ps_facetedsearch | 1.890 ms | 0.10 Mb |
| ps_languageselector | 0.610 ms | 0.06 Mb |
| ps_currencyselector | 0.427 ms | 0.06 Mb |
| ps_customersignin | 3.071 ms | 0.08 Mb |
| ps_categorytree | 23.118 ms | 0.75 Mb |
| zonecolumnblocks | 3.488 ms | 0.13 Mb |
| zonepopupnewsletter | 1.603 ms | 0.05 Mb |
| statsdata | 6.880 ms | 0.21 Mb |
| 23 module(s) | 269.083 ms | 10.70 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 312 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (580,803264849),(580,1693150473),(580,2165251395),(580,1289214159),(580,1785617407),(580,2936477779),(580,1727466530),(580,1432532875),(580,1025009294),(580,1804081323),(580,3479716883),(580,66301815),(580,537553573),(580,3045727500),(580,3231073010),(580,1825096520),(580,3225262556),(580,2645763144),(580,2027619899),(580,786864081),(580,1849360992),(580,294428854),(580,3774376179),(580,2880678980),(580,114155291),(580,2929321318),(580,2087307803),(580,2369020978),(580,1152186767),(580,4222788516),(580,2858566420),(580,848840972),(580,4147554351),(580,770698498),(580,2244011448),(580,477004582),(580,3610318732),(580,1070190107),(580,937307692),(580,25761885),(580,3366890060),(580,3483396593),(580,392306519),(580,909258745),(580,179865882),(580,3099645137),(580,3371246540),(580,2390640699),(580,501027234),(580,3032495894),(580,2100541971),(580,2793494280),(580,180908336),(580,1192985740),(580,1972034646),(580,2419117650),(580,3803768817),(580,4265874642),(580,67723771),(580,3423129237),(580,3399895114),(580,3221089548),(580,2990154896),(580,2728213885),(580,933991437),(580,2513627470),(580,468067826),(580,4137721533),(580,1552016987),(580,4080301755),(580,4245349388),(580,1973472416),(580,1839057912),(580,3745041382),(580,3035734567),(580,3719469943),(580,3466131047),(580,679558129),(580,462819688),(580,4267553191),(580,518809702),(580,3303811122),(580,2883778317),(580,1694893476),(580,3287268691),(580,3711637102),(580,698879415),(580,885817714),(580,125306139),(580,1634619674),(580,58280175),(580,3363778289),(580,1161663254),(580,201135304),(580,288600709),(580,1021330335),(580,2858809635),(580,2763627026),(580,3717400459),(580,4125370705),(580,3997906175),(580,4162316513),(580,3219397995),(580,2539165674),(580,1046234598),(580,787652129),(580,1595426297),(580,4184932827),(580,1985552396),(580,1944795689),(580,3799916950),(580,1827123668),(580,1447744642),(580,1636796806),(580,2645405926),(580,1474595477),(580,3375525138),(580,3902077767),(580,3507415422),(580,2781072282),(580,2002273313),(580,3164880625),(580,2490789905),(580,1000843653),(580,48947005),(580,3883347157),(580,3700474777),(580,4264269047),(580,2125390191),(580,4270481046),(580,343450730),(580,381351735),(580,2863449446),(580,3772294966),(580,3877457961),(580,1492116830),(580,4041511410),(580,828132466),(580,4090211224),(580,2185737194),(580,3517149926),(580,647687838),(580,733479784),(580,1440916471),(580,3262261204),(580,1872100372),(580,2092461357),(580,3357609169),(580,2365529006),(580,1263061406),(580,2296732656),(580,534196217),(580,482025419),(580,2811467352),(580,2488480532),(580,3501473861),(580,1917272649),(580,1878317490),(580,1789511633),(580,956713705),(580,89981727),(580,1143557322),(580,2749361789),(580,3857194488),(580,1024086260),(580,26040876),(580,1804243295),(580,1281618245),(580,2793993627),(580,426054238),(580,3398682121),(580,1025101115),(580,2974984653),(580,2214325187),(580,997821910),(580,2005463392),(580,3252396061),(580,942332382),(580,3816934055),(580,1661692647),(580,975758589),(580,3974931321),(580,2301364099),(580,855746680),(580,637832447),(580,3938675492),(580,508940865),(580,911480697),(580,1283363269),(580,3552869238),(580,2961923901),(580,3747234531),(580,3155646160),(580,3164668199),(580,2271068282),(580,84354396),(580,2915068863),(580,4064530110),(580,3216991891),(580,2045363644),(580,2664176477),(580,1076722390),(580,505410826),(580,3544422162),(580,2506779464),(580,2552384108),(580,876907216),(580,82980331),(580,3890150098),(580,3475437886),(580,2302280848),(580,1133144647),(580,801167173),(580,2059315716),(580,3139619822),(580,2937007520),(580,1589371182),(580,693370988),(580,2708427394),(580,1007456900),(580,610735313),(580,3846627131),(580,2031830639),(580,1908602231),(580,1401333655),(580,378101424),(580,996218346),(580,660881695),(580,2938384267),(580,4250264855),(580,1895305721),(580,502965417),(580,1982471117),(580,2524144246),(580,2774996218),(580,1068709096),(580,4077513867),(580,2900588200),(580,465472731),(580,4139839450),(580,2360011682),(580,4211248848),(580,283341417),(580,4165214622),(580,3508523596),(580,234404923),(580,2782693783),(580,3413880379),(580,3540168379),(580,861653603),(580,3160995915),(580,1391251310),(580,2106651858),(580,3572623339),(580,4629984),(580,2488722736),(580,3486510944),(580,2675016634),(580,2165907305),(580,136687257),(580,3540179561),(580,2792526429),(580,2220600372),(580,2914585448),(580,3882733113),(580,1688090355),(580,3534950496),(580,1182870252),(580,412601709),(580,574969182),(580,2970413814),(580,1487282505),(580,3228977345),(580,2023459642),(580,3291711134),(580,2792891444),(580,3335276918),(580,502111155),(580,1347492703),(580,2832080533),(580,1215320197),(580,2317239205),(580,1931846913),(580,1721014625),(580,738600257),(580,2998338424),(580,1207945902),(580,734241479),(580,3324570843),(580,4126771257),(580,1712456575),(580,3169253733),(580,1160958045),(580,1130949510),(580,3116084871),(580,269178051),(580,24773614),(580,3204450510),(580,3468662336),(580,1808444077),(580,4095410992),(580,1012520131),(580,2367920745),(580,2603361072),(580,2741539031),(580,607507456),(580,616165826),(580,2288576869),(580,4252798532),(580,2692385638),(580,4100315394),(580,3061254709),(580,1657292258),(580,2148967437),(580,1248236410),(580,2457219175),(580,1920985790),(580,1340703149),(580,1618471777),(580,4160689201),(580,1822364967),(580,479188821),(580,1661785323),(580,4137484009),(580,2636427258),(580,1499247737),(580,2061922205),(580,665830591),(580,916194615),(580,495595719),(580,3026469794),(580,1845449656),(580,4078122428),(580,2044505385),(580,3156749269),(580,3919036276),(580,204613135),(580,605377709),(580,766051911),(580,30400764),(580,4211022030),(580,715827285),(580,1092948871),(580,610201349),(580,1023110113),(580,3379323545),(580,2591028766),(580,1994095466),(580,33157726),(580,198243957),(580,94201498),(580,2540831776),(580,1707019604),(580,2730046909),(580,4101073252),(580,207761914),(580,2750534087),(580,980926717),(580,377071036),(580,2983490672),(580,584353846),(580,1743688562),(580,3223058413),(580,1665991311),(580,3093731065),(580,1095877807),(580,1085889875),(580,2059985562),(580,3618062925),(580,592374860),(580,4217863027),(580,3425247989),(580,1636391408),(580,1698766782),(580,2162739858),(580,1538367880),(580,3760626336),(580,1987713032),(580,2338874856),(580,4206689645),(580,1723372602),(580,2788329276),(580,2095305502),(580,3135330775),(580,2402748468),(580,24058172),(580,4000683245),(580,315670382),(580,2558276906),(580,1745365471),(580,2782569384),(580,3422117706),(580,552626444),(580,1506232339),(580,2933163456),(580,1483801350),(580,1400586123),(580,3746875726),(580,2604810181),(580,2905930158),(580,803588046),(580,1651400661),(580,1431243585),(580,1586185269),(580,4110009762),(580,3647374073),(580,4196158832),(580,644435096),(580,1862966990),(580,2098775956),(580,4045847707),(580,3122054119),(580,1971194991),(580,2149367276),(580,1888540635),(580,2660577125),(580,2508340497),(580,196341346),(580,1790101800),(580,1054130805),(580,2741947598),(580,1292400575),(580,545037028),(580,1516477184),(580,2706799993),(580,562470873),(580,2591346466),(580,613023703),(580,2725609989),(580,2082081559),(580,572560232),(580,2833489058),(580,1999611979),(580,1938789650),(580,2958717166),(580,1035708154),(580,2025067287),(580,3804047398),(580,248028803),(580,4243412966),(580,628124381),(580,1271215494),(580,2140466223),(580,1298495884),(580,3585931255),(580,532975694),(580,892763084),(580,203145038),(580,470924714),(580,1460516495),(580,2732318442),(580,3996868778),(580,862206445),(580,3193479021),(580,3382171736),(580,3362897893),(580,3598913121),(580,1342337107),(580,3202829344),(580,1335223071),(580,270790954),(580,1086966479),(580,484642328),(580,4274468042),(580,1740107684),(580,2117688527),(580,1393082718),(580,366510022),(580,341328174),(580,1469264429),(580,968691010),(580,3210232788),(580,809700252),(580,3705477223),(580,1639200307),(580,3585776886),(580,3305319229),(580,1052899681),(580,2176267881),(580,357387863),(580,451177334),(580,677589039),(580,1181390953),(580,898241702),(580,3480303789),(580,1736215096),(580,2511740146),(580,2560762429),(580,1570623991),(580,897080848),(580,891021207),(580,2807843172),(580,411231410),(580,2413680770),(580,519468981),(580,1898829954),(580,4274422817),(580,2781196321),(580,433695516),(580,1652336127),(580,4200438598),(580,3032893805),(580,1435170492),(580,341146430),(580,755973553),(580,2183774725),(580,3967614532),(580,1589097164),(580,2441764320),(580,745126750),(580,348450311),(580,2084175962),(580,3357611772),(580,1654631620),(580,3098454302),(580,2029227635),(580,1731761366),(580,2444253995),(580,2906032508),(580,872274856),(580,4282856364),(580,3328013593),(580,4184469063),(580,1074477927),(580,475878802),(580,1341972790),(580,2770374005),(580,4237489391),(580,2818813526),(580,3131100007),(580,4267621199),(580,1031922959),(580,1616292706),(580,630426110),(580,1846388513),(580,2239793094),(580,1660370824),(580,3321716633),(580,2551727033),(580,1836172154),(580,1870881122),(580,3324207484),(580,1065867023),(580,1459310880),(580,1395112921),(580,893552556),(580,1795813847),(580,2544364435),(580,4188602229),(580,1437064809),(580,922605498),(580,4180843510),(580,2554784265),(580,3798404205),(580,1216801552),(580,225525148),(580,274058040),(580,3206796234),(580,610255635),(580,3139895407),(580,3993594441),(580,2078652070),(580,3340749058),(580,2282248923),(580,3201099700),(580,3944887276),(580,887478137),(580,620965629),(580,53639561),(580,687854272),(580,4204526813),(580,3434636086),(580,3859247582),(580,2160451939),(580,419013317),(580,488655959),(580,2224381764),(580,857621694),(580,593880699),(580,1743569168),(580,747100668),(580,2627272664),(580,1477316791),(580,852002855),(580,3813191394),(580,3206482767),(580,2935275735),(580,825997452),(580,4128572079),(580,4149399208),(580,2432005645),(580,945310979),(580,206553734),(580,3381625344),(580,2613891474),(580,1285565060),(580,725086502),(580,2181279565),(580,2136294074),(580,531227063),(580,3291030245),(580,3423892574),(580,1818418110),(580,1175554195),(580,231365613),(580,3071984169),(580,1510809703),(580,2304894647),(580,724387218),(580,3702122266),(580,3105745802),(580,3598888791),(580,40599425),(580,4256434691),(580,1198380170),(580,3549401556),(580,2300237909),(580,484124464),(580,3042798728),(580,767973032),(580,4146324303),(580,1493350341),(580,2166736334),(580,3061340275),(580,1468811388),(580,714571165),(580,1958965990),(580,2146366302),(580,2212338847),(580,2088651590),(580,2684538463),(580,2292708505),(580,571001464),(580,608126571),(580,2736309071),(580,1479333754),(580,1794660366),(580,2319975337),(580,1093438481),(580,2975864804),(580,2504416172),(580,3531750290),(580,219666672),(580,4219072870),(580,1053258155),(580,2382983142),(580,1006288562),(580,1770263986),(580,3089735283),(580,3689334927),(580,2901629603),(580,2019277020),(580,2853333944),(580,1110695191),(580,3884283185),(580,4268093708),(580,159799075),(580,1715997742),(580,1009155269),(580,3922001006),(580,3916338789),(580,1085252167),(580,207705430),(580,1190601026),(580,1441004396),(580,1567147586),(580,964098054),(580,1385174189),(580,3607427007),(580,4065177061),(580,1552830538),(580,3778287701),(580,3986294473),(580,4127238085),(580,1865170325),(580,2161789419),(580,2889615117),(580,785261358),(580,3873733217),(580,2600209543),(580,3958092558),(580,4143434528),(580,3225228598),(580,3451063310),(580,810085901),(580,1502204888),(580,2931931582),(580,1339720903),(580,4093703382),(580,1016897830),(580,1186809094),(580,2269117600),(580,813555736),(580,733475850),(580,305814753),(580,2720553993),(580,212227262),(580,1328958432),(580,3903742053),(580,2617942920),(580,4254367326),(580,2895836413),(580,1090341105),(580,3174277595),(580,639084285),(580,4064195579),(580,2134315289),(580,608843276),(580,4190247440),(580,1090444753),(580,2554275840),(580,2758076506),(580,2518001916),(580,3620157415),(580,1195920681),(580,1822840633),(580,1087551238),(580,235508323),(580,1139244570),(580,810960133),(580,425550269),(580,1767940144),(580,1488780247),(580,1250541405),(580,1715845038),(580,3777612587),(580,2285237154),(580,802817926),(580,4280998710),(580,1108258121),(580,1107026853),(580,2913745362),(580,1129101120),(580,2454813183),(580,1690919006),(580,23973636),(580,293370743),(580,1041759778),(580,3142497267),(580,2920365983),(580,2300359472),(580,885232682),(580,1995817456),(580,3443377157),(580,863919144),(580,1324348692),(580,4019216150),(580,443752815),(580,4223293),(580,1182491637),(580,4257294915),(580,3629776934),(580,582958316),(580,3061655453),(580,1665355533),(580,1929899841),(580,1033949851),(580,2010879266),(580,1872304779),(580,1282102725),(580,3589651214),(580,4095654001),(580,2447713556),(580,2543494532),(580,2069898435),(580,3286503857),(580,2662939963),(580,93111834),(580,3160936308),(580,261262800),(580,141197408),(580,1904512268),(580,3001025754),(580,2247670246),(580,535154833),(580,3476002757),(580,3806439314),(580,1819793014),(580,3545273473),(580,3957652542),(580,3018295592),(580,1367893712),(580,1034338066),(580,3229510223),(580,4276953245),(580,3363858574),(580,2870596766),(580,648526699),(580,3627085975),(580,1585047995),(580,1960922033),(580,748737253),(580,1175066615),(580,1318322018),(580,260367662),(580,643741484),(580,1013706048),(580,1726352130),(580,2222354404),(580,1327031463),(580,1131865044),(580,839200087),(580,1407668396),(580,3548333318),(580,237845721),(580,3056051791),(580,747235328),(580,172675174),(580,2781705803),(580,2111348799),(580,3067187587),(580,618638032),(580,3369756381),(580,2232055662),(580,55113216),(580,3939915090),(580,2586983921),(580,3286008345),(580,1956055310),(580,740042513),(580,2282536358),(580,1863122946),(580,1296880981),(580,2589434346),(580,1621393368),(580,39250009),(580,72263924),(580,1587391050),(580,847186998),(580,2455499024),(580,859347884),(580,2244795234),(580,64890532),(580,429344071),(580,4090286523),(580,4275791614),(580,485027865),(580,134264746),(580,2500464810),(580,4049930793),(580,3924888977),(580,1697117306),(580,3406763364),(580,1129505049) ON DUPLICATE KEY UPDATE id=id |
10.381 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 275 | SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps21_category` c INNER JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps21_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 1669 AND c.id_category IN ( SELECT id_category FROM `ps21_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC |
7.765 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
| 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>=89 AND c.nright<=90 GROUP BY p.id_product) p INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 24 |
3.238 ms | 13664674816 | Yes | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | |
| 2 | SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
3.119 ms | 1298 | /classes/Configuration.php:180 | ||
| 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>=89 AND c.nright<=90 GROUP BY p.id_product) p |
2.591 ms | 13664674816 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
| 51 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps21_hook_alias` ha INNER JOIN `ps21_hook` h ON ha.name = h.name |
2.278 ms | 0 | /classes/Hook.php:1292 | ||
| 15 | SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps21_module` m INNER JOIN ps21_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps21_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps21_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps21_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
1.981 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
| 300 | INSERT INTO `ps21_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0') |
1.892 ms | 1 | /classes/ObjectModel.php:622 | ||
| 52 | SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.789 ms | 386 | /classes/Hook.php:456 | ||
| 313 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache` WHERE ((id_controller=1 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=2 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=3 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=4 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=5 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=6 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=7 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=8 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR id_controller=9 OR (id_controller=10 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=11 AND last_gen < (NOW() - INTERVAL 691200 SECOND))) ORDER BY last_gen ASC LIMIT 2 |
1.677 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
| 309 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 1122478195, 'https://cadeaufou.com/860-parapluies', 1, 2, 1, 860, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.229 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 305 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('895362', '', 'cadeaufou.com/860-parapluies', '', '2023-11-30 12:28:54') |
1.210 ms | 1 | /classes/ObjectModel.php:622 | ||
| 119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.056 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 171 | 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 (179389,225894,261475,287709,342234,350136,373873) |
1.051 ms | 7 | /classes/ProductAssembler.php:95 | ||
| 304 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('897651', '7172', '752115218', '', '1', '1', '2023-11-30 12:28:54') |
0.978 ms | 1 | /classes/ObjectModel.php:622 | ||
| 14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.944 ms | 880 | /classes/Hook.php:1332 | ||
| 277 | 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 (179389) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.880 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
0.824 ms | 880 | /classes/Hook.php:1292 | ||
| 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` = 860 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.772 ms | 1 | Yes | Yes | /classes/Category.php:921 |
| 280 | 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 (225894) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.752 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 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` < 89) AND (a0.`nright` > 90) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.612 ms | 46 | /classes/PrestaShopCollection.php:383 | ||
| 276 | SELECT SQL_NO_CACHE * FROM `ps21_zcolumnblock` b LEFT JOIN `ps21_zcolumnblock_lang` bl ON b.`id_zcolumnblock` = bl.`id_zcolumnblock` WHERE b.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY b.`id_zcolumnblock` ORDER BY b.`position` ASC |
0.611 ms | 16 | Yes | Yes | /modules/zonecolumnblocks/classes/ZColumnBlock.php:116 |
| 285 | 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 (373873) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.580 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 239 | 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` = 225894) AND (b.`id_shop` = 1) LIMIT 1 |
0.578 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 18 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.576 ms | 81 | /classes/module/Module.php:345 | ||
| 183 | 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 = 179389 ORDER BY f.position ASC |
0.545 ms | 1 | Yes | /classes/Product.php:5993 | |
| 242 | 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` = 261475) AND (b.`id_shop` = 1) LIMIT 1 |
0.545 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 308 | 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.537 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
| 284 | 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 (350136) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.536 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 282 | 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 (287709) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.534 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 234 | 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` = 373873 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` = 373873 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.532 ms | 0 | /classes/Cart.php:1410 | ||
| 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.525 ms | 81 | /classes/module/Module.php:345 | ||
| 281 | 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 (261475) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.525 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 225 | 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` = 350136 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` = 350136 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.524 ms | 0 | /classes/Cart.php:1410 | ||
| 217 | 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` = 342234 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` = 342234 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.521 ms | 0 | /classes/Cart.php:1410 | ||
| 237 | 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` = 179389 ORDER BY `position` |
0.511 ms | 9 | 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.506 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
| 236 | 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` = 179389) AND (b.`id_shop` = 1) LIMIT 1 |
0.503 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 0 | SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps21_shop_url su LEFT JOIN ps21_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'cadeaufou.com' OR su.domain_ssl = 'cadeaufou.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.502 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
| 248 | 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` = 342234) AND (b.`id_shop` = 1) LIMIT 1 |
0.499 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 251 | 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` = 350136) AND (b.`id_shop` = 1) LIMIT 1 |
0.498 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 192 | 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` = 225894 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` = 225894 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.497 ms | 0 | /classes/Cart.php:1410 | ||
| 283 | 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 (342234) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.492 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 254 | 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` = 373873) AND (b.`id_shop` = 1) LIMIT 1 |
0.484 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 292 | 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.484 ms | 25 | Yes | Yes | /classes/CMS.php:184 |
| 252 | 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` = 350136 ORDER BY `position` |
0.481 ms | 1 | Yes | /classes/Product.php:3545 | |
| 200 | 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` = 261475 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` = 261475 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.480 ms | 0 | /classes/Cart.php:1410 | ||
| 182 | 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` = 179389 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` = 179389 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.475 ms | 0 | /classes/Cart.php:1410 | ||
| 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.474 ms | 41 | Yes | /classes/Dispatcher.php:654 | |
| 249 | 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` = 342234 ORDER BY `position` |
0.467 ms | 1 | Yes | /classes/Product.php:3545 | |
| 303 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 860 LIMIT 1 |
0.461 ms | 1 | /classes/Page.php:83 | ||
| 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.460 ms | 1 | /classes/CartRule.php:418 | ||
| 245 | 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` = 287709) AND (b.`id_shop` = 1) LIMIT 1 |
0.453 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 255 | 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` = 373873 ORDER BY `position` |
0.453 ms | 1 | Yes | /classes/Product.php:3545 | |
| 201 | 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 = 261475 ORDER BY f.position ASC |
0.444 ms | 1 | Yes | /classes/Product.php:5993 | |
| 210 | 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 = 287709 ORDER BY f.position ASC |
0.444 ms | 1 | Yes | /classes/Product.php:5993 | |
| 209 | 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` = 287709 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` = 287709 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.426 ms | 0 | /classes/Cart.php:1410 | ||
| 243 | 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` = 261475 ORDER BY `position` |
0.423 ms | 16 | Yes | /classes/Product.php:3545 | |
| 295 | 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.421 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 246 | 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` = 287709 ORDER BY `position` |
0.419 ms | 1 | Yes | /classes/Product.php:3545 | |
| 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.414 ms | 5 | /classes/CartRule.php:357 | ||
| 257 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.412 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 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.392 ms | 81 | /classes/module/Module.php:345 | ||
| 176 | 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` = 179389) |
0.387 ms | 1 | /classes/Product.php:3857 | ||
| 218 | 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 = 342234 ORDER BY f.position ASC |
0.386 ms | 1 | Yes | /classes/Product.php:5993 | |
| 270 | 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.386 ms | 7 | Yes | Yes | /modules/zonemegamenu/classes/ZMenu.php:104 |
| 240 | 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` = 225894 ORDER BY `position` |
0.384 ms | 7 | Yes | /classes/Product.php:3545 | |
| 226 | 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 = 350136 ORDER BY f.position ASC |
0.380 ms | 1 | Yes | /classes/Product.php:5993 | |
| 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.379 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 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.373 ms | 1 | /classes/Customer.php:475 | ||
| 294 | 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.365 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 235 | 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 = 373873 ORDER BY f.position ASC |
0.363 ms | 1 | Yes | /classes/Product.php:5993 | |
| 142 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1 |
0.361 ms | 6 | /classes/CartRule.php:418 | ||
| 301 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 897651 AND `date_add` > '2023-11-30 11:58:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.356 ms | 1 | Yes | /classes/Connection.php:168 | |
| 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.355 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 172 | 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` = 179389 AND image_shop.`cover` = 1 LIMIT 1 |
0.354 ms | 9 | /classes/Product.php:3570 | ||
| 193 | 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 = 225894 ORDER BY f.position ASC |
0.350 ms | 1 | Yes | /classes/Product.php:5993 | |
| 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` < 89) AND (a0.`nright` > 90) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.346 ms | 46 | /classes/PrestaShopCollection.php:383 | ||
| 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.339 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 184 | 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` = 225894 AND image_shop.`cover` = 1 LIMIT 1 |
0.331 ms | 7 | /classes/Product.php:3570 | ||
| 296 | 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.317 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-11-30 12:28:00' OR date_to<'2023-11-30 12:28:00'; |
0.309 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 165 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 860 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.304 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
| 188 | 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` = 225894) |
0.300 ms | 1 | /classes/Product.php:3857 | ||
| 230 | 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` = 373873) |
0.300 ms | 1 | /classes/Product.php:3857 | ||
| 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.299 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 213 | 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` = 342234) |
0.296 ms | 1 | /classes/Product.php:3857 | ||
| 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.293 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 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.290 ms | 1 | /classes/Currency.php:1136 | ||
| 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.283 ms | 1 | /classes/Language.php:1216 | ||
| 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.283 ms | 1 | /classes/Customer.php:503 | ||
| 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.280 ms | 1 | /classes/Language.php:1080 | ||
| 181 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 179389) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.277 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 272 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.276 ms | 1 | /classes/module/Module.php:2636 | ||
| 221 | 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` = 350136) |
0.272 ms | 1 | /classes/Product.php:3857 | ||
| 227 | 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` = 373873 AND image_shop.`cover` = 1 LIMIT 1 |
0.269 ms | 1 | /classes/Product.php:3570 | ||
| 194 | 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` = 261475 AND image_shop.`cover` = 1 LIMIT 1 |
0.269 ms | 16 | /classes/Product.php:3570 | ||
| 274 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.264 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 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.262 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 293 | 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.261 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 65 | SELECT SQL_NO_CACHE tr.*
FROM `ps21_tax_rule` tr
JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 5
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.260 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 307 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.258 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 289 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.257 ms | 1 | /classes/module/Module.php:2636 | ||
| 287 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.256 ms | 1 | /classes/module/Module.php:2636 | ||
| 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.255 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.255 ms | 1 | Yes | /classes/Currency.php:709 | |
| 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` = 860) AND (b.`id_shop` = 1) LIMIT 1 |
0.255 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 59 | SELECT SQL_NO_CACHE tr.*
FROM `ps21_tax_rule` tr
JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 3
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.254 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 196 | 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` = 261475) |
0.253 ms | 1 | /classes/Product.php:3857 | ||
| 148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.248 ms | 10 | Yes | /classes/ImageType.php:109 | |
| 271 | 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.246 ms | 8 | Yes | /modules/zonemegamenu/classes/ZMenu.php:232 | |
| 135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 860 AND ctg.`id_group` = 1 LIMIT 1 |
0.245 ms | 1 | /classes/Category.php:1751 | ||
| 205 | 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` = 287709) |
0.245 ms | 1 | /classes/Product.php:3857 | ||
| 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.245 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 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.244 ms | 5 | /classes/CartRule.php:357 | ||
| 258 | 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.243 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.242 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 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` = 860) LIMIT 1 |
0.240 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.235 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 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.235 ms | 1 | /classes/Customer.php:475 | ||
| 155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.235 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.232 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
| 16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.231 ms | 88 | /classes/Hook.php:287 | ||
| 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.230 ms | 1 | /classes/Customer.php:503 | ||
| 298 | SELECT SQL_NO_CACHE `save_time` FROM `ps21_zpopupnewsletter` WHERE `id_shop` = 1 AND `active` = 1 LIMIT 1 |
0.230 ms | 1 | /modules/zonepopupnewsletter/classes/ZPopupNewsletter.php:78 | ||
| 291 | 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 | ||
| 219 | 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` = 350136 AND image_shop.`cover` = 1 LIMIT 1 |
0.224 ms | 1 | /classes/Product.php:3570 | ||
| 208 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 287709) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.221 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 211 | 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` = 342234 AND image_shop.`cover` = 1 LIMIT 1 |
0.219 ms | 1 | /classes/Product.php:3570 | ||
| 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.218 ms | 1 | /classes/shop/Shop.php:218 | ||
| 202 | 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` = 287709 AND image_shop.`cover` = 1 LIMIT 1 |
0.218 ms | 1 | /classes/Product.php:3570 | ||
| 306 | SELECT SQL_NO_CACHE data FROM `ps21_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.218 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43 | ||
| 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.217 ms | 1 | /classes/order/Order.php:881 | ||
| 151 | SELECT SQL_NO_CACHE * FROM `ps21_country` a LEFT JOIN `ps21_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1 |
0.216 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 126 | SELECT SQL_NO_CACHE * FROM `ps21_group_lang` WHERE `id_group` = 1 |
0.214 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 199 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 261475) 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 `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 307 AND `active` = 1 LIMIT 1 |
0.207 ms | 1 | /classes/Manufacturer.php:316 | ||
| 180 | 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.206 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 260 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.205 ms | 1 | /classes/module/Module.php:2636 | ||
| 297 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.204 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 170 | SELECT SQL_NO_CACHE data FROM ps21_layered_filter_block WHERE hash="332d29569fe4d17580b52f959a22c016" LIMIT 1 |
0.201 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:186 | ||
| 299 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.201 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.198 ms | 10 | Yes | /classes/ImageType.php:109 | |
| 288 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.198 ms | 1 | /classes/module/Module.php:2109 | ||
| 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.197 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 247 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 287709 |
0.197 ms | 1 | /classes/Product.php:2902 | ||
| 244 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 261475 |
0.196 ms | 1 | /classes/Product.php:2902 | ||
| 286 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.195 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 156 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.191 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 266 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.191 ms | 1 | /classes/module/Module.php:2636 | ||
| 136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.190 ms | 1 | /classes/FeatureFlag.php:105 | ||
| 127 | SELECT SQL_NO_CACHE id_shop FROM `ps21_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.189 ms | 1 | /classes/ObjectModel.php:1729 | ||
| 66 | SELECT SQL_NO_CACHE id FROM `ps21_jm_pagecache_details` WHERE `details_md5`=MD5('{\"1\":{\"taxes\":{\"id_tax\":1},\"computation_method\":0},\"2\":{\"taxes\":{\"id_tax\":2},\"computation_method\":0},\"3\":{\"taxes\":{\"id_tax\":3},\"computation_method\":0},\"4\":{\"taxes\":{\"id_tax\":4},\"computation_method\":0},\"5\":{\"taxes\":{\"id_tax\":1},\"computation_method\":0}}'); |
0.187 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 222 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 350136 AND id_shop=1 LIMIT 1 |
0.184 ms | 1 | /classes/Product.php:6848 | ||
| 216 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 342234) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.182 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 121 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key_mobile' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.178 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 228 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 361 LIMIT 1 |
0.177 ms | 1 | /classes/Product.php:5639 | ||
| 23 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "bvkseodispatcher" LIMIT 1 |
0.176 ms | 0 | /classes/module/Module.php:2636 | ||
| 157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.176 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 302 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.174 ms | 1 | /classes/Page.php:104 | ||
| 268 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.172 ms | 1 | /classes/module/Module.php:2636 | ||
| 24 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "superuser" LIMIT 1 |
0.172 ms | 0 | /classes/module/Module.php:2636 | ||
| 138 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` |
0.171 ms | 10 | /classes/ImageType.php:161 | ||
| 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.170 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 173 | 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` = 860 LIMIT 1 |
0.170 ms | 1 | /classes/Category.php:1375 | ||
| 54 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.168 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 130 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.168 ms | 1 | /classes/Language.php:883 | ||
| 190 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 225894 AND `id_group` = 1 LIMIT 1 |
0.168 ms | 0 | /classes/GroupReduction.php:156 | ||
| 259 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.168 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 167 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 860 AND `id_shop` = 1 |
0.166 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.165 ms | 88 | /classes/Hook.php:339 | ||
| 146 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_legalcompliance" LIMIT 1 |
0.164 ms | 0 | /classes/module/Module.php:2636 | ||
| 31 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.160 ms | 0 | /classes/module/Module.php:2109 | ||
| 122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-11-30 12:28:00' AND date_from <= '2023-11-30 14:28:00') OR (date_to >= '2023-11-30 12:28:00' AND date_to <= '2023-11-30 14:28:00'); |
0.160 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 238 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 179389 |
0.160 ms | 1 | /classes/Product.php:2902 | ||
| 241 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 225894 |
0.159 ms | 1 | /classes/Product.php:2902 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.158 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 131 | SELECT SQL_NO_CACHE value FROM `ps21_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.156 ms | 1 | /classes/shop/Shop.php:1183 | ||
| 61 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 3 |
0.155 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 21 | SELECT SQL_NO_CACHE * FROM `ps21_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.155 ms | 1 | /classes/module/Module.php:2018 | ||
| 185 | 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` = 361 LIMIT 1 |
0.155 ms | 1 | /classes/Category.php:1375 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.154 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 250 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 342234 |
0.153 ms | 1 | /classes/Product.php:2902 | ||
| 150 | SELECT SQL_NO_CACHE `need_identification_number` FROM `ps21_country` WHERE `id_country` = 8 LIMIT 1 |
0.152 ms | 1 | /classes/Country.php:402 | ||
| 203 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 860 LIMIT 1 |
0.150 ms | 1 | /classes/Product.php:5639 | ||
| 164 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.149 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 149 | SELECT SQL_NO_CACHE format FROM `ps21_address_format` WHERE `id_country` = 8 LIMIT 1 |
0.148 ms | 1 | /classes/AddressFormat.php:656 | ||
| 311 | DELETE FROM `ps21_jm_pagecache_bl` WHERE `id`=580; |
0.147 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 178 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 179389 AND `id_group` = 1 LIMIT 1 |
0.146 ms | 0 | /classes/GroupReduction.php:156 | ||
| 198 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 261475 AND `id_group` = 1 LIMIT 1 |
0.146 ms | 0 | /classes/GroupReduction.php:156 | ||
| 58 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 2 |
0.146 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 153 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps21_required_field |
0.146 ms | 1 | /classes/ObjectModel.php:1592 | ||
| 256 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 373873 |
0.146 ms | 1 | /classes/Product.php:2902 | ||
| 310 | DELETE FROM `ps21_jm_pagecache_mods` WHERE `id`=580; |
0.146 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 253 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 350136 |
0.145 ms | 1 | /classes/Product.php:2902 | ||
| 195 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 860 LIMIT 1 |
0.144 ms | 1 | /classes/Product.php:5639 | ||
| 278 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.144 ms | 1 | /classes/module/Module.php:2636 | ||
| 11 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 91 AND `id_shop` = 1 LIMIT 1 |
0.141 ms | 1 | /classes/module/Module.php:2109 | ||
| 55 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 1 |
0.141 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 162 | SELECT SQL_NO_CACHE * FROM `ps21_zcolorsfonts` a WHERE (a.`id_zcolorsfonts` = 1) LIMIT 1 |
0.141 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 220 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 860 LIMIT 1 |
0.141 ms | 1 | /classes/Product.php:5639 | ||
| 189 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 225894 AND id_shop=1 LIMIT 1 |
0.139 ms | 1 | /classes/Product.php:6848 | ||
| 232 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 373873 AND `id_group` = 1 LIMIT 1 |
0.137 ms | 0 | /classes/GroupReduction.php:156 | ||
| 233 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 373873) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.137 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 10 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "jprestaspeedpack" LIMIT 1 |
0.137 ms | 1 | /classes/module/Module.php:2636 | ||
| 214 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 342234 AND id_shop=1 LIMIT 1 |
0.136 ms | 1 | /classes/Product.php:6848 | ||
| 64 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 4 |
0.135 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 132 | SELECT SQL_NO_CACHE c.id_currency FROM `ps21_currency` c WHERE (iso_code = 'EUR') LIMIT 1 |
0.134 ms | 1 | /classes/Currency.php:893 | ||
| 279 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.134 ms | 1 | /classes/module/Module.php:2109 | ||
| 42 | SELECT SQL_NO_CACHE id_shop FROM `ps21_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.133 ms | 1 | /classes/ObjectModel.php:1729 | ||
| 152 | SELECT SQL_NO_CACHE * FROM `ps21_country_lang` WHERE `id_country` = 8 |
0.133 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 89 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "cookiesplus" LIMIT 1 |
0.132 ms | 0 | /classes/module/Module.php:2636 | ||
| 147 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.132 ms | 0 | /classes/module/Module.php:2109 | ||
| 191 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 225894) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.132 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 177 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 179389 AND id_shop=1 LIMIT 1 |
0.131 ms | 1 | /classes/Product.php:6848 | ||
| 224 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 350136) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.131 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 158 | SELECT SQL_NO_CACHE `content` FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.130 ms | 1 | /modules/zonethememanager/classes/ZManager.php:194 | ||
| 29 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.130 ms | 0 | /classes/module/Module.php:2109 | ||
| 186 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 361 LIMIT 1 |
0.130 ms | 1 | /classes/Product.php:5639 | ||
| 267 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 1 | /classes/module/Module.php:2109 | ||
| 223 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 350136 AND `id_group` = 1 LIMIT 1 |
0.127 ms | 0 | /classes/GroupReduction.php:156 | ||
| 231 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 373873 AND id_shop=1 LIMIT 1 |
0.127 ms | 1 | /classes/Product.php:6848 | ||
| 204 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 144 AND `active` = 1 LIMIT 1 |
0.126 ms | 1 | /classes/Manufacturer.php:316 | ||
| 57 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 2) LIMIT 1 |
0.125 ms | 1 |
