Accueil
Il y a 4 produits.
| Load Time | 503.121 ms |
| Querying Time | 107 ms |
| Queries | 274 |
| Memory Peak Usage | 23.6 Mb |
| Included Files | 1263 files - 11.89 Mb |
| PrestaShop Cache | - Mb |
| Global vars | 0.19 Mb |
| PrestaShop Version | 8.1.2 |
| PHP Version | 8.1.25 |
| MySQL Version | 10.6.16-MariaDB |
| Memory Limit | 2048M |
| Max Execution Time | 3600s |
| Smarty Cache | enabled |
| Smarty Compilation | force compile |
| Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
|---|---|---|---|---|
| config | 5.638 ms | 5.638 ms | 8.54 Mb | 9.2 Mb |
| __construct | 9.155 ms | 14.793 ms | 1.73 Mb | 11.9 Mb |
| config | 26.679 ms | 41.472 ms | 1.21 Mb | 11.9 Mb |
| __construct | 0.020 ms | 41.492 ms | - Mb | 11.9 Mb |
| init | 31.897 ms | 73.389 ms | 2.13 Mb | 14.8 Mb |
| checkAccess | 0.002 ms | 73.391 ms | - Mb | 14.8 Mb |
| setMedia | 2.743 ms | 76.134 ms | 0.26 Mb | 14.8 Mb |
| postProcess | 0.002 ms | 76.136 ms | - Mb | 14.8 Mb |
| initHeader | 0.001 ms | 76.137 ms | - Mb | 14.8 Mb |
| initContent | 108.179 ms | 184.316 ms | 4.23 Mb | 19.0 Mb |
| initFooter | 0.003 ms | 184.319 ms | - Mb | 19.0 Mb |
| display | 318.802 ms | 503.121 ms | 4.92 Mb | 23.6 Mb |
| Hook | Time | Memory Usage |
|---|---|---|
| ActionDispatcherBefore | 38.495 ms | 3.09 Mb |
| ActionOutputHTMLBefore | 37.329 ms | 0.15 Mb |
| displayProductListReviews | 25.384 ms | 1.29 Mb |
| displayLeftColumn | 25.169 ms | 0.74 Mb |
| displayTop | 16.977 ms | 0.20 Mb |
| DisplayFooter | 11.633 ms | 0.11 Mb |
| ActionDispatcher | 11.465 ms | 0.70 Mb |
| DisplayBeforeBodyClosingTag | 10.775 ms | 0.27 Mb |
| displayFooterRight | 3.658 ms | 0.07 Mb |
| DisplayHeader | 3.109 ms | 0.06 Mb |
| DisplayLeftColumn | 1.451 ms | 0.02 Mb |
| displayNav2 | 1.355 ms | 0.08 Mb |
| ActionFrontControllerSetVariables | 1.186 ms | 0.06 Mb |
| displayFooterLeft | 0.962 ms | 0.06 Mb |
| DisplayOutsideMainPage | 0.960 ms | 0.03 Mb |
| ActionFrontControllerSetMedia | 0.786 ms | 0.01 Mb |
| DisplayBanner | 0.476 ms | 0.01 Mb |
| DisplayFooterLeft | 0.440 ms | 0.01 Mb |
| DisplayNavFullWidth | 0.392 ms | 0.01 Mb |
| DisplaySidebarNavigation | 0.362 ms | - Mb |
| DisplayFooterAfter | 0.358 ms | 0.01 Mb |
| ProductSearchProvider | 0.335 ms | - Mb |
| DisplayFooterRight | 0.323 ms | 0.01 Mb |
| DisplayNav1 | 0.245 ms | 0.01 Mb |
| ActionObjectAddAfter | 0.034 ms | - Mb |
| ModuleRoutes | 0.025 ms | 0.02 Mb |
| ActionFrontControllerInitAfter | 0.014 ms | - Mb |
| DisplayAfterBodyOpeningTag | 0.012 ms | - Mb |
| DisplayFooterBefore | 0.009 ms | - Mb |
| 29 hook(s) | 193.719 ms | 7.05 Mb |
| Module | Time | Memory Usage |
|---|---|---|
| prestaadvanceloyaltyprogram | 6.523 ms | 0.54 Mb |
| jprestaspeedpack | 88.511 ms | 4.02 Mb |
| blockreassurance | 1.231 ms | 0.09 Mb |
| blockwishlist | 11.961 ms | 0.13 Mb |
| ps_emailsubscription | 3.849 ms | 0.10 Mb |
| ps_socialfollow | 1.084 ms | 0.07 Mb |
| ps_emailalerts | 0.209 ms | 0.09 Mb |
| zonethememanager | 14.188 ms | 1.30 Mb |
| ps_shoppingcart | 11.808 ms | 0.11 Mb |
| ps_searchbar | 1.944 ms | 0.14 Mb |
| productcomments | 25.630 ms | 1.32 Mb |
| ps_googleanalytics | 4.562 ms | 0.05 Mb |
| zonecolorsfonts | 1.372 ms | 0.06 Mb |
| zonemegamenu | 1.876 ms | 0.06 Mb |
| prestastripe | 2.787 ms | 0.02 Mb |
| ps_facetedsearch | 1.909 ms | 0.10 Mb |
| ps_languageselector | 0.936 ms | 0.06 Mb |
| ps_currencyselector | 0.682 ms | 0.06 Mb |
| ps_customersignin | 3.744 ms | 0.08 Mb |
| ps_categorytree | 25.322 ms | 0.75 Mb |
| zonecolumnblocks | 0.726 ms | 0.11 Mb |
| zonepopupnewsletter | 0.577 ms | 0.03 Mb |
| statsdata | 6.528 ms | 0.27 Mb |
| 23 module(s) | 217.959 ms | 9.56 Mb |
| # | Query | Time (ms) | Rows | Filesort | Group By | Location |
|---|---|---|---|---|---|---|
| 269 | INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (873,803264849),(873,94201498),(873,592374860),(873,1289214159),(873,1785617407),(873,2936477779),(873,1727466530),(873,1432532875),(873,1025009294),(873,1804081323),(873,3479716883),(873,66301815),(873,537553573),(873,3045727500),(873,3231073010),(873,1825096520),(873,3225262556),(873,2645763144),(873,2027619899),(873,786864081),(873,1849360992),(873,294428854),(873,3774376179),(873,2880678980),(873,114155291),(873,2929321318),(873,2087307803),(873,2369020978),(873,1152186767),(873,4222788516),(873,2858566420),(873,848840972),(873,4147554351),(873,770698498),(873,2244011448),(873,477004582),(873,3610318732),(873,1070190107),(873,937307692),(873,25761885),(873,3366890060),(873,3483396593),(873,392306519),(873,909258745),(873,179865882),(873,3099645137),(873,3371246540),(873,2390640699),(873,501027234),(873,3032495894),(873,2100541971),(873,2793494280),(873,180908336),(873,1192985740),(873,1972034646),(873,2419117650),(873,3803768817),(873,4265874642),(873,67723771),(873,3423129237),(873,3399895114),(873,3221089548),(873,2990154896),(873,2728213885),(873,933991437),(873,2513627470),(873,468067826),(873,4137721533),(873,1552016987),(873,4080301755),(873,4245349388),(873,1973472416),(873,1839057912),(873,3745041382),(873,3035734567),(873,3719469943),(873,3466131047),(873,679558129),(873,462819688),(873,4267553191),(873,518809702),(873,3303811122),(873,2883778317),(873,1694893476),(873,3287268691),(873,3711637102),(873,698879415),(873,885817714),(873,125306139),(873,1634619674),(873,58280175),(873,3363778289),(873,1161663254),(873,201135304),(873,288600709),(873,1021330335),(873,2858809635),(873,2763627026),(873,3717400459),(873,4125370705),(873,3997906175),(873,4162316513),(873,3219397995),(873,2539165674),(873,1046234598),(873,787652129),(873,1595426297),(873,4184932827),(873,1985552396),(873,1944795689),(873,3799916950),(873,1827123668),(873,1447744642),(873,1636796806),(873,2645405926),(873,1474595477),(873,3375525138),(873,3902077767),(873,3507415422),(873,2781072282),(873,2002273313),(873,3164880625),(873,2490789905),(873,1000843653),(873,48947005),(873,3883347157),(873,3700474777),(873,4264269047),(873,2125390191),(873,4270481046),(873,1693150473),(873,343450730),(873,381351735),(873,2863449446),(873,3772294966),(873,3877457961),(873,1492116830),(873,4041511410),(873,828132466),(873,4090211224),(873,2185737194),(873,3517149926),(873,647687838),(873,733479784),(873,1440916471),(873,3262261204),(873,1872100372),(873,2092461357),(873,3357609169),(873,2365529006),(873,1263061406),(873,2296732656),(873,534196217),(873,482025419),(873,2811467352),(873,2488480532),(873,3501473861),(873,1917272649),(873,1878317490),(873,1789511633),(873,956713705),(873,89981727),(873,1143557322),(873,2749361789),(873,3857194488),(873,1024086260),(873,26040876),(873,1804243295),(873,2165251395),(873,1281618245),(873,2793993627),(873,426054238),(873,3398682121),(873,1025101115),(873,2974984653),(873,2214325187),(873,997821910),(873,2005463392),(873,3252396061),(873,942332382),(873,3816934055),(873,1661692647),(873,975758589),(873,3974931321),(873,2301364099),(873,855746680),(873,637832447),(873,3938675492),(873,508940865),(873,911480697),(873,1283363269),(873,3552869238),(873,2961923901),(873,3747234531),(873,3155646160),(873,3164668199),(873,2271068282),(873,84354396),(873,2915068863),(873,4064530110),(873,3216991891),(873,2045363644),(873,2664176477),(873,1076722390),(873,505410826),(873,3544422162),(873,2506779464),(873,2552384108),(873,876907216),(873,82980331),(873,3890150098),(873,3475437886),(873,2302280848),(873,1133144647),(873,801167173),(873,2059315716),(873,3139619822),(873,2937007520),(873,1589371182),(873,693370988),(873,2708427394),(873,1007456900),(873,610735313),(873,3846627131),(873,2031830639),(873,1908602231),(873,1401333655),(873,378101424),(873,996218346),(873,660881695),(873,2938384267),(873,4250264855),(873,1895305721),(873,502965417),(873,1982471117),(873,2524144246),(873,2774996218),(873,1068709096),(873,4077513867),(873,2900588200),(873,465472731),(873,4139839450),(873,2360011682),(873,4211248848),(873,283341417),(873,4165214622),(873,3508523596),(873,234404923),(873,2782693783),(873,3413880379),(873,3540168379),(873,861653603),(873,3160995915),(873,1391251310),(873,2106651858),(873,3572623339),(873,4629984),(873,2488722736),(873,3486510944),(873,2675016634),(873,2165907305),(873,136687257),(873,3540179561),(873,2792526429),(873,2220600372),(873,2914585448),(873,3882733113),(873,1688090355),(873,3534950496),(873,1182870252),(873,412601709),(873,574969182),(873,2970413814),(873,1487282505),(873,3228977345),(873,2023459642),(873,3291711134),(873,2792891444),(873,3335276918),(873,502111155),(873,1347492703),(873,2832080533),(873,1215320197),(873,2317239205),(873,1931846913),(873,1721014625),(873,738600257),(873,2998338424),(873,1207945902),(873,734241479),(873,3324570843),(873,4126771257),(873,1712456575),(873,3169253733),(873,1160958045),(873,1130949510),(873,3116084871),(873,269178051),(873,24773614),(873,3204450510),(873,3468662336),(873,1808444077),(873,4095410992),(873,1012520131),(873,2367920745),(873,2603361072),(873,2741539031),(873,607507456),(873,616165826),(873,2288576869),(873,4252798532),(873,2692385638),(873,4100315394),(873,3061254709),(873,1657292258),(873,2148967437),(873,1248236410),(873,2457219175),(873,1920985790),(873,1340703149),(873,1618471777),(873,4160689201),(873,1822364967),(873,479188821),(873,1661785323),(873,4137484009),(873,2636427258),(873,1499247737),(873,2061922205),(873,665830591),(873,916194615),(873,495595719),(873,3026469794),(873,1845449656),(873,4078122428),(873,2044505385),(873,3156749269),(873,3919036276),(873,204613135),(873,605377709),(873,766051911),(873,30400764),(873,4211022030),(873,715827285),(873,1092948871),(873,610201349),(873,1023110113),(873,3379323545),(873,2591028766),(873,1994095466),(873,33157726),(873,198243957),(873,2540831776),(873,1707019604),(873,2730046909),(873,4101073252),(873,207761914),(873,2750534087),(873,980926717),(873,377071036),(873,2983490672),(873,584353846),(873,1743688562),(873,3223058413),(873,1665991311),(873,3093731065),(873,1095877807),(873,1085889875),(873,2059985562),(873,3618062925),(873,4217863027),(873,3425247989),(873,1636391408),(873,1698766782),(873,2162739858),(873,1538367880),(873,3760626336),(873,1987713032),(873,2338874856),(873,4206689645),(873,1723372602),(873,2788329276),(873,2095305502),(873,3135330775),(873,2402748468),(873,24058172),(873,4000683245),(873,315670382),(873,2558276906),(873,1745365471),(873,2782569384),(873,3422117706),(873,552626444),(873,1506232339),(873,2933163456),(873,1483801350),(873,1400586123),(873,3746875726),(873,2604810181),(873,2905930158),(873,803588046),(873,1651400661),(873,1431243585),(873,1586185269),(873,4110009762),(873,3647374073),(873,4196158832),(873,644435096),(873,1862966990),(873,2098775956),(873,4045847707),(873,3122054119),(873,1971194991),(873,2149367276),(873,1888540635),(873,2660577125),(873,2508340497),(873,196341346),(873,1790101800),(873,1054130805),(873,2741947598),(873,1292400575),(873,545037028),(873,1516477184),(873,2706799993),(873,562470873),(873,2591346466),(873,613023703),(873,2725609989),(873,2082081559),(873,572560232),(873,2833489058),(873,1999611979),(873,1938789650),(873,2958717166),(873,1035708154),(873,2025067287),(873,3804047398),(873,248028803),(873,4243412966),(873,628124381),(873,1271215494),(873,2140466223),(873,1298495884),(873,3585931255),(873,532975694),(873,892763084),(873,203145038),(873,470924714),(873,1460516495),(873,2732318442),(873,3996868778),(873,862206445),(873,3193479021),(873,3382171736),(873,3362897893),(873,3598913121),(873,1342337107),(873,3202829344),(873,1335223071),(873,270790954),(873,1086966479),(873,484642328),(873,4274468042),(873,1740107684),(873,2117688527),(873,1393082718),(873,366510022),(873,341328174),(873,1469264429),(873,968691010),(873,3210232788),(873,809700252),(873,3705477223),(873,1639200307),(873,3585776886),(873,3305319229),(873,1052899681),(873,2176267881),(873,357387863),(873,451177334),(873,677589039),(873,1181390953),(873,898241702),(873,3480303789),(873,1736215096),(873,2511740146),(873,2560762429),(873,1570623991),(873,897080848),(873,891021207),(873,2807843172),(873,411231410),(873,2413680770),(873,519468981),(873,1898829954),(873,4274422817),(873,2781196321),(873,433695516),(873,1652336127),(873,4200438598),(873,3032893805),(873,1435170492),(873,341146430),(873,755973553),(873,2183774725),(873,3967614532),(873,1589097164),(873,2441764320),(873,745126750),(873,348450311),(873,2084175962),(873,3357611772),(873,1654631620),(873,3098454302),(873,2029227635),(873,1731761366),(873,2444253995),(873,2906032508),(873,872274856),(873,4282856364),(873,3328013593),(873,4184469063),(873,1074477927),(873,475878802),(873,1341972790),(873,2770374005),(873,4237489391),(873,2818813526),(873,3131100007),(873,4267621199),(873,1031922959),(873,1616292706),(873,630426110),(873,1846388513),(873,2239793094),(873,1660370824),(873,3321716633),(873,2551727033),(873,1836172154),(873,1870881122),(873,3324207484),(873,1065867023),(873,1459310880),(873,1395112921),(873,893552556),(873,1795813847),(873,2544364435),(873,4188602229),(873,1437064809),(873,922605498),(873,4180843510),(873,2554784265),(873,3798404205),(873,1216801552),(873,225525148),(873,274058040),(873,3206796234),(873,610255635),(873,3139895407),(873,3993594441),(873,2078652070),(873,3340749058),(873,2282248923),(873,3201099700),(873,3944887276),(873,887478137),(873,620965629),(873,53639561),(873,687854272),(873,4204526813),(873,3434636086),(873,3859247582),(873,2160451939),(873,419013317),(873,488655959),(873,2224381764),(873,857621694),(873,593880699),(873,1743569168),(873,747100668),(873,2627272664),(873,1477316791),(873,852002855),(873,3813191394),(873,3206482767),(873,2935275735),(873,825997452),(873,4128572079),(873,4149399208),(873,2432005645),(873,945310979),(873,206553734),(873,3381625344),(873,2613891474),(873,1285565060),(873,725086502),(873,2181279565),(873,2136294074),(873,531227063),(873,3291030245),(873,3423892574),(873,1818418110),(873,1175554195),(873,231365613),(873,3071984169),(873,1510809703),(873,2304894647),(873,724387218),(873,3702122266),(873,3105745802),(873,3598888791),(873,40599425),(873,4256434691),(873,1198380170),(873,3549401556),(873,2300237909),(873,484124464),(873,3042798728),(873,767973032),(873,4146324303),(873,1493350341),(873,2166736334),(873,3061340275),(873,1468811388),(873,714571165),(873,1958965990),(873,2146366302),(873,2212338847),(873,2088651590),(873,2684538463),(873,2292708505),(873,571001464),(873,608126571),(873,2736309071),(873,1479333754),(873,1794660366),(873,2319975337),(873,1093438481),(873,2975864804),(873,2504416172),(873,3531750290),(873,219666672),(873,4219072870),(873,1053258155),(873,2382983142),(873,1006288562),(873,1770263986),(873,3089735283),(873,3689334927),(873,2901629603),(873,2019277020),(873,2853333944),(873,1110695191),(873,3884283185),(873,4268093708),(873,159799075),(873,1715997742),(873,1009155269),(873,3922001006),(873,3916338789),(873,1085252167),(873,207705430),(873,1190601026),(873,1441004396),(873,1567147586),(873,964098054),(873,1385174189),(873,3607427007),(873,4065177061),(873,1552830538),(873,3778287701),(873,3986294473),(873,4127238085),(873,1865170325),(873,2161789419),(873,2889615117),(873,785261358),(873,3873733217),(873,2600209543),(873,3958092558),(873,4143434528),(873,3225228598),(873,3451063310),(873,810085901),(873,1502204888),(873,2931931582),(873,1339720903),(873,4093703382),(873,1016897830),(873,1186809094),(873,2269117600),(873,813555736),(873,733475850),(873,305814753),(873,2720553993),(873,212227262),(873,1328958432),(873,3903742053),(873,2617942920),(873,4254367326),(873,2895836413),(873,1090341105),(873,3174277595),(873,639084285),(873,4064195579),(873,2134315289),(873,608843276),(873,4190247440),(873,1090444753),(873,2554275840),(873,2758076506),(873,2518001916),(873,3620157415),(873,1195920681),(873,1822840633),(873,1087551238),(873,235508323),(873,1139244570),(873,810960133),(873,425550269),(873,1767940144),(873,1488780247),(873,1250541405),(873,1715845038),(873,3777612587),(873,2285237154),(873,802817926),(873,4280998710),(873,1108258121),(873,1107026853),(873,2913745362),(873,1129101120),(873,2454813183),(873,1690919006),(873,23973636),(873,293370743),(873,1041759778),(873,3142497267),(873,2920365983),(873,2300359472),(873,885232682),(873,1995817456),(873,3443377157),(873,863919144),(873,1324348692),(873,4019216150),(873,443752815),(873,4223293),(873,1182491637),(873,4257294915),(873,3629776934),(873,582958316),(873,3061655453),(873,1665355533),(873,1929899841),(873,1033949851),(873,2010879266),(873,1872304779),(873,1282102725),(873,3589651214),(873,4095654001),(873,2447713556),(873,2543494532),(873,2069898435),(873,3286503857),(873,2662939963),(873,93111834),(873,3160936308),(873,261262800),(873,141197408),(873,1904512268),(873,3001025754),(873,2247670246),(873,535154833),(873,3476002757),(873,3806439314),(873,1819793014),(873,3545273473),(873,3957652542),(873,3018295592),(873,1367893712),(873,1034338066),(873,3229510223),(873,4276953245),(873,3363858574),(873,2870596766),(873,648526699),(873,3627085975),(873,1585047995),(873,1960922033),(873,748737253),(873,1175066615),(873,1318322018),(873,260367662),(873,643741484),(873,1013706048),(873,1726352130),(873,2222354404),(873,1327031463),(873,1131865044),(873,839200087),(873,1407668396),(873,3548333318),(873,237845721),(873,3056051791),(873,747235328),(873,172675174),(873,2781705803),(873,2111348799),(873,3067187587),(873,618638032),(873,3369756381),(873,2232055662),(873,55113216),(873,3939915090),(873,2586983921),(873,3286008345),(873,1956055310),(873,740042513),(873,2282536358),(873,1863122946),(873,1296880981),(873,2589434346),(873,1621393368),(873,39250009),(873,72263924),(873,1587391050),(873,847186998),(873,2455499024),(873,859347884),(873,2244795234),(873,64890532),(873,1712315840),(873,4235513153),(873,3576592434),(873,1431376154),(873,3924888977),(873,1697117306),(873,3406763364),(873,1129505049) ON DUPLICATE KEY UPDATE id=id |
9.765 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 238 | SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps21_category` c INNER JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps21_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 1669 AND c.id_category IN ( SELECT id_category FROM `ps21_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC |
8.364 ms | 835 | Yes | /modules/ps_categorytree/ps_categorytree.php:166 | |
| 2 | SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
3.421 ms | 1298 | /classes/Configuration.php:180 | ||
| 165 | SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=523 AND c.nright<=524 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 |
2.666 ms | 21351054400 | Yes | /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.646 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.106 ms | 148 | Yes | Yes | /classes/Hook.php:1233 |
| 166 | SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=523 AND c.nright<=524 GROUP BY p.id_product) p |
2.069 ms | 21351054400 | /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 | ||
| 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.993 ms | 386 | /classes/Hook.php:456 | ||
| 270 | 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.783 ms | 11 | Yes | /modules/jprestaspeedpack/classes/PageCacheDAO.php:335 | |
| 266 | INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 301179640, 'https://cadeaufou.com/500-toners-recycles', 1, 2, 1, 500, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0; |
1.319 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 262 | INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('915650', '', 'cadeaufou.com/500-toners-recycles', '', '2023-12-01 09:50:52') |
1.244 ms | 1 | /classes/ObjectModel.php:622 | ||
| 257 | 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.236 ms | 1 | /classes/ObjectModel.php:622 | ||
| 168 | SELECT SQL_NO_CACHE p.*, ps.*, pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-12-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (184806,200124,350110,364032) |
1.207 ms | 4 | /classes/ProductAssembler.php:95 | ||
| 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` = 500 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
1.112 ms | 1 | Yes | Yes | /classes/Category.php:921 |
| 119 | UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1; |
1.067 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 261 | INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('917941', '2107', '751134203', '', '1', '1', '2023-12-01 09:50:52') |
1.049 ms | 1 | /classes/ObjectModel.php:622 | ||
| 271 | DELETE FROM `ps21_jm_pagecache` WHERE id IN (100899) |
1.048 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 161 | SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 523) AND (a0.`nright` > 524) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
1.048 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
| 17 | SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` |
1.014 ms | 880 | /classes/Hook.php:1292 | ||
| 14 | SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1) |
0.998 ms | 880 | /classes/Hook.php:1332 | ||
| 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` < 523) AND (a0.`nright` > 524) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc |
0.985 ms | 835 | Yes | /classes/PrestaShopCollection.php:383 | |
| 239 | 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 (184806) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.779 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 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.687 ms | 1 | Yes | /classes/shop/Shop.php:1364 | |
| 194 | SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 200124 AND pac.`id_product_attribute` = 38694 AND agl.`id_lang` = 1 |
0.659 ms | 1 | /classes/Product.php:7506 | ||
| 252 | 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 (364032) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.623 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 246 | SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps21_product_attribute_combination` pac LEFT JOIN `ps21_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (38694,38695,38697,38698) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute |
0.617 ms | 4 | /classes/Product.php:2752 | ||
| 250 | 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 (200124) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.613 ms | 4 | Yes | Yes | /classes/Product.php:4504 |
| 189 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 200124 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` = 200124 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.582 ms | 0 | /classes/Cart.php:1410 | ||
| 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.578 ms | 81 | /classes/module/Module.php:345 | ||
| 179 | 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` = 184806 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` = 184806 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.563 ms | 0 | /classes/Cart.php:1410 | ||
| 265 | 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.560 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
| 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.547 ms | 1 | Yes | /classes/shop/Shop.php:715 | |
| 251 | 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 (350110) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.546 ms | 1 | Yes | Yes | /classes/Product.php:4504 |
| 245 | SELECT SQL_NO_CACHE pa.*, product_attribute_shop.* FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 200124 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute` |
0.537 ms | 4 | Yes | Yes | /classes/Product.php:2734 |
| 213 | 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` = 184806) AND (b.`id_shop` = 1) LIMIT 1 |
0.534 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 20 | SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps21_meta` m LEFT JOIN `ps21_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.520 ms | 46 | Yes | /classes/Dispatcher.php:654 | |
| 191 | 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` = 38694 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 200124 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` = 38694 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 200124 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.516 ms | 0 | /classes/Cart.php:1410 | ||
| 18 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.502 ms | 81 | /classes/module/Module.php:345 | ||
| 180 | 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 = 184806 ORDER BY f.position ASC |
0.499 ms | 1 | Yes | /classes/Product.php:5993 | |
| 225 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_languageselector" LIMIT 1 |
0.497 ms | 1 | /classes/module/Module.php:2636 | ||
| 211 | 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` = 364032 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` = 364032 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.486 ms | 0 | /classes/Cart.php:1410 | ||
| 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 = 200124 ORDER BY f.position ASC |
0.483 ms | 1 | Yes | /classes/Product.php:5993 | |
| 222 | 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` = 364032) AND (b.`id_shop` = 1) LIMIT 1 |
0.481 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 203 | SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 350110 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` = 350110 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1 |
0.477 ms | 0 | /classes/Cart.php:1410 | ||
| 183 | 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` = 200124) AND (b.`id_shop` = 1) LIMIT 1 |
0.470 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 142 | SELECT SQL_NO_CACHE * FROM `ps21_cart_rule` cr LEFT JOIN `ps21_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ((cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1 |
0.468 ms | 6 | /classes/CartRule.php:418 | ||
| 219 | 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` = 350110) AND (b.`id_shop` = 1) LIMIT 1 |
0.467 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 204 | 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 = 350110 ORDER BY f.position ASC |
0.465 ms | 1 | Yes | /classes/Product.php:5993 | |
| 141 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-12-01 00:00:00" AND date_to <= "2023-12-01 23:59:59") OR (date_from >= "2023-12-01 00:00:00" AND date_from <= "2023-12-01 23:59:59") OR (date_from < "2023-12-01 00:00:00" AND date_to > "2023-12-01 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.460 ms | 5 | /classes/CartRule.php:357 | ||
| 212 | 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 = 364032 ORDER BY f.position ASC |
0.459 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.458 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 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.458 ms | 1 | /classes/CartRule.php:418 | ||
| 242 | SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 200124) LIMIT 1 |
0.456 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 162 | SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps21_layered_category WHERE controller = 'category' AND id_category = 500 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.454 ms | 1 | Yes | Yes | /modules/ps_facetedsearch/src/Filters/Provider.php:61 |
| 214 | 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` = 184806 ORDER BY `position` |
0.451 ms | 1 | Yes | /classes/Product.php:3545 | |
| 220 | 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` = 350110 ORDER BY `position` |
0.443 ms | 1 | Yes | /classes/Product.php:3545 | |
| 169 | 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` = 184806 AND image_shop.`cover` = 1 LIMIT 1 |
0.440 ms | 1 | /classes/Product.php:3570 | ||
| 143 | SELECT SQL_NO_CACHE 1 FROM `ps21_cart_rule` WHERE ((date_to >= "2023-12-01 00:00:00" AND date_to <= "2023-12-01 23:59:59") OR (date_from >= "2023-12-01 00:00:00" AND date_from <= "2023-12-01 23:59:59") OR (date_from < "2023-12-01 00:00:00" AND date_to > "2023-12-01 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1 |
0.437 ms | 5 | /classes/CartRule.php:357 | ||
| 185 | SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 200124) |
0.430 ms | 4 | /classes/Product.php:3857 | ||
| 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.423 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 260 | SELECT SQL_NO_CACHE `id_page` FROM `ps21_page` WHERE `id_page_type` = 1 AND `id_object` = 500 LIMIT 1 |
0.423 ms | 1 | /classes/Page.php:83 | ||
| 216 | 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` = 200124 ORDER BY `position` |
0.420 ms | 4 | Yes | /classes/Product.php:3545 | |
| 207 | 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` = 364032) |
0.413 ms | 1 | /classes/Product.php:3857 | ||
| 223 | 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` = 364032 ORDER BY `position` |
0.402 ms | 1 | Yes | /classes/Product.php:3545 | |
| 22 | SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps21_module` m LEFT JOIN `ps21_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 |
0.395 ms | 81 | /classes/module/Module.php:345 | ||
| 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.394 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 258 | SELECT SQL_NO_CACHE `id_guest` FROM `ps21_connections` WHERE `id_guest` = 917941 AND `date_add` > '2023-12-01 09:20:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.388 ms | 1 | Yes | /classes/Connection.php:168 | |
| 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.386 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 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` = 500) AND (b.`id_shop` = 1) LIMIT 1 |
0.372 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 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.370 ms | 1 | /classes/Customer.php:475 | ||
| 199 | 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` = 350110) |
0.365 ms | 1 | /classes/Product.php:3857 | ||
| 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.356 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 192 | SELECT SQL_NO_CACHE pa.`available_date` FROM `ps21_product` p LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps21_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 200124 AND pa.`id_product` = 200124 AND pa.`id_product_attribute` = 38694 LIMIT 1 |
0.338 ms | 1 | /classes/Product.php:1209 | ||
| 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.337 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 235 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_categorytree" LIMIT 1 |
0.331 ms | 1 | /classes/module/Module.php:2636 | ||
| 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.321 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.320 ms | 1 | /classes/Customer.php:475 | ||
| 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.318 ms | 1 | /classes/Language.php:1080 | ||
| 253 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_socialfollow" LIMIT 1 |
0.312 ms | 1 | /classes/module/Module.php:2636 | ||
| 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.311 ms | 1 | /classes/Customer.php:503 | ||
| 195 | SELECT SQL_NO_CACHE * FROM `ps21_product_attribute` a LEFT JOIN `ps21_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 38694) LIMIT 1 |
0.305 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 163 | SELECT SQL_NO_CACHE * FROM `ps21_category` a LEFT JOIN `ps21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 500) LIMIT 1 |
0.303 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 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.299 ms | 1 | /classes/Language.php:1216 | ||
| 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.299 ms | 1 | /classes/Customer.php:503 | ||
| 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.295 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 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.291 ms | 5 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 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.286 ms | 1 | /classes/order/Order.php:881 | ||
| 173 | 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` = 184806) |
0.285 ms | 1 | /classes/Product.php:3857 | ||
| 12 | SELECT SQL_NO_CACHE domain, domain_ssl FROM ps21_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.283 ms | 1 | /classes/shop/ShopUrl.php:182 | ||
| 197 | 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` = 350110 AND image_shop.`cover` = 1 LIMIT 1 |
0.281 ms | 1 | /classes/Product.php:3570 | ||
| 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.278 ms | 1 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 237 | 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.277 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 181 | 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` = 200124 AND image_shop.`cover` = 1 LIMIT 1 |
0.274 ms | 4 | /classes/Product.php:3570 | ||
| 243 | SELECT SQL_NO_CACHE * FROM `ps21_product_lang` WHERE `id_product` = 200124 AND `id_shop` = 1 |
0.273 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 129 | SELECT SQL_NO_CACHE * FROM `ps21_currency` c ORDER BY `iso_code` ASC |
0.270 ms | 1 | Yes | /classes/Currency.php:709 | |
| 247 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 200124) AND (id_product_attribute = 38695) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.267 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 205 | 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` = 364032 AND image_shop.`cover` = 1 LIMIT 1 |
0.267 ms | 1 | /classes/Product.php:3570 | ||
| 136 | SELECT SQL_NO_CACHE state FROM ps21_feature_flag WHERE name = 'multiple_image_format' LIMIT 1 |
0.264 ms | 1 | /classes/FeatureFlag.php:105 | ||
| 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.258 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.258 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 177 | 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.256 ms | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
| 120 | SELECT SQL_NO_CACHE date_upd FROM `ps21_configuration` WHERE name='pagecache_default_context_key' AND date_upd >= (NOW() - INTERVAL 1 DAY) |
0.255 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 3 | SELECT SQL_NO_CACHE * FROM `ps21_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.254 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 218 | SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps21_product_attribute_image` pai LEFT JOIN `ps21_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps21_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (38695, 38697, 38698, 38694) AND il.`id_lang` = 1 ORDER by i.`position` |
0.254 ms | 1 | Yes | /classes/Product.php:2921 | |
| 227 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_currencyselector" LIMIT 1 |
0.252 ms | 1 | /classes/module/Module.php:2636 | ||
| 135 | SELECT SQL_NO_CACHE ctg.`id_group` FROM ps21_category_group ctg WHERE ctg.`id_category` = 500 AND ctg.`id_group` = 1 LIMIT 1 |
0.250 ms | 1 | /classes/Category.php:1751 | ||
| 231 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_customersignin" LIMIT 1 |
0.247 ms | 1 | /classes/module/Module.php:2636 | ||
| 264 | SELECT SQL_NO_CACHE * FROM `ps21_shop_url` a WHERE (a.`id_shop_url` = 1) LIMIT 1 |
0.246 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 7 | SELECT SQL_NO_CACHE * FROM `ps21_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.244 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 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.242 ms | 1 | /classes/Currency.php:1136 | ||
| 259 | SELECT SQL_NO_CACHE id_page_type FROM ps21_page_type WHERE name = 'category' LIMIT 1 |
0.240 ms | 1 | /classes/Page.php:104 | ||
| 19 | SELECT SQL_NO_CACHE name, alias FROM `ps21_hook_alias` |
0.237 ms | 88 | /classes/Hook.php:339 | ||
| 157 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager_lang` WHERE `id_zthememanager` = 1 |
0.231 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 263 | SELECT SQL_NO_CACHE data FROM `ps21_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1 |
0.231 ms | 0 | /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43 | ||
| 16 | SELECT SQL_NO_CACHE `name`, `alias` FROM `ps21_hook_alias` |
0.228 ms | 88 | /classes/Hook.php:287 | ||
| 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.228 ms | 1 | /classes/shop/Shop.php:218 | ||
| 164 | SELECT SQL_NO_CACHE * FROM `ps21_category_lang` WHERE `id_category` = 500 AND `id_shop` = 1 |
0.228 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 156 | SELECT SQL_NO_CACHE * FROM `ps21_zthememanager` a WHERE (a.`id_zthememanager` = 1) LIMIT 1 |
0.226 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 210 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 364032) 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 | ||
| 233 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1 |
0.215 ms | 1 | /classes/module/Module.php:2636 | ||
| 122 | SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache_sp` WHERE (date_from >= '2023-12-01 09:50:00' AND date_from <= '2023-12-01 11:50:00') OR (date_to >= '2023-12-01 09:50:00' AND date_to <= '2023-12-01 11:50:00'); |
0.214 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 178 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 184806) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.210 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 184 | SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 38694 LIMIT 1 |
0.208 ms | 1 | /classes/Combination.php:564 | ||
| 167 | SELECT SQL_NO_CACHE data FROM ps21_layered_filter_block WHERE hash="aea2b00a7f22cd4fddd17a7c9241ec9d" LIMIT 1 |
0.207 ms | 1 | /modules/ps_facetedsearch/src/Filters/Block.php:186 | ||
| 254 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1 |
0.207 ms | 1 | /classes/module/Module.php:2109 | ||
| 21 | SELECT SQL_NO_CACHE * FROM `ps21_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.204 ms | 1 | /classes/module/Module.php:2018 | ||
| 186 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 200124 AND id_shop=1 LIMIT 1 |
0.203 ms | 1 | /classes/Product.php:6848 | ||
| 55 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 1 |
0.200 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 47 | SELECT SQL_NO_CACHE DISTINCT id_product FROM `ps21_jm_pagecache_sp` WHERE date_from<='2023-12-01 09:50:00' OR date_to<'2023-12-01 09:50:00'; |
0.199 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 137 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `categories` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.199 ms | 10 | Yes | /classes/ImageType.php:109 | |
| 100 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.198 ms | 0 | /classes/module/Module.php:2109 | ||
| 255 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_emailsubscription" LIMIT 1 |
0.189 ms | 1 | /classes/module/Module.php:2636 | ||
| 23 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "bvkseodispatcher" LIMIT 1 |
0.186 ms | 0 | /classes/module/Module.php:2636 | ||
| 54 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.186 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 236 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1 |
0.186 ms | 1 | /classes/module/Module.php:2109 | ||
| 244 | SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps21_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 500 LIMIT 1 |
0.186 ms | 0 | /classes/Category.php:1375 | ||
| 41 | SELECT SQL_NO_CACHE * FROM `ps21_currency_lang` WHERE `id_currency` = 1 |
0.185 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 11 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 91 AND `id_shop` = 1 LIMIT 1 |
0.184 ms | 1 | /classes/module/Module.php:2109 | ||
| 206 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 500 LIMIT 1 |
0.182 ms | 1 | /classes/Product.php:5639 | ||
| 228 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1 |
0.181 ms | 1 | /classes/module/Module.php:2109 | ||
| 256 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1 |
0.181 ms | 1 | /classes/module/Module.php:2109 | ||
| 147 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.180 ms | 0 | /classes/module/Module.php:2109 | ||
| 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.179 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 190 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 200124) AND (id_product_attribute = 38694) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.178 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 196 | SELECT SQL_NO_CACHE * FROM `ps21_product_attribute_lang` WHERE `id_product_attribute` = 38694 |
0.178 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 10 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "jprestaspeedpack" LIMIT 1 |
0.177 ms | 1 | /classes/module/Module.php:2636 | ||
| 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.177 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 148 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC |
0.175 ms | 10 | Yes | /classes/ImageType.php:109 | |
| 224 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 364032 |
0.174 ms | 1 | /classes/Product.php:2902 | ||
| 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.172 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 130 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.169 ms | 1 | /classes/Language.php:883 | ||
| 131 | SELECT SQL_NO_CACHE value FROM `ps21_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.169 ms | 1 | /classes/shop/Shop.php:1183 | ||
| 188 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 200124) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.169 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 215 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 184806 |
0.168 ms | 1 | /classes/Product.php:2902 | ||
| 61 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 3 |
0.167 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 170 | 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` = 500 LIMIT 1 |
0.167 ms | 1 | /classes/Category.php:1375 | ||
| 155 | SELECT SQL_NO_CACHE id_zthememanager FROM `ps21_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.165 ms | 1 | /modules/zonethememanager/classes/ZManager.php:177 | ||
| 268 | DELETE FROM `ps21_jm_pagecache_bl` WHERE `id`=873; |
0.165 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 182 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 500 LIMIT 1 |
0.164 ms | 1 | /classes/Product.php:5639 | ||
| 58 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 2 |
0.160 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 9 | SELECT SQL_NO_CACHE id_shop FROM `ps21_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.160 ms | 1 | /classes/ObjectModel.php:1729 | ||
| 85 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "tnzcookie" LIMIT 1 |
0.159 ms | 0 | /classes/module/Module.php:2636 | ||
| 126 | SELECT SQL_NO_CACHE * FROM `ps21_group_lang` WHERE `id_group` = 1 |
0.159 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 149 | SELECT SQL_NO_CACHE format FROM `ps21_address_format` WHERE `id_country` = 8 LIMIT 1 |
0.159 ms | 1 | /classes/AddressFormat.php:656 | ||
| 198 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 500 LIMIT 1 |
0.159 ms | 1 | /classes/Product.php:5639 | ||
| 217 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 200124 |
0.159 ms | 4 | /classes/Product.php:2902 | ||
| 234 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1 |
0.156 ms | 1 | /classes/module/Module.php:2109 | ||
| 174 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 184806 AND id_shop=1 LIMIT 1 |
0.155 ms | 1 | /classes/Product.php:6848 | ||
| 201 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 350110 AND `id_group` = 1 LIMIT 1 |
0.154 ms | 0 | /classes/GroupReduction.php:156 | ||
| 209 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 364032 AND `id_group` = 1 LIMIT 1 |
0.154 ms | 0 | /classes/GroupReduction.php:156 | ||
| 152 | SELECT SQL_NO_CACHE * FROM `ps21_country_lang` WHERE `id_country` = 8 |
0.151 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 76 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.149 ms | 0 | /classes/module/Module.php:2109 | ||
| 202 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 350110) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.149 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 127 | SELECT SQL_NO_CACHE id_shop FROM `ps21_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.147 ms | 1 | /classes/ObjectModel.php:1729 | ||
| 221 | SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps21_product_attribute` WHERE `id_product` = 350110 |
0.147 ms | 1 | /classes/Product.php:2902 | ||
| 240 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "productcomments" LIMIT 1 |
0.147 ms | 1 | /classes/module/Module.php:2636 | ||
| 57 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 2) LIMIT 1 |
0.145 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 153 | SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps21_required_field |
0.144 ms | 1 | /classes/ObjectModel.php:1592 | ||
| 158 | SELECT SQL_NO_CACHE `content` FROM `ps21_zcolorsfonts` m WHERE m.`id_shop` = 1 LIMIT 1 |
0.144 ms | 1 | /modules/zonethememanager/classes/ZManager.php:194 | ||
| 176 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_group` WHERE `id_group` = 1 LIMIT 1 |
0.143 ms | 1 | /classes/Group.php:154 | ||
| 248 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 200124) AND (id_product_attribute = 38697) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.142 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 200 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 350110 AND id_shop=1 LIMIT 1 |
0.142 ms | 1 | /classes/Product.php:6848 | ||
| 106 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.141 ms | 0 | /classes/module/Module.php:2109 | ||
| 241 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1 |
0.139 ms | 1 | /classes/module/Module.php:2109 | ||
| 249 | SELECT SQL_NO_CACHE SUM(quantity) FROM `ps21_stock_available` WHERE (id_product = 200124) AND (id_product_attribute = 38698) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.139 ms | 1 | /classes/stock/StockAvailable.php:453 | ||
| 226 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 6 AND `id_shop` = 1 LIMIT 1 |
0.138 ms | 1 | /classes/module/Module.php:2109 | ||
| 112 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.137 ms | 0 | /classes/module/Module.php:2109 | ||
| 69 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "generaldataprotectionregulation" LIMIT 1 |
0.137 ms | 0 | /classes/module/Module.php:2636 | ||
| 42 | SELECT SQL_NO_CACHE id_shop FROM `ps21_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.136 ms | 1 | /classes/ObjectModel.php:1729 | ||
| 84 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.136 ms | 0 | /classes/module/Module.php:2109 | ||
| 78 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.135 ms | 0 | /classes/module/Module.php:2109 | ||
| 175 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 184806 AND `id_group` = 1 LIMIT 1 |
0.135 ms | 0 | /classes/GroupReduction.php:156 | ||
| 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 | ||
| 267 | DELETE FROM `ps21_jm_pagecache_mods` WHERE `id`=873; |
0.134 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 93 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "pm_advancedcookiebanner" LIMIT 1 |
0.132 ms | 0 | /classes/module/Module.php:2636 | ||
| 114 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.131 ms | 0 | /classes/module/Module.php:2109 | ||
| 46 | 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 | ||
| 68 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 0 | /classes/module/Module.php:2109 | ||
| 70 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.129 ms | 0 | /classes/module/Module.php:2109 | ||
| 25 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.128 ms | 0 | /classes/module/Module.php:2109 | ||
| 64 | SELECT SQL_NO_CACHE * FROM `ps21_tax_lang` WHERE `id_tax` = 4 |
0.128 ms | 1 | /src/Adapter/EntityMapper.php:79 | ||
| 172 | SELECT SQL_NO_CACHE `name` FROM `ps21_manufacturer` WHERE `id_manufacturer` = 1154 AND `active` = 1 LIMIT 1 |
0.128 ms | 1 | /classes/Manufacturer.php:316 | ||
| 208 | SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps21_product_shop` WHERE `id_product` = 364032 AND id_shop=1 LIMIT 1 |
0.127 ms | 1 | /classes/Product.php:6848 | ||
| 232 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1 |
0.127 ms | 1 | /classes/module/Module.php:2109 | ||
| 60 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 3) LIMIT 1 |
0.126 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 91 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "systemina_employeefilter" LIMIT 1 |
0.126 ms | 0 | /classes/module/Module.php:2636 | ||
| 272 | DELETE FROM `ps21_jm_pagecache_bl` WHERE id IN (100899) |
0.126 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 229 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_searchbar" LIMIT 1 |
0.125 ms | 1 | /classes/module/Module.php:2636 | ||
| 138 | SELECT SQL_NO_CACHE * FROM `ps21_image_type` |
0.125 ms | 10 | /classes/ImageType.php:161 | ||
| 99 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ultimateimagetool" LIMIT 1 |
0.124 ms | 0 | /classes/module/Module.php:2636 | ||
| 104 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.123 ms | 0 | /classes/module/Module.php:2109 | ||
| 187 | SELECT SQL_NO_CACHE `reduction` FROM `ps21_product_group_reduction_cache` WHERE `id_product` = 200124 AND `id_group` = 1 LIMIT 1 |
0.123 ms | 0 | /classes/GroupReduction.php:156 | ||
| 273 | DELETE FROM `ps21_jm_pagecache_mods` WHERE id IN (100899) |
0.123 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:710 | ||
| 134 | SELECT SQL_NO_CACHE `id_lang` FROM `ps21_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1 |
0.122 ms | 1 | /classes/Language.php:883 | ||
| 146 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ps_legalcompliance" LIMIT 1 |
0.122 ms | 0 | /classes/module/Module.php:2636 | ||
| 118 | SELECT SQL_NO_CACHE context_key FROM `ps21_jm_pagecache_contexts` WHERE id = 1 |
0.120 ms | 1 | /modules/jprestaspeedpack/classes/JprestaUtils.php:746 | ||
| 30 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "groupinc" LIMIT 1 |
0.119 ms | 0 | /classes/module/Module.php:2636 | ||
| 63 | SELECT SQL_NO_CACHE * FROM `ps21_tax` a WHERE (a.`id_tax` = 4) LIMIT 1 |
0.119 ms | 1 | /src/Adapter/EntityMapper.php:71 | ||
| 150 | SELECT SQL_NO_CACHE `need_identification_number` FROM `ps21_country` WHERE `id_country` = 8 LIMIT 1 |
0.119 ms | 1 | /classes/Country.php:402 | ||
| 32 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "shaim_gdpr" LIMIT 1 |
0.116 ms | 0 | /classes/module/Module.php:2636 | ||
| 44 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.116 ms | 0 | /classes/module/Module.php:2109 | ||
| 24 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "superuser" LIMIT 1 |
0.114 ms | 0 | /classes/module/Module.php:2636 | ||
| 43 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ets_affiliatemarketing" LIMIT 1 |
0.114 ms | 0 | /classes/module/Module.php:2636 | ||
| 71 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "ageverify" LIMIT 1 |
0.114 ms | 0 | /classes/module/Module.php:2636 | ||
| 171 | SELECT SQL_NO_CACHE name FROM ps21_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 500 LIMIT 1 |
0.114 ms | 1 | /classes/Product.php:5639 | ||
| 116 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.113 ms | 0 | /classes/module/Module.php:2109 | ||
| 28 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "wkadminloginascustomer" LIMIT 1 |
0.112 ms | 0 | /classes/module/Module.php:2636 | ||
| 79 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "idxcookies" LIMIT 1 |
0.111 ms | 0 | /classes/module/Module.php:2636 | ||
| 105 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "dm_cookies" LIMIT 1 |
0.110 ms | 0 | /classes/module/Module.php:2636 | ||
| 159 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "pm_advancedsearch4" LIMIT 1 |
0.109 ms | 0 | /classes/module/Module.php:2636 | ||
| 38 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "smartseourl" LIMIT 1 |
0.108 ms | 0 | /classes/module/Module.php:2636 | ||
| 92 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1 |
0.108 ms | 0 | /classes/module/Module.php:2109 | ||
| 230 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1 |
0.108 ms | 1 | /classes/module/Module.php:2109 | ||
| 67 | SELECT SQL_NO_CACHE `id_module` FROM `ps21_module` WHERE `name` = "gdprpro" LIMIT 1 |
0.107 ms | 0 | /classes/module/Module.php:2636 |
