DEBUG enable Num SQL queries:42 Num fetched rows:299 including array rows:8 Time of script run:0.061124086380005 Time of SQL queries:0.031435489654541 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.0034с Счетчик "ModIshopTree tree data", время выполнения - 0.0004с Счетчик "ModIshopTree breads", время выполнения - 0.0005с Счетчик "ModIshopTree treecache", время выполнения - 0.0001с Счетчик "ModIshopTree leftmenu", время выполнения - 0.0035с Счетчик "ModIshopTree cardcollect", время выполнения - 0.0343с Счетчик "ModIshopTree treesort", время выполнения - 0.0002с Счетчик "ModIshopTree filters", время выполнения - 0.007с Счетчик "ModIshopTree design", время выполнения - 0.0005с Счетчик "ModIshopTree cardsviews", время выполнения - 0.0004с Счетчик "ModIshopTree paginator", время выполнения - 0с Счетчик "ModIshopTree mclasses", время выполнения - 0с Счетчик "Module=ishop", время выполнения - 0.0476с Счетчик "Block=stat", время выполнения - 0.0001с Счетчик "Block=cssstyles", время выполнения - 0с Счетчик "Block=headcatalogjs", время выполнения - 0с Счетчик "Block=header", время выполнения - 0.0001с Счетчик "Block=catalogtree", время выполнения - 0.0004с Счетчик "Block=mclasslive", время выполнения - 0.0001с Счетчик "Block=advert", время выполнения - 0.0004с Счетчик "Block=mclassbytheme", время выполнения - 0.0004с Счетчик "Block=footer", время выполнения - 0.0002с Счетчик "Block=appdownload", время выполнения - 0.0001с Счетчик "Block=footercatalogjs", время выполнения - 0.0001с Счетчик "Block=ganalitics", время выполнения - 0.0001с Счетчик "Block=metrika", время выполнения - 0.0001с Счетчик "Block=statmailru", время выполнения - 0.0001с Счетчик "Block=jivosite", время выполнения - 0.0001с
SELECT * FROM leo_clients_unregistered WHERE register_code='60efc1e171a5e7418eb0a3cae542808441c9f929' # Num rows 1Run time:Time of run:0.00049591064453125
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/tree_9538925221/" AND active = 1 # Num rows 0Run time:Time of run:0.00031089782714844
SELECT geo_city FROM leo_clients_unregistered WHERE client_id=567467679 LIMIT 1; # Num rows 1Run time:Time of run:0.00029897689819336
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.00029301643371582
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.00024580955505371
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.00030708312988281
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.00028204917907715
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'tree_9538925221' LIMIT 1; # Num rows 0Run time:Time of run:0.00024604797363281
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.00025391578674316
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00022101402282715
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00019621849060059
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = 567467679 # Num rows 1Run time:Time of run:0.00016903877258301
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=567467679 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.00035190582275391
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=9538925221 # Num rows 1Run time:Time of run:0.00034999847412109
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=9538925221 # Num rows 1Run time:Time of run:0.0004580020904541
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.00051403045654297
SELECT filter_class,indexed,opened,expanded FROM leo_tree_filters WHERE id_tree= '9538925221' ORDER BY pos ASC; # Num rows 3Run time:Time of run:0.00028300285339355
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d2669873932' # Num rows 1Run time:Time of run:0.0014359951019287
SELECT id_city, dep_id FROM leo_shops WHERE work = 1 # Num rows 136Run time:Time of run:0.00040912628173828
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.0007479190826416
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Распродажа декупажной бумаги 2024" # Num rows 4Run time:Time of run:0.0074090957641602
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Семь дней выгоды" # Num rows 85Run time:Time of run:0.00043892860412598
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=567467679 AND t1.discount_start<NOW() AND t1.discount_end>NOW(); # Num rows 0Run time:Time of run:0.00038909912109375
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d2796435512' # Num rows 1Run time:Time of run:0.0011439323425293
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d3228842912' # Num rows 1Run time:Time of run:0.00033307075500488
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d3742667642' # Num rows 1Run time:Time of run:0.0029811859130859
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d5603635552' # Num rows 1Run time:Time of run:0.00092697143554688
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d6297641402' # Num rows 1Run time:Time of run:0.00096392631530762
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d7864797992' # Num rows 1Run time:Time of run:0.0012550354003906
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d8750270652' # Num rows 1Run time:Time of run:0.00030803680419922
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d12762376692' # Num rows 1Run time:Time of run:0.0007479190826416
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d13411872422' # Num rows 1Run time:Time of run:0.00025010108947754
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d13799446242' # Num rows 1Run time:Time of run:0.00088286399841309
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d13812382022' # Num rows 1Run time:Time of run:0.00030303001403809
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d17510843592' # Num rows 1Run time:Time of run:0.00029993057250977
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d18989987262' # Num rows 1Run time:Time of run:0.0012421607971191
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d20211971312' # Num rows 1Run time:Time of run:0.0011551380157471
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d23364511312' # Num rows 1Run time:Time of run:0.0012059211730957
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=9538925221 OR ltg.newtree_id = 9538925221 ORDER BY ltg.position; # Num rows -1Run time:Time of run:0.00039196014404297
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/tree_9538925221/" AND active = 1 # Num rows 0Run time:Time of run:0.0003199577331543
SELECT groups FROM advert_client_groups WHERE adv_client='60efc1e171a5e7418eb0a3cae542808441c9f929' # Num rows -1Run time:Time of run:0.00022315979003906
SELECT id_mclass FROM `leo_mclasses_tree` WHERE id_tree=9538925221 # Num rows 0Run time:Time of run:0.00026917457580566