DEBUG enable Num SQL queries:81 Num fetched rows:457 including array rows:8 Time of script run:0.092262983322144 Time of SQL queries:0.032396793365479 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.0027с Счетчик "ModIshopTree tree data", время выполнения - 0.0003с Счетчик "ModIshopTree breads", время выполнения - 0.0004с Счетчик "ModIshopTree treecache", время выполнения - 0.0001с Счетчик "ModIshopTree leftmenu", время выполнения - 0.0029с Счетчик "ModIshopTree cardcollect", время выполнения - 0.0457с Счетчик "ModIshopTree treesort", время выполнения - 0.0001с Счетчик "ModIshopTree filters", время выполнения - 0.0253с Счетчик "ModIshopTree design", время выполнения - 0.0003с Счетчик "ModIshopTree cardsviews", время выполнения - 0.0014с Счетчик "ModIshopTree paginator", время выполнения - 0с Счетчик "ModIshopTree mclasses", время выполнения - 0с Счетчик "Module=ishop", время выполнения - 0.0781с Счетчик "Block=stat", время выполнения - 0.0001с Счетчик "Block=cssstyles", время выполнения - 0.0001с Счетчик "Block=headcatalogjs", время выполнения - 0.0001с Счетчик "Block=header", время выполнения - 0.0001с Счетчик "Block=catalogtree", время выполнения - 0.0005с Счетчик "Block=mclasslive", время выполнения - 0.0001с Счетчик "Block=advert", время выполнения - 0.0003с Счетчик "Block=mclassbytheme", время выполнения - 0.0003с Счетчик "Block=footer", время выполнения - 0.0002с Счетчик "Block=appdownload", время выполнения - 0.0001с Счетчик "Block=footercatalogjs", время выполнения - 0.0001с Счетчик "Block=ganalitics", время выполнения - 0.0002с Счетчик "Block=metrika", время выполнения - 0.0002с Счетчик "Block=statmailru", время выполнения - 0.0001с Счетчик "Block=jivosite", время выполнения - 0.0002с
SELECT * FROM leo_clients_unregistered WHERE register_code='8e11cc8d888ff1463a1b9f89e29cc9a07f89b422' # Num rows 1Run time:Time of run:0.0003659725189209
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/tree_9538925606/" AND active = 1 # Num rows 0Run time:Time of run:0.00023698806762695
SELECT geo_city FROM leo_clients_unregistered WHERE client_id=566348463 LIMIT 1; # Num rows 1Run time:Time of run:0.0001530647277832
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.00015616416931152
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.00019502639770508
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.00020313262939453
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'tree_9538925606' LIMIT 1; # Num rows 0Run time:Time of run:0.00014090538024902
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.00043702125549316
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00020289421081543
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00012707710266113
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = 566348463 # Num rows 1Run time:Time of run:0.00017714500427246
UPDATE leo_clients_unregistered SET personaldata = '{"exp2":"expS0"}' WHERE client_id = 566348463 # Num rows 1Run time:Time of run:0.00022411346435547
UPDATE leo_clients_unregistered SET personaldata = '{"exp2":"expS1"}' WHERE client_id = 566348463 # Num rows 1Run time:Time of run:0.00017309188842773
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=566348463 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.00024890899658203
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=9538925606 # Num rows 1Run time:Time of run:0.00030016899108887
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=9538925606 # Num rows 1Run time:Time of run:0.00031185150146484
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.00040006637573242
SELECT filter_class,indexed,opened,expanded FROM leo_tree_filters WHERE id_tree= '9538925606' ORDER BY pos ASC; # Num rows 7Run time:Time of run:0.0002129077911377
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d19041359402' # Num rows 1Run time:Time of run:0.00017786026000977
SELECT id_city, dep_id FROM leo_shops WHERE work = 1 # Num rows 135Run time:Time of run:0.0003969669342041
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.00057196617126465
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Распродажа декупажной бумаги 2024" # Num rows 121Run time:Time of run:0.016072988510132
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Семь дней выгоды" # Num rows 86Run time:Time of run:0.0004119873046875
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=566348463 AND t1.discount_start<NOW() AND t1.discount_end>NOW(); # Num rows 0Run time:Time of run:0.00025510787963867
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d19043111502' # Num rows 1Run time:Time of run:0.00022006034851074
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d23320227482' # Num rows 1Run time:Time of run:0.00015997886657715
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d23322340762' # Num rows 1Run time:Time of run:0.0001530647277832
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d30471916212' # Num rows 1Run time:Time of run:0.00019979476928711
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d30471930632' # Num rows 1Run time:Time of run:0.00020790100097656
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d30471959232' # Num rows 1Run time:Time of run:0.0001838207244873
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d32207002682' # Num rows 1Run time:Time of run:0.0001518726348877
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d33093579652' # Num rows 1Run time:Time of run:0.00019478797912598
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d33100027922' # Num rows 1Run time:Time of run:0.00019502639770508
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d49403925192' # Num rows 1Run time:Time of run:0.00021815299987793
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d49403931022' # Num rows 1Run time:Time of run:0.0003058910369873
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d49406115052' # Num rows 1Run time:Time of run:0.00023484230041504
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041658132' # Num rows 1Run time:Time of run:0.00023984909057617
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041658712' # Num rows 1Run time:Time of run:0.00025391578674316
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041662282' # Num rows 1Run time:Time of run:0.00023913383483887
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041662372' # Num rows 1Run time:Time of run:0.00019121170043945
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041663632' # Num rows 1Run time:Time of run:0.00021100044250488
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041663892' # Num rows 1Run time:Time of run:0.00021886825561523
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041664482' # Num rows 1Run time:Time of run:0.00017499923706055
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041665342' # Num rows 1Run time:Time of run:0.0002129077911377
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041665892' # Num rows 1Run time:Time of run:0.0002129077911377
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041666112' # Num rows 1Run time:Time of run:0.00019502639770508
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041666422' # Num rows 1Run time:Time of run:0.00016283988952637
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041666492' # Num rows 1Run time:Time of run:0.00016117095947266
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d54041676082' # Num rows 1Run time:Time of run:0.00024294853210449
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=19041359402/*trademark*/ # Num rows 1Run time:Time of run:0.00029516220092773
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=19043111502/*trademark*/ # Num rows 1Run time:Time of run:0.00014591217041016
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=23320227482/*trademark*/ # Num rows 1Run time:Time of run:0.00012087821960449
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=23322340762/*trademark*/ # Num rows 1Run time:Time of run:0.00012397766113281
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=30471916212/*trademark*/ # Num rows 1Run time:Time of run:0.00011706352233887
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=30471930632/*trademark*/ # Num rows 1Run time:Time of run:0.00011897087097168
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=30471959232/*trademark*/ # Num rows 1Run time:Time of run:0.0001370906829834
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=32207002682/*trademark*/ # Num rows 1Run time:Time of run:0.0001220703125
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=33093579652/*trademark*/ # Num rows 1Run time:Time of run:0.0001368522644043
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=33100027922/*trademark*/ # Num rows 1Run time:Time of run:0.00012803077697754
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=49403925192/*trademark*/ # Num rows 1Run time:Time of run:0.00012302398681641
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=49403931022/*trademark*/ # Num rows 1Run time:Time of run:0.00012302398681641
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=49406115052/*trademark*/ # Num rows 1Run time:Time of run:0.00011610984802246
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041658132/*trademark*/ # Num rows 1Run time:Time of run:0.00014185905456543
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041658712/*trademark*/ # Num rows 1Run time:Time of run:0.00013494491577148
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041662282/*trademark*/ # Num rows 1Run time:Time of run:0.00014519691467285
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041662372/*trademark*/ # Num rows 1Run time:Time of run:0.00012993812561035
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041663632/*trademark*/ # Num rows 1Run time:Time of run:0.00012993812561035
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041663892/*trademark*/ # Num rows 1Run time:Time of run:0.00013899803161621
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041664482/*trademark*/ # Num rows 1Run time:Time of run:0.00012993812561035
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041665342/*trademark*/ # Num rows 1Run time:Time of run:0.00013995170593262
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041665892/*trademark*/ # Num rows 1Run time:Time of run:0.0001368522644043
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041666112/*trademark*/ # Num rows 1Run time:Time of run:0.00013303756713867
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041666422/*trademark*/ # Num rows 1Run time:Time of run:0.00012803077697754
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041666492/*trademark*/ # Num rows 1Run time:Time of run:0.00011897087097168
SELECT SQL_NO_CACHE id_good FROM leo_details WHERE id_detail=54041676082/*trademark*/ # Num rows 1Run time:Time of run:0.00011420249938965
SELECT name FROM leo_shops WHERE dep_id = 401 # Num rows 1Run time:Time of run:0.0003659725189209
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=9538925606 OR ltg.newtree_id = 9538925606 ORDER BY ltg.position; # Num rows -1Run time:Time of run:0.00021886825561523
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/tree_9538925606/" AND active = 1 # Num rows 0Run time:Time of run:0.0003058910369873
SELECT groups FROM advert_client_groups WHERE adv_client='8e11cc8d888ff1463a1b9f89e29cc9a07f89b422' # Num rows -1Run time:Time of run:0.00016021728515625
SELECT id_mclass FROM `leo_mclasses_tree` WHERE id_tree=9538925606 # Num rows 0Run time:Time of run:0.00017786026000977