Script executed in 0.219 seconds using 14.51/14.65 MB memory/peak
Queries: 268
Cached queries: 2 (0.75%)
(0.2ms):SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
(0.1ms):SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));
(0.3ms):SELECT `session_id`,`data`,`ip`,`agent`,`stamp` FROM `_sessions` WHERE session_id='7888d27e641c132b0e2aa13b45b7e528'
(0.7ms):SELECT region.* FROM `region` WHERE (`region`.`published` = '1') ORDER BY `sort` ASC,`title` ASC
(0.5ms):SELECT price_settings.*, __join_region.title AS cat_region, __join_supplier.title AS cat_supplier FROM `price_settings` LEFT JOIN `region` __join_region ON `__join_region`.id = `price_settings`.fko_region LEFT JOIN `supplier` __join_supplier ON `__join_supplier`.id = `price_settings`.fko_supplier WHERE (`price_settings`.`fko_region` = 4)
(0.1ms):[CACHED] SELECT * FROM `htmlpage` WHERE pid=0 AND slug=''
(0.0ms):[CACHED] SELECT * FROM `htmlpage` WHERE pid='1' AND slug='katalog'
(0.8ms):SELECT * FROM `tovar` WHERE slug LIKE 'aiko-berkut-146'
(1.7ms):SELECT "tovar" as `table`, `tovar`.*, __join_htmlpage.title AS cat_htmlpage, __join_htmlpage.slug AS cat_htmlpage_slug, __join_optional__supplier.title AS cat_optional__supplier, __join_optional__brand.title AS cat_optional__brand, __join_optional__brand.slug AS cat_optional__brand_slug, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `tovar` LEFT JOIN `htmlpage` __join_htmlpage ON `__join_htmlpage`.id = `tovar`.fko_htmlpage LEFT JOIN `supplier` __join_optional__supplier ON `__join_optional__supplier`.id = `tovar`.fk_supplier LEFT JOIN `brand` __join_optional__brand ON `__join_optional__brand`.id = `tovar`.fk_brand LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `tovar`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `tovar`.user_id WHERE (`tovar`.`id` = 3095)
(0.6ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 3095) ORDER BY `sort` ASC
(0.6ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 3095) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.2ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 3095
(0.4ms):SHOW TABLES FROM `altskm` LIKE "review";
(0.4ms):SELECT review.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `review` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `review`.fko_tovar WHERE (`review`.`fko_tovar` = 3095) AND (`review`.`published` = 1) AND (`review`.`moderation` = 2) ORDER BY `created` DESC
(0.7ms):SHOW columns FROM `altskm`.`or_files_tovar`
(0.2ms):SELECT `id`,`tovar_id`,`files_id` FROM `or_files_tovar` WHERE tovar_id = 3095
(0.2ms):SELECT files.* FROM `files` WHERE (`files`.`id` IN (626,627,631))
(0.3ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 3095) ORDER BY `sort` ASC
(1.4ms):SELECT t1.*, count(t2.id) AS childs FROM `htmlpage` t1 LEFT JOIN `htmlpage` t2 ON t2.pid = t1.id WHERE t1.pid IN (1) AND t1.published = "1" GROUP BY t1.id ORDER BY t1.pid ASC, t1.sort ASC
(2.1ms):SELECT t1.*, count(t2.id) AS childs FROM `htmlpage` t1 LEFT JOIN `htmlpage` t2 ON t2.pid = t1.id WHERE t1.pid IN (380,439) AND t1.published = "1" GROUP BY t1.id ORDER BY t1.pid ASC, t1.sort ASC
(3.4ms):SELECT t1.*, count(t2.id) AS childs FROM `htmlpage` t1 LEFT JOIN `htmlpage` t2 ON t2.pid = t1.id WHERE t1.pid IN (173,38,3,151,381,10,259,124,12,4,421,62,103,24,245,257,458,232,612,440,444) AND t1.published = "1" GROUP BY t1.id ORDER BY t1.pid ASC, t1.sort ASC
(3.2ms):SELECT t1.*, count(t2.id) AS childs FROM `htmlpage` t1 LEFT JOIN `htmlpage` t2 ON t2.pid = t1.id WHERE t1.pid IN (137,391,392,154,418,37,372,32,316,317,376,318,402,320,319,75,632,429,106,128,107,109,159,482,152,455,604,153,436,437,438,157,158,565,434,669,7,6,599,432,660,5,383,271,459,460,477,473,468) AND t1.published = "1" GROUP BY t1.id ORDER BY t1.pid ASC, t1.sort ASC
(1.2ms):SELECT t1.*, count(t2.id) AS childs FROM `htmlpage` t1 LEFT JOIN `htmlpage` t2 ON t2.pid = t1.id WHERE t1.pid IN (554,559,560,561,557,562,563,535,461) AND t1.published = "1" GROUP BY t1.id ORDER BY t1.pid ASC, t1.sort ASC
(0.3ms):SELECT DISTINCT af_h FROM rampa WHERE published="1" ORDER BY af_h ASC
(0.2ms):SELECT DISTINCT af_w FROM rampa WHERE published="1" ORDER BY af_w ASC
(0.2ms):SELECT nastil_tip.* FROM `nastil_tip` WHERE (`nastil_tip`.`published` = '1') ORDER BY `created` DESC
(0.2ms):SELECT rampa.* FROM `rampa` WHERE (`rampa`.`published` = '1') ORDER BY `af_h` ASC,`af_w` ASC
(0.3ms):SELECT sg_price.*, __join_sg_balka.title AS cat_sg_balka, __join_sg_weight.title AS cat_sg_weight FROM `sg_price` LEFT JOIN `sg_balka` __join_sg_balka ON `__join_sg_balka`.id = `sg_price`.fko_sg_balka LEFT JOIN `sg_weight` __join_sg_weight ON `__join_sg_weight`.id = `sg_price`.fko_sg_weight WHERE (`sg_price`.`published` = '1') ORDER BY `af_price` ASC
(0.2ms):SELECT sg_balka.* FROM `sg_balka` WHERE (`sg_balka`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT sg_weight.* FROM `sg_weight` ORDER BY `sort` ASC
(0.4ms):SELECT nastil.*, __join_nastil_tip.title AS cat_nastil_tip FROM `nastil` LEFT JOIN `nastil_tip` __join_nastil_tip ON `__join_nastil_tip`.id = `nastil`.fko_nastil_tip WHERE (`nastil`.`published` = '1') ORDER BY `af_l` ASC
(0.4ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 0 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 2 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.2ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 3 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 124 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 227 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.2ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 81 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.2ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 1 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.2ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 41 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 221 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 59 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.6ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 218 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(1.0ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 30 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.4ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 154 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 203 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 206 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.6ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 210 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 58 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.5ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 245 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT t1.*, count(t2.id) AS childs FROM `main_menu` t1 LEFT JOIN `main_menu` t2 ON t2.pid = t1.id WHERE t1.pid = 92 AND t1.published = "1" GROUP BY t1.id ORDER BY t1.sort ASC
(0.3ms):SELECT * FROM `htmlpage` WHERE id = 173
(0.3ms):SELECT * FROM `htmlpage` WHERE id = 380
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 1
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 669
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 7
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 6
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 599
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 432
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 660
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 493
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 5
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 47
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 75
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 38
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 79
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 81
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 487
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 82
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 80
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 230
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 83
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 45
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 137
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 3
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 35
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 10
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 391
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 392
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 14
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 525
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 154
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 433
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 418
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 329
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 77
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 37
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 152
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 151
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 455
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 604
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 153
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 436
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 437
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 438
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 157
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 158
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 565
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 434
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 404
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 374
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 381
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 375
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 377
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 409
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 46
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 393
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 33
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 454
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 32
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 417
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 249
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 245
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 248
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 246
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 243
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 4
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 43
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 484
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 399
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 244
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 372
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 76
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 29
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 334
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 609
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 270
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 259
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 268
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 269
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 267
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 271
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 106
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 103
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 128
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 107
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 109
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 328
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 325
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 456
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 159
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 482
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 410
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 124
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 411
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 315
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 12
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 316
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 376
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 402
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 320
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 424
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 319
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 321
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 459
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 458
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 460
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 477
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 473
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 469
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 468
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 632
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 62
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 568
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 429
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 394
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 24
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 395
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 396
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 258
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 257
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 262
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 261
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 263
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 264
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 265
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 266
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 422
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 421
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 423
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 427
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 383
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 232
(0.2ms):SELECT * FROM `htmlpage` WHERE id = 236
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 240
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 425
(0.1ms):SELECT * FROM `htmlpage` WHERE id = 174
(0.3ms):SELECT footer_block.* FROM `footer_block` WHERE (`footer_block`.`published` = '1') ORDER BY `sort` ASC
(0.3ms):SELECT footer_link.*, __join_footer_block.title AS cat_footer_block FROM `footer_link` LEFT JOIN `footer_block` __join_footer_block ON `__join_footer_block`.id = `footer_link`.fko_footer_block WHERE (`footer_link`.`fko_footer_block` = 1)
(0.2ms):SELECT footer_link.*, __join_footer_block.title AS cat_footer_block FROM `footer_link` LEFT JOIN `footer_block` __join_footer_block ON `__join_footer_block`.id = `footer_link`.fko_footer_block WHERE (`footer_link`.`fko_footer_block` = 2)
(0.2ms):SELECT footer_link.*, __join_footer_block.title AS cat_footer_block FROM `footer_link` LEFT JOIN `footer_block` __join_footer_block ON `__join_footer_block`.id = `footer_link`.fko_footer_block WHERE (`footer_link`.`fko_footer_block` = 12)
(0.3ms):SELECT footer_link.*, __join_footer_block.title AS cat_footer_block FROM `footer_link` LEFT JOIN `footer_block` __join_footer_block ON `__join_footer_block`.id = `footer_link`.fko_footer_block WHERE (`footer_link`.`fko_footer_block` = 6)
(0.2ms):SELECT footer_link.*, __join_footer_block.title AS cat_footer_block FROM `footer_link` LEFT JOIN `footer_block` __join_footer_block ON `__join_footer_block`.id = `footer_link`.fko_footer_block WHERE (`footer_link`.`fko_footer_block` = 5)
(0.2ms):SELECT region.* FROM `region` WHERE (`region`.`published` = '1') ORDER BY `sort` ASC,`title` ASC
(1.1ms):SELECT htmlpage_id FROM `htmlpage_region_product_count` WHERE region_id = 4 AND product_count > 0 AND htmlpage_id IN (173,669,670,8,671,7,553,6,551,600,601,599,603,432,571,660,570,493,5,554,572,573,559,574,560,575,576,561,577,578,557,579,580,562,581,582,563,583,584,597,564,558,431,47,38,75,529,530,532,533,531,534,535,661,662,663,664,79,81,487,82,80,393,230,83,45,3,137,140,516,517,518,519,520,522,143,144,523,35,391,50,51,48,420,392,299,524,298,297,14,525,154,156,490,155,433,418,526,527,528,77,37,457,489,151,152,607,608,455,615,616,604,606,605,153,617,618,436,619,620,437,621,622,438,623,624,157,625,626,158,628,627,565,567,566,434,629,630,404,381,374,375,377,409,46,10,33,454,32,279,282,280,278,281,284,285,283,417,259,270,268,269,267,271,591,124,410,411,12,315,316,494,495,496,497,498,317,499,500,501,376,502,503,318,504,505,402,506,507,320,508,509,424,319,510,511,512,321,4,243,43,484,399,244,372,665,666,602,76,29,334,609,421,422,423,427,62,632,633,634,635,639,651,653,655,568,429,638,637,103,106,537,538,540,541,539,542,128,543,544,545,107,546,547,548,109,549,550,328,325,456,450,159,164,165,166,163,486,482,161,162,24,394,395,396,329,245,249,248,246,257,258,262,261,263,264,265,266,458,459,642,461,654,644,645,462,647,648,649,650,646,460,463,464,465,466,467,477,478,479,473,474,475,476,469,468,472,641,232,383,384,386,387,388,389,236,240,425,611,612,613,631,614,610)
(0.6ms):SELECT htmlpage_id FROM `htmlpage_region_product_count` WHERE region_id = 4 AND product_count > 0 AND htmlpage_id IN (173,669,7,6,599,432,660,493,5,47,75,79,81,487,82,80,230,83,45,137,35,10,391,392,14,525,154,433,418,329,77,37,152,455,604,153,436,437,438,157,158,565,434,404,374,375,377,409,46,151,393,33,454,32,417,249,248,246,243,43,484,399,244,372,76,29,334,609,270,268,269,267,271,106,128,107,109,328,325,456,159,482,410,411,315,316,376,402,320,424,319,321,459,460,477,473,469,468,632,568,429,394,395,396,258,262,261,263,264,265,266,422,423,427,383,236,240,425)
(1.9ms):SELECT "_user_profile" as `table`,`_user_profile`.*, _user.email FROM `_user_profile`, `_user` WHERE (_user_profile.user_id = _user.id) AND (`_user_profile`.`user_id` = '1') ORDER BY `_user_profile`.`created` DESC
(1.8ms):SELECT "_user_profile" as `table`,`_user_profile`.*, _user.email FROM `_user_profile`, `_user` WHERE (_user_profile.user_id = _user.id) AND (`_user_profile`.`user_id` = 2) ORDER BY `_user_profile`.`created` DESC
(0.3ms):SELECT * FROM `settings` WHERE slug LIKE 'product_page_title'
(1.4ms):SELECT "settings" as `table`, `settings`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `settings` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `settings`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `settings`.user_id WHERE (`settings`.`id` = 18)
(0.4ms):SELECT * FROM `settings` WHERE slug LIKE 'product_meta_description'
(1.3ms):SELECT "settings" as `table`, `settings`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `settings` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `settings`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `settings`.user_id WHERE (`settings`.`id` = 19)
(0.4ms):SELECT * FROM `settings` WHERE slug LIKE 'product_meta_keywords'
(2.0ms):SELECT "settings" as `table`, `settings`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `settings` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `settings`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `settings`.user_id WHERE (`settings`.`id` = 20)
(0.3ms):SELECT region_id FROM or_region_tovar WHERE tovar_id = 3095
(2.0ms):SELECT "supplier" as `table`, `supplier`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `supplier` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `supplier`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `supplier`.user_id WHERE (`supplier`.`id` = 194)
(2.0ms):SELECT "brand" as `table`, `brand`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `brand` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `brand`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `brand`.user_id WHERE (`brand`.`id` = 3)
(0.3ms):SELECT * FROM `brand__items` WHERE (`brand__items`.`pid` = 3) AND (`brand__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.3ms):SELECT fko_2_tovar AS rel_id FROM additional_product WHERE fko_tovar = 3095 AND published = 1 ORDER BY sort ASC
(6.7ms):SELECT tovar.id FROM tovar WHERE (((`tovar`.`fko_htmlpage` = 271 OR EXISTS (SELECT 1 FROM `or_htmlpage_tovar` oht WHERE oht.`tovar_id` = `tovar`.`id` AND oht.`htmlpage_id` = 271))) AND (tovar.id != 3095) AND ((NOT EXISTS (SELECT 1 FROM `or_region_tovar` ort WHERE ort.`tovar_id` = `tovar`.`id`) OR EXISTS (SELECT 1 FROM `or_region_tovar` ort2 WHERE ort2.`tovar_id` = `tovar`.`id` AND ort2.`region_id` = 4)))) AND (tovar.published = '1') ORDER BY RAND() LIMIT 12
(1.0ms):SELECT tovar.*, __join_htmlpage.title AS cat_htmlpage, __join_htmlpage.slug AS cat_htmlpage_slug, __join_optional__supplier.title AS cat_optional__supplier, __join_optional__brand.title AS cat_optional__brand, __join_optional__brand.slug AS cat_optional__brand_slug FROM `tovar` LEFT JOIN `htmlpage` __join_htmlpage ON `__join_htmlpage`.id = `tovar`.fko_htmlpage LEFT JOIN `supplier` __join_optional__supplier ON `__join_optional__supplier`.id = `tovar`.fk_supplier LEFT JOIN `brand` __join_optional__brand ON `__join_optional__brand`.id = `tovar`.fk_brand WHERE (`tovar`.`id` IN (3076,1220,3082,6370,6369,1228,1229,4116,4112,6365,6368,1227))
(0.4ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 1220) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.3ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 1227) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.3ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 1228) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.3ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 1229) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.3ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 3076) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 3082) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 4112) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 4116) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 6365) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 6368) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 6369) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` = 6370) AND (`tovar__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.2ms):SELECT tovar_id, region_id FROM or_region_tovar WHERE tovar_id IN (1220,1227,1228,1229,3076,3082,4112,4116,6365,6368,6369,6370)
(0.3ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 1220) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 1220
(0.2ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 1227) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 1227
(0.2ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 1228) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 1228
(0.2ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 1229) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 1229
(0.3ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 3076) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.2ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 3076
(0.3ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 3082) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.2ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 3082
(0.3ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 4112) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.2ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 4112
(0.3ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 4116) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 4116
(0.2ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 6365) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 6365
(0.3ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 6368) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 6368
(0.2ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 6369) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.1ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 6369
(0.2ms):SELECT tovar_variant.*, __join_tovar.title AS cat_tovar, __join_tovar.slug AS cat_tovar_slug FROM `tovar_variant` LEFT JOIN `tovar` __join_tovar ON `__join_tovar`.id = `tovar_variant`.fko_tovar WHERE (`tovar_variant`.`fko_tovar` = 6370) AND (`tovar_variant`.`published` = '1') ORDER BY `sort` ASC
(0.2ms):SELECT `id`,`tovar_id`,`label_id` FROM `or_label_tovar` WHERE tovar_id = 6370
(0.4ms):SELECT * FROM `tovar__items` WHERE (`tovar__items`.`pid` IN (1220,1227,1228,1229,3076,3082,4112,4116,6365,6368,6369,6370)) AND (`tovar__items`.`type` = 'photo') ORDER BY `pid` ASC,`sort` ASC
(0.2ms):SELECT fko_2_tovar, af_quantity, af_variant_id FROM complectation WHERE fko_tovar = 3095 AND published = 1 ORDER BY sort ASC
(1.2ms):SELECT "htmlpage" as `table`, `htmlpage`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `htmlpage` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `htmlpage`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `htmlpage`.user_id WHERE (`htmlpage`.`id` = 271)
(0.2ms):SELECT * FROM `htmlpage__items` WHERE (`htmlpage__items`.`pid` = 271) AND (`htmlpage__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(1.1ms):SELECT "htmlpage" as `table`, `htmlpage`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `htmlpage` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `htmlpage`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `htmlpage`.user_id WHERE (`htmlpage`.`id` = 259)
(0.2ms):SELECT * FROM `htmlpage__items` WHERE (`htmlpage__items`.`pid` = 259) AND (`htmlpage__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(1.0ms):SELECT "htmlpage" as `table`, `htmlpage`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `htmlpage` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `htmlpage`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `htmlpage`.user_id WHERE (`htmlpage`.`id` = 380)
(0.2ms):SELECT * FROM `htmlpage__items` WHERE (`htmlpage__items`.`pid` = 380) AND (`htmlpage__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(1.0ms):SELECT "htmlpage" as `table`, `htmlpage`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `htmlpage` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `htmlpage`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `htmlpage`.user_id WHERE (`htmlpage`.`id` = 1)
(0.2ms):SELECT * FROM `htmlpage__items` WHERE (`htmlpage__items`.`pid` = 1) AND (`htmlpage__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(1.1ms):SELECT "htmlpage" as `table`, `htmlpage`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `htmlpage` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `htmlpage`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `htmlpage`.user_id WHERE (`htmlpage`.`id` = 271)
(0.2ms):SELECT * FROM `htmlpage__items` WHERE (`htmlpage__items`.`pid` = 271) AND (`htmlpage__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.6ms):SELECT * FROM `htmlpage` WHERE pid=0 AND slug=''
(0.2ms):SELECT * FROM `htmlpage` WHERE pid=1 AND slug='katalog'
(1.6ms):SELECT "htmlpage" as `table`, `htmlpage`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `htmlpage` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `htmlpage`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `htmlpage`.user_id WHERE (`htmlpage`.`id` = 259)
(0.4ms):SELECT * FROM `htmlpage__items` WHERE (`htmlpage__items`.`pid` = 259) AND (`htmlpage__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
(0.3ms):SHOW TABLES FROM `altskm` LIKE "tovar__items";
(0.3ms):SELECT * FROM `htmlpage` WHERE id = 591
(1.2ms):SELECT "htmlpage" as `table`, `htmlpage`.*, __join_owner__user.email AS owner__user_email, __join_owner__user.group_id AS owner__user_group_id, __join_owner__user_profile.title AS owner__user_profile, __join_owner__user_profile.slug AS owner__user_profile_slug FROM `htmlpage` LEFT JOIN `_user` __join_owner__user ON `__join_owner__user`.id = `htmlpage`.user_id LEFT JOIN `_user_profile` __join_owner__user_profile ON `__join_owner__user_profile`.user_id = `htmlpage`.user_id WHERE (`htmlpage`.`id` = 259)
(0.3ms):SELECT * FROM `htmlpage__items` WHERE (`htmlpage__items`.`pid` = 259) AND (`htmlpage__items`.`type` = 'photo') ORDER BY `sort` ASC LIMIT 0,1
Debug info executed in 0.052 seconds