DEBUG enable Num SQL queries:108 Num fetched rows:1130 including array rows:8 Time of script run:0.10974597930908 Time of SQL queries:0.040509939193726 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.0025с Счетчик "ModIshopTree tree data", время выполнения - 0.0003с Счетчик "ModIshopTree breads", время выполнения - 0.0004с Счетчик "ModIshopTree treecache", время выполнения - 0.0001с Счетчик "ModIshopTree leftmenu", время выполнения - 0.0033с Счетчик "ModIshopTree cardcollect", время выполнения - 0.0447с Счетчик "ModIshopTree treesort", время выполнения - 0.0002с Счетчик "ModIshopTree filters", время выполнения - 0.0451с Счетчик "ModIshopTree design", время выполнения - 0.0003с Счетчик "ModIshopTree cardsviews", время выполнения - 0.0002с Счетчик "ModIshopTree paginator", время выполнения - 0с Счетчик "ModIshopTree mclasses", время выполнения - 0с Счетчик "Module=ishop", время выполнения - 0.096с Счетчик "Block=stat", время выполнения - 0.0001с Счетчик "Block=cssstyles", время выполнения - 0.0001с Счетчик "Block=headcatalogjs", время выполнения - 0с Счетчик "Block=header", время выполнения - 0.0002с Счетчик "Block=catalogtree", время выполнения - 0.0006с Счетчик "Block=mclasslive", время выполнения - 0.0001с Счетчик "Block=advert", время выполнения - 0.0003с Счетчик "Block=mclassbytheme", время выполнения - 0.0003с Счетчик "Block=footer", время выполнения - 0.0002с Счетчик "Block=appdownload", время выполнения - 0.0002с Счетчик "Block=footercatalogjs", время выполнения - 0.0002с Счетчик "Block=ganalitics", время выполнения - 0.0001с Счетчик "Block=metrika", время выполнения - 0.0002с Счетчик "Block=statmailru", время выполнения - 0.0001с Счетчик "Block=jivosite", время выполнения - 0.0002с
SELECT * FROM leo_clients_unregistered WHERE register_code='399e2a85fdd452a9cdc43097f1f60d26fa0ac751' # Num rows 1Run time:Time of run:0.0004270076751709
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/tree_9538925222/?pages=2" AND active = 1 # Num rows 0Run time:Time of run:0.00020694732666016
SELECT geo_city FROM leo_clients_unregistered WHERE client_id=567413992 LIMIT 1; # Num rows 1Run time:Time of run:0.00015807151794434
SELECT id_city,path,name,ishop_id,ishop_name,kladr_id,country_id,utc,largest_dep_id,final_sale FROM leo_city WHERE id_city=0 # Num rows 0Run time:Time of run:0.00016903877258301
SELECT id_city FROM leo_city_preffered WHERE city='Astana' ORDER BY `lock` DESC,countEnt DESC LIMIT 1; # Num rows -1Run time:Time of run:0.00017905235290527
SELECT id_city,path,name,ishop_id,ishop_name,kladr_id,country_id,utc,largest_dep_id,final_sale FROM leo_city WHERE path='astana'; # Num rows 1Run time:Time of run:0.00019001960754395
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=0 AND alias
LIKE 'ishop' LIMIT 1; # Num rows 1Run time:Time of run:0.00018405914306641
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'tree_9538925222' LIMIT 1; # Num rows 0Run time:Time of run:0.00016283988952637
SELECT IFNULL(NULLIF(lil.title,""), li.title) as title,li.template_id,li.content,li.domen,li.index_id
FROM leonardo_kz_ru.leo_index AS li LEFT JOIN leonardo_kz_ru.leo_index_lang AS lil ON li.index_id=lil.index_id AND lil.lang="kz" WHERE li.index_id=2; # Num rows 1Run time:Time of run:0.00020408630371094
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00014710426330566
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00014209747314453
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = 567413992 # Num rows 1Run time:Time of run:0.00013589859008789
SELECT t1.id,t1.discount_id,t1.discount_value,t1.discountprice_value,t1.discount_from,t1.discountcode,t1.discount_start,t2.discount_description FROM leo_clients_discounts_unregistered AS t1 LEFT JOIN leo_discounts AS t2 ON t1.discount_id=t2.discount_id WHERE t1.client_id=567413992 AND t1.discount_start<NOW() AND t1.discount_end>NOW() AND t1.discount_from<=0 ORDER BY t1.id DESC LIMIT 1; # Num rows 0Run time:Time of run:0.00021696090698242
SELECT
IFNULL(NULLIF(t3.treename,""), t1.treename) AS treename,
t2.treetype,IFNULL(NULLIF(t3.tree_description,""), t2.tree_description) AS tree_description,IFNULL(NULLIF(t3.tree_meta_description,""), t2.tree_meta_description) AS tree_meta_description,
t1.shop_tree_id,t1.level1,t1.level2,t1.level3,t1.relatedtree,
IFNULL(NULLIF(t3.titletag,""), t2.titletag) AS titletag,IFNULL(NULLIF(t3.tree_notice,""), t2.tree_notice) AS tree_notice,IFNULL(NULLIF(t3.h1tag,""), t2.h1tag) AS h1tag,t2.maintitledisable,IFNULL(NULLIF(t3.tree_meta_key,""), t2.tree_meta_key) AS tree_meta_key,t2.id_tree_canonical,t2.noindex, t2.submenuhide
FROM leo_tree AS t1
LEFT JOIN leo_tree_description AS t2 ON t1.id_tree=t2.tree_id
LEFT JOIN leo_tree_lang AS t3 ON t1.id_tree=t3.id_tree AND t3.lang="kz"
WHERE t1.id_tree=9538925222 # Num rows 1Run time:Time of run:0.00026702880859375
SELECT
t1.id_tree,IFNULL(NULLIF(lt1.treename,""),t1.treename) as treename,
t2.id_tree,IFNULL(NULLIF(lt2.treename,""),t2.treename) as treename,
t3.id_tree,IFNULL(NULLIF(lt3.treename,""),t3.treename) as treename,
t4.id_tree,IFNULL(NULLIF(lt4.treename,""),t4.treename) as treename,
t5.id_tree,IFNULL(NULLIF(lt5.treename,""),t5.treename) as treename
FROM leo_tree AS t1
LEFT JOIN leo_tree AS t2 ON t1.shop_tree_id=t2.id_tree
LEFT JOIN leo_tree AS t3 ON t2.shop_tree_id=t3.id_tree
LEFT JOIN leo_tree AS t4 ON t3.shop_tree_id=t4.id_tree
LEFT JOIN leo_tree AS t5 ON t4.shop_tree_id=t5.id_tree
LEFT JOIN leo_tree_lang AS lt1 ON t1.id_tree = lt1.id_tree AND lt1.lang = "kz"
LEFT JOIN leo_tree_lang AS lt2 ON t2.id_tree = lt2.id_tree AND lt2.lang = "kz"
LEFT JOIN leo_tree_lang AS lt3 ON t3.id_tree = lt3.id_tree AND lt3.lang = "kz"
LEFT JOIN leo_tree_lang AS lt4 ON t4.id_tree = lt4.id_tree AND lt4.lang = "kz"
LEFT JOIN leo_tree_lang AS lt5 ON t5.id_tree = lt5.id_tree AND lt5.lang = "kz"
WHERE t1.id_tree=9538925222 # Num rows 1Run time:Time of run:0.00032305717468262
SELECT lt.id_tree, IFNULL(NULLIF(ltl.treename,""),lt.treename) as treename FROM `leo_tree` AS lt LEFT JOIN `leo_tree_lang` AS ltl ON lt.id_tree=ltl.id_tree AND ltl.lang="kz" WHERE lt.id_tree IN (9538925150, 9538925221, 9538925222, 9538925231, 9538925232, 9538925241, 9538925255, 9538925257, 9538925279, 9538925297, 9538925322, 9538925368, 9538925369, 9538925370, 9538925427, 9538925430, 9538925531, 9538925595, 9538925605, 9538925606, 9538925627, 9538925652, 9538925663, 9538925805, 9538925806, 9538925808, 9538925814, 9538925816, 9538925820, 9538925872, 9538925873, 9538925911, 9538925930) # Num rows 33Run time:Time of run:0.00042295455932617
SELECT filter_class,indexed,opened,expanded FROM leo_tree_filters WHERE id_tree= '9538925222' ORDER BY pos ASC; # Num rows 17Run time:Time of run:0.00026607513427734
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g636820012' # Num rows 1Run time:Time of run:0.00023198127746582
SELECT id_city, dep_id FROM leo_shops WHERE work = 1 # Num rows 136Run time:Time of run:0.00043416023254395
SELECT * FROM leo_actions AS t1 WHERE t1.visible=1 AND t1.startaction<NOW() AND t1.endaction>NOW() AND (t1.region=0 || t1.region=3) # Num rows 4Run time:Time of run:0.00052905082702637
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Распродажа декупажной бумаги 2024" # Num rows 4Run time:Time of run:0.0044980049133301
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Семь дней выгоды" # Num rows 85Run time:Time of run:0.00032615661621094
SELECT t1.id,t1.discount_id,t1.discount_value,t1.discountprice_value,t1.discount_from,t1.discountcode,t1.discount_start,t2.discount_description,t2.discount_type FROM leo_clients_discounts_unregistered AS t1 LEFT JOIN leo_discounts AS t2 ON t1.discount_id=t2.discount_id WHERE t1.client_id=567413992 AND t1.discount_start<NOW() AND t1.discount_end>NOW(); # Num rows 0Run time:Time of run:0.00030303001403809
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g636830992' # Num rows 1Run time:Time of run:0.00095009803771973
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g1252151532' # Num rows 1Run time:Time of run:0.0013680458068848
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g1252046702' # Num rows 1Run time:Time of run:0.00016903877258301
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g1822003382' # Num rows 1Run time:Time of run:0.00016093254089355
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g1822078772' # Num rows 1Run time:Time of run:0.0001678466796875
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g2066703902' # Num rows 1Run time:Time of run:0.00017404556274414
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g3243749132' # Num rows 1Run time:Time of run:0.00014805793762207
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g3638981752' # Num rows 1Run time:Time of run:0.0011320114135742
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g4593137422' # Num rows 1Run time:Time of run:0.00017595291137695
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g6286881212' # Num rows 1Run time:Time of run:0.00056004524230957
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g6287179402' # Num rows 1Run time:Time of run:0.00018215179443359
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g6287618842' # Num rows 1Run time:Time of run:0.00035881996154785
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g8016290882' # Num rows 1Run time:Time of run:0.00077605247497559
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g8820222812' # Num rows 1Run time:Time of run:0.00094699859619141
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g9466640772' # Num rows 1Run time:Time of run:0.00061798095703125
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g11532476122' # Num rows 1Run time:Time of run:0.00017309188842773
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g13525371322' # Num rows 1Run time:Time of run:0.00063991546630859
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g20813290592' # Num rows 1Run time:Time of run:0.00021219253540039
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g20814330432' # Num rows 1Run time:Time of run:0.00017189979553223
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g22355968282' # Num rows 1Run time:Time of run:0.00075697898864746
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g30372044262' # Num rows 1Run time:Time of run:0.0012228488922119
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g33172288292' # Num rows 1Run time:Time of run:0.00072407722473145
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g36164052502' # Num rows 1Run time:Time of run:0.00057196617126465
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g42762876582' # Num rows 1Run time:Time of run:0.00070905685424805
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g53837448502' # Num rows 1Run time:Time of run:0.00023579597473145
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g53839692312' # Num rows 1Run time:Time of run:0.00017094612121582
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g53840283532' # Num rows 1Run time:Time of run:0.00078511238098145
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g53862113942' # Num rows 1Run time:Time of run:0.00020408630371094
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g55937517682' # Num rows 1Run time:Time of run:0.00071907043457031
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g62388404744' # Num rows 1Run time:Time of run:0.00074386596679688
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g67750525934' # Num rows 1Run time:Time of run:0.00021195411682129
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g71537738244' # Num rows 1Run time:Time of run:0.0011179447174072
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g74394455484' # Num rows 1Run time:Time of run:0.00084590911865234
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g80345129664' # Num rows 1Run time:Time of run:0.00152587890625
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g80791094134' # Num rows 1Run time:Time of run:0.0014960765838623
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g81155088944' # Num rows 1Run time:Time of run:0.0005948543548584
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g81572893854' # Num rows 1Run time:Time of run:0.00055718421936035
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g90750153664' # Num rows 1Run time:Time of run:0.00021195411682129
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='g94043322524' # Num rows 1Run time:Time of run:0.0001671314239502
SELECT id_detail FROM leo_details WHERE id_good=636820012 # Num rows 25Run time:Time of run:0.00028014183044434
SELECT id_detail FROM leo_details WHERE id_good=636830992 # Num rows 10Run time:Time of run:0.00018692016601562
SELECT id_detail FROM leo_details WHERE id_good=1252151532 # Num rows 15Run time:Time of run:0.00014686584472656
SELECT id_detail FROM leo_details WHERE id_good=1252046702 # Num rows 30Run time:Time of run:0.00014495849609375
SELECT id_detail FROM leo_details WHERE id_good=1822003382 # Num rows 17Run time:Time of run:0.00014901161193848
SELECT id_detail FROM leo_details WHERE id_good=1822078772 # Num rows 14Run time:Time of run:0.00014305114746094
SELECT id_detail FROM leo_details WHERE id_good=2066703902 # Num rows 11Run time:Time of run:0.00013113021850586
SELECT id_detail FROM leo_details WHERE id_good=3243749132 # Num rows 26Run time:Time of run:0.00015497207641602
SELECT id_detail FROM leo_details WHERE id_good=3638981752 # Num rows 29Run time:Time of run:0.00015687942504883
SELECT id_detail FROM leo_details WHERE id_good=4593137422 # Num rows 22Run time:Time of run:0.00016593933105469
SELECT id_detail FROM leo_details WHERE id_good=6286881212 # Num rows 26Run time:Time of run:0.00025105476379395
SELECT id_detail FROM leo_details WHERE id_good=6287179402 # Num rows 28Run time:Time of run:0.00016379356384277
SELECT id_detail FROM leo_details WHERE id_good=6287618842 # Num rows 30Run time:Time of run:0.00014710426330566
SELECT id_detail FROM leo_details WHERE id_good=8016290882 # Num rows 29Run time:Time of run:0.00018191337585449
SELECT id_detail FROM leo_details WHERE id_good=8820222812 # Num rows 9Run time:Time of run:0.00014805793762207
SELECT id_detail FROM leo_details WHERE id_good=9466640772 # Num rows 11Run time:Time of run:0.00012803077697754
SELECT id_detail FROM leo_details WHERE id_good=11532476122 # Num rows 27Run time:Time of run:0.00014901161193848
SELECT id_detail FROM leo_details WHERE id_good=13525371322 # Num rows 13Run time:Time of run:0.00018787384033203
SELECT id_detail FROM leo_details WHERE id_good=20813290592 # Num rows 22Run time:Time of run:0.00014901161193848
SELECT id_detail FROM leo_details WHERE id_good=20814330432 # Num rows 14Run time:Time of run:0.0001530647277832
SELECT id_detail FROM leo_details WHERE id_good=22355968282 # Num rows 27Run time:Time of run:0.00014305114746094
SELECT id_detail FROM leo_details WHERE id_good=30372044262 # Num rows 16Run time:Time of run:0.00016117095947266
SELECT id_detail FROM leo_details WHERE id_good=33172288292 # Num rows 20Run time:Time of run:0.00013899803161621
SELECT id_detail FROM leo_details WHERE id_good=36164052502 # Num rows 11Run time:Time of run:0.00013995170593262
SELECT id_detail FROM leo_details WHERE id_good=42762876582 # Num rows 10Run time:Time of run:0.00015687942504883
SELECT id_detail FROM leo_details WHERE id_good=53837448502 # Num rows 16Run time:Time of run:0.00014305114746094
SELECT id_detail FROM leo_details WHERE id_good=53839692312 # Num rows 12Run time:Time of run:0.00017189979553223
SELECT id_detail FROM leo_details WHERE id_good=53840086872 # Num rows 14Run time:Time of run:0.00015687942504883
SELECT id_detail FROM leo_details WHERE id_good=53840283532 # Num rows 29Run time:Time of run:0.00015997886657715
SELECT id_detail FROM leo_details WHERE id_good=53862113942 # Num rows 12Run time:Time of run:0.00020098686218262
SELECT id_detail FROM leo_details WHERE id_good=55937517682 # Num rows 15Run time:Time of run:0.00019216537475586
SELECT id_detail FROM leo_details WHERE id_good=62388404744 # Num rows 9Run time:Time of run:0.00018501281738281
SELECT id_detail FROM leo_details WHERE id_good=67750525934 # Num rows 8Run time:Time of run:0.00019192695617676
SELECT id_detail FROM leo_details WHERE id_good=71537738244 # Num rows 22Run time:Time of run:0.0001528263092041
SELECT id_detail FROM leo_details WHERE id_good=74394455484 # Num rows 23Run time:Time of run:0.00013995170593262
SELECT id_detail FROM leo_details WHERE id_good=80345129664 # Num rows 20Run time:Time of run:0.0001368522644043
SELECT id_detail FROM leo_details WHERE id_good=80791094134 # Num rows 22Run time:Time of run:0.00014209747314453
SELECT id_detail FROM leo_details WHERE id_good=81155088944 # Num rows 7Run time:Time of run:0.00015616416931152
SELECT id_detail FROM leo_details WHERE id_good=81572893854 # Num rows 10Run time:Time of run:0.00013399124145508
SELECT id_detail FROM leo_details WHERE id_good=90750153664 # Num rows 16Run time:Time of run:0.0001370906829834
SELECT id_detail FROM leo_details WHERE id_good=94043322524 # Num rows 24Run time:Time of run:0.0001521110534668
SELECT name FROM leo_shops WHERE dep_id = 401 # Num rows 1Run time:Time of run:0.00021910667419434
SELECT ltg.tag_id, ltg.tree_id,
IFNULL(NULLIF(ltgl.tagname, ""), ltg.tagname) as tagname, ltg.taglink, ltg.path, ltg.newtree_id,
IFNULL(NULLIF(ltgl.filterkeys, ""), ltg.filterkeys) as filterkeys,
IFNULL(NULLIF(ltgl.meta_description, ""), ltg.meta_description) as meta_description,
IFNULL(NULLIF(ltgl.titletag, ""), ltg.titletag) as titletag,
IFNULL(NULLIF(ltgl.h1tag, ""), ltg.h1tag) as h1tag, show_in_head, show_in_foot, show_in_kz, show_in_by
FROM leo_tree_tags AS ltg
LEFT JOIN leo_tree_tags_lang AS ltgl ON ltg.tag_id = ltgl.tag_id AND ltgl.lang = "kz"
WHERE ltg.tree_id=9538925222 OR ltg.newtree_id = 9538925222 ORDER BY ltg.position; # Num rows -1Run time:Time of run:0.00020098686218262
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/tree_9538925222/?pages=2" AND active = 1 # Num rows 0Run time:Time of run:0.00020194053649902
SELECT groups FROM advert_client_groups WHERE adv_client='399e2a85fdd452a9cdc43097f1f60d26fa0ac751' # Num rows -1Run time:Time of run:0.00014519691467285
SELECT id_mclass FROM `leo_mclasses_tree` WHERE id_tree=9538925222 # Num rows 0Run time:Time of run:0.00016403198242188