/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/filter.php
Journal3\Opencart\Model->dbQuery
|
0.011876821517944 |
SELECT
p.product_id,
(SELECT SUM(p2m.quantity) FROM oc_multistore m LEFT JOIN oc_product_to_multistore p2m ON (m.multistore_id = p2m.multistore_id) WHERE m.type = 'stock' AND p2m.product_id = p.product_id) AS 'multistore_quantity',
(
SELECT AVG(rating) total
FROM `oc_review` r1
WHERE
r1.product_id = p.product_id
AND r1.status = '1'
GROUP BY r1.product_id
) rating,
(
SELECT price
FROM `oc_product_discount` pd2
WHERE
pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND pd2.quantity = '1'
AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
) discount,
(
SELECT price
FROM `oc_product_special` ps
WHERE
ps.product_id = p.product_id
AND ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1
) special,
p.viewed
FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
AND pd.language_id = '3'
AND p2c.category_id IN (227) AND p.product_id NOT IN (13991,13993,13994,13995,13996,13997,13998,13999,14000,13992,15652,15653,15654,14489,14490,14491,14492,14493,14494,13306,13550,13309,15849,15200,13554,13350,13286,13267,13256,13254,13551,13330,13328,13336,13345,13308,13303,13268,13278,13283,13273,13297,13295,13292,13293,13253,13255,13257,13284,13291,13279,13319,13317,13337,13335,13333,13304,13344,13559,13299,13321,13320,13351,13348,13334,13354,15633,15202,15210,15195,15196,14052,13316,13558,13556,13560,13323,13296,13298,13272,13294,13561,13271,13269,13251,13252,13265,13249,13250,13264,13261,13247,13246,13241,13248,15209,13342,13340,13346,13347,13553,13339,13338,13332,13547,13310,15754,13313,13302,13331,13277,13318,15198,13290,13289,13288,13287,13285,13280,13281,13305,13349,13352,13307,13245,13244,13242,13341,13343,13312,13314,13276,13274,13557,13552,13329,13315,13275,13549,13311,13555,13301,13300,13243,13240,13325,13327,13326,13324,13322,13270,13266,13353,13355,13263,13356,13262,13357,13260,13259,13258,13960,13780,13779,13781,13782,13783,13784,13785,13786,13787,13788,13789,13790,13791,13792,13793,13794,13795,13796,13797,13798,13799,13800,13801,13805,15203,13893,13894,15236,15580,13961,13962,13963,13964,13965,13966,13967,13968,13969,13970,13971,13972,13973,13974,13975,13976,13977,13978,13979,13980,13981,13982,13983,13984,13985,13986,13987,13988,13989,13990,13991,13992,13993,13994,13995,13996,13997,13998,13999,14000,14001,14002,14003,14004,14005,14006,14007,14008,14009,14010,14011,14012,14013,14014,14015,14016,14017,14018,14019,14020,14021,14022,14023,15226,15229,15164,14053,14054,14055,14056,15225,15228,15227,14089,14090,14091,14092,14093,14094,14096,14097,14102,14095,15166,15165,15211,15577,15235,15208,15232,16468,16798,16832,16801,16822,16825,16828,15201,15234,15207,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14601,14602,14603,14604,14605,14606,14607,14608,14609,14610,14611,14612,14613,14614,14615,14616,14617,14633,14634,14635,14636,14637,14638,14639,14640,14641,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,14652,14653,14654,14655,14656,14657,14658,14659,14660,14661,14662,14663,14664,13282,14088,14686,14687,14688,14689,14690,14691,14692,14693,14694,14695,14696,14697,14698,14699,14700,14701,14702,14703,14707,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,14729,14730,14731,14732,14733,14734,14735,14736,14737,14738,14739,14740,14741,14742,14743,14744,14745,14746,14747,14748,14749,14750,14751,14752,14753,14754,14755,14756,14757,14758,14759,14760,14761,14762,14763,14764,14765,14766,14767,15237,15231,15239,15230,15199,14860,14861,14862,14863,14864,14865,14866,14867,14868,14869,14870,14871,14872,14873,14874,14875,14876,14877,14878,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,15238,15581,15233,14924,14925,14926,14927,14928,15197,16829,15057,15058,15060,15061,15062,15063,15064,15065,15066,15067,15204,15576,15206,15205,15579,15167,15168,15169,15170,15171,15172,15173,15174,15175,15176,15177,15178,15179,15180,15181,15182,15183,15184,15185,15186,15187,15188,15189,15190,15191,15192,15193,15240,15241,15242,15243,15244,15245,15246,15247,15248,15249,15250,15251,15252,15253,15254,15255,15256,15257,15258,15259,15260,15261,15262,15263,15264,15265,15266,15267,15268,15578,15324,15325,15326,15327,15352,15329,15330,15331,15332,15333,15334,15335,15336,15337,15338,15339,15340,15341,15342,15343,15344,15345,15346,15347,15348,15349,15350,15351,15353,15354,15355,15356,15357,15358,15359,15360,15361,15362,15363,15364,15365,15388,15389,15390,15391,15392,15393,15394,15395,15396,15397,15398,15399,15400,15401,15402,15403,15404,15405,15406,15407,15408,15409,15410,15411,15412,15413,15414,15415,15416,15417,15418,15419,15420,15421,15422,15423,15424,15425,15426,15427,15428,15429,15430,15431,15432,15433,15434,15435,15436,15437,15438,15439,15440,15441,15442,15443,15444,15445,15446,15447,15448,15449,15475,15476,15477,15478,15479,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15607,15608,15609,15610,15611,15612,15613,15614,15615,15616,15617,15618,15619,15714,15752,15713,15753,15634,15635,15652,15653,15654,15711,15712,15710,15717,15716,15715,15695,15696,15697,15698,15699,15700,15718,15719,15720,15722,15723,15724,15725,15726,15727,15728,15729,15730,15731,15732,15733,15734,15735,15736,15737,15738,15739,15740,15741,15742,15743,15744,15745,15721,15755,15756,15757,15758,15772,15773,15774,15775,15776,15777,15789,15790,15791,15792,15793,15794,15795,15796,15797,16397,16396,16395,16394,16393,15815,15816,16471,15850,15851,15852,15853,15854,16475,16474,16473,15863,16469,15876,15877,15878,15879,15880,15881,15882,15883,15884,15885,15886,15887,15888,15889,15913,15914,16472,15921,15922,15923,15924,15925,15926,15927,15928,15929,15930,15931,15932,15933,15934,15935,15936,15937,15938,15939,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15982,15958,15959,15960,15961,15962,15963,15964,15965,15966,15967,15968,15969,15970,15971,15972,15973,15974,15975,15976,15977,15978,15979,15980,15981,15996,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16033,16034,16035,16036,16037,16038,16039,16040,16041,16042,16043,16045,16046,16047,16048,16049,16050,16051,16052,16053,16054,16055,16056,16057,16058,16059,16060,16061,16062,16063,16064,16065,16067,16068,16069,16070,16071,16072,16073,16074,16075,16076,16077,16078,16079,16080,16081,16082,16083,16084,16470,16114,16115,16116,16117,16118,16119,16120,16121,16122,16123,16124,16125,16126,16127,16128,16129,16130,16131,16132,16158,16159,16160,16161,16162,16163,16164,16165,16166,16167,16168,16177,16178,16179,16180,16181,16182,16183,16186,16187,16189,16190,16200,16201,16202,16203,16204,16205,16206,16207,16208,16209,16210,16211,16212,16213,16296,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16413,16414,16415,16416,16417,16418,16421,16420,16422,16423,16424,16425,16426,16430,16428,16429,16431,16432,16433,16434,16435,16436,16437,16438,16439,16440,16441,16442,16443,16444,16445,16446,16447,16448,16449,16450,16451,16452,16453,16454,16455,16456,16457,16458,16459,16460,16461,16476,16477,16478,16479,16480,16481,16482,16483,16484,16485,16486,16487,16488,16489,16490,16491,16492,16493,16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16548,16547,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579,16580,16581,16586,16831,16595,16596,16597,16598,16650,16651,16652,16653,16654,16655,16656,16657,16658,16659,16660,16661,16670,16671,16672,16673,16674,16677,16678,16679,16680,16681,16682,16683,16684,16830,16701,16702,16703,16704,16705,16706,16707,16708,16709,16710,16711,16712,16713,16714,16715,16716,16717,16718,16719,16720,16721,16722,16723,16724,16725,16726,16727,16728,16729,16730,16731,16732,16733,16834,16833,16747,16748,16823,16824,16800,16799,16803,16802,16836,16835,16827,16826,16959,16915,16916,16917,16918,16919,16920,16921,16922,16923,16924,16925,16926,16927,16928,16929,16930,16931,16932,16933,16960,16947,16948,16949,16950,16951,16952,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,14729,14730,14731,14732,14733,14734,14735,14736,14737,14738,14739,14740,15326,15327,15329,15633,15634,15635,14745,14746,14747,14748,14749,14750,14751,14752,14753,14754,14755,14756,14757,14758,14759,14760,14761,14762,14763,14764,14765,14766,14767,15330,15331,15332,15333,15334,15335,14514,14515,14523,14524,14526,14527,14530,16797,16696,16874,16685,16687,16689,16749,16691,16692,16697,16698,16700,16968,16742,16743,16787,16969,16970,16971,16972,16973,16974,16975,16976,16977,16978,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14601,14602,14603,14604,14605,14606,14607,14608,14609,14610,14611,14612,14613,14614,14615,14616,14617,14888,14889,14890,14891,14892,14893,14894,14895,14896,14020,14021,14022,15061,15062,15063,15064,15065,15066,15067,15137,15141,15144,15145,15146,15150,15148,15149,15151,15152,13706,13707,13708,13709,13710,13711,13712,13713,13714,13715,13716,13717,13718,13719,13720,13721,15200,15202,15210,15198,15209,15203,15211,15208,15201,15207,15199,15197,15204,15206,15205,15733,15722,15723,15724,15725,15726,15727,15728,15729,15730,15731,15732,15734,15735,15736,15737,15738,15739,15740,15741,15742,15743,15744,15745,16127,16682,16683,16684,16920,16921,15229,15236,15225,15230,15228,15227,15226,15235,15232,15234,15237,15231,15239,15238,15233,15240,15241,15242,15243,15244,15245,15246,15247,15248,15249,15250,15251,15252,15253,15254,15255,15256,15257,15258,15259,15260,15261,15262,15263,15264,15265,15266,15267,15268,14532,14533,14534,14535,14536,14537,14538,14539,14540,14541,14542,14543,14544,14545,14546,14547,14548,14549,14550,14551,14552,14553,14554,14555,14556,14557,14558,14570,14571,14572,15324,15325,15336,15337,15338,15339,15340,15341,15342,15343,15344,15345,15346,15347,15348,15349,15350,15351,13976,13977,13978,13979,13980,13981,13982,13983,13984,13985,13986,13987,13988,13989,13990,14700,14701,14702,14703,14696,14697,14698,14699,15057,13960,13961,13962,13963,13964,13965,13966,13967,13968,13969,13970,13971,13972,13973,13974,13975,14023,14686,14687,14688,14689,14690,14691,14692,14693,14694,14695,15058,15757,15758,15355,15356,15357,15358,15359,15360,15361,15362,15363,15364,15365,16200,16201,16701,16702,16703,16704,16705,16706,16707,15372,15373,15674,15675,15676,15677,15678,15374,15375,15376,15371,15386,16822,16824,15388,15389,15390,15391,15392,15393,15394,15395,15396,15397,15398,15399,15400,15401,15402,15403,15404,15405,15406,15407,15408,15409,15410,15411,15412,15413,15414,15415,15416,15417,15418,15419,15420,15421,15422,15423,15424,15425,15426,15427,15428,15429,15430,15431,15432,15433,15434,15435,15436,15437,15438,15439,15440,15441,15442,15443,15444,15445,15446,15447,15448,15449,15695,15696,15697,15698,15699,15700,15815,15816,16158,16451,16452,16453,16454,16455,16747,16748,16823,15371,15372,15373,15374,15375,15376,15386,15674,15675,15676,15677,15678,14169,14170,14046,14047,14048,14049,14069,14070,14087,14171,14172,14173,14174,14175,14176,14177,14178,14179,14180,15705,14182,14685,14768,15504,15750,15751,15749,15748,16263,16812,16953,14131,14132,14133,14134,14135,14250,16837,15003,16841,15622,15632,15858,15867,16881,16877,15912,15993,16261,16297,16324,16325,16966,16967,16955,15604,15605,15606,15607,15608,15609,15610,15611,15612,15613,15614,15615,15616,15617,15618,15619,15580,15577,15581,15578,15579,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,16202,16203,16204,16205,16206,16207,16208,16209,16210,16211,16212,16213,16708,16709,16710,16712,16713,16714,16717,16718,16719,16720,16721,16722,16723,16724,16725,16726,16728,16730,16732,16733,14495,14496,14497,14498,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,14510,16807,16808,16806,15662,15663,15664,15665,15666,15667,15668,15669,15670,15671,15672,15673,16805,16811,16810,16809,15655,15656,15657,15658,15659,15660,15661,16191,16192,16193,16194,16195,16196,16197,13600,13601,13602,13603,13604,13605,13606,13607,13608,13609,13610,13611,13612,13613,13614,13615,13616,13617,13618,13619,13888,13889,13954,13955,13766,13769,13764,13765,13768,13767,13755,13753,13752,13751,13757,13754,13756,13763,13758,13761,13759,13760,13762,13775,13772,13774,13773,13771,13770,13777,13776,13743,13747,13750,13749,13748,14906,14907,14908,14909,14910,14912,14913,14914,14915,14916,14917,14918,14919,14920,14921,14922,14923,14900,14901,14902,14911,14903,14904,14905,16825,16827,15876,15877,15878,15879,15880,15881,15882,15883,15884,15885,15886,15887,15888,15889,16177,16178,16179,16180,16181,16456,16457,16458,16459,16460,16461,16826,16799,16802,16798,16801,15772,15773,15774,15775,15776,15777,15789,15790,15791,15792,15793,15794,15795,15796,15797,16397,16396,16395,16394,16393,15863,15913,15914,16182,16183,16296,16650,16401,16402,16403,16586,16595,16596,16597,16598,16651,16652,16653,16654,16655,16656,16657,16658,16659,16660,16661,16800,16803,16947,16948,16949,16950,16951,16952,15996,15997,15998,15999,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16033,16523,16524,16525,16526,16527,16528,16468,16471,16475,16474,16473,16469,16472,16000,16025,16026,16027,16028,16029,16030,16031,16032,16034,16035,16036,16037,16038,16039,16040,16041,16042,16043,16045,16046,16047,16048,16049,16050,16051,16470,16476,16477,16478,16479,16480,16481,16482,16483,16484,16485,16486,16487,16488,16489,16052,16053,16054,16055,16056,16057,16058,16059,16060,16061,16062,16063,16064,16065,16067,16068,16069,16070,16071,16072,16073,16074,16075,16076,16077,16078,16079,16080,16081,16082,16083,16084,14234,14235,14236,14237,14238,14239,14240,14241,14242,14243,14244,14245,14246,14247,16089,15915,16090,16091,16116,16117,16118,16119,16120,16121,16122,16123,16124,16125,16126,16130,16406,16410,16416,16677,16918,16131,16132,16404,16405,16407,16408,16409,16411,16412,16413,16414,16415,16417,16418,16421,16420,16422,16678,16679,16680,16919,16833,16829,16830,16828,16832,16959,16159,16160,16161,16162,16163,16164,16165,16166,16167,16168,16439,16440,16441,16442,16443,16444,16445,16446,16447,16448,16449,16450,16831,16960,13565,13567,13568,13570,13563,13571,13578,13575,13576,13572,13577,13574,13573,13569,13566,13564,13562,14560,14018,14019,14016,14017,14001,14002,14003,14004,14005,14006,14007,14008,14009,14010,14011,14012,14013,14014,14015,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,15164,15166,15165,15167,15168,15169,15170,15171,15172,15173,15174,15175,15176,15177,15178,15179,15180,15181,15182,15183,15184,15185,15186,15187,15188,15189,15190,15191,15192,15193,16490,16491,16492,16493,16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16548,16547,16549,16550,16551,16552,16555,16556,16557,16558,16559,16560,16561,16553,16554,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579,16580,16581,15642,15641,15640,15643,15644,15645,15646,15647,15648,15649,15650,15651,16185,14089,14090,14091,14092,14093,14094,14095,14096,14097,14741,14742,14743,14744,16681,13915,13896,13911,13918,13897,13906,13899,13900,13901,13924,14365,14364,13907,13909,13910,13908,13912,13913,13914,13917,13919,13898,13920,13895,13921,13916,13922,13905,13923,13925,12995,12997,12996,13004,13009,13006,13005,13010,13007,12999,13504,13505,12991,12992,12993,12994,12998,13000,13001,13002,13003,13008,13011,13012,14629,14630,14631,14632,16922,16923,16924,16925,16926,16927,16928,16929,16930,16931,16932,16933,13309,13318,13315,13314,13319,13300,13308,13296,15195,15196,14052,13301,13298,13297,13303,13323,13304,13311,13316,13312,13313,13317,13552,13551,13550,13321,13547,13310,13307,13306,13305,13302,13299,13549,13320,13322,14707,15714,15713,15711,15712,15710,15716,15715,16114,16115,16128,16430,16431,16432,16433,16434,16435,16436,16437,16438,16915,16916,16917) GROUP BY p.product_id ORDER BY p.quantity > 0 DESC, RAND() LIMIT 0, 10 |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.009782075881958 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '0' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0088930130004883 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.007796049118042 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '15809' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategoryTree
|
0.0076339244842529 |
SELECT
c.category_id,
c.parent_id,
cd.name as title
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
ORDER BY
c.sort_order, LCASE(cd.name)
|
/var/www/www-root/data/www/armahookah.by/catalog/model/design/layout.php
ModelDesignLayout->getLayout
|
0.0073881149291992 |
SELECT * FROM oc_layout_route WHERE 'account/login' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0066289901733398 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '2' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0060739517211914 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '76' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0055780410766602 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '103' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0054450035095215 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '141' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.005424976348877 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '312' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0050840377807617 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '61' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0050308704376221 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '13' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.0050208568572998 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '16887' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0048398971557617 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '8' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.004647970199585 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '13' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0042378902435303 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '4' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.0041689872741699 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '16734' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.003903865814209 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '3' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0035929679870605 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '14' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.0034351348876953 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '16867' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0034279823303223 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '13' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0034120082855225 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0033321380615234 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '141' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0031750202178955 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.0031089782714844 |
SELECT DISTINCT *, pd.name AS name,
p.image, p.ms_in_store AS 'in_store', p.ms_in_stock AS 'in_stock', p.ms_in_trade AS 'in_trade',
m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward,
(SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id IN (16940,16889,16734,16887,16903,15988,16867,15809,15909,16883) AND pd.language_id = '3' AND p.status = '1' AND p.product_id NOT IN (13991,13993,13994,13995,13996,13997,13998,13999,14000,13992,15652,15653,15654,14489,14490,14491,14492,14493,14494,13306,13550,13309,15849,15200,13554,13350,13286,13267,13256,13254,13551,13330,13328,13336,13345,13308,13303,13268,13278,13283,13273,13297,13295,13292,13293,13253,13255,13257,13284,13291,13279,13319,13317,13337,13335,13333,13304,13344,13559,13299,13321,13320,13351,13348,13334,13354,15633,15202,15210,15195,15196,14052,13316,13558,13556,13560,13323,13296,13298,13272,13294,13561,13271,13269,13251,13252,13265,13249,13250,13264,13261,13247,13246,13241,13248,15209,13342,13340,13346,13347,13553,13339,13338,13332,13547,13310,15754,13313,13302,13331,13277,13318,15198,13290,13289,13288,13287,13285,13280,13281,13305,13349,13352,13307,13245,13244,13242,13341,13343,13312,13314,13276,13274,13557,13552,13329,13315,13275,13549,13311,13555,13301,13300,13243,13240,13325,13327,13326,13324,13322,13270,13266,13353,13355,13263,13356,13262,13357,13260,13259,13258,13960,13780,13779,13781,13782,13783,13784,13785,13786,13787,13788,13789,13790,13791,13792,13793,13794,13795,13796,13797,13798,13799,13800,13801,13805,15203,13893,13894,15236,15580,13961,13962,13963,13964,13965,13966,13967,13968,13969,13970,13971,13972,13973,13974,13975,13976,13977,13978,13979,13980,13981,13982,13983,13984,13985,13986,13987,13988,13989,13990,13991,13992,13993,13994,13995,13996,13997,13998,13999,14000,14001,14002,14003,14004,14005,14006,14007,14008,14009,14010,14011,14012,14013,14014,14015,14016,14017,14018,14019,14020,14021,14022,14023,15226,15229,15164,14053,14054,14055,14056,15225,15228,15227,14089,14090,14091,14092,14093,14094,14096,14097,14102,14095,15166,15165,15211,15577,15235,15208,15232,16468,16798,16832,16801,16822,16825,16828,15201,15234,15207,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14601,14602,14603,14604,14605,14606,14607,14608,14609,14610,14611,14612,14613,14614,14615,14616,14617,14633,14634,14635,14636,14637,14638,14639,14640,14641,14642,14643,14644,14645,14646,14647,14648,14649,14650,14651,14652,14653,14654,14655,14656,14657,14658,14659,14660,14661,14662,14663,14664,13282,14088,14686,14687,14688,14689,14690,14691,14692,14693,14694,14695,14696,14697,14698,14699,14700,14701,14702,14703,14707,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,14729,14730,14731,14732,14733,14734,14735,14736,14737,14738,14739,14740,14741,14742,14743,14744,14745,14746,14747,14748,14749,14750,14751,14752,14753,14754,14755,14756,14757,14758,14759,14760,14761,14762,14763,14764,14765,14766,14767,15237,15231,15239,15230,15199,14860,14861,14862,14863,14864,14865,14866,14867,14868,14869,14870,14871,14872,14873,14874,14875,14876,14877,14878,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,15238,15581,15233,14924,14925,14926,14927,14928,15197,16829,15057,15058,15060,15061,15062,15063,15064,15065,15066,15067,15204,15576,15206,15205,15579,15167,15168,15169,15170,15171,15172,15173,15174,15175,15176,15177,15178,15179,15180,15181,15182,15183,15184,15185,15186,15187,15188,15189,15190,15191,15192,15193,15240,15241,15242,15243,15244,15245,15246,15247,15248,15249,15250,15251,15252,15253,15254,15255,15256,15257,15258,15259,15260,15261,15262,15263,15264,15265,15266,15267,15268,15578,15324,15325,15326,15327,15352,15329,15330,15331,15332,15333,15334,15335,15336,15337,15338,15339,15340,15341,15342,15343,15344,15345,15346,15347,15348,15349,15350,15351,15353,15354,15355,15356,15357,15358,15359,15360,15361,15362,15363,15364,15365,15388,15389,15390,15391,15392,15393,15394,15395,15396,15397,15398,15399,15400,15401,15402,15403,15404,15405,15406,15407,15408,15409,15410,15411,15412,15413,15414,15415,15416,15417,15418,15419,15420,15421,15422,15423,15424,15425,15426,15427,15428,15429,15430,15431,15432,15433,15434,15435,15436,15437,15438,15439,15440,15441,15442,15443,15444,15445,15446,15447,15448,15449,15475,15476,15477,15478,15479,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15607,15608,15609,15610,15611,15612,15613,15614,15615,15616,15617,15618,15619,15714,15752,15713,15753,15634,15635,15652,15653,15654,15711,15712,15710,15717,15716,15715,15695,15696,15697,15698,15699,15700,15718,15719,15720,15722,15723,15724,15725,15726,15727,15728,15729,15730,15731,15732,15733,15734,15735,15736,15737,15738,15739,15740,15741,15742,15743,15744,15745,15721,15755,15756,15757,15758,15772,15773,15774,15775,15776,15777,15789,15790,15791,15792,15793,15794,15795,15796,15797,16397,16396,16395,16394,16393,15815,15816,16471,15850,15851,15852,15853,15854,16475,16474,16473,15863,16469,15876,15877,15878,15879,15880,15881,15882,15883,15884,15885,15886,15887,15888,15889,15913,15914,16472,15921,15922,15923,15924,15925,15926,15927,15928,15929,15930,15931,15932,15933,15934,15935,15936,15937,15938,15939,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15982,15958,15959,15960,15961,15962,15963,15964,15965,15966,15967,15968,15969,15970,15971,15972,15973,15974,15975,15976,15977,15978,15979,15980,15981,15996,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16033,16034,16035,16036,16037,16038,16039,16040,16041,16042,16043,16045,16046,16047,16048,16049,16050,16051,16052,16053,16054,16055,16056,16057,16058,16059,16060,16061,16062,16063,16064,16065,16067,16068,16069,16070,16071,16072,16073,16074,16075,16076,16077,16078,16079,16080,16081,16082,16083,16084,16470,16114,16115,16116,16117,16118,16119,16120,16121,16122,16123,16124,16125,16126,16127,16128,16129,16130,16131,16132,16158,16159,16160,16161,16162,16163,16164,16165,16166,16167,16168,16177,16178,16179,16180,16181,16182,16183,16186,16187,16189,16190,16200,16201,16202,16203,16204,16205,16206,16207,16208,16209,16210,16211,16212,16213,16296,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16413,16414,16415,16416,16417,16418,16421,16420,16422,16423,16424,16425,16426,16430,16428,16429,16431,16432,16433,16434,16435,16436,16437,16438,16439,16440,16441,16442,16443,16444,16445,16446,16447,16448,16449,16450,16451,16452,16453,16454,16455,16456,16457,16458,16459,16460,16461,16476,16477,16478,16479,16480,16481,16482,16483,16484,16485,16486,16487,16488,16489,16490,16491,16492,16493,16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16523,16524,16525,16526,16527,16528,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16548,16547,16549,16550,16551,16552,16553,16554,16555,16556,16557,16558,16559,16560,16561,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579,16580,16581,16586,16831,16595,16596,16597,16598,16650,16651,16652,16653,16654,16655,16656,16657,16658,16659,16660,16661,16670,16671,16672,16673,16674,16677,16678,16679,16680,16681,16682,16683,16684,16830,16701,16702,16703,16704,16705,16706,16707,16708,16709,16710,16711,16712,16713,16714,16715,16716,16717,16718,16719,16720,16721,16722,16723,16724,16725,16726,16727,16728,16729,16730,16731,16732,16733,16834,16833,16747,16748,16823,16824,16800,16799,16803,16802,16836,16835,16827,16826,16959,16915,16916,16917,16918,16919,16920,16921,16922,16923,16924,16925,16926,16927,16928,16929,16930,16931,16932,16933,16960,16947,16948,16949,16950,16951,16952,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,14729,14730,14731,14732,14733,14734,14735,14736,14737,14738,14739,14740,15326,15327,15329,15633,15634,15635,14745,14746,14747,14748,14749,14750,14751,14752,14753,14754,14755,14756,14757,14758,14759,14760,14761,14762,14763,14764,14765,14766,14767,15330,15331,15332,15333,15334,15335,14514,14515,14523,14524,14526,14527,14530,16797,16696,16874,16685,16687,16689,16749,16691,16692,16697,16698,16700,16968,16742,16743,16787,16969,16970,16971,16972,16973,16974,16975,16976,16977,16978,14589,14590,14591,14592,14593,14594,14595,14596,14597,14598,14599,14600,14601,14602,14603,14604,14605,14606,14607,14608,14609,14610,14611,14612,14613,14614,14615,14616,14617,14888,14889,14890,14891,14892,14893,14894,14895,14896,14020,14021,14022,15061,15062,15063,15064,15065,15066,15067,15137,15141,15144,15145,15146,15150,15148,15149,15151,15152,13706,13707,13708,13709,13710,13711,13712,13713,13714,13715,13716,13717,13718,13719,13720,13721,15200,15202,15210,15198,15209,15203,15211,15208,15201,15207,15199,15197,15204,15206,15205,15733,15722,15723,15724,15725,15726,15727,15728,15729,15730,15731,15732,15734,15735,15736,15737,15738,15739,15740,15741,15742,15743,15744,15745,16127,16682,16683,16684,16920,16921,15229,15236,15225,15230,15228,15227,15226,15235,15232,15234,15237,15231,15239,15238,15233,15240,15241,15242,15243,15244,15245,15246,15247,15248,15249,15250,15251,15252,15253,15254,15255,15256,15257,15258,15259,15260,15261,15262,15263,15264,15265,15266,15267,15268,14532,14533,14534,14535,14536,14537,14538,14539,14540,14541,14542,14543,14544,14545,14546,14547,14548,14549,14550,14551,14552,14553,14554,14555,14556,14557,14558,14570,14571,14572,15324,15325,15336,15337,15338,15339,15340,15341,15342,15343,15344,15345,15346,15347,15348,15349,15350,15351,13976,13977,13978,13979,13980,13981,13982,13983,13984,13985,13986,13987,13988,13989,13990,14700,14701,14702,14703,14696,14697,14698,14699,15057,13960,13961,13962,13963,13964,13965,13966,13967,13968,13969,13970,13971,13972,13973,13974,13975,14023,14686,14687,14688,14689,14690,14691,14692,14693,14694,14695,15058,15757,15758,15355,15356,15357,15358,15359,15360,15361,15362,15363,15364,15365,16200,16201,16701,16702,16703,16704,16705,16706,16707,15372,15373,15674,15675,15676,15677,15678,15374,15375,15376,15371,15386,16822,16824,15388,15389,15390,15391,15392,15393,15394,15395,15396,15397,15398,15399,15400,15401,15402,15403,15404,15405,15406,15407,15408,15409,15410,15411,15412,15413,15414,15415,15416,15417,15418,15419,15420,15421,15422,15423,15424,15425,15426,15427,15428,15429,15430,15431,15432,15433,15434,15435,15436,15437,15438,15439,15440,15441,15442,15443,15444,15445,15446,15447,15448,15449,15695,15696,15697,15698,15699,15700,15815,15816,16158,16451,16452,16453,16454,16455,16747,16748,16823,15371,15372,15373,15374,15375,15376,15386,15674,15675,15676,15677,15678,14169,14170,14046,14047,14048,14049,14069,14070,14087,14171,14172,14173,14174,14175,14176,14177,14178,14179,14180,15705,14182,14685,14768,15504,15750,15751,15749,15748,16263,16812,16953,14131,14132,14133,14134,14135,14250,16837,15003,16841,15622,15632,15858,15867,16881,16877,15912,15993,16261,16297,16324,16325,16966,16967,16955,15604,15605,15606,15607,15608,15609,15610,15611,15612,15613,15614,15615,15616,15617,15618,15619,15580,15577,15581,15578,15579,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,16202,16203,16204,16205,16206,16207,16208,16209,16210,16211,16212,16213,16708,16709,16710,16712,16713,16714,16717,16718,16719,16720,16721,16722,16723,16724,16725,16726,16728,16730,16732,16733,14495,14496,14497,14498,14499,14500,14501,14502,14503,14504,14505,14506,14507,14508,14509,14510,16807,16808,16806,15662,15663,15664,15665,15666,15667,15668,15669,15670,15671,15672,15673,16805,16811,16810,16809,15655,15656,15657,15658,15659,15660,15661,16191,16192,16193,16194,16195,16196,16197,13600,13601,13602,13603,13604,13605,13606,13607,13608,13609,13610,13611,13612,13613,13614,13615,13616,13617,13618,13619,13888,13889,13954,13955,13766,13769,13764,13765,13768,13767,13755,13753,13752,13751,13757,13754,13756,13763,13758,13761,13759,13760,13762,13775,13772,13774,13773,13771,13770,13777,13776,13743,13747,13750,13749,13748,14906,14907,14908,14909,14910,14912,14913,14914,14915,14916,14917,14918,14919,14920,14921,14922,14923,14900,14901,14902,14911,14903,14904,14905,16825,16827,15876,15877,15878,15879,15880,15881,15882,15883,15884,15885,15886,15887,15888,15889,16177,16178,16179,16180,16181,16456,16457,16458,16459,16460,16461,16826,16799,16802,16798,16801,15772,15773,15774,15775,15776,15777,15789,15790,15791,15792,15793,15794,15795,15796,15797,16397,16396,16395,16394,16393,15863,15913,15914,16182,16183,16296,16650,16401,16402,16403,16586,16595,16596,16597,16598,16651,16652,16653,16654,16655,16656,16657,16658,16659,16660,16661,16800,16803,16947,16948,16949,16950,16951,16952,15996,15997,15998,15999,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16033,16523,16524,16525,16526,16527,16528,16468,16471,16475,16474,16473,16469,16472,16000,16025,16026,16027,16028,16029,16030,16031,16032,16034,16035,16036,16037,16038,16039,16040,16041,16042,16043,16045,16046,16047,16048,16049,16050,16051,16470,16476,16477,16478,16479,16480,16481,16482,16483,16484,16485,16486,16487,16488,16489,16052,16053,16054,16055,16056,16057,16058,16059,16060,16061,16062,16063,16064,16065,16067,16068,16069,16070,16071,16072,16073,16074,16075,16076,16077,16078,16079,16080,16081,16082,16083,16084,14234,14235,14236,14237,14238,14239,14240,14241,14242,14243,14244,14245,14246,14247,16089,15915,16090,16091,16116,16117,16118,16119,16120,16121,16122,16123,16124,16125,16126,16130,16406,16410,16416,16677,16918,16131,16132,16404,16405,16407,16408,16409,16411,16412,16413,16414,16415,16417,16418,16421,16420,16422,16678,16679,16680,16919,16833,16829,16830,16828,16832,16959,16159,16160,16161,16162,16163,16164,16165,16166,16167,16168,16439,16440,16441,16442,16443,16444,16445,16446,16447,16448,16449,16450,16831,16960,13565,13567,13568,13570,13563,13571,13578,13575,13576,13572,13577,13574,13573,13569,13566,13564,13562,14560,14018,14019,14016,14017,14001,14002,14003,14004,14005,14006,14007,14008,14009,14010,14011,14012,14013,14014,14015,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14799,14800,14801,14802,14803,14804,14805,14806,14807,14808,14809,15164,15166,15165,15167,15168,15169,15170,15171,15172,15173,15174,15175,15176,15177,15178,15179,15180,15181,15182,15183,15184,15185,15186,15187,15188,15189,15190,15191,15192,15193,16490,16491,16492,16493,16494,16495,16496,16497,16498,16499,16500,16501,16502,16503,16504,16505,16506,16507,16508,16509,16510,16511,16512,16513,16514,16515,16516,16517,16518,16519,16520,16521,16522,16529,16530,16531,16532,16533,16534,16535,16536,16537,16538,16539,16540,16541,16542,16543,16544,16548,16547,16549,16550,16551,16552,16555,16556,16557,16558,16559,16560,16561,16553,16554,16562,16563,16564,16565,16566,16567,16568,16569,16570,16571,16572,16573,16574,16575,16576,16577,16578,16579,16580,16581,15642,15641,15640,15643,15644,15645,15646,15647,15648,15649,15650,15651,16185,14089,14090,14091,14092,14093,14094,14095,14096,14097,14741,14742,14743,14744,16681,13915,13896,13911,13918,13897,13906,13899,13900,13901,13924,14365,14364,13907,13909,13910,13908,13912,13913,13914,13917,13919,13898,13920,13895,13921,13916,13922,13905,13923,13925,12995,12997,12996,13004,13009,13006,13005,13010,13007,12999,13504,13505,12991,12992,12993,12994,12998,13000,13001,13002,13003,13008,13011,13012,14629,14630,14631,14632,16922,16923,16924,16925,16926,16927,16928,16929,16930,16931,16932,16933,13309,13318,13315,13314,13319,13300,13308,13296,15195,15196,14052,13301,13298,13297,13303,13323,13304,13311,13316,13312,13313,13317,13552,13551,13550,13321,13547,13310,13307,13306,13305,13302,13299,13549,13320,13322,14707,15714,15713,15711,15712,15710,15716,15715,16114,16115,16128,16430,16431,16432,16433,16434,16435,16436,16437,16438,16915,16916,16917) AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
ControllerStartupStartup->index
|
0.0030770301818848 |
SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0029540061950684 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '349' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0026528835296631 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.002525806427002 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '307' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0022599697113037 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '8' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0020978450775146 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '12' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0020639896392822 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '72' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0020029544830322 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0017790794372559 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '315' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0017619132995605 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '101' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0016598701477051 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '13' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0016520023345947 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '396' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0016441345214844 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '100' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0015859603881836 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '126' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Cart->__construct
|
0.0015649795532227 |
SHOW TABLES LIKE 'oc_cartkeeper' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0014119148254395 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '257' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0013988018035889 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '15' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0013980865478516 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.00136399269104 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '21' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Cart->__construct
|
0.0013279914855957 |
DELETE FROM oc_cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0013148784637451 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '8' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0012791156768799 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '8' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0012669563293457 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.0012071132659912 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '100'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0012021064758301 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '13' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Cart->__construct
|
0.0011990070343018 |
DELETE FROM oc_cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0011649131774902 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '102' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0010929107666016 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '114' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/system/engine/action.php
ControllerStartupSeoPro->__construct
|
0.0010428428649902 |
SELECT `url` FROM `oc_language` WHERE `language_id` = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.0010221004486084 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '137' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0010080337524414 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '12' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Cart->__construct
|
0.00090909004211426 |
SHOW TABLES LIKE 'oc_cartkeeper_share' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00088405609130859 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '111' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00086212158203125 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '101'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00082111358642578 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.0007779598236084 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '14' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00075793266296387 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00075387954711914 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '15' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00060606002807617 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Tax->setShippingAddress
|
0.00055694580078125 |
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00054502487182617 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '12' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.00054097175598145 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '15909' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00046515464782715 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '7' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00044703483581543 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '7' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.0004429817199707 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '111' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00042295455932617 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/system/library/config.php
|
0.00038814544677734 |
SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00038409233093262 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00038313865661621 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '4' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00037407875061035 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '10' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00037384033203125 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '109'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.0003659725189209 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '102'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00036096572875977 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/library/openbay.php
Openbay->getInstalled
|
0.00033903121948242 |
SELECT * FROM oc_extension WHERE `type` = 'openbay' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Cart->__construct
|
0.00033092498779297 |
SELECT `session_id` FROM `oc_cart` WHERE `session_id` = '2hfmf9hgnqinjqeva5edm73of5' LIMIT 1 |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/layout.php
ModelJournal3Layout->get
|
0.00032615661621094 |
SELECT
layout_id,
layout_data
FROM
`oc_journal3_layout`
WHERE
`layout_id` = '6'
OR `layout_id` = -1
ORDER BY
`layout_id` DESC
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00032210350036621 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '107'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00032186508178711 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '111' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00031900405883789 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '206'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.0003049373626709 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '106'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00029611587524414 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '111'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00029587745666504 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '7' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Weight->__construct
|
0.00029516220092773 |
SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.0002899169921875 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '102'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00028896331787109 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '206' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.0002739429473877 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '16940' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00027298927307129 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '103'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00027108192443848 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '109'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00026583671569824 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '119' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00026416778564453 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '101'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00026297569274902 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '4' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/extension/event.php
ModelExtensionEvent->getEvents
|
0.0002591609954834 |
SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00025796890258789 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '115'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/library/openbay.php
Openbay->getInstalled
|
0.00025701522827148 |
SELECT * FROM oc_extension WHERE `type` = 'openbay' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Tax->setPaymentAddress
|
0.00025606155395508 |
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00025486946105957 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '109' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00025391578674316 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '133'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00025296211242676 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '247' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00025200843811035 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '103'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.00025081634521484 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '69' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00024914741516113 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '113' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00024890899658203 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '113'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00024819374084473 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '130'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00024795532226562 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '122' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00024700164794922 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '206'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00024509429931641 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '110'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00024104118347168 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '110' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00024080276489258 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '111' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00023984909057617 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '121'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00023913383483887 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '121' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00023889541625977 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '107' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00023818016052246 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '122'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00023794174194336 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '131' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00023698806762695 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '111' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00023603439331055 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '247'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00023508071899414 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '132' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00023412704467773 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '111'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory
|
0.00023388862609863 |
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '130' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1' AND c.category_id NOT IN (169,193,137,201,202,203,195,197,173,211,212,161,214,215,216,196,217,168,199,167,218,221,220,222,223,224,225,219,176,166,229,228,194,231,232,158,236,235,237,233,240,241,242,243,177,244,245,246,248,154,172,171,170,205,213,249,250,251,252,230,175,253,190,185,198,254,147) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getCategories
|
0.00023293495178223 |
SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
AND c.parent_id = '131'
ORDER BY
c.sort_order, LCASE(cd.name)
LIMIT 4
|
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00022602081298828 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '12' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00022292137145996 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '106'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Tax->setStoreAddress
|
0.00022006034851074 |
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '20' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '339') ORDER BY tr1.priority ASC |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00021815299987793 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '114'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.00021791458129883 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '311' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00021696090698242 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00021600723266602 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '8' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.0002140998840332 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '16889' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
ControllerStartupStartup->index
|
0.0002131462097168 |
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://armahookah.by/' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00021004676818848 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '123'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00020885467529297 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '115'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.00020790100097656 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '15988' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00020599365234375 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00020503997802734 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00020480155944824 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '119'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Currency->__construct
|
0.00020408630371094 |
SELECT * FROM oc_currency |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00020289421081543 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '116'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00020194053649902 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '4' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00020003318786621 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '113'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.0001990795135498 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '122'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.0001981258392334 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '130'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/system/library/journal3.php
Journal3->isProductCustomerGroupDiscounts
|
0.0001978874206543 |
SELECT COUNT(*) AS total FROM oc_product_discount WHERE product_id = '16883' AND customer_group_id = '1' AND quantity > 0 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00019717216491699 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '16' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00019693374633789 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '132'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/category.php
ModelJournal3Category->getTotalCategories
|
0.00019598007202148 |
SELECT COUNT(*) AS total
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.parent_id = '110'
AND cd.language_id = '3'
AND c2s.store_id = '0'
AND c.status = '1'
|
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00019502639770508 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '10' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00019478797912598 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/catalog/model/catalog/information.php
ModelCatalogInformation->getInformation
|
0.00019288063049316 |
SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '11' AND id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Cart->__construct
|
0.00018501281738281 |
DELETE FROM oc_cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY) |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.00017690658569336 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '75' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.00016403198242188 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '240' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/module.php
ModelJournal3Module->get
|
0.00016379356384277 |
SELECT * FROM `oc_journal3_module` WHERE `module_id` = '0' |
/var/www/www-root/data/www/armahookah.by/catalog/model/journal3/settings.php
ModelJournal3Settings->haveSkins
|
0.00015497207641602 |
SELECT
count(*) AS total
FROM
`oc_journal3_skin`
|
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.0001370906829834 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '7' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/controller/startup/startup.php
Cart\Cart->__construct
|
0.00013589859008789 |
DELETE FROM oc_cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY) |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00012993812561035 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '7' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00012421607971191 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '7' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00012302398681641 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '7' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00011897087097168 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '10' AND ss.language_id = '3' |
/var/www/www-root/data/www/armahookah.by/system/storage/modification/catalog/model/journal3/product.php
ModelJournal3Product->getProduct
|
0.00011706352233887 |
SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = '10' AND ss.language_id = '3' |