Caught redirection to https://secure.ups-trader.co.uk/order?ipa=1056

Load Time1024 ms - OK... for a shared hosting
Querying Time121 ms
Queries153
Memory Peak Usage27.6 Mb
Included Files265 files - 5.43 Mb
PrestaShop Cache- Mb
Global vars0.76 Mb
PrestaShop Version1.6.1.24
PHP Version7.0.33-11+ubuntu18.04.1+deb.sury.org+1 (OK)
MySQL Version5.6.35-1+deb.sury.org~xenial+0.1 (OK)
Memory Limit8192M
Max Execution Time30s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 93 ms 93 ms 10.34 Mb 10.62 Mb
__construct 0 ms 93 ms - Mb 10.62 Mb
init 19 ms 112 ms 2.70 Mb 13.62 Mb
checkAccess 0 ms 112 ms - Mb 13.62 Mb
setMedia 19 ms 131 ms 1.06 Mb 14.24 Mb
postProcess 153 ms 285 ms 4.57 Mb 18.92 Mb
initHeader 0 ms 285 ms - Mb 18.92 Mb
initContent 722 ms 1007 ms 8.84 Mb 27.56 Mb
initFooter 17 ms 1024 ms 0.02 Mb 27.57 Mb
Hook Time Memory Usage
__construct 180 ms 10.00 Mb
hooktop 131 ms - Mb
hookdisplayHeader 33 ms - Mb
hookactionObjectCartAddAfter 31 ms 2.00 Mb
hookHeader 15 ms - Mb
hookdisplayTop 5 ms - Mb
hookactionCartSave 5 ms - Mb
hookdisplayFooter 4 ms - Mb
hookfooter 0 ms - Mb
hookmoduleRoutes - ms - Mb
hookactionFrontControllerSetMedia - ms - Mb
hookactionBeforeCartUpdateQty - ms - Mb
hookdisplayProductPriceBlock - ms - Mb
13 hooks 404 ms 12.00 Mb
Module Time Memory Usage
blockcart 126 ms - Mb
productvideo 38 ms 2.00 Mb
facebookpsconnect 35 ms - Mb
gamification 32 ms 2.00 Mb
paypal 29 ms - Mb
blocktopmenu 14 ms - Mb
fedexdotcom 11 ms - Mb
blockcms 10 ms - Mb
wpstyleswitcher 10 ms - Mb
blocksearch 10 ms - Mb
pm_applepay 8 ms 2.00 Mb
productcomments 8 ms 2.00 Mb
blocklayered 8 ms - Mb
wpbxslider 7 ms - Mb
revolutpayment 7 ms 2.00 Mb
ganalytics 7 ms - Mb
xenforum 6 ms - Mb
sekeywords 5 ms 2.00 Mb
testimonialswithavatars 4 ms - Mb
wpcopylogo 4 ms - Mb
wpmanufacturerlogos 3 ms - Mb
wphomefeatured 3 ms - Mb
blocktags 3 ms - Mb
productscategory 3 ms - Mb
wpblockspecials 3 ms - Mb
wpblocknewproducts 2 ms - Mb
blockcontact 2 ms - Mb
wpzoom 2 ms - Mb
blockmyaccount 2 ms - Mb
pagesnotfound 2 ms - Mb
blockcategories 1 ms - Mb
blockbestsellers 1 ms - Mb
32 modules 404 ms 12.00 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 153 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE c.`id_condition`
FROM `ps_condition` c
LEFT JOIN `ps_condition_advice` ca ON ca.`id_condition` = c.`id_condition`
WHERE (c.`calculation_type` = 'hook') AND (c.`calculation_detail` = 'actionObjectCartAddAfter') AND (c.`validated` = 0) AND (ca.`id_advice` IN (19190,19241,19292,19343,19394,19445,19496,19542,19588,19634,19680,19726,19772,19818,19863,19908,19953,19998,20043,20088,20133,20178,20223,20268,20269,20276,20315,20316,20323,20362,20363,20370,20409,20410,20417,20456,20457,20464,20503,20504,20511,20550,20551,20558,20597,20598,20605,20644,20645,20652,20691,20692,20699,20738,20739,20746,20785,20786,20793,20832,20833,20840,20879,20880,20887,20893,20927,20928,20935,20941,20975,20976,20983,20989,21023,21024,21031,21037,21070,21071,21078,21084,21117,21118,21125,21131,21164,21165,21172,21178,21211,21212,21219,21225,21258,21259,21266,21272,21305,21306,21313,21319,21352,21353,21360,21366,21399,21400,21407,21413,21446,21447,21454,21460,21493,21494,21501,21507,21540,21541,21548,21554,21587,21588,21595,21601,21634,21635,21642,21648,21681,21682,21689,21695,21728,21729,21736,21742,21775,21776,21783,21789,21822,21823,21830,21836,21869,21870,21877,21883,21916,21917,21924,21930,21963,21964,21971,21977,22010,22011,22018,22024,22057,22058,22065,22071,22104,22105,22112,22118,22151,22152,22159,22165,22198,22199,22206,22212,22245,22246,22253,22259,22292,22293,22300,22306,22339,22340,22347,22353,22386,22387,22394,22400,22433,22434,22441,22447,22480,22481,22488,22494,22527,22528,22535,22541,22574,22575,22582,22588,22621,22622,22629,22635,22668,22669,22676,22682,22715,22716,22723,22729,22762,22763,22770,22776,22809,22810,22817,22823,22856,22857,22864,22870,22903,22904,22911,22917,22950,22951,22958,22964,22997,22998,23005,23011,23044,23045,23052,23058,23091,23092,23099,23105,23138,23139,23146,23152,23185,23186,23193,23199,23232,23233,23239,23245,23278,23279,23285,23291,23324,23325,23331,23337,23370,23371,23377,23383,23416,23417,23423,23429,23462,23463,23469,23474,23507,23508,23514,23519,23552,23553,23559,23564,23597,23598,23604,23609,23642,23643,23649,23654,23687,23688,23694,23699,23732,23733,23739,23744,23777,23778,23784,23789,23821,23824,23828,23829,23830,23837,23857,23860,23864,23865,23866,23873,23893,23896,23900,23901,23902,23909,23929,23932,23936,23937,23938,23945,23965,23967,23971,23972,23973,23974,23980,23999,24001,24005,24006,24007,24008,24014,24033,24035,24039,24040,24041,24042,24048,24067,24069,24073,24074,24075,24076,24082,24101,24103,24107,24108,24109,24110,24116,24135,24137,24141,24142,24143,24144,24150,24169,24171,24175,24176,24177,24178,24184,24203,24205,24209,24210,24211,24212,24218,24237,24238,24240,24244,24245,24246,24247,24253,24272,24273,24275,24279,24280,24281,24282,24288,24307,24308,24310,24314,24315,24316,24317,24323,24342,24343,24345,24349,24350,24351,24352,24358,24377,24378,24380,24384,24385,24386,24387,24393,24412,24413,24415,24419,24420,24421,24422,24423,24429,24448,24449,24451,24455,24456,24457,24458,24459,24465,24484,24485,24487,24491,24492,24493,24494,24495,24501,24520,24521,24523,24527,24528,24529,24530,24531,24537,24556,24557,24559,24563,24564,24565,24566,24567,24573,24592,24593,24595,24599,24600,24601,24602,24603,24609,24628,24629,24631,24635,24636,24637,24638,24639,24645,24664,24665,24666,24667,24668,24671,24675,24676,24677,24678,24679,24680,24681,24707,24708,24709,24710,24711,24714,24718,24719,24720,24721,24722,24723,24724,24750,24751,24752,24753,24754,24757,24761,24762,24763,24764,24765,24766,24767,24793,24794,24795,24796,24797,24800,24804,24805,24806,24807,24808,24809,24810,24836,24837,24838,24839,24840,24843,24847,24848,24849,24850,24851,24852,24853,24879,24880,24881,24882,24883,24886,24890,24891,24892,24893,24894,24895,24896,24922,24923,24924,24925,24926,24929,24933,24934,25001,25002,25003,25004,25005,25008,25012,25013,25014,25015,25016,25017,25033,25034,25035,25036,25037,25040,25044,25045,25046,25047,25048,25049,25065,25066,25067,25068,25069,25072,25076,25077,25078,25079,25080,25081,25097,25098,25099,25100,25101,25104,25108,25109,25110,25111,25112,25113,25129,25130,25131,25132,25133,25136,25140,25141,25142,25143,25144,25145,25161,25162,25163,25164,25165,25168,25172,25173,25174,25175,25176,25177,25193,25194,25195,25196,25197,25200,25204,25205,25206,25207,25208,25209,25225,25226,25227,25228,25229,25232,25236,25237,25238,25239,25240,25241,25257,25258,25259,25260,25261,25264,25268,25269,25270,25271,25272,25273,25289,25290,25291,25292,25293,25296,25300,25301,25302,25303,25304,25305,25321,25322,25323,25324,25325,25328,25332,25333,25334,25335,25336,25337,25353,25354,25355,25356,25357,25360,25364,25365,25366,25367,25368,25369,25385,25386,25387,25388,25389,25392,25396,25397,25398,25399,25400,25401,25417,25418,25419,25420,25421,25424,25428,25429,25430,25431,25432,25433,25449,25450,25451,25452,25453,25456,25460,25461,25462,25463,25464,25465,25481,25482,25483,25484,25485,25488,25492,25493,25494,25495,25496,25497,25513,25514,25515,25516,25517,25520,25524,25525,25526,25527,25528,25529,25545,25546,25547,25548,25549,25552,25556,25557,25558,25559,25560,25561,25577,25578,25579,25580,25581,25584,25588,25589,25590,25591,25592,25604,25605,25606,25607,25608,25611,25615,25616,25617,25618,25619,25631,25632,25633,25634,25635,25638,25642,25643,25644,25645,25646,25658,25659,25660,25661,25662,25665,25669,25670,25671,25672,25673,25685,25686,25687,25688,25689,25692,25696,25697,25698,25699,25700,25712,25713,25714,25715,25716,25719,25723,25724,25725,25726,25727,25739,25740,25741,25742,25743,25746,25750,25751,25752,25753,25754,25766,25767,25768,25769,25770,25773,25777,25778,25779,25780,25792,25793,25794,25795,25796,25799,25803,25804,25805,25806,25818,25819,25820,25821,25822,25825,25829,25830,25831,25832,25844,25845,25846,25847,25848,25851,25855,25856,25857,25858,25870,25871,25872,25873,25874,25877,25881,25882,25883,25884,25896,25897,25898,25899,25900,25903,25907,25908,25909,25910,25922,25923,25924,25925,25926,25929,25933,25934,25935,25936,25948,25949,25950,25951,25952,25955,25959,25960,25961,25962,25974,25975,25976,25977,25978,25981,25985,25986,25987,25988,26000,26001,26002,26003,26004,26007,26011,26012,26013,26014,26026,26027,26028,26029,26030,26033,26037,26038,26039,26040,26052,26053,26054,26055,26056,26059,26063,26064,26065,26066,26078,26079,26080,26081,26082,26085,26089,26090,26091,26092,26104,26105,26106,26107,26108,26111,26115,26116,26117,26118,26130,26131,26132,26133,26134,26137,26141,26142,26143,26144,26156,26157,26158,26159,26160,26163,26167,26168,26169,26170,26182,26183,26184,26185,26186,26189,26193,26194,26195,26196,26208,26209,26210,26211,26212,26215,26219,26220,26221,26222,26234,26235,26236,26237,26238,26241,26245,26246,26247,26248,26260,26261,26262,26263,26264,26267,26271,26272,26273,26274,26286,26287,26288,26289,26290,26293,26297,26298,26299,26300,26312,26313,26314,26315,26316,26319,26323,26324,26325,26326,26338,26339,26340,26341,26342,26345,26349,26350,26351,26352,26364,26365,26366,26367,26368,26371,26375,26376,26377,26378,26390,26391,26392,26393,26394,26397,26401,26402,26403,26404,26416,26417,26418,26419,26420,26423,26427,26428,26429,26430,26442,26443,26444,26445,26446,26449,26453,26454,26455,26456,26468,26469,26470,26471,26472,26475,26479,26480,26481,26482,26494,26495,26496,26497,26498,26501,26505,26506,26507,26508,26520,26521,26522,26523,26524,26527,26531,26532,26533,26534,26546,26547,26548,26549,26550,26553,26557,26558,26559,26560,26572,26573,26574,26575,26576,26579,26583,26584,26585,26586,26598,26599,26600,26601,26602,26605,26609,26610,26611,26612,26624,26625,26626,26627,26628,26631,26635,26636,26637,26638,26650,26651,26652,26653,26654,26657,26661,26662,26663,26664,26676,26677,26678,26679,26680,26683,26687,26688,26689,26690,26702,26703,26704,26705,26706,26709,26713,26714,26715,26716,26728,26729,26730,26731,26732,26735,26739,26740,26741,26742,26754,26755,26756,26757,26758,26761,26765,26766,26767,26768,26780,26781,26782,26783,26784,26787,26791,26792,26793,26794,26806,26807,26808,26809,26810,26813,26817,26818,26819,26820,26832,26833,26834,26835,26836,26839,26843,26844,26845,26846,26858,26859,26860,26861,26862,26865,26869,26870,26871,26872,26884,26885,26886,26887,26888,26891,26895,26896,26897,26898,26910,26911,26912,26913,26914,26917,26921,26922,26923,26924,26936,26937,26938,26939,26940,26943,26947,26948,26949,26950,26962,26963,26964,26965,26966,26969,26973,26974,26975,26976,26988,26989,26990,26991,26992,26995,26999,27000,27001,27002,27014,27015,27016,27017,27018,27021,27025,27026,27027,27028,27040,27041,27042,27043,27044,27047,27051,27052,27053,27054,27066,27067,27068,27069,27070,27073,27077,27078,27079,27080,27092,27093,27094,27095,27096,27099,27103,27104,27105,27106,27118,27119,27120,27121,27122,27125,27129,27130,27131,27132,27144,27145,27146,27147,27148,27151,27155,27156,27157,27158,27170,27171,27172,27173,27174,27177,27181,27182,27183,27184,27196,27197,27198,27199,27200,27203,27207,27208,27209,27210,27222,27223,27224,27225,27226,27229,27233,27234,27235,27236,27248,27249,27250,27251,27252,27255,27259,27260,27261,27262,27274,27275,27276,27277,27278,27281,27285,27286,27287,27288,27300,27301,27302,27303,27304,27307,27311,27312,27313,27314,27326,27327,27328,27329,27330,27331,27334,27338,27339,27340,27341,27353,27354,27355,27356,27357,27358,27361,27365,27366,27367,27368,27380,27381,27382,27383,27384,27385,27388,27392,27393,27394,27395,27407,27408,27409,27410,27411,27412,27415,27419,27420,27421,27422,27434,27435,27436,27437,27438,27439,27442,27446,27447,27448,27449,27461,27462,27463,27464,27465,27466,27469,27473,27474,27475,27476,27488,27489,27490,27491,27492,27493,27496,27500,27501,27502,27503,27515,27516,27517,27518,27519,27520,27523,27527,27528,27529,27530,27542,27543,27544,27545,27546,27547,27550,27554,27555,27556,27557,27569,27570,27571,27572,27573,27574,27577,27581,27582,27583,27584,27596,27597,27598,27599,27600,27601,27604,27608,27609,27610,27611,27623,27624,27625,27626,27627,27628,27631,27635,27636,27637,27638,27650,27651,27652,27653,27654,27655,27658,27662,27663,27664,27665,27677,27678,27679,27680,27681,27682,27685,27689,27690,27691,27692,27704,27705,27706,27707,27708,27709,27712,27716,27717,27718,27719,27720,27732,27733,27734,27735,27736,27737,27740,27744,27745,27746,27747,27748,27760,27761,27762,27763,27764,27765,27768,27772,27773,27774,27775,27776,27788,27789,27790,27791,27792,27793,27796,27800,27801,27802,27803,27804,27816,27817,27818,27819,27820,27821,27824,27828,27829,27830,27831,27832,27844,27845,27846,27847,27848,27849,27852,27856,27857,27858,27859,27860,27872,27873,27874,27875,27876,27877,27880,27884,27885,27886,27887,27888,27900,27901,27902,27903,27904,27905,27908,27912,27913,27914,27915,27916,27928,27929,27930,27931,27932,27933,27936,27940,27941,27942,27943,27944,27956,27957,27958,27959,27960,27961,27964,27968,27969,27970,27971,27972,27978,27979,27980,27981,27984,27988,27989,27990,27991,27992,27998,27999,28000,28001,28004,28008,28009,28010,28011,28012,28018,28019,28020,28021,28024,28028,28029,28030,28031,28032,28038,28039,28040,28041,28044,28048,28049,28050,28051,28052,28058,28059,28060,28061,28064,28068,28069,28070,28071,28072,28078,28079,28080,28081,28084,28088,28089,28090,28091,28092,28098,28099,28100,28103,28107,28108,28109,28110,28111,28112,28118,28119,28120,28123,28127,28128,28129,28130,28131,28132,28136,28137,28138,28141,28145,28146,28147,28148,28149,28150,28154,28155,28156,28159,28163,28164,28165,28166,28167,28168,28172,28173,28174,28177,28181,28182,28183,28184,28185,28186,28190,28191,28192,28195,28199,28200,28201,28202,28203,28204,28208,28209,28210,28213,28217,28218,28219,28220,28221,28222,28226,28227,28228,28231,28235,28236,28237,28238,28239,28240,28241,28245,28246,28247,28250,28254,28255,28256,28257,28258,28259,28260,28264,28265,28266,28269,28273,28274,28275,28276,28277,28278,28279,28283,28284,28285,28288,28292,28293,28294,28295,28296,28297,28298,28302,28303,28304,28307,28311,28312,28313,28314,28315,28316,28317,28321,28322,28323,28326,28330,28331,28332,28333,28334,28335,28336,28340,28341,28342,28343,28344,28345,28346,28347,28348,28349,28350,28351,28352,28353,28354,28355,28356,28357,28358))
GROUP BY c.`id_condition`
 26 36984 Yes Yes /modules/gamification/classes/Condition.php:143 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND d.`id_carrier` = 477
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter2` DESC LIMIT 1
 9.5 182 Yes /classes/Carrier.php:315 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 477
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 9.5 182 Yes /classes/Carrier.php:292 
INSERT INTO `ps_cart_product` (`id_product`, `id_product_attribute`, `id_cart`, `id_address_delivery`, `id_shop`, `quantity`, `date_add`) VALUES ('1056', '0', '78934', '0', '1', '1', '2026-05-01 13:57:51')
 6.8 1 /classes/Cart.php:1058 
UPDATE `ps_cart` SET `id_cart` = '78934',`id_shop_group` = '1',`id_shop` = '1',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '2026-05-01 13:57:50',`date_upd` = '2026-05-01 13:57:51' WHERE `id_cart` = 78934
 3.5 1 /classes/ObjectModel.php:652 
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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 3.3 1448 /classes/Configuration.php:148 
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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 3.3 1448 /classes/Configuration.php:148 
INSERT INTO `ps_cart` (`id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES ('1', '1', '0', '0', '0', '1', '0', '0', '1', '0', '0', '', '0', '', '', '0', '2026-05-01 13:57:50', '2026-05-01 13:57:50')
 3 1 /classes/ObjectModel.php:487 
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
p.`reference` AS reference, p.`ean13`,
p.`upc` AS upc, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON 
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1
WHERE (cp.`id_cart` = 78934) AND (p.`id_product` IS NOT NULL)
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
 2.9 1 /classes/Cart.php:580 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND cr.date_from < "2026-05-01 13:57:50"
AND cr.date_to > "2026-05-01 13:57:50"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND cr.date_from < "2026-05-01 13:57:50"
AND cr.date_to > "2026-05-01 13:57:50"
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
 2.2 1 /classes/CartRule.php:291 
SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `ps_cart_cart_rule` cd
LEFT JOIN `ps_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `ps_cart_rule_lang` crl ON (
cd.`id_cart_rule` = crl.`id_cart_rule`
AND crl.id_lang = 1
)
WHERE `id_cart` = 78934
ORDER by cr.priority ASC
 2.2 1 Yes /classes/Cart.php:383 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 1.6 422 /classes/Hook.php:235 
SELECT SQL_NO_CACHE id_advice
FROM `ps_advice` a
 1.4 1932 /modules/gamification/classes/Condition.php:124 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_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 `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 1.4 59 Yes Yes /classes/Hook.php:355 
SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `ps_cart_cart_rule` cd
LEFT JOIN `ps_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `ps_cart_rule_lang` crl ON (
cd.`id_cart_rule` = crl.`id_cart_rule`
AND crl.id_lang = 1
)
WHERE `id_cart` = 78934
AND (reduction_percent != 0 OR reduction_amount != 0) ORDER by cr.priority ASC
 1.3 1 Yes /classes/Cart.php:383 
SELECT SQL_NO_CACHE c.*, cl.delay
FROM `ps_carrier` c
LEFT JOIN `ps_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`)LEFT JOIN `ps_zone` z ON (z.`id_zone` = 1)
INNER JOIN ps_carrier_shop carrier_shop
ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1  AND cz.`id_zone` = 1 AND z.`active` = 1  AND EXISTS (SELECT 1 FROM ps_carrier_group
WHERE ps_carrier_group.id_carrier = c.id_carrier
AND id_group IN (3))  AND (c.is_module = 0 OR c.need_range = 1)  GROUP BY c.`id_carrier` ORDER BY c.`position` ASC
 1.3 9 Yes Yes /classes/Carrier.php:497 
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
p.`reference` AS reference, p.`ean13`,
p.`upc` AS upc, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON 
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1
WHERE (cp.`id_cart` = 78934) AND (p.`id_product` IS NOT NULL)
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
 1.2 1 /classes/Cart.php:580 
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
p.`reference` AS reference, p.`ean13`,
p.`upc` AS upc, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON 
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1
WHERE (cp.`id_cart` = 78934) AND (p.`id_product` IS NOT NULL)
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
 1.2 1 /classes/Cart.php:580 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
 1.2 0 /classes/Hook.php:131 
SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `ps_cart_cart_rule` cd
LEFT JOIN `ps_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `ps_cart_rule_lang` crl ON (
cd.`id_cart_rule` = crl.`id_cart_rule`
AND crl.id_lang = 1
)
WHERE `id_cart` = 78934
AND gift_product != 0
ORDER by cr.priority ASC
 1 1 Yes /classes/Cart.php:383 
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND cr.date_from < "2026-05-01 13:57:51"
AND cr.date_to > "2026-05-01 13:57:51"
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND cr.date_from < "2026-05-01 13:57:51"
AND cr.date_to > "2026-05-01 13:57:51"
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
 0.9 1 /classes/CartRule.php:291 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 0.9 3 /classes/Currency.php:470 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 0, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country`  = 0 AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-05-01 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-01 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.7 1 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND d.`id_carrier` = 513
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter2` DESC LIMIT 1
 0.7 6 Yes /classes/Carrier.php:315 
SELECT SQL_NO_CACHE cr.*
FROM ps_cart_rule cr
LEFT JOIN ps_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN ps_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN ps_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND cr.date_from < "2026-05-01 13:57:51"
AND cr.date_to > "2026-05-01 13:57:51"
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
)
AND (
cr.`group_restriction` = 0
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `ps_cart_product`
WHERE `ps_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 78934
)
)
AND NOT EXISTS (SELECT 1 FROM ps_cart_cart_rule WHERE cr.id_cart_rule = ps_cart_cart_rule.id_cart_rule
AND id_cart = 78934)
ORDER BY priority
 0.7 1 Yes /classes/CartRule.php:1350 
SELECT SQL_NO_CACHE cr.*
FROM ps_cart_rule cr
LEFT JOIN ps_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN ps_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN ps_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND cr.date_from < "2026-05-01 13:57:51"
AND cr.date_to > "2026-05-01 13:57:51"
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
)
AND (
cr.`group_restriction` = 0
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `ps_cart_product`
WHERE `ps_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 78934
)
)
AND NOT EXISTS (SELECT 1 FROM ps_cart_cart_rule WHERE cr.id_cart_rule = ps_cart_cart_rule.id_cart_rule
AND id_cart = 78934)
ORDER BY priority
 0.7 1 Yes /classes/CartRule.php:1350 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-05-01 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-01 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.7 1 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 513
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.7 6 Yes /classes/Carrier.php:292 
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
p.`reference` AS reference, p.`ean13`,
p.`upc` AS upc, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON 
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT JOIN ps_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1
WHERE (cp.`id_cart` = 78934) AND (p.`id_product` IS NOT NULL)
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
 0.6 1 /classes/Cart.php:580 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`)
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 513
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.6 6 Yes /classes/Carrier.php:262 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1056) LIMIT 1
 0.6 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5e593a38bbb1f55007b6f0fe7cdd1847' AND cache_id="blocksearch-top|1|1|17" AND compile_id="" LIMIT 1
 0.6 1 /classes/SmartyCustom.php:215 
SELECT SQL_NO_CACHE c.`id_condition`
FROM `ps_condition` c
LEFT JOIN `ps_condition_badge` cb ON cb.`id_condition` = c.`id_condition`
WHERE (c.`calculation_type` = 'hook') AND (c.`calculation_detail` = 'actionObjectCartAddAfter') AND (c.`validated` = 0) AND (cb.`id_badge` IN (21,22,23,24,25,26,27,28,45,46,47,48,49,50,51,52,53,54,55,56,57,58,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,155,163,164,166,167,168,172,173,174,175,176,177,178,185,186,193,194,195,196,201,202,207,208,212,213,214,219,220,226,227,228,229,230,231,232,233,234,235,236,237,242,243,244,245,246,247,248,249,250,254,255,256,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276))
GROUP BY c.`id_condition`
 0.5 244 Yes /modules/gamification/classes/Condition.php:114 
SELECT SQL_NO_CACHE id_carrier
FROM `ps_product_carrier` pc
INNER JOIN `ps_carrier` c ON c.id_reference = pc.id_carrier_reference AND c.deleted = 0 AND c.active = 1
WHERE (pc.id_product = 1056) AND (pc.id_shop = 1)
 0.5 1 /classes/Carrier.php:1329 
SELECT SQL_NO_CACHE * FROM `ps_image_type`
 0.5 11 /classes/ImageType.php:143 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
 0.5 0 /classes/SmartyCustom.php:95 
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 513 AND `id_shop` = 1
 0.5 71 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND d.`id_carrier` = 563
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter2` DESC LIMIT 1
 0.5 2 Yes /classes/Carrier.php:315 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
 0.4 0 /classes/SmartyCustom.php:142 
SELECT SQL_NO_CACHE `server`, `getvar` FROM `ps_search_engine`
 0.4 38 /modules/sekeywords/sekeywords.php:194 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2629ca8d3916ddd1e595e8af85877786' AND cache_id="blocktopmenu|1|1|17|index" AND compile_id="" LIMIT 1
 0.4 1 /classes/SmartyCustom.php:215 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`)
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 563
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.4 2 Yes /classes/Carrier.php:262 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 513) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 513) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE SUM(p.`weight` * cp.`quantity`) as nb
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` p ON (cp.`id_product` = p.`id_product`)
WHERE (cp.`id_product_attribute` IS NULL OR cp.`id_product_attribute` = 0)
AND cp.`id_cart` = 78934 LIMIT 1
 0.4 1 /classes/Cart.php:3094 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
 0.4 93 /classes/module/Module.php:277 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 17
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.4 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`)
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 521
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.4 6 Yes /classes/Carrier.php:262 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
 0.4 93 /classes/module/Module.php:277 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 521
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.4 6 Yes /classes/Carrier.php:292 
SELECT SQL_NO_CACHE * FROM ps_product_videos WHERE id_product = 1056 AND id_lang = 1 AND id_shop = 1 ORDER BY position ASC
 0.4 1 Yes /modules/productvideo/productvideo.php:3079 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND d.`id_carrier` = 521
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter2` DESC LIMIT 1
 0.4 6 Yes /classes/Carrier.php:315 
SELECT SQL_NO_CACHE stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
FROM ps_product p
INNER JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product = 1056 LIMIT 1
 0.4 1 /classes/Cart.php:1034 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 17) LIMIT 1
 0.4 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 380
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.4 2 Yes /classes/Carrier.php:292 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.4 55 Yes /classes/Dispatcher.php:452 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`)
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 383
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.4 2 Yes /classes/Carrier.php:262 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`)
WHERE d.`id_zone` = 1
AND 8 >= w.`delimiter1`
AND 8 < w.`delimiter2`
AND d.`id_carrier` = 380
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter1` ASC LIMIT 1
 0.3 2 Yes /classes/Carrier.php:262 
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 ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_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.3 1 Yes /classes/shop/Shop.php:663 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 1056 AND `id_shop` = 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE * FROM `ps_fbpsc_connector_position`
 0.3 6 /modules/facebookpsconnect/lib/module-dao_class.php:366 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND d.`id_carrier` = 383
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter2` DESC LIMIT 1
 0.3 2 Yes /classes/Carrier.php:315 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
WHERE d.`id_zone` = 1
AND d.`id_carrier` = 380
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_weight` = `d`.`id_range_weight`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY w.`delimiter2` DESC LIMIT 1
 0.3 2 Yes /classes/Carrier.php:315 
SELECT SQL_NO_CACHE cp.`quantity` FROM `ps_cart_product` cp
WHERE cp.`id_product` = 1056
AND cp.`id_product_attribute` = 0
AND cp.`id_cart` = 78934 LIMIT 1
 0.3 1 /classes/Cart.php:900 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 513 AND id_shop=1 LIMIT 1
 0.3 1 /classes/Carrier.php:1075 
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 563 AND `id_shop` = 1
 0.3 71 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE * FROM ps_product_videos_providers
 0.3 2 /modules/productvideo/classes/ThumbNail.php:149 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-05-01 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-05-01 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.3 1 Yes /classes/SpecificPrice.php:362 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1056) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `ps_cart_product`
WHERE `id_product` = 1056
AND `id_cart` = 78934 LIMIT 1
 0.3 1 /classes/Product.php:2835 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_cart`) FROM `ps_specific_price` WHERE `id_cart` != 0 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:230 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 563) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'secure.ups-trader.co.uk' OR su.domain_ssl = 'secure.ups-trader.co.uk')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.3 1 Yes /classes/shop/Shop.php:334 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 563) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE id_badge
FROM `ps_badge` b
WHERE (b.`validated` = 0)
 0.3 234 /modules/gamification/classes/Condition.php:96 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1
 0.3 1 /classes/Language.php:680 
SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1
 0.3 1 /modules/paypal/paypal.php:329 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
 0.3 0 /classes/Category.php:1054 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 17
 0.3 1 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT 1
 0.3 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'es' LIMIT 1
 0.3 1 /classes/Language.php:680 
SELECT SQL_NO_CACHE count(distinct id_address_delivery)
FROM `ps_cart_product` cp
WHERE (id_cart = 78934) LIMIT 1
 0.3 1 /classes/Cart.php:2499 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'it' LIMIT 1
 0.2 1 /classes/Language.php:680 
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr' LIMIT 1
 0.2 1 /classes/Language.php:680 
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 521 AND `id_shop` = 1
 0.2 71 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 380 AND `id_shop` = 1
 0.2 71 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 380) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 561 AND `id_shop` = 1
 0.2 71 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 477 AND `id_shop` = 1
 0.2 71 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE *
FROM `ps_carrier_lang`
WHERE `id_carrier` = 383 AND `id_shop` = 1
 0.2 71 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 17
AND tr.`id_tax_rules_group` = 11
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.2 1 Yes /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 561) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 521) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.2 1 /classes/shop/Shop.php:202 
SELECT SQL_NO_CACHE `id_address` FROM ps_address a WHERE a.`id_address` = 0 LIMIT 1
 0.2 0 /classes/Address.php:344 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 380) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE * FROM ps_memcached_servers
 0.2 1 /classes/cache/CacheMemcached.php:230 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 563 AND id_shop=1 LIMIT 1
 0.2 1 /classes/Carrier.php:1075 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 561) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 521) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 383) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 477) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 0.2 78 /classes/SpecificPrice.php:230 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.2 1 /classes/shop/Shop.php:1067 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
 0.2 9 Yes /classes/Currency.php:231 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_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.2 1 /classes/Language.php:892 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.2 86 /classes/Hook.php:187 
SELECT SQL_NO_CACHE *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = 1
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 383) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 383 AND id_shop=1 LIMIT 1
 0.2 1 /classes/Carrier.php:1075 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
 0.2 76 /classes/SpecificPrice.php:238 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 380 AND id_shop=1 LIMIT 1
 0.2 1 /classes/Carrier.php:1075 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 561 AND id_shop=1 LIMIT 1
 0.2 1 /classes/Carrier.php:1075 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 521 AND id_shop=1 LIMIT 1
 0.2 1 /classes/Carrier.php:1075 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 17) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "cart" LIMIT 1
 0.2 1 /classes/Theme.php:275 
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 1056
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2026-05-01 00:00:00",
INTERVAL 50 DAY
)
) > 0
 0.1 0 /classes/Product.php:1278 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.1 1 /classes/Language.php:777 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.1 1 /classes/Language.php:777 
CREATE TABLE IF NOT EXISTS `ps_revolut_payment_orders` (
`id` INT NOT NULL AUTO_INCREMENT,
`id_order` INT NULL ,
`id_cart` INT NULL ,
`id_revolut_order` VARCHAR(250) NOT NULL ,
`payment_method` VARCHAR(250) NULL ,
`public_id` VARCHAR(250) NOT NULL ,
`save_card` TINYINT NOT NULL DEFAULT "0" ,
PRIMARY KEY (`id`),
UNIQUE (`id_revolut_order`),
UNIQUE (`id_order`)
) ENGINE = InnoDB;
 0.1 1 /modules/revolutpayment/revolutpayment.php:400 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/shop/ShopUrl.php:169 
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "cart"
OR m.page = "cart"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
 0.1 1 /classes/Meta.php:149 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_carrier_tax_rules_group_shop`
WHERE `id_carrier` = 477 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Carrier.php:1075 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=1056
 0.1 3 /classes/Tag.php:205 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1458 
SELECT SQL_NO_CACHE * FROM ps_cart_cart_rule WHERE id_cart = 78934
 0.1 1 /classes/Cart.php:2249 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2026-05-01 00:00:00' AND '2026-05-01 23:59:59' LIMIT 1
 0.1 1 /classes/SpecificPrice.php:302 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 8
AND `active` = 1 LIMIT 1
 0.1 1 /classes/Manufacturer.php:246 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2026-05-01 00:00:00' AND '2026-05-01 23:59:59' LIMIT 1
 0.1 1 /classes/SpecificPrice.php:306 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1458 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 1056)
 0.1 1 /classes/Product.php:3002 
SELECT SQL_NO_CACHE `name` FROM `ps_hook_alias` WHERE `alias` = 'actionObjectCartAddAfter' LIMIT 1
 0.1 0 /modules/gamification/gamification.php:190 
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
 0.1 0 /classes/Supplier.php:192 
CREATE TABLE IF NOT EXISTS `ps_revolut_cards` (
`id` INT NOT NULL AUTO_INCREMENT,
`customer_id` INT NOT NULL ,
`card_number` VARCHAR(25) NOT NULL,
`expire_month` INT NOT NULL ,
`expire_year` INT NOT NULL ,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
 0.1 1 /modules/revolutpayment/revolutpayment.php:411 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1056) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:380 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.1 1 /classes/module/Module.php:2141 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1056) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:672 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1056) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:672 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 1056
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1056) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:648 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1458 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1056 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5037 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.1 1 /classes/ObjectModel.php:1376 
SELECT SQL_NO_CACHE `price_display_method`
FROM `ps_group`
WHERE `id_group` = 3 LIMIT 1
 0.1 1 /classes/Group.php:144

Doubles

7
SELECT *
							FROM `ps_carrier_lang`
							WHERE `id_carrier` = XX AND `id_shop` = XX
7
SELECT *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = XX
WHERE (a.`id_carrier` = XX) LIMIT XX
7
							SELECT `id_tax_rules_group`
							FROM `ps_carrier_tax_rules_group_shop`
							WHERE `id_carrier` = XX AND id_shop=XX LIMIT XX
6
SELECT *
FROM `ps_carrier` a
LEFT JOIN `ps_carrier_lang` `b` ON a.`id_carrier` = b.`id_carrier` AND b.`id_lang` = XX
LEFT JOIN `ps_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = XX
WHERE (a.`id_carrier` = XX) AND (b.`id_shop` = XX) LIMIT XX
6
SELECT d.`price`
					FROM `ps_delivery` d
					INNER JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
					WHERE d.`id_zone` = XX
						AND d.`id_carrier` = XX
						AND d.id_delivery = (
					SELECT dXX.id_delivery
					FROM ps_delivery dXX
					WHERE dXX.id_carrier = `d`.id_carrier
						AND dXX.id_zone = `d`.id_zone
						AND dXX.`id_range_weight` = `d`.`id_range_weight`
						AND (dXX.id_shop = XX OR (dXX.id_shop_group = XX
					AND dXX.id_shop IS NULL) OR (dXX.id_shop_group IS NULL AND dXX.id_shop IS NULL))
					ORDER BY dXX.id_shop DESC, dXX.id_shop_group DESC
					LIMIT XX
				)
					ORDER BY w.`delimiterXX` DESC LIMIT XX
5
SELECT d.`price`
					FROM `ps_delivery` d
					LEFT JOIN `ps_range_weight` w ON (d.`id_range_weight` = w.`id_range_weight`)
					WHERE d.`id_zone` = XX
						AND XX >= w.`delimiterXX`
						AND XX < w.`delimiterXX`
						AND d.`id_carrier` = XX
						AND d.id_delivery = (
					SELECT dXX.id_delivery
					FROM ps_delivery dXX
					WHERE dXX.id_carrier = `d`.id_carrier
						AND dXX.id_zone = `d`.id_zone
						AND dXX.`id_range_weight` = `d`.`id_range_weight`
						AND (dXX.id_shop = XX OR (dXX.id_shop_group = XX
					AND dXX.id_shop IS NULL) OR (dXX.id_shop_group IS NULL AND dXX.id_shop IS NULL))
					ORDER BY dXX.id_shop DESC, dXX.id_shop_group DESC
					LIMIT XX
				)
					ORDER BY w.`delimiterXX` ASC LIMIT XX
4
SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`,
						pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
						p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
						product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
						stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
						p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, XX) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
						CONCAT(LPAD(cp.`id_product`, XX, XX), LPAD(IFNULL(cp.`id_product_attribute`, XX), XX, XX), IFNULL(cp.`id_address_delivery`, XX)) AS unique_id, cp.id_address_delivery,
						product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
p.`reference` AS reference, p.`eanXX`,
				p.`upc` AS upc, product_shop.`minimal_quantity` AS minimal_quantity, product_shop.`wholesale_price` wholesale_price,
image_shop.`id_image` id_image, il.`legend`
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON 
			p.`id_product` = pl.`id_product`
			AND pl.`id_lang` = XX AND pl.id_shop = cp.id_shop 
LEFT JOIN `ps_category_lang` `cl` ON 
			product_shop.`id_category_default` = cl.`id_category`
			AND cl.`id_lang` = XX AND cl.id_shop = cp.id_shop 
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
 LEFT JOIN ps_stock_available stock
			ON (stock.id_product = cp.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX  AND stock.id_shop_group = XX  )
LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = XX
WHERE (cp.`id_cart` = XX) AND (p.`id_product` IS NOT NULL)
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
4
SELECT d.`price`
					FROM `ps_delivery` d
					LEFT JOIN `ps_range_weight` w ON d.`id_range_weight` = w.`id_range_weight`
					WHERE d.`id_zone` = XX
						AND XX >= w.`delimiterXX`
						AND XX < w.`delimiterXX`
						AND d.`id_carrier` = XX
						AND d.id_delivery = (
					SELECT dXX.id_delivery
					FROM ps_delivery dXX
					WHERE dXX.id_carrier = `d`.id_carrier
						AND dXX.id_zone = `d`.id_zone
						AND dXX.`id_range_weight` = `d`.`id_range_weight`
						AND (dXX.id_shop = XX OR (dXX.id_shop_group = XX
					AND dXX.id_shop IS NULL) OR (dXX.id_shop_group IS NULL AND dXX.id_shop IS NULL))
					ORDER BY dXX.id_shop DESC, dXX.id_shop_group DESC
					LIMIT XX
				)
					ORDER BY w.`delimiterXX` ASC LIMIT XX
2
				SELECT tr.*
				FROM `ps_tax_rule` tr
				JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `ps_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
2
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `ps_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `ps_module` m
2
		SELECT SQL_NO_CACHE cr.*
		FROM ps_cart_rule cr
		LEFT JOIN ps_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
		
		LEFT JOIN ps_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
		
		LEFT JOIN ps_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
		WHERE cr.active = XX
		AND cr.code = ""
		AND cr.quantity > XX
		AND cr.date_from < "XX-XX-XX XX:XX:XX"
		AND cr.date_to > "XX-XX-XX XX:XX:XX"
		AND (
			cr.id_customer = XX
			
		)
		AND (
			cr.`carrier_restriction` = XX
			
		)
		AND (
			cr.`shop_restriction` = XX
			
		)
		AND (
			cr.`group_restriction` = XX
			
		)
		AND (
			cr.`reduction_product` <= XX
			OR EXISTS (
				SELECT XX
				FROM `ps_cart_product`
				WHERE `ps_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = XX
			)
		)
		AND NOT EXISTS (SELECT XX FROM ps_cart_cart_rule WHERE cr.id_cart_rule = ps_cart_cart_rule.id_cart_rule
																			AND id_cart = XX)
		ORDER BY priority
2
SELECT out_of_stock
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2
SELECT l.*, ls.`id_shop`
				FROM `ps_lang` l
				LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
2
SELECT 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 `ps_configuration` c
                LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX

Tables stress

30 delivery
15 carrier
15 range_weight
14 carrier_lang
14 carrier_shop
10 product
10 cart_product
9 cart_rule
9 product_shop
9 stock_available
8 lang
8 specific_price
7 carrier_tax_rules_group_shop
7 cart_rule_lang
6 module
6 category_lang
6 product_lang
6 cart_cart_rule
5 lang_shop
4 shop_url
4 product_supplier
4 image_lang
4 image_shop
4 currency_shop
4 shop
4 hook
4 module_shop
3 currency
3 meta
3 hook_alias
3 configuration
3 theme
2 group_shop
2 country
2 shop_group
2 configuration_lang
2 condition
2 smarty_lazy_cache
2 hook_module
2 country_lang
2 country_shop
2 group
2 cart_rule_shop
2 cart_rule_carrier
2 tax_rules_group
2 tax_rule
2 smarty_last_flush
2 meta_lang
2 cart_rule_country
1 fbpsc_connector_position
1 memcached_servers
1 image_type
1 product_videos_providers
1 product_videos
1 product_carrier
1 carrier_zone
1 zone
1 carrier_group
1 tag
1 address
1 condition_advice
1 advice
1 condition_badge
1 badge
1 required_field
1 product_tag
1 specific_price_priority
1 tax_lang
1 tax
1 supplier
1 manufacturer
1 hook_module_exceptions
1 group_lang
1 theme_meta
1 search_engine

ObjectModel instances

NameInstancesSource
Carrier 41 /classes/Cart.php [1863]
/classes/Cart.php [3962]
/classes/Cart.php [2900]
/classes/Cart.php [3962]
/classes/Cart.php [1863]
/classes/Cart.php [3962]
/classes/Cart.php [2900]
/classes/Cart.php [3962]
/classes/Cart.php [1863]
/classes/Cart.php [3962]
/classes/Cart.php [2900]
/classes/Cart.php [3962]
/classes/Cart.php [1863]
/classes/Cart.php [3962]
/classes/Cart.php [2900]
/classes/Cart.php [3962]
/classes/Cart.php [1863]
/classes/Cart.php [1863]
/classes/Cart.php [3962]
/classes/Cart.php [2900]
/classes/Cart.php [3962]
/classes/Cart.php [1863]
/classes/Cart.php [1863]
/classes/Cart.php [1863]
/classes/Cart.php [1863]
/classes/Cart.php [2118]
/classes/Cart.php [3962]
/classes/Cart.php [3962]
/classes/Cart.php [2118]
/classes/Cart.php [3962]
/classes/Cart.php [3962]
/classes/Cart.php [2118]
/classes/Cart.php [3962]
/classes/Cart.php [2900]
/classes/Cart.php [3962]
/classes/Cart.php [2306]
/classes/Cart.php [2306]
/classes/Cart.php [2306]
/classes/Cart.php [4071]
/classes/Cart.php [4071]
/classes/Cart.php [4071]
Address 10 /classes/Product.php [492]
/classes/Product.php [5053]
/classes/Product.php [2941]
/classes/Product.php [4408]
/modules/fedexdotcom/classes/FedExDotComHandler.php [1748]
/modules/fedexdotcom/classes/FedExDotComHandler.php [1748]
/modules/fedexdotcom/classes/FedExDotComHandler.php [1748]
/modules/fedexdotcom/classes/FedExDotComHandler.php [1748]
/modules/fedexdotcom/classes/FedExDotComHandler.php [1748]
/modules/fedexdotcom/classes/FedExDotComHandler.php [1748]
Product 7 /controllers/front/CartController.php [234]
/classes/Cart.php [931]
/modules/productvideo/productvideo.php [3027]
/classes/Cart.php [1863]
/classes/Link.php [104]
/classes/Link.php [102]
/classes/Cart.php [4071]
Country 5 /config/config.inc.php [142]
/classes/controller/FrontController.php [279]
/modules/paypal/paypal.php [118]
/classes/Carrier.php [1311]
/classes/Carrier.php [1311]
Language 3 /override/classes/shop/Shop.php [51]
/config/config.inc.php [195]
/classes/Tools.php [500]
Currency 2 /override/classes/shop/Shop.php [60]
/classes/Tools.php [617]
Customer 2 /config/config.inc.php [221]
/classes/Carrier.php [1358]
Shop 1 /config/config.inc.php [114]
ShopGroup 1 /classes/shop/Shop.php [518]
Theme 1 /config/config.inc.php [115]
Cart 1 /classes/controller/FrontController.php [348]
Group 1 /classes/Cart.php [184]
Tax 1 /classes/tax/TaxRulesTaxManager.php [115]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/settings.inc.php
5/config/autoload.php
6/config/alias.php
7/classes/PrestaShopAutoload.php
8/cache/class_index.php
9/config/bootstrap.php
10/Core/Business/Core_Business_ContainerBuilder.php
11/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
12/Adapter/Adapter_ServiceLocator.php
13/classes/controller/Controller.php
14/classes/ObjectModel.php
15/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
16/classes/db/Db.php
17/classes/Tools.php
18/classes/Context.php
19/classes/shop/Shop.php
20/override/classes/shop/Shop.php
21/classes/db/DbPDO.php
22/classes/cache/Cache.php
23/classes/cache/CacheMemcached.php
24/config/db_slave_server.inc.php
25/classes/Configuration.php
26/classes/Validate.php
27/Adapter/Adapter_EntityMapper.php
28/classes/db/DbQuery.php
29/classes/Language.php
30/classes/shop/ShopGroup.php
31/classes/Cookie.php
32/classes/Rijndael.php
33/classes/Currency.php
34/classes/Theme.php
35/config/defines_uri.inc.php
36/tools/htmlpurifier/HTMLPurifier.standalone.php
37/classes/Country.php
38/classes/PrestaShopCollection.php
39/config/smarty.config.inc.php
40/tools/smarty/Smarty.class.php
41/tools/smarty/sysplugins/smarty_internal_data.php
42/tools/smarty/sysplugins/smarty_internal_templatebase.php
43/tools/smarty/sysplugins/smarty_internal_template.php
44/tools/smarty/sysplugins/smarty_resource.php
45/tools/smarty/sysplugins/smarty_internal_resource_file.php
46/tools/smarty/sysplugins/smarty_cacheresource.php
47/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
48/classes/SmartyCustom.php
49/config/smartyfront.config.inc.php
50/classes/Customer.php
51/classes/Group.php
52/classes/Link.php
53/classes/shop/ShopUrl.php
54/classes/Dispatcher.php
55/classes/Hook.php
56/tools/mobile_Detect/Mobile_Detect.php
57/classes/module/Module.php
58/modules/xenforum/xenforum.php
59/modules/xenforum/classes/XenForumAttachment.php
60/modules/xenforum/classes/XenForumTopic.php
61/modules/xenforum/classes/XenForumCat.php
62/modules/xenforum/classes/XenForumPost.php
63/modules/xenforum/classes/XenForumUser.php
64/modules/xenforum/classes/XenForumNotification.php
65/modules/xenforum/classes/XenForumGroup.php
66/modules/xenforum/classes/XenForumTags.php
67/modules/xenforum/classes/XenForumPosition.php
68/modules/xenforum/classes/XenForumReport.php
69/modules/xenforum/classes/XenForumRelated.php
70/classes/Translate.php
71/modules/xenforum/translations/en.php
72/controllers/front/CartController.php
73/classes/controller/FrontController.php
74/themes/novus/lang/en.php
75/classes/Cart.php
76/classes/CartRule.php
77/classes/Meta.php
78/classes/Product.php
79/classes/webservice/WebserviceRequest.php
80/classes/Media.php
81/modules/revolutpayment/revolutpayment.php
82/modules/revolutpayment/classes/RevolutApi.php
83/modules/revolutpayment/classes/RevolutDatabaseHelper.php
84/modules/revolutpayment/classes/RevolutPRBSettingsHelper.php
85/modules/revolutpayment/classes/RevolutApplePayOnBoardingHelper.php
86/modules/revolutpayment/classes/RevolutModuleHelper.php
87/classes/PaymentModule.php
88/classes/Manufacturer.php
89/classes/Supplier.php
90/classes/Address.php
91/classes/tax/TaxManagerFactory.php
92/classes/tax/TaxRulesTaxManager.php
93/classes/tax/TaxManagerInterface.php
94/Adapter/Adapter_Configuration.php
95/Core/Business/Core_Business_ConfigurationInterface.php
96/classes/tax/Tax.php
97/classes/tax/TaxCalculator.php
98/classes/Combination.php
99/classes/SpecificPrice.php
100/classes/GroupReduction.php
101/classes/Tag.php
102/classes/stock/StockAvailable.php
103/classes/Category.php
104/classes/Pack.php
105/modules/gamification/gamification.php
106/modules/gamification/classes/Badge.php
107/modules/gamification/classes/Advice.php
108/modules/gamification/classes/Condition.php
109/modules/gamification/classes/GamificationTools.php
110/modules/gamification/translations/en.php
111/modules/ganalytics/ganalytics.php
112/modules/ganalytics/translations/en.php
113/classes/Customization.php
114/classes/Feature.php
115/modules/paypal/paypal.php
116/modules/paypal/api/paypal_lib.php
117/modules/paypal/api/paypal_connect.php
118/modules/paypal/api/CallApiPaypalPlus.php
119/modules/paypal/api/ApiPaypalPlus.php
120/modules/paypal/paypal_logos.php
121/modules/paypal/paypal_orders.php
122/modules/paypal/paypal_tools.php
123/modules/paypal/paypal_login/paypal_login.php
124/modules/paypal/paypal_login/PayPalLoginUser.php
125/modules/paypal/classes/PaypalCapture.php
126/modules/paypal/classes/Services/OrderPrice.php
127/modules/paypal/classes/AuthenticatePaymentMethods.php
128/modules/paypal/classes/PaypalPlusPui.php
129/modules/paypal/classes/Braintree.php
130/modules/paypal/api/sdk/braintree/lib/Braintree.php
131/modules/paypal/api/sdk/braintree/lib/autoload.php
132/modules/paypal/classes/InstallmentBanner/ConfigurationMap.php
133/modules/paypal/classes/InstallmentBanner/BannerManager.php
134/modules/paypal/classes/InstallmentBanner/Banner.php
135/modules/paypal/classes/Services/CurrencyConverter.php
136/modules/paypal/express_checkout/ExpressCheckout.php
137/modules/paypal/classes/InstallmentBanner/BNPL/BnplButton.php
138/modules/paypal/classes/Builder/BuilderInterface.php
139/modules/paypal/classes/Builder/OrderBuilder.php
140/modules/paypal/classes/Services/FormatterPaypal.php
141/modules/paypal/classes/Services/Token.php
142/modules/paypal/classes/InstallmentBanner/BNPL/BnplAvailabilityManager.php
143/modules/paypal/smarty/plugins/modifier.paypalreplace.php
144/modules/paypal/translations/en.php
145/modules/paypal/en.php
146/classes/order/Order.php
147/override/classes/order/order.php
148/modules/blockbestsellers/blockbestsellers.php
149/modules/blockbestsellers/translations/en.php
150/modules/blockcart/blockcart.php
151/modules/blockcart/translations/en.php
152/modules/blockcategories/blockcategories.php
153/modules/blockcategories/translations/en.php
154/modules/blocklayered/blocklayered.php
155/modules/blocklayered/translations/en.php
156/modules/blockcms/blockcms.php
157/modules/blockcms/BlockCMSModel.php
158/themes/novus/modules/blockcms/translations/en.php
159/modules/blockcms/translations/en.php
160/modules/blockcontact/blockcontact.php
161/modules/blockcontact/translations/en.php
162/modules/blockmyaccount/blockmyaccount.php
163/modules/blockmyaccount/translations/en.php
164/modules/blocksearch/blocksearch.php
165/modules/blocksearch/translations/en.php
166/modules/blocktags/blocktags.php
167/modules/blocktags/translations/en.php
168/modules/wpzoom/wpzoom.php
169/modules/wpmanufacturerlogos/wpmanufacturerlogos.php
170/modules/wpcopylogo/wpcopylogo.php
171/modules/wpcopylogo/WPCopyLogoClass.php
172/modules/productscategory/productscategory.php
173/modules/productscategory/translations/en.php
174/modules/wpbxslider/wpbxslider.php
175/modules/wpbxslider/WPBxSlide.php
176/modules/wpbxslider/translations/en.php
177/modules/productcomments/productcomments.php
178/modules/productcomments/translations/en.php
179/modules/wpstyleswitcher/wpstyleswitcher.php
180/modules/wpblocknewproducts/wpblocknewproducts.php
181/modules/wpblockspecials/wpblockspecials.php
182/modules/wpblockspecials/translations/en.php
183/modules/wphomefeatured/wphomefeatured.php
184/modules/blocktopmenu/blocktopmenu.php
185/modules/blocktopmenu/menutoplinks.class.php
186/modules/blocktopmenu/translations/en.php
187/cache/smarty/compile/5b/1b/38/5b1b387d05ba72c041a12c7271e13dc3ef75ea64.file.paypal.js.php
188/tools/smarty/sysplugins/smarty_internal_filter_handler.php
189/tools/minify_html/minify_html.class.php
190/cache/smarty/compile/b6/de/4a/b6de4adee163d276ef863ee1ae44f326d54161b3.file.header.tpl.php
191/modules/facebookpsconnect/facebookpsconnect.php
192/modules/facebookpsconnect/conf/common.conf.php
193/modules/facebookpsconnect/lib/warning_class.php
194/modules/facebookpsconnect/lib/module-tools_class.php
195/modules/facebookpsconnect/en.php
196/modules/facebookpsconnect/conf/hook.conf.php
197/modules/facebookpsconnect/lib/hook/hook-ctrl_class.php
198/modules/facebookpsconnect/lib/hook/i-hook_class.php
199/modules/facebookpsconnect/lib/hook/hook-display_class.php
200/modules/facebookpsconnect/lib/module-dao_class.php
201/modules/facebookpsconnect/lib/render/facade-render-connectors_class.php
202/modules/facebookpsconnect/lib/render/render-connectors_class.php
203/cache/smarty/compile/d8/b7/93/d8b7934610bd234de2c4e6fc7fd88fff7b7b2c2d.file.header.tpl.php
204/modules/pm_applepay/pm_applepay.php
205/modules/pm_applepay/class/ApplePayPayment.php
206/modules/pm_applepay/class/StripePaymentGateway.php
207/modules/testimonialswithavatars/testimonialswithavatars.php
208/modules/productvideo/productvideo.php
209/modules/productvideo/classes/autoload.php
210/modules/productvideo/translations/en.php
211/classes/ImageType.php
212/modules/productvideo/classes/SmartForm.php
213/modules/productvideo/classes/ThumbNail.php
214/cache/smarty/compile/60/e3/19/60e319bc2b3850b55fb7382be8e2edbae5d210f6.file.productvars.tpl.php
215/cache/smarty/compile/6d/a5/f1/6da5f10908240a878a88847f1d5170ca0e6bb979.file.microdata.tpl.php
216/cache/smarty/cache/blocksearch_top/1/1/17/8a/47/86/8a4786940e0d0371565a38a2e23138ed65d699a1.blocksearch-top.tpl.php
217/Adapter/Adapter_AddressFactory.php
218/Adapter/Adapter_ProductPriceCalculator.php
219/classes/ProductDownload.php
220/classes/Carrier.php
221/modules/fedexdotcom/fedexdotcom.php
222/modules/fedexdotcom/init.php
223/modules/fedexdotcom/classes/FedExDotComBoxing.php
224/modules/fedexdotcom/classes/BoxPacker/init.php
225/modules/fedexdotcom/classes/BoxPacker/FedExDotComPacker.php
226/modules/fedexdotcom/classes/BoxPacker/FedExDotComPackedBoxList.php
227/modules/fedexdotcom/classes/BoxPacker/FedExDotComPackedBox.php
228/modules/fedexdotcom/classes/BoxPacker/FedExDotComPackedItemList.php
229/modules/fedexdotcom/classes/BoxPacker/FedExDotComPackedItem.php
230/modules/fedexdotcom/classes/BoxPacker/FedExDotComItemList.php
231/modules/fedexdotcom/classes/BoxPacker/FedExDotComItem.php
232/modules/fedexdotcom/classes/BoxPacker/FedExDotComPackedProduct.php
233/modules/fedexdotcom/classes/BoxPacker/FedExDotComBoxList.php
234/modules/fedexdotcom/classes/BoxPacker/FedExDotComBox.php
235/modules/fedexdotcom/classes/BoxPacker/FedExDotComPackage.php
236/modules/fedexdotcom/classes/BoxPacker/FedExDotComVolumePacker.php
237/modules/fedexdotcom/classes/BoxPacker/FedExDotComPackedLayer.php
238/modules/fedexdotcom/classes/BoxPacker/FedExDotComOrientatedItemFactory.php
239/modules/fedexdotcom/classes/BoxPacker/FedExDotComOrientatedItem.php
240/modules/fedexdotcom/classes/BoxPacker/FedExDotComLayerStabiliser.php
241/modules/fedexdotcom/classes/BoxPacker/FedExDotComWeightRedistributor.php
242/modules/fedexdotcom/classes/FedExDotComCache.php
243/modules/fedexdotcom/classes/FedExDotComCarrierModule.php
244/classes/module/CarrierModule.php
245/modules/fedexdotcom/classes/FedExDotComCarrier.php
246/modules/fedexdotcom/classes/FedExDotComConfiguration.php
247/modules/fedexdotcom/classes/FedExDotComHandler.php
248/modules/fedexdotcom/classes/FedExDotComLogContent.php
249/modules/fedexdotcom/classes/FedExDotComLog.php
250/modules/fedexdotcom/classes/FedExDotComValidator.php
251/cache/smarty/compile/cc/63/90/cc63901f727a1fd83c9f366677cf7c0e79c8714a.file.blockcart.tpl.php
252/tools/smarty/plugins/modifier.replace.php
253/tools/smarty/plugins/function.counter.php
254/cache/smarty/cache/blocktopmenu/1/1/17/index/1a/c3/c8/1ac3c8621e3d05d46d67639bb833cb566aeb377b.blocktopmenu.tpl.php
255/modules/pagesnotfound/pagesnotfound.php
256/modules/pagesnotfound/translations/en.php
257/modules/sekeywords/sekeywords.php
258/classes/module/ModuleGraph.php
259/modules/sekeywords/translations/en.php
260/modules/facebookpsconnect/lib/render/iterator-render-connectors_class.php
261/cache/smarty/compile/bd/a3/d6/bda3d6a6e05595f59f65c397f233d66c9a261a6b.file.connector-buttons-js.tpl.php