Бастауыш! - бұл карталардағы ақпаратты пайдалана отырып, қылмысты бірлесіп шешуге болатын кооперативтік детективтік ойын. Алынған ақпаратты талдаңыз, қажет карталарды ашыңыз және сіздің ойыңызша, маңызды емес карталарды тастаңыз. Екі атыс Торнадо Таун тұрғындарының ұйқысын бұзды. Таңертең ерте не болуы мүмкін?
Бастауыш! - бұл карталардағы ақпаратты пайдалана отырып, қылмысты бірлесіп шешуге болатын кооперативтік детективтік ойын. Алынған ақпаратты талдаңыз, қажет карталарды ашыңыз және сіздің ойыңызша, маңызды емес карталарды тастаңыз. Екі атыс Торнадо Таун тұрғындарының ұйқысын бұзды. Таңертең ерте не болуы мүмкін?
DEBUG enable Num SQL queries:82 Num fetched rows:349 including array rows:33 Time of script run:0.23744106292725 Time of SQL queries:0.22099351882935 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.0028с Счетчик "ModIshopGood Good statistic", время выполнения - 0с Счетчик "ModIshopGood bread", время выполнения - 0.0008с Счетчик "ModIshopGood photos", время выполнения - 0.0088с Счетчик "ModIshopGood main data", время выполнения - 0.0026с Счетчик "ModIshopGood params", время выполнения - 0.002с Счетчик "ModIshopGood Nalichie", время выполнения - 0.2083с Счетчик "ModIshopGood mklass", время выполнения - 0.0003с Счетчик "Start GetDeliveryList", время выполнения - 0с Счетчик "Get DeliveryList from cache", время выполнения - 0.0001с Счетчик "DeliveryList transforms", время выполнения - 0с Счетчик "ModIshopGood delivery", время выполнения - 0с Счетчик "Module=ishop", время выполнения - 0.2235с Счетчик "Block=stat", время выполнения - 0.0001с Счетчик "Block=cssstylescard", время выполнения - 0с Счетчик "Block=headcardjs", время выполнения - 0с Счетчик "Block=header", время выполнения - 0.0001с Счетчик "Block=catalogtree", время выполнения - 0.0005с Счетчик "Block=retailrocketblocks", время выполнения - 0.0001с Счетчик "Block=footer", время выполнения - 0.0002с Счетчик "Block=appdownload", время выполнения - 0.0001с Счетчик "Block=footercardjs", время выполнения - 0.0001с Счетчик "Block=ganalitics", время выполнения - 0.0001с Счетчик "Block=metrika", время выполнения - 0.0001с Счетчик "Block=jivosite", время выполнения - 0.0001с Счетчик "Block=statmailru", время выполнения - 0.0001с
SELECT * FROM leo_clients_unregistered WHERE register_code='32a78172a979f1f73dd5d6dc19137cfc26854d7c' # Num rows 1Run time:Time of run:0.00043702125549316
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/good_77312152464/" AND active = 1 # Num rows 0Run time:Time of run:0.00033903121948242
SELECT geo_city FROM leo_clients_unregistered WHERE client_id=567289368 LIMIT 1; # Num rows 1Run time:Time of run:0.00021696090698242
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.00017595291137695
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.0001380443572998
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.00017189979553223
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.00020217895507812
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'good_77312152464' LIMIT 1; # Num rows 0Run time:Time of run:0.0002140998840332
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.00022983551025391
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00018000602722168
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00016307830810547
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = 567289368 # Num rows 1Run time:Time of run:0.00014400482177734
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=77312152464 ORDER BY f1; # Num rows 1Run time:Time of run:0.00032782554626465
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=114701398484 # Num rows 1Run time:Time of run:0.00042486190795898
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d77312152464' # Num rows 1Run time:Time of run:0.00025296211242676
SELECT id_city, dep_id FROM leo_shops WHERE work = 1 # Num rows 136Run time:Time of run:0.00043296813964844
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.0005650520324707
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Распродажа декупажной бумаги 2024" # Num rows 4Run time:Time of run:0.0040960311889648
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Семь дней выгоды" # Num rows 85Run time:Time of run:0.0003211498260498
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=567289368 AND t1.discount_start<NOW() AND t1.discount_end>NOW(); # Num rows 0Run time:Time of run:0.00024890899658203
SELECT t2.FileName FROM images.detail_photo AS t2 WHERE DetailId=77312152464 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 1Run time:Time of run:0.00034308433532715
SELECT FileName FROM images.goods_photo WHERE GoodId=114701398484 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 0Run time:Time of run:0.00020813941955566
SELECT videolink,preview FROM images.goods_video WHERE GoodId=114701398484 AND (DetailId=0 OR DetailId=77312152464) # Num rows 0Run time:Time of run:0.00017118453979492
SELECT * FROM leo_goods_params AS t1,leo_actions AS t2 WHERE t1.id_good=114701398484 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.001816987991333
SELECT count(*) FROM `leo_details` AS t1, leo_goods_params AS t2 WHERE t1.`id_good`=t2.id_good AND t1.`id_detail` = 77312152464 AND t2.id_param=72250129794 # Num rows 1Run time:Time of run:0.00024509429931641
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=114701398484 GROUP BY t2.id_detail
ORDER BY t2.detailname ASC # Num rows 1Run time:Time of run:0.00025796890258789
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=114701398484 AND t1.id_param!=-5 ORDER BY t2.name,t1.value; # Num rows 22Run time:Time of run:0.00035500526428223
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=77312152464 ORDER BY t2.name,t1.value; # Num rows 2Run time:Time of run:0.00025486946105957
SELECT t2.filename, t2.id_purpose, t2.id_good, t2.id_detail, t2.filetype FROM images.goodfiles AS t2 WHERE (id_good = 114701398484 OR id_detail = 77312152464) AND t2.filename LIKE "%.pdf%" ORDER BY t2.filename # Num rows 1Run time:Time of run:0.00034403800964355
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=567289368; # Num rows 0Run time:Time of run:0.00035405158996582
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=567289368 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.0002439022064209
SELECT * FROM images.good_links WHERE id_good=114701398484 # Num rows 1Run time:Time of run:0.00016593933105469
SELECT * FROM images.good_links WHERE id_good=114701398484 # Num rows 1Run time:Time of run:0.00017786026000977
SELECT * FROM images.goodlinks WHERE id_goodlink = 114701398484 OR id_good=114701398484 # Num rows 21Run time:Time of run:0.043577909469604
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=114701398484 AND id_goodlink!=114701398484 AND linktype=3110748592 GROUP BY `id_goodlink`
UNION ALL
SELECT id_good AS id_goods,id_detail FROM images.goodlinks WHERE id_good!=114701398484 AND id_goodlink=114701398484 AND linktype=3110748592 GROUP BY `id_good`
)T GROUP BY id_goods # Num rows 21Run time:Time of run:0.15570592880249
SELECT value FROM leo_reviews_onpages WHERE id_good=63187625474; # Num rows 1Run time:Time of run:0.00021696090698242
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 63187625474 AND `status` = 1 # Num rows 0Run time:Time of run:0.00016593933105469
SELECT value FROM leo_reviews_onpages WHERE id_good=67531155034; # Num rows 1Run time:Time of run:0.00014019012451172
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 67531155034 AND `status` = 1 # Num rows 0Run time:Time of run:0.00014209747314453
SELECT value FROM leo_reviews_onpages WHERE id_good=71227299584; # Num rows 1Run time:Time of run:0.00012993812561035
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 71227299584 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012993812561035
SELECT value FROM leo_reviews_onpages WHERE id_good=71228341654; # Num rows 1Run time:Time of run:0.00013399124145508
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 71228341654 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013303756713867
SELECT value FROM leo_reviews_onpages WHERE id_good=77312066954; # Num rows 1Run time:Time of run:0.00012588500976562
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 77312066954 AND `status` = 1 # Num rows 0Run time:Time of run:0.00014209747314453
SELECT value FROM leo_reviews_onpages WHERE id_good=82577967694; # Num rows 1Run time:Time of run:0.00016307830810547
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 82577967694 AND `status` = 1 # Num rows 0Run time:Time of run:0.0001220703125
SELECT value FROM leo_reviews_onpages WHERE id_good=91306719744; # Num rows 1Run time:Time of run:0.00011515617370605
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 91306719744 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012493133544922
SELECT value FROM leo_reviews_onpages WHERE id_good=114166744734; # Num rows 1Run time:Time of run:0.00012302398681641
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114166744734 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012588500976562
SELECT value FROM leo_reviews_onpages WHERE id_good=114695690134; # Num rows 1Run time:Time of run:0.00014686584472656
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114695690134 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013208389282227
SELECT value FROM leo_reviews_onpages WHERE id_good=114701369634; # Num rows 1Run time:Time of run:0.00011706352233887
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701369634 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012612342834473
SELECT value FROM leo_reviews_onpages WHERE id_good=114701382504; # Num rows 1Run time:Time of run:0.00011706352233887
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701382504 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012683868408203
SELECT value FROM leo_reviews_onpages WHERE id_good=114701392084; # Num rows 1Run time:Time of run:0.00015902519226074
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701392084 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012397766113281
SELECT value FROM leo_reviews_onpages WHERE id_good=114701411374; # Num rows 1Run time:Time of run:0.00011205673217773
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701411374 AND `status` = 1 # Num rows 0Run time:Time of run:0.00011920928955078
SELECT value FROM leo_reviews_onpages WHERE id_good=114701423274; # Num rows 1Run time:Time of run:0.00013995170593262
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701423274 AND `status` = 1 # Num rows 0Run time:Time of run:0.00015616416931152
SELECT value FROM leo_reviews_onpages WHERE id_good=114701430914; # Num rows 1Run time:Time of run:0.00019097328186035
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701430914 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012993812561035
SELECT value FROM leo_reviews_onpages WHERE id_good=114701446664; # Num rows 1Run time:Time of run:0.00011301040649414
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701446664 AND `status` = 1 # Num rows 0Run time:Time of run:0.00014686584472656
SELECT value FROM leo_reviews_onpages WHERE id_good=114701469604; # Num rows 1Run time:Time of run:0.00011301040649414
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701469604 AND `status` = 1 # Num rows 0Run time:Time of run:0.00011706352233887
SELECT value FROM leo_reviews_onpages WHERE id_good=114701481804; # Num rows 1Run time:Time of run:0.00011301040649414
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701481804 AND `status` = 1 # Num rows 0Run time:Time of run:0.00029993057250977
SELECT value FROM leo_reviews_onpages WHERE id_good=114713680384; # Num rows 1Run time:Time of run:0.00022101402282715
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114713680384 AND `status` = 1 # Num rows 0Run time:Time of run:0.00016999244689941
SELECT value FROM leo_reviews_onpages WHERE id_good=114713693194; # Num rows 1Run time:Time of run:0.00019598007202148
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114713693194 AND `status` = 1 # Num rows 0Run time:Time of run:0.00016903877258301
SELECT value FROM leo_reviews_onpages WHERE id_good=114713698274; # Num rows 1Run time:Time of run:0.00012612342834473
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114713698274 AND `status` = 1 # Num rows 0Run time:Time of run:0.00015902519226074
SELECT * FROM images.goodlinks WHERE id_good=114701398484 # Num rows 2Run time:Time of run:0.00014495849609375
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=114701398484 AND id_goodlink!=114701398484 AND linktype=105 GROUP BY `id_goodlink`
)T GROUP BY id_goods # Num rows 0Run time:Time of run:0.00025200843811035
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=77312152464 OR leo_mclasses_goods.id_good=leo_details.id_good) AND leo_details.id_detail=77312152464 GROUP BY leo_mclasses.id ORDER BY leo_mclasses.id DESC LIMIT 5; # Num rows 0Run time:Time of run:0.0005180835723877
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=21 # Num rows 1Run time:Time of run:0.00020194053649902
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/good_77312152464/" AND active = 1 # Num rows 0Run time:Time of run:0.0001521110534668