Канва – кесте тігуге арналған мақта мата. Санақ крестпен, есепсіз крестпен, атлас тігіспен, гобелен тігісімен кесте тігу үшін, кілем технологиясында қолданылады. Кенеп өте қатты және тығыз, бұл шеңберді пайдаланбай кестелеуге мүмкіндік береді.
Канва – кесте тігуге арналған мақта мата. Санақ крестпен, есепсіз крестпен, атлас тігіспен, гобелен тігісімен кесте тігу үшін, кілем технологиясында қолданылады. Кенеп өте қатты және тығыз, бұл шеңберді пайдаланбай кестелеуге мүмкіндік береді.
DEBUG enable Num SQL queries:69 Num fetched rows:275 including array rows:20 Time of script run:0.22150301933289 Time of SQL queries:0.19643473625183 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.0028с Счетчик "ModIshopGood Good statistic", время выполнения - 0с Счетчик "ModIshopGood bread", время выполнения - 0.0009с Счетчик "ModIshopGood photos", время выполнения - 0.0118с Счетчик "ModIshopGood main data", время выполнения - 0.0042с Счетчик "ModIshopGood params", время выполнения - 0.002с Счетчик "ModIshopGood Nalichie", время выполнения - 0.1794с Счетчик "ModIshopGood mklass", время выполнения - 0.0007с Счетчик "Start GetDeliveryList", время выполнения - 0с Счетчик "Get DeliveryList from cache", время выполнения - 0.0003с Счетчик "DeliveryList transforms", время выполнения - 0.0001с Счетчик "ModIshopGood delivery", время выполнения - 0.0001с Счетчик "Module=ishop", время выполнения - 0.2001с Счетчик "Block=stat", время выполнения - 0.0001с Счетчик "Block=cssstylescard", время выполнения - 0с Счетчик "Block=headcardjs", время выполнения - 0с Счетчик "Block=header", время выполнения - 0.0001с Счетчик "Block=catalogtree", время выполнения - 0.0019с Счетчик "Block=retailrocketblocks", время выполнения - 0.0003с Счетчик "Block=footer", время выполнения - 0.0007с Счетчик "Block=appdownload", время выполнения - 0.0004с Счетчик "Block=footercardjs", время выполнения - 0.0004с Счетчик "Block=ganalitics", время выполнения - 0.0004с Счетчик "Block=metrika", время выполнения - 0.0005с Счетчик "Block=jivosite", время выполнения - 0.0005с Счетчик "Block=statmailru", время выполнения - 0.0004с
SELECT * FROM leo_clients_unregistered WHERE register_code='785a382c166827e1e499166c94c86fd42568d3bd' # Num rows 1Run time:Time of run:0.00042605400085449
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/good_9602200112/" AND active = 1 # Num rows 0Run time:Time of run:0.00026583671569824
SELECT geo_city FROM leo_clients_unregistered WHERE client_id=567617062 LIMIT 1; # Num rows 1Run time:Time of run:0.00020098686218262
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.0002131462097168
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.00018000602722168
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.00017881393432617
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.00021004676818848
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'good_9602200112' LIMIT 1; # Num rows 0Run time:Time of run:0.00017809867858887
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.00025606155395508
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00019192695617676
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00013613700866699
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = 567617062 # Num rows 1Run time:Time of run:0.0001368522644043
SELECT t2.id_detail,t2.id_good,CONCAT_WS(' ',t4.f_tree_fullname,t1.goodname,t2.detailname) AS f1,CONCAT_WS('\n\n',t1.gooddescr,t6.detaildescr) AS f2, 0 AS none ,t1.id_tree,t1.dimension,t1.price, NULL, t1.f_tree_id
FROM leonardo_kz.leo_details AS t2
LEFT JOIN leonardo_kz.leo_goods AS t1 ON t2.id_good=t1.id_good
LEFT JOIN leonardo_kz.leo_tistree AS t4 ON t4.f_tree_id=t1.f_tree_id
LEFT JOIN leo_detail_desc AS t6 ON t2.id_detail=t6.id_detail
WHERE t2.id_detail=9602200112 ORDER BY f1; # Num rows 1Run time:Time of run:0.00036215782165527
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_goods AS tn
LEFT JOIN leo_tree AS t1 ON tn.id_tree=t1.id_tree
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 t1.id_tree=lt4.id_tree AND lt4.lang = "kz"
LEFT JOIN leo_tree_lang AS lt5 ON t1.id_tree=lt5.id_tree AND lt5.lang = "kz"
WHERE tn.id_good=9602199762 # Num rows 1Run time:Time of run:0.00055289268493652
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d9602200112' # Num rows 1Run time:Time of run:0.00023508071899414
SELECT id_city, dep_id FROM leo_shops WHERE work = 1 # Num rows 136Run time:Time of run:0.00056099891662598
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.00073099136352539
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Распродажа декупажной бумаги 2024" # Num rows 4Run time:Time of run:0.0065650939941406
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Семь дней выгоды" # Num rows 37Run time:Time of run:0.00031208992004395
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=567617062 AND t1.discount_start<NOW() AND t1.discount_end>NOW(); # Num rows 0Run time:Time of run:0.00029492378234863
SELECT t2.FileName FROM images.detail_photo AS t2 WHERE DetailId=9602200112 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 3Run time:Time of run:0.0003960132598877
SELECT FileName FROM images.goods_photo WHERE GoodId=9602199762 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 3Run time:Time of run:0.00029492378234863
SELECT videolink,preview FROM images.goods_video WHERE GoodId=9602199762 AND (DetailId=0 OR DetailId=9602200112) # Num rows 0Run time:Time of run:0.00020313262939453
SELECT * FROM leo_goods_params AS t1,leo_actions AS t2 WHERE t1.id_good=9602199762 AND t1.id_param=-5 AND t1.value=t2.tisname AND t2.typeid > 0 AND t2.visible = 1 AND startaction<NOW() AND endaction>NOW() AND (t2.region=0 || t2.region=3) # Num rows 0Run time:Time of run:0.0032029151916504
SELECT count(*) FROM `leo_details` AS t1, leo_goods_params AS t2 WHERE t1.`id_good`=t2.id_good AND t1.`id_detail` = 9602200112 AND t2.id_param=72250129794 # Num rows 1Run time:Time of run:0.00033807754516602
SELECT t2.id_detail,t2.detailname,t2.colorcode, t3.goodname
FROM leonardo_kz.leo_details AS t2
LEFT JOIN leonardo_kz.leo_goods AS t3 ON t2.id_good=t3.id_good
WHERE t2.id_good=9602199762 GROUP BY t2.id_detail
ORDER BY t2.detailname ASC # Num rows 1Run time:Time of run:0.0002899169921875
SELECT t2.name,t1.value,t1.id_param
FROM leonardo_kz.leo_goods_params AS t1
LEFT JOIN leonardo_kz.params AS t2 ON t1.id_param=t2.id_param
WHERE t1.id_good=9602199762 AND t1.id_param!=-5 ORDER BY t2.name,t1.value; # Num rows 17Run time:Time of run:0.00039100646972656
SELECT t2.name,t1.value, t1.id_param
FROM leonardo_kz.leo_details_params AS t1
LEFT JOIN leonardo_kz.paramsd AS t2 ON t1.id_param=t2.id_param
WHERE t1.id_detail=9602200112 ORDER BY t2.name,t1.value; # Num rows 3Run time:Time of run:0.00024509429931641
SELECT t2.filename, t2.id_purpose, t2.id_good, t2.id_detail, t2.filetype FROM images.goodfiles AS t2 WHERE (id_good = 9602199762 OR id_detail = 9602200112) AND t2.filename LIKE "%.pdf%" ORDER BY t2.filename # Num rows 0Run time:Time of run:0.00025701522827148
SELECT t1.count,t2.price,t4.goodname,t3.detailname,t1.id_detail,t5.f_tree_fullname,t2.sizes,tz.sizes,t4.discount,t4.dimension,t3.id_good,t1.market_source,t1.market_type,t1.market_id, t4.nds,t1.waited FROM leo_cart_unregistered AS t1 LEFT JOIN tis_dep AS t2 ON t1.id_detail=t2.code AND t2.dep_id=401 LEFT JOIN tis_dep AS tz ON t1.id_detail=tz.code AND tz.dep_id=1 LEFT JOIN leo_details AS t3 ON t1.id_detail=t3.id_detail LEFT JOIN leo_goods AS t4 ON t3.id_good=t4.id_good LEFT JOIN leo_tistree AS t5 ON t4.f_tree_id=t5.f_tree_id WHERE t1.client_id=567617062; # Num rows 0Run time:Time of run:0.00036907196044922
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=567617062 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.00023889541625977
SELECT * FROM images.good_links WHERE id_good=9602199762 # Num rows 1Run time:Time of run:0.0001530647277832
SELECT * FROM images.good_links WHERE id_good=9602199762 # Num rows 1Run time:Time of run:0.00013613700866699
SELECT id_goodlink,id_detail FROM images.goodlinks WHERE id_good=9602199762 AND linktype=100; # Num rows 17Run time:Time of run:0.00023412704467773
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=2177159241 LIMIT 1; # Num rows 0Run time:Time of run:0.00022101402282715
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=2177169431 LIMIT 1; # Num rows 0Run time:Time of run:0.00018978118896484
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=2177173541 LIMIT 1; # Num rows 0Run time:Time of run:0.00017499923706055
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=2503761422 LIMIT 1; # Num rows 0Run time:Time of run:0.00020122528076172
SELECT value FROM leo_reviews_onpages WHERE id_good=14315203482; # Num rows 1Run time:Time of run:0.00015401840209961
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 14315203482 AND `status` = 1 # Num rows 0Run time:Time of run:0.00015497207641602
SELECT value FROM leo_reviews_onpages WHERE id_good=28026523252; # Num rows 1Run time:Time of run:0.00012803077697754
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 28026523252 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013113021850586
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=14315179062 LIMIT 1; # Num rows 0Run time:Time of run:0.00019407272338867
SELECT value FROM leo_reviews_onpages WHERE id_good=28026516722; # Num rows 1Run time:Time of run:0.00013399124145508
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 28026516722 AND `status` = 1 # Num rows 0Run time:Time of run:0.0001380443572998
SELECT value FROM leo_reviews_onpages WHERE id_good=61762723972; # Num rows 1Run time:Time of run:0.00013113021850586
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 61762723972 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013589859008789
SELECT value FROM leo_reviews_onpages WHERE id_good=61764237902; # Num rows 1Run time:Time of run:0.00012993812561035
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 61764237902 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013303756713867
SELECT value FROM leo_reviews_onpages WHERE id_good=13364077682; # Num rows 1Run time:Time of run:0.00013113021850586
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 13364077682 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013589859008789
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=61446783772 LIMIT 1; # Num rows 1Run time:Time of run:0.00026392936706543
SELECT count(*) FROM leo_goods_params WHERE `id_good` = 61446783772 AND id_param=65531636804 # Num rows 1Run time:Time of run:0.0002140998840332
SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leo_good_price WHERE id_good=61446783772 AND id_city=46 # Num rows 0Run time:Time of run:0.00016212463378906
SELECT value FROM leo_reviews_onpages WHERE id_good=10218991092; # Num rows 1Run time:Time of run:0.00012898445129395
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 10218991092 AND `status` = 1 # Num rows 0Run time:Time of run:0.0001530647277832
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=53894521532 LIMIT 1; # Num rows 0Run time:Time of run:0.00019598007202148
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=2067820332 LIMIT 1; # Num rows 0Run time:Time of run:0.00018596649169922
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=2258927542 LIMIT 1; # Num rows 0Run time:Time of run:0.00018787384033203
SELECT value FROM leo_reviews_onpages WHERE id_good=89328299274; # Num rows 1Run time:Time of run:0.00018501281738281
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 89328299274 AND `status` = 1 # Num rows 0Run time:Time of run:0.00015091896057129
SELECT * FROM images.goodlinks WHERE id_goodlink = 9602199762 OR id_good=9602199762 # Num rows 26Run time:Time of run:0.068997859954834
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=9602199762 AND id_goodlink!=9602199762 AND linktype=3110748592 GROUP BY `id_goodlink`
UNION ALL
SELECT id_good AS id_goods,id_detail FROM images.goodlinks WHERE id_good!=9602199762 AND id_goodlink=9602199762 AND linktype=3110748592 GROUP BY `id_good`
)T GROUP BY id_goods # Num rows 1Run time:Time of run:0.10208296775818
SELECT SQL_NO_CACHE t4.id_tree,goodname,gooddescr,dimension,f_tree_id,cardtype,tis_fullname,prepic,detailcount,goodrating,oncedetail,price,good_id,t1.id_good,t1.discount FROM leo_goods AS t1 LEFT JOIN leo_goods_month ON t1.id_good=leo_goods_month.good_id LEFT JOIN leo_tree_goods AS t4 ON t1.id_good=t4.id_good WHERE t1.id_good=5142592812 LIMIT 1; # Num rows 0Run time:Time of run:0.00041317939758301
SELECT * FROM images.goodlinks WHERE id_good=9602199762 # Num rows 17Run time:Time of run:0.00021815299987793
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=9602199762 AND id_goodlink!=9602199762 AND linktype=105 GROUP BY `id_goodlink`
)T GROUP BY id_goods # Num rows 0Run time:Time of run:0.00024700164794922
SELECT leo_mclasses.* FROM leo_mclasses,leo_mclasses_goods,leo_details WHERE visible=1 AND leo_mclasses.id=leo_mclasses_goods.id_mclasses AND (leo_mclasses_goods.id_detail=9602200112 OR leo_mclasses_goods.id_good=leo_details.id_good) AND leo_details.id_detail=9602200112 GROUP BY leo_mclasses.id ORDER BY leo_mclasses.id DESC LIMIT 5; # Num rows 0Run time:Time of run:0.00057101249694824
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=21 # Num rows 1Run time:Time of run:0.00022006034851074
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/good_9602200112/" AND active = 1 # Num rows 0Run time:Time of run:0.00017619132995605