DEBUG enable Num SQL queries:19 Num fetched rows:52 including array rows:1 Time of script run:0.04243016242981 Time of SQL queries:0.0050690174102783 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.002с Счетчик "ModIshopTree tree data", время выполнения - 0.0004с Счетчик "ModIshopTree breads", время выполнения - 0.0005с Счетчик "ModIshopTree treecache", время выполнения - 0.0001с Счетчик "ModIshopTree leftmenu", время выполнения - 0.0013с Счетчик "ModIshopTree cardcollect", время выполнения - 0.0115с Счетчик "ModIshopTree treesort", время выполнения - 0.0002с Счетчик "ModIshopTree filters", время выполнения - 0.0047с Счетчик "ModIshopTree design", время выполнения - 0.0003с Счетчик "ModIshopTree cardsviews", время выполнения - 0.0023с Счетчик "ModIshopTree paginator", время выполнения - 0с Счетчик "ModIshopTree mclasses", время выполнения - 0с Счетчик "Module=ishop", время выполнения - 0.0233с Счетчик "Block=stat", время выполнения - 0.0002с Счетчик "Block=cssstyles", время выполнения - 0.0001с Счетчик "Block=headcatalogjs", время выполнения - 0.0001с Счетчик "Block=header", время выполнения - 0.0003с Счетчик "Block=catalogtree", время выполнения - 0.0008с Счетчик "Block=mclasslive", время выполнения - 0.0002с Счетчик "Block=advert", время выполнения - 0.0003с Счетчик "Block=mclassbytheme", время выполнения - 0.0005с Счетчик "Block=footer", время выполнения - 0.0003с Счетчик "Block=appdownload", время выполнения - 0.0003с Счетчик "Block=footercatalogjs", время выполнения - 0.0002с Счетчик "Block=ganalitics", время выполнения - 0.0003с Счетчик "Block=metrika", время выполнения - 0.0003с Счетчик "Block=statmailru", время выполнения - 0.0002с Счетчик "Block=jivosite", время выполнения - 0.0003с
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/tree_3811211309/?pages=9" AND active = 1 # 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.0001680850982666
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.00021219253540039
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.00025105476379395
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'tree_3811211309' LIMIT 1; # Num rows 0Run time:Time of run:0.00020408630371094
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.00025415420532227
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00019001960754395
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00018000602722168
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = -1 # Num rows 0Run time:Time of run:0.00017213821411133
UPDATE leo_clients_unregistered SET personaldata = '{"exp2":"expS0"}' WHERE client_id = -1 # Num rows 0Run time:Time of run:0.00021100044250488
UPDATE leo_clients_unregistered SET personaldata = '{"exp2":"expS1"}' WHERE client_id = -1 # Num rows 0Run time:Time of run:0.00015997886657715
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=3811211309 # Num rows 1Run time:Time of run:0.00040102005004883
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=3811211309 # Num rows 1Run time:Time of run:0.00044488906860352
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 (3811211309, 9538925608, 9538925607, 9538925535, 9538925628, 9538925635, 9538925640, 9538925642, 9538925665, 9538925687, 9538925694, 9538925714, 9538925715, 9538925716, 9538925802, 9538925803, 9538925277, 9538925807, 9538925626, 9538925818, 9538925545, 9538925935, 9538925557, 9538925565, 9538925952, 9538925953, 9538925954, 9538925601, 9538925304) # Num rows 29Run time:Time of run:0.00053715705871582
SELECT filter_class,indexed,opened,expanded FROM leo_tree_filters WHERE id_tree= '3811211309' ORDER BY pos ASC; # Num rows 12Run time:Time of run:0.00026798248291016
SELECT name FROM leo_shops WHERE dep_id = 401 # Num rows 1Run time:Time of run:0.00031208992004395
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=3811211309 OR ltg.newtree_id = 3811211309 ORDER BY ltg.position; # Num rows -1Run time:Time of run:0.0002291202545166
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/tree_3811211309/?pages=9" AND active = 1 # Num rows 0Run time:Time of run:0.00025796890258789
SELECT id_mclass FROM `leo_mclasses_tree` WHERE id_tree=3811211309 # Num rows 0Run time:Time of run:0.00028300285339355