SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-09-26 00:00:00",
INTERVAL 5 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_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_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT 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 )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
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 (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1 AND p.id_product IN (23698,23699,23700,23701,23702,23703,23704,23705,23706,23707,23708,23709,23710,23711,23712,23713,23714,23715,23716,23717,23718,23719,23720,23721,23722,23723,23724,23725,23726,23727,23728,23729,23730,23731,23732,23733,23734,23735,23737,23739,23740,23742,23743,23744,23758,23759,23760,23761,23811,23812,23813,23814,23815,23816,23817,23818,23819,23820,23821,23822,23823,23824,23825,23826,23828,23832,23833,23932,23933,23934,23935,23936,23937,23938,23939,23940,23941,23942,23943,23944,23945,23946,23947,23948,23949,23950,23951,23952,23953,23954,23955,23956,23957,23958,23959,23960,23961,23962,23963,23964,23965,23966,23967,23968,23969,23970,23971,23972,23973,23974,23976,23978,23980,23981,23982,23983,23984,23985,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079,24080,24081,24082,24083,24084,24085,24086,24087,24088,24089,24090,24092,24093,24094,24190,24191,24192,24193,24194,24195,24196,24197,24198,24199,24200,24201,24202,24203,24204,24205,24206,24207,24208,24209,24210,24211,24212,24213,24214,24215,24216,24217,24218,24219,24220,24221,24222,24223,24224,24225,24226,24227,24228,24229,24230,24231,24232,24233,24234,24235,24236,24237,24238,24239,24240,24241,24242,24243,24244,24245,24246,24247,24257,24258,24412,24413,24414,24415,24416,24417,24418,24419,24420,24421,24422,24423,24424,24425,24426,24427,24428,24429,24430,24431,24432,24433,24434,24435,24436,24437,24438,24439,24440,24441,24442,24443,24444,24445,24446,24447,24448,24449,24450,24451,24452,24453,24454,24455,24457,24458,24459,24460,24461,24463,24464,24465,24466,24468,24469,24471,24472,24474,24476,24479,24480,24484,24486,24487,24488,24499,30137,30138,30139,30140,30141,30156,30157,30158,30159,30160,30161,30162,30163,30164,30165,30166,30167,30168,30169,30170,30171,30172,30173,30201,30202,30203,30204,30205,30212,30213,30214,30215,30216,30217,30218,30219,30220,30221,30222,30223,30232,30233,30246,30247,30248,30255,30267,30273,30274,30275,30280,30288,30289,30290,30291,30292,30313,30314,30315,30316,30317,30318,30319,30320,30321,30322,30323,30324,30325,30326,30327,30328,30329,30330,30331,30332,30333,30334,30335,30336,30337,38104,38105,39736,39737,39738,39739,39740,39741,39742,39743,39744,39746,39747,39748,39749,39750,39751,39752,39753,39754,39755,39756,39757,39758,39759,39761,39762,39763,39764,39765,39766,39767,39768,39769,39770,39771,39772,39773,39774,39775,39776,39777,39778,39779,39780,39781,39782,39783,39784,39785,39786,39787,39788,39789,39790,39791,39792,39793,39794,39795,39796,39797,39798,39799,39800,39801,39802,39803,39804,39805,39806,39807,39808,39809,39810,39811,39812,39813,39814,39815,39816,39817,39818,39819,39820,39821,39822,39823,39824,39825,39826,39827,39828,39829,39830,39831,39833,39835,39836,39837,39838,39839,39840,39841,39842,39843,39844,39845,39846,39847,39848,39849,39850,39851,39852,39853,39854,39855,39856,39857,39858,39859,39860,39861,39862,39863,39864,39865,39866,39867,39868,39869,39870,39871,39872,39874,39875,39876,39877,39878,39880,39881,39882,39884,39885,39886,39887,39888,39889,39890,39891,39892,39893,39894,39895,39896,39897,39898,39899,39900,39901,39902,39903,39905,39907,39909,39911,39912,39913,39915,39917,39918,39920,39921,39922,39924,39925,39927,39928,39929,41950,41951,41952,41953,41954,41955,41956,41957,41958,41959,41960,41961,41962,41963,41964,41965,41966,41967,41968,41969,41970,41971,41972,41973,41974,41975,41976,41977,41978,41979,41980,41981,41982,41983,41984,41985,41986,41987,41988,41989,41990,41991,41992,41994,42002,42004,42005,42006,42007,42008,42009,42010,42011,42012,42013,42014,42015,42016,42017,42018,42019,42020,43315,44123,44125,44126,44127,44128,44129,44130,44360,44368,44369,44370,44406,44536,44537,44538,44539,46088,46089,46090,46091,46092,46093,46094,46095,46096,46097,46098,46099,46100,46101,46102,46103,46104,46105,46106,46107,46108,46109,46110,46111,46112,46113,46114,46115,46116,46117,46118,46119,46120,46121,46122,46123,46124,46125,46126,46127,46128,46129,46130,46131,46132,46133,46134,46135,46136,46137,46138,46139,46140,46141,46142,46143,46144,46145,46146,46147,46148,46149,46150,46151,46152,46153,46154,46155,46156,46157,46158,46159,46160,46161,46162,46163,46164,46165,46166,46167,46168,46169,46170,46171,46172,46173,46174,46175,46176,46177,46178,46179,46180,46181,46182,46183,46184,46185,46186,46187,46188,46189,46190,46191,46192,46193,46194,46195,46196,46197,46198,46199,46200,46201,46202,46203,46204,46205,46206,47768,47769,47770,47771,47772,48478,48479,48480,52277,52278,52279,52280,52281,52282,52283,52284,52285,52286,52287,52288,52289,52290,52291,52292,52293,52294,52295,52296,52297,52298,52299,52300,52301,52302,52303,52304,52305,52306,52307,52308,52309,52310,52311,52312,52313,52314,52315,52316,52318,52319,52320,52321,52322,52323,52324,52325,52326,52327,52328,52329,52330,52331,52332,52333,52334,52335,52336,52337,52338,52339,52340,52341,52342,52343,52344,52345,52346,52474,52475,52476,52477,52478,52479,52481,52482,52483,52484,52485,52486,52487,52488,52489,52490,52491,52492,52493,52494,52495,52496,52497,52498,52499,52500,52501,52502,52503,52504,52505,52506,52507,52508,52509,52510,52511,52512,52513,52514,52515,52516,52517,52518,52519,52520,52521,52522,52523,52524,52525,52526,52527,52528,52529,52530,52531,52532,52533,52534,52535,52536,52537,52538,52539,52540,52541,52542,52543,52545,52546,52547,52548,52549,52550,52551,52552,52553,52554,52555,52556,52557,52558,52559,52560,52561,52562,52563,52564,52565,52566,52567,52568,52569,52570,52571,52573,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52587,52588,52589,52590,52591,52592,52593,52594,52595,52596,52597,52598,52599,52600,52601,52602,52603,52604,52605,52606,52607,52608,52609,52610,52611,52612,52613,52614,52615,52616,52617,52618,52619,52620,52621,52622,52623,52624,52625,52626,52627,52628,52629,52630,52631,52632,52633,52634,52635,52636,52637,52638,52639,52640,52641,52642,52643,52644,52645,52646,52647,52648,52649,52650,52651,52652,52653,52654,52655,52656,52657,52658,52659,52660,52661,52662,52663,52664,52665,52666,52667,52668,52669,52670,52671,52672,52673,52674,52675,52676,52677,52678,52679,52680,52681,52682,52683,52684,52685,52686,52687,52688,52689,52690,52691,52692,52693,52694,52695,52696,52697,52698,52699,52700,52701,52702,52703,52704,52705,52706,52707,52708,52709,52710,52711,52712,52713,52714,52715,52716,52717,52718,52719,52720,52721,52722,52723,52724,52725,52726,52727,52728,52729,52730,52731,52732,52733,52734,52735,52736,52737,52738,52739,52740,52741,52742,52743,52744,52745,52746,52747,52748,52749,52750,52751,52752,52753,52754,52755,52756,52757,52758,52759,52760,52761,52762,52763,52764,52765,52766,52767,52768,52769,52770,52771,52772,52773,52774,52775,52776,52777,52778,52779,52780,52781,52782,52783,52784,52785,52786,52787,52788,52789,52790,52791,52792,52793,52794,52795,52796,52797,52798,52799,52800,52801,52802,52803,52804,52805,52806,52807,52808,52809,52810,52811,52812,52813,52814,52815,52816,52817,52818,52819,52820,52821,52822,52823,52824,52825,52826,52827,52828,52829,52830,52831,52832,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52845,52846,52847,52848,52849,52850,52851,52852,52853,52854,52855,52856,52857,52858,52859,52860,52861,52862,52863,52864,52865,52866,52867,52868,52869,52870,52871,52872,52873,52874,52875,52876,52877,52878,52879,52880,53536,53537,53684,53685,53686,58147,58154,59518,59572,60676,60677,60678,60679,60680,61465,64388,64389,64390,64391,64393,64394,64395,78335,78346,78347,78348,78349,78350,78351,78352,78354,82983,82984,85399,85400,85401,85402,85403,85804,85805,85806,85807,85808,85809,85810,85811,85812,85813,85814,85815,85816,85817,85818,85819,85820,85821,85822,85823,85824,85825,85826,85827,85828,85829,85830,85831,85832,85833,85834,85835,85836,85837,85838,85839,85840,85841,85842,85843,85844,85845,85846,85847,85848,85849,85850,85851,85852,85853,85854,85855,85856,85857,85858,85859,85860,85861,85862,85863,85864,85865,85866,85867,85868,85869,85870,85871,85872,85873,85874,85875,85876,85877,85878,85879,85880,85881,85882,85883,85884,85885,85886,85887,85888,85889,85890,85891,85892,85893,85894,85895,85896,85897,85898,85899,85900,85901,85902,85903,85904,85905,85906,85907,85908,85909,85910,85911,85912,85913,85914,85915,85916,85917,85918,85919,85920,85921,85922,85923,85924,85925,85926,85927,85928,85929,85930,85931,85932,85933,85934,85935,85936,85937,85938,85939,85940,85941,85942,85943,85944,85945,85946,85947,85948,85949,85950,85951,85952,85953,85954,85955,85956,85957,85958,85959,85960,85961,85962,85963,85964,85965,85966,85967,85968,85969,85970,85971,85972,85973,85974,85975,85976,85977,85978,85979,85980,85981,85982,85983,85984,85985,85986,85987,85988,85989,85990,85991,85992,85993,85994,85995,85996,85997,85998,85999,86000,86001,86002,86003,86004,86005,86006,86007,86008,86009,86010,86011,86012,86013,86014,86015,86016,86017,86018,86019,86020,140182,140183,140184,140185,140186,140187,140188,140189,140190,140191,140192,140193,140194,140195,140196,140197,140198,140199,140200,140201,140202,140203,140204,140205,140206,140207,140208,140209,140210,140211,140212,140213,140214,140215,140216,140217,140218,140219,140220,140221,140222,140223,140224,140225,140226,140227,140228,140229,140230,140231,140232,140233,140234,140235,140236,140237,140238,140239,140240,140241,140242,140243,140244,140245,140246,140247,140248,140249,140250,140251,140252,140253,140254,140255,140256,140257,140258,140259,140260,140261,140262,140263,140264,140265,140266,140267,140268,140269,140270,140271,140272,140273,140274,140275,140276,140277,140278,140279,140280,140281,140282,140283,140284,140285,140286,140287,140288,140289,140290,140291,140292,140293,140294,140295,140296,140297,140298,140299,140300,140301,140302,140303,140304,140305,140306,140307,140308,140309,140310,140311,140312,140313,140314,140315,140316,140317,140318,140319,140320,140321,140322,140323,140324,140325,140326,140327,140328,140329,140330,140331,140332,140333,140334,140335,140336,140337,140338,140339,140340,140341,140342,140343,140344,140345,140346,140347,140348,140349,140350,140351,140352,140353,140354,140355,140356,140357,140358,140359,140360,140361,140362,140363,140364,140365,140366,140367,140368,140369,140370,140371,140372,140373,140374,140375,140376,140377,140378,140379,140380,140381,140382,140383,140384,140385,140386,140387,140388,140389,140390,140391,140392,140393,140394,140395,140396,140397,140398,140399,140400,140401,140402,140403,140404,140405,140406,140407,140408,140409,140410,140411,140412,140413,140414,140415,140416,140417,140418,140419,140420,140421,140422,140423,140424,140425,140426,140427,140428,140429,140430,140431,140432,140433,140434,140435,140436,140437,140438,140439,140440,140441,140442,140443,140444,140445,140446,140447,140448,140449,140450,140451,140452,140453,140454,140455,140456,140457,140458,140459,140460,140461,140462,140463,140464,140465,140466,140467,140468,140469,140470,140471,140472,140473,140474,140475,140476,140477,140478,140479,140480,140481,140482,140483,140484,140485,140486,140487,140488,140489,140490,140491,140492,140493,140494,140495,140496,140497,140498,140499,140500,140501,140502,140503,140504,140505,140506,140507,140508,140509,140510,140511,140512,140513,140514,140515,140516,140517,140518,140519,140520,140521,140522,140523,140524,140525,140526,140527,140528,140529,140530,140531,140532,140533,140534,140535,140536,140537,140538,140539,140540,140541,140542,140543,140544,140545,140546,140547,140548,140549,140550,140551,140552,140553,140554,140555,140556,140557,140558,140559,140560,140561,140562,140563,140564,140565,140566,140567,140568,140569,140570,140571,140572,140573,140574,140575,140576,140577,140578,140579,140580,140581,140582,140583,140584,140585,140586,140587,140588,140589,140590,140591,140592,140593,140594,140595,140596,140597,140598,140599,140600,140601,140602,140603,140604,140605,140606,140607,140608,140609,140610,140611,140612,140613,140614,140615,140616,140617,140618,140619,140620,140621,140622,140623,140624,140625,140626,140627,140628,140629,140630,140631,140632,140633,140634,140635,140636,140637,140638,140639,140640,140641,140642,140643,140644,140645,140646,140647,140648,140649,140650,140651,140652,140653,140654,140655,140656,140657,140659,140660,140661,140662,140663,140664,140665,140666,140667,140668,140669,140670,140671,140672,140673,140674,140675,140676,140677,140678,140679,140680,140681,140682,140683,140684,140685,140686,140687,140688,140689,140690,140691,140692,140693,140694,140695,140696,140697,140698,140699,140700,140701,140702,140703,140704,140705,140706,140707,140708,140709,140710,140711,140712,140713,140714,140715,140716,140717,140718,140719,140720,140721,140722,140723,140724,140725,140726,140727,140728,140729,140730,140731,140732,140733,140734,140735,140736,140737,140738,140739,140740,140741,140742,140743,140744,140745,140746,140747,140748,140749,140750,140751,140752,140753,140754,140755,140756,140757,140758,140759,140760,140761,140762,140763,140764,140765,140766,140767,140769,140770,140771,140772,140773,140774,140775,140776,140777,140778,140779,140780,140781,140782,140783,140784,140785,140786,140787,140788,140789,140790,140791,140792,140793,140794,140795,140796,140797,140798,140799,140800,140801,140802,140803,140804,140805,140806,140807,140808,140809,140810,140811,140812,140813,140814,140815,140816,140817,140818,140819,140820,140821,140822,140823,140824,140825,140826,140827,140828,140829,140830,140831,140832,140833,140834,140835,140836,140837,140838,140839,140840,140841,140842,140843,140844,140845,140846,140847,140848,140849,140850,140851,140852,140853,140854,140855,140856,140857,140858,140859,140860,140861,140862,140863,140864,140865,140866,140867,140868,140869,140870,140871,140872,140873,140874,140875,140876,140877,140878,140879,140880,140881,140882,140883,140884,140885,140886,140887,140888,140889,140890,140891,140892,140893,140894,140895,140896,140897,140898,140899,140900,140901,140902,140903,140904,140905,140906,140907,140908,140909,140910,140911,140912,140913,140914,140915,140916,140917,140918,140919,140920,140921,140922,140923,140924,140925,140926,140927,140928,140929,140930,140931,140932,140933,140934,140935,140936,140937,140938,140939,140940,140941,140942,140943,140944,140945,140946,140947,140948,140949,140950,140951,140952,140953,140954,140955,140956,140957,140958,140959,140960,140961,140962,140963,140964,140965,140966,140967,140968,140969,140970,140971,140972,140973,140974,140975,140976,140977,140978,140979,140980,140981,140982,140983,140984,140985,140986,140987,140988,140989,140990,140991,140992,140993,140994,140995,140996,140997,140998,140999,141000,141001,141002,141003,141004,141005,141006,141007,141008,141009,141010,141011,141012,141013,141014,141015,141016,141017,141018,141019,141020,141021,141022,141023,141024,141025,141026,141027,141028,141029,141030,141031,141032,141033,141034,141035,141036,141037,141038,141039,141040,141041,141042,141043,141044,141045,141046,141047,141048,141049,141050,141051,141052,141053,141054,141055,141056,141057,141058,141059,141060,141061,141062,141063,141064,141065,141066,141067,141068,141069,141070,141071,141072,141073,141074,141075,141076,141077,141078,141079,141080,141081,141082,141083,141084,141085,141086,141087,141088,141089,141090,141091,141092,141093,141094,141095,141096,141097,141098,141099,141100,141101,141102,141103,141104,141105,141106,141107,141108,141109,141110,141111,141112,141113,141114,141115,141116,141117,141118,141119,141120,141121,141122,141123,141124,141125,141126,141127,141128,141129,141130,141131,141132,141133,141134,141135,141136,141137,141138,141139,141140,141141,141142,141143,141144,141145,141146,141147,141148,141149,141150,141151,141152,141153,141154,141155,141156,141157,141158,141159,141160,141161,141162,141163,141164,141165,141166,141167,141168,141169,141170,141171,141172,141173,141174,141175,141176,141177,141178,141179,141180,141181,141182,141183,141184,141185,141186,141187,141188,141189,141190,141191,141192,141193,141194,141195,141196,141197,141198,141199,141200,141201,141202,141203,141204,141205,141206,141207,141208,141209,141210,141211,141212,141213,141214,141215,141216,141217,141218,141219,141220,141221,141222,141223,141224,141225,141226,141227,141228,141229,141230,141231,141232,141233,141234,141235,141236,141237,141238,141239,141240,141241,141242,141243,141244,141245,141246,141247,141248,141249,141250,141251,141252,141253,141254,141255,141256,141257,141258,141259,141260,141261,141262,141263,141264,141265,141266,141267,141268,141269,141270,141271,141272,141273,141274,141275,141276,141277,141278,141279,141280,141281,141282,141283,141284,141286,141287,141288,141289,141290,141291,141292,141293,141294,141295,141296,141297,141298,141299,141300,141301,141302,141303,141304,141305,141306,141307,141308,141309,141310,141311,141312,141313,141314,141315,141316,141317,141318,141319,141320,141321,141322,141323,141324,141325,141326,141327,141328,141329,141330,141331,141332,141333,141334,141335,141336,141337,141338,141339,141340,141341,141342,141343,141344,141345,141346,141347,141348,141349,141350,141351,141352,141353,141354,141355,141356,141357,141358,141359,141360,141361,141362,141363,141364,141365,141366,141367,141368,141369,141370,141371,141372,141373,141374,141375,141376,141377,141378,141379,141380,141381,141382,141383,141384,141385,141386,141387,141388,141389,141390,141391,141392,141393,141394,141395,141396,141397,141398,141400,141401,141402,141403,141404,141405,141406,141407,141408,141409,141410,141411,141412,141413,141414,141415,141416,141417,141418,141419,141420,141421,141422,141423,141424,141425,141426,141427,141428,141429,141430,141431,141432,141433,141434,141435,141436,141437,141438,141439,141440,141441,141442,141443,141444,141445,141446,141447,141448,141449,141450,141451,141452,141453,141454,141455,141456,141457,141458,141459,141460,141461,141462,141463,141464,141465,141466,141467,141468,141469,141470,141471,141472,141473,141474,141475,141476,141477,141478,141479,141480,141481,141482,141483,141484,141485,141486,141487,141488,141489,141490,141491,141492,141493,141494,141495,141496,141497,141498,141499,141500,141501,141502,141503,141504,141505,141506,141507,141508,141509,141510,141511,141512,141513,141514,141515,141516,141517,141518,141519,141520,141521,141522,141523,141524,141525,141526,141527,141528,141529,141530,141531,141532,141533,141534,141535,141536,141537,141538,141539,141540,141541,141542,141543,141544,141545,141546,141547,141548,141549,141550,141551,141552,141553,141554,141555,141556,141557,141558,141559,141560,141561,141562,141563,141564,141565,141566,141567,141568,141569,141570,141571,141572,141573,141574,141575,141576,141577,141578,141579,141580,141581,141582,141583,141584,141585,141586,141587,141588,141589,141590,141591,141592,141593,141594,141595,141596,141597,141598,141599,141600,141601,141602,141603,141604,141605,141606,141607,141608,141609,141610,141611,141612,141613,141614,141615,141616,141617,141618,141619,141620,141621,141622,141623,141624,141625,141626,141627,141628,141629,141630,141631,141632,141633,141634,141635,141636,141637,141638,141639,141640,141641,141642,141643,141644,141645,141646,141647,141648,141649,141650,141651,141652,141653,141654,141655,141656,141657,141658,141659,141660,141661,141662,141663,141664,141665,141666,141667,141668,141669,141670,141671,141672,141673,141674,141675,141676,141677,141678,141679,141680,141681,141682,141683,141684,141685,141686,141687,141688,141689,141690,141691,141692,141693,141694,141695,141696,141697,141698,141699,141700,141701,141702,141703,141704,141705,141706,141707,141708,141709,141710,141711,141712,141713,141714,141715,141716,141717,141718,141719,141720,141721,141722,141723,141724,141725,141726,141727,141728,141729,141730,141731,141732,141733,141734,141735,141736,141737,141738,141739,141740,141741,141742,141743,141744,141745,141746,141747,141748,141749,141750,141751,141752,141753,141754,141755,141756,141757,141758,141759,141760,141761,141762,141763,141764,141765,141766,141767,141768,141769,141770,141771,141772,141773,141774,141775,141776,141777,141778,141779,141780,141781,141782,141783,141784,141785,141786,141787,141788,141789,141790,141791,141792,141793,141794,141795,141796,141797,141798,141799,141800,141801,141802,141803,141804,141805,141806,141807,141808,141809,141810,141811,141812,141813,141814,141815,141816,141817,141818,141819,141820,141821,141822,141823,141824,141825,141826,141827,141828,141829,141830,141831,141832,141833,141834,141835,141836,141837,141838,141839,141840,141841,141842,141843,141844,141845,141846,141847,141848,141849,141850,141851,141852,141853,141854,141855,141856,141857,141858,141859,141860,141861,141862,141863,141864,141865,141866,141867,141868,141869,141870,141871,141872,141873,141874,141875,141876,141877,141878,141879,141880,141881,141882,141883,141884,141885,141886,141887,141888,141889,141890,141891,141892,141893,141894,141895,141896,141897,141898,141899,141900,141901,141902,141903,141904,141905,141906,141907,141908,141909,141910,141911,141912,141913,141914,141916,141917,141918,141919,141920,141921,141922,141923,141924,141925,141926,141927,141928,141929,141930,141931,141932,141933,141934,141935,141936,141937,141938,141939,141940,141941,141942,141943,141944,141945,141946,141947,141948,141949,141950,141951,141952,141953,141954,141955,141956,141957,141958,141959,141960,141961,141962,141963,141964,141965,141966,141967,141968,141969,141970,141971,141972,141973,141974,141975,141976,141977,141978,141979,141980,141981,141982,141983,141984,141985,141986,141987,141988,141989,141990,141991,141992,141993,141994,141995,141996,141997,141998,141999,142000,142001,142002,142003,142004,142005,142006,142007,142008,142009,142010,142011,142012,142013,142014,142015,142016,142017,142018,142019,142020,142021,142022,142023,142024,142025,142026,142027,142028,142030,142031,142032,142033,142034,142035,142036,142037,142038,142039,142040,142041,142042,142043,142044,142045,142046,142047,142048,142049,142050,142051,142052,142053,142054,142055,142056,142057,142058,142059,142060,142061,142062,142063,142064,142065,142066,142067,142068,142069,142070,142071,142072,142073,142074,142075,142076,142077,142078,142079,142080,142081,142082,142083,142084,142085,142086,142087,142088,142089,142090,142091,142092,142093,142094,142095,142096,142097,142098,142099,142100,142101,142102,142103,142104,142105,142106,142107,142108,142109,142110,142111,142112,142113,142114,142115,142116,142117,142118,142119,142120,142121,142122,142123,142124,142125,142126,142127,142128,142129,142130,142131,142132,142133,142134,142135,142136,142137,142138,142139,142140,142141,142142,142143,142144,142145,142146,142147,142148,142149,142150,142151,142152,142153,142154,142155,142156,142157,142158,142159,142160,142161,142162,142163,142164,142165,142166,142167,142168,142169,142170,142171,142172,142173,142174,142175,142176,142177,142178,142179,142180,142181,142182,142183,142184,142185,142186,142187,142188,142189,142190,142191,142192,142193,142194,142195,142196,142197,142198,142199,142200,142201,142202,142203,142204,142205,142206,142207,142208,142209,142210,142211,142212,142213,142214,142215,142216,142217,142218,142219,142220,142221,142222,142223,142224,142225,142226,142227,142228,142229,142230,142231,142232,142233,142234,142235,142236,142237,142238,142239,142240,142241,142242,142243,142244,142245,142246,142247,142248,142249,142250,142251,142252,142253,142254,142255,142256,142257,142258,142259,142260,142261,142262,142263,142264,142265,142266,142267,142268,142269,142270,142271,142272,142273,142274,142275,142276,142277,142278,142279,142280,142281,142282,142283,142284,142285,142286,142287,142288,142289,142290,142291,142292,142293,142294,142295,142296,142297,142298,142299,142300,142301,142302,142303,142304,142305,142306,142307,142308,142309,142310,142311,142312,142313,142314,142315,142316,142317,142318,142319,142320,142321,142322,142323,142324,142325,142326,142327,142328,142329,142330,142331,142332,142333,142334,142335,142336,142337,142338,142339,142340,142341,142342,142343,142344,142345,142346,142347,142348,142349,142350,142351,142352,142353,142354,142355,142356,142357,142358,142359,142360,142361,142362,142363,142364,142365,142366,142367,142368,142369,142370,142371,142372,142373,142374,142375,142376,142377,142378,142379,142380,142381,142382,142383,142384,142385,142386,142387,142388,142389,142390,142391,142392,142393,142394,142395,142396,142397,142398,142399,142400,142401,142402,142403,142404,142405,142406,142407,142408,142409,142410,142411,142412,142413,142414,142415,142416,142417,142418,142419,142420,142421,142422,142423,142424,142425,142426,142427,142428,142429,142430,142431,142432,142433,142434,142435,142436,142437,142438,142439,142440,142441,142442,142443,142444,142445,142446,142447,142448,142449,142450,142451,142452,142453,142454,142455,142456,142457,142458,142459,142460,142461,142462,142463,142464,142465,142466,142467,142468,142469,142470,142471,142472,142473,142474,142475,142476,142477,142478,142479,142480,142481,142482,142483,142484,142485,142486,142487,142488,142489,142490,142491,142492,142493,142494,142495,142496,142497,142498,142499,142500,142501,142502,142503,142504,142505,142506,142507,142508,142509,142510,142511,142512,142513,142514,142515,142516,142517,142518,142519,142520,142521,142522,142523,142524,142525,142526,142527,142528,142529,142530,142531,142532,142533,142534,142535,142536,142537,142538,142539,142540,142541,142542,142543,142545,142546,142547,142548,142549,142550,142551,142552,142553,142554,142555,142556,142557,142558,142559,142560,142561,142562,142563,142564,142565,142566,142567,142568,142569,142570,142571,142572,142573,142574,142575,142576,142577,142578,142579,142580,142581,142582,142583,142584,142585,142586,142587,142588,142589,142590,142591,142592,142593,142594,142595,142596,142597,142598,142599,142600,142601,142602,142603,142604,142605,142606,142607,142608,142609,142610,142611,142612,142613,142614,142615,142616,142617,142618,142619,142620,142621,142622,142623,142624,142625,142626,142627,142628,142629,142630,142631,142632,142633,142634,142635,142636,142637,142638,142639,142640,142641,142642,142643,142644,142645,142646,142647,142648,142649,142650,142651,142652,142653,142654,142655,142656,142657,142659,142660,142661,142662,142663,142664,142665,142666,142667,142668,142669,142670,142671,142672,142673,142674,142675,142676,142677,142678,142679,142680,142681,142682,142683,142684,142685,142686,142687,142688,142689,142690,142691,142692,142693,142694,142695,142696,142697,142698,142699,142700,142701,142702,142703,142704,142705,142706,142707,142708,142709,142710,142711,142712,142713,142714,142715,142716,142717,142718,142719,142720,142721,142722,142723,142724,142725,142726,142727,142728,142729,142730,142731,142732,142733,142734,142735,142736,142737,142738,142739,142740,142741,142742,142743,142744,142745,142746,142747,142748,142749,142750,142751,142752,142753,142754,142755,142756,142757,142758,142759,142760,142761,142762,142763,142764,142765,142766,142767,142768,142769,142770,142771,142772,142773,142774,142775,142776,142777,142778,142779,142780,142781,142782,142783,142784,142785,142786,142787,142788,142789,142790,142791,142792,142793,142794,142795,142796,142797,142798,142799,142800,142801,142802,142803,142804,142805,142806,142807,142808,142809,142810,142811,142812,142813,142814,142815,142816,142817,142818,142819,142820,142821,142822,142823,142824,142825,142826,142827,142828,142829,142830,142831,142832,142833,142834,142835,142836,142837,142838,142839,142840,142841,142842,142843,142844,142845,142846,142847,142848,142849,142850,142851,142852,142853,142854,142855,142856,142857,142858,142859,142860,142861,142862,142863,142864,142865,142866,142867,142868,142869,142870,142871,142872,142873,142874,142875,142876,142877,142878,142879,142880,142881,142882,142883,142884,142885,142886,142887,142888,142889,142890,142891,142892,142893,142894,142895,142896,142897,142898,142899,142900,142901,142902,142903,142904,142905,142906,142907,142908,142909,142910,142911,142912,142913,142914,142915,142916,142917,142918,142919,142920,142921,142922,142923,142924,142925,142926,142927,142928,142929,142930,142931,142932,142933,142934,142935,142936,142937,142938,142939,142940,142941,142942,142943,142944,142945,142946,142947,142948,142949,142950,142951,142952,142953,142954,142955,142956,142957,142958,142959,142960,142961,142962,142963,142964,142965,142966,142967,142968,142969,142970,142971,142972,142973,142974,142975,142976,142977,142978,142979,142980,142981,142982,142983,142984,142985,142986,142987,142988,142989,142990,142991,142992,142993,142994,142995,142996,142997,142998,142999,143000,143001,143002,143003,143004,143005,143006,143007,143008,143009,143010,143011,143012,143013,143014,143015,143016,143017,143018,143019,143020,143021,143022,143023,143024,143025,143026,143027,143028,143029,143030,143031,143032,143033,143034,143035,143036,143037,143038,143039,143040,143041,143042,143043,143044,143045,143046,143047,143048,143049,143050,143051,143052,143053,143054,143055,143056,143057,143058,143059,143060,143061,143062,143063,143064,143065,143066,143067,143068,143069,143070,143071,143072,143073,143074,143075,143076,143077,143078,143079,143080,143081,143082,143083,143084,143085,143086,143087,143088,143089,143090,143091,143092,143093,143094,143095,143096,143097,143098,143099,143100,143101,143102,143103,143104,143105,143106,143107,143108,143109,143110,143111,143112,143113,143114,143115,143116,143117,143118,143119,143120,143121,143122,143123,143124,143125,143126,143127,143128,143129,143130,143131,143132,143133,143134,143135,143136,143137,143138,143139,143140,143141,143142,143143,143144,143145,143146,143147,143148,143149,143150,143151,143152,143153,143154,143155,143156,143157,143158,143159,143160,143161,143162,143163,143164,143165,143166,143167,143168,143169,143170,143171,143172,143173,143174,143176,143177,143178,143179,143180,143181,143182,143183,143184,143185,143186,143187,143188,143189,143190,143191,143192,143193,143194,143195,143196,143197,143198,143199,143200,143201,143202,143203,143204,143205,143206,143207,143208,143209,143210,143211,143212,143213,143214,143215,143216,143217,143218,143219,143220,143221,143222,143223,143224,143225,143226,143227,143228,143229,143230,143231,143232,143233,143234,143235,143236,143237,143238,143239,143240,143241,143242,143243,143244,143245,143246,143247,143248,143249,143250,143251,143252,143253,143254,143255,143256,143257,143258,143259,143260,143261,143262,143263,143264,143265,143266,143267,143268,143269,143270,143271,143272,143273,143274,143275,143276,143277,143278,143279,143280,143281,143282,143283,143284,143285,143286,143287,143288,143290,143291,143292,143293,143294,143295,143296,143297,143298,143299,143300,143301,143302,143303,143304,143305,143306,143307,143308,143309,143310,143311,143312,143313,143314,143315,143316,143317,143318,143319,143320,143321,143322,143323,143324,143325,143326,143327,143328,143329,143330,143331,143332,143333,143334,143335,143336,143337,143338,143339,143340,143341,143342,143343,143344,143345,143346,143347,143348,143349,143350,143351,143352,143353,143354,143355,143356,143357,143358,143359,143360,143361,143362,143363,143364,143365,143366,143367,143368,143369,143370,143371,143372,143373,143374,143375,143376,143377,143378,143379,143380,143381,143382,143383,143384,143385,143386,143387,143388,143389,143390,143391,143392,143393,143394,143395,143396,143397,143398,143399,143400,143401,143402,143403,143404,143405,143406,143407,143408,143409,143410,143411,143412,143413,143414,143415,143416,143417,143418,143419,143420,143421,143422,143423,143424,143425,143426,143427,143428,143429,143430,143431,143432,143433,143434,143435,143436,143437,143438,143439,143440,143441,143442,143443,143444,143445,143446,143447,143448,143449,143450,143451,143452,143453,143454,143455,143456,143457,143458,143459,143460,143461,143462,143463,143464,143465,143466,143467,143468,143469,143470,143471,143472,143473,143474,143475,143476,143477,143478,143479,143480,143481,143482,143483,143484,143485,143486,143487,143488,143489,143490,143491,143492,143493,143494,143495,143496,143497,143498,143499,143500,143501,143502,143503,143504,143505,143506,143507,143508,143509,143510,143511,143512,143513,143514,143515,143516,143517,143518,143519,143520,143521,143522,143523,143524,143525,143526,143527,143528,143529,143530,143531,143532,143533,143534,143535,143536,143537,143538,143539,143540,143541,143542,143543,143544,143545,143546,143547,143548,143549,143550,143551,143552,143553,143554,143555,143556,143557,143558,143559,143560,143561,143562,143563,143564,143565,143566,143567,143568,143569,143570,143571,143572,143573,143574,143575,143576,143577,143578,143579,143580,143581,143582,143583,143584,143585,143586,143587,143588,143589,143590,143591,143592,143593,143594,143595,143596,143597,143598,143599,143600,143601,143602,143603,143604,143605,143606,143607,143608,143609,143610,143611,143612,143613,143614,143615,143616,143617,143618,143619,143620,143621,143622,143623,143624,143625,143626,143627,143628,143629,143630,143631,143632,143633,143634,143635,143636,143637,143638,143639,143640,143641,143642,143643,143644,143645,143646,143647,143648,143649,143650,143651,143652,143653,143654,143655,143656,143657,143658,143659,143660,143661,143662,143663,143664,143665,143666,143667,143668,143669,143670,143671,143672,143673,143674,143675,143676,143677,143678,143679,143680,143681,143682,143683,143684,143685,143686,143687,143688,143689,143690,143691,143692,143693,143694,143695,143696,143697,143698,143699,143700,143701,143702,143703,143704,143705,143706,143707,143708,143709,143710,143711,143712,143713,143714,143715,143716,143717,143718,143719,143720,143721,143722,143723,143724,143725,143726,143727,143728,143729,143730,143731,143732,143733,143734,143735,143736,143737,143738,143739,143740,143741,143742,143743,143744,143745,143746,143747,143748,143749,143750,143751,143752,143753,143754,143755,143756,143757,143758,143759,143760,143761,143762,143763,143764,143765,143766,143767,143768,143769,143770,143771,143772,143773,143774,143775,143776,143777,143778,143779,143780,143781,143782,143783,143784,143785,143786,143787,143788,143789,143790,143791,143792,143793,143794,143795,143796,143797,143798,143799,143800,143801,143802,143803,143804,143805,143806,143807,143808,143809,143810,143811,143812,143813,143814,143815,143816,143817,143818,143819,143820,143821,143822,143823,143824,143825,143826,143827,143828,143829,143830,143831,143832,143833,143834,143835,143836,143837,143838,143839,143840,143841,143842,143843,143844,143845,143846,143847,143848,143849,143850,143851,143852,143853,143854,143855,143856,143857,143858,143859,143860,143861,143862,143863,143864,143865,143866,143867,143868,143869,143870,143871,143872,143873,143874,143876,143877,143878,143879,143880,143881,143882,143883,143884,143885,143886,143887,143888,143889,143890,143891,143892,143893,143894,143895,143896,143897,143898,143899,143900,143901,143902,143903,143904,143905,143906,143907,143908,143909,143910,143911,143912,143913,143914,143915,143916,143917,143918,143919,143920,143921,143922,143923,143924,143925,143926,143927,143928,143929,143930,143931,143932,143933,143934,143935,143936,143937,143938,143939,143940,143941,143942,143943,143944,143945,143946,143947,143948,143949,143950,143951,143952,143953,143954,143955,143956,143957,143958,143959,143960,143961,143962,143963,143964,143965,143966,143967,143968,143969,143970,143971,143972,143973,143974,143975,143976,143977,143978,143979,143980,143981,143982,143983,143984,143985,143986,143987,143988,143990,143991,143992,143993,143994,143995,143996,143997,143998,143999,144000,144001,144002,144003,144004,144005,144006,144007,144008,144009,144010,144011,144012,144013,144014,144015,144016,144017,144018,144019,144020,144021,144022,144023,144024,144025,144026,144027,144028,144033,144034,144035,144036,144037,144038,144039,144040,144041,144042,144043,144044,144045,144046,144047,144048,144049,144050,144051,144052,144053,144054,144055,144056,144057,144058,144059,144060,144061,144062,144063,144064,144065,144066,144067,144068,144069,144070,144071,144072,144073,144074,144075,144076,144077,144078,144079,144080,144081,144082,144083,144084,144085,144086,144087,144088,144089,144090,144091,144092,144093,144094,144095,144097,144098,144099,144250,144251,144252,144253,144254,144255,144256,144257,144258,144259,144260,144261,144262,144263,144264,144265,144266,144267,144268,144269,144270,144271,144272,144273,144274,144275,144276,144277,144278,144279,144280,144281,144282,144283,144284,144285,144286,144287,144288,144289,144290,144291,144292,144293,144294,144295,144296,144297,144298,144299,144300,144301,144302,151431,151717,151728,152103,152104,152105,152106,152107,152108,152109,153309,153688,153689,153690,158207,158208,158209,158210,158211,158212,158213,158214,158215,158216,158217,158218,158219,158220,158221,158222,158223,158224,158225,158226,158227,158228,158229,158230,158231,158232,158233,158234,158235,158236,158237,158238,158239,158240,158241,158242,158243,158244,158245,158246,158247,158248,158249,158250,158251,158252,158253,158254,158255,158256,158257,158258,158259,158260,158261,158262,158263,158264,158265,158266,158267,158268,158269,158270,158271,158272,158273,158274,158275,158276,158277,158278,158279,158280,158281,158282,158283,158284,158285,158286,158287,158288,158289,158290,158291,158292,158293,158294,158295,158296,158297,158298,158299,158300,158301,158302,158303,158304,158305,158306,158307,158308,158309,158310,158311,158312,158313,158315,158316,158317,158318,158319,158320,158322,158323,158324,158325,158326,158327,158329,158330,158331,158332,158333,158334,158335,158336,158337,158338,158339,158340,158341,158342,158343,158344,158345,158346,158347,158348,158349,158350,158351,158352,158353,158354,158355,158356,158357,158358,158359,158360,158361,158362,158363,158364,166010,166011,168905,168906,168907,176575,178976,239905,240356,262734)
AND cp.`id_category` = 24150 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.is_universal, `quantity` DESC
LIMIT 0,9 |
666496
ms
|
0 |
Yes
|
|
/override/classes/Category.php:272
/src/Adapter/Category/CategoryProductSearchProvider.php:88<br>/src/Adapter/Category/CategoryProductSearchProvider.php:105<br>/modules/ps_categoryproducts/ps_categoryproducts.php:287<br>/modules/ps_categoryproducts/ps_categoryproducts.php:242<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:67<br>/classes/Hook.php:954<br>/config/smarty.config.inc.php:164<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/aryalayouts_layout_left_column_tpl/30/99/08/3099084db4e0808b91b761822cf3f6ecb65973c4_2.file.product.tpl.php:792<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/aryalayouts_layout_left_column_tpl/30/99/08/3099084db4e0808b91b761822cf3f6ecb65973c4_2.file.product.tpl.php:1206<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/aryalayouts_layout_left_column_tpl/29/c9/49/29c94992ed94ec5a32d92fbff29b19871c895f0f_2.file.layout-left-column.tpl.php:253<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/aryalayouts_layout_left_column_tpl/29/c9/49/29c94992ed94ec5a32d92fbff29b19871c895f0f_2.file.layout-left-column.tpl.php:84<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/aryalayouts_layout_left_column_tpl/30/99/08/3099084db4e0808b91b761822cf3f6ecb65973c4_2.file.product.tpl.php:52<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/controller/FrontController.php:727<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:28
|
