Бастауыш! - бұл карталардағы ақпаратты пайдалана отырып, қылмысты бірлесіп шешуге болатын кооперативтік детективтік ойын. Алынған ақпаратты талдаңыз, қажет карталарды ашыңыз және сіздің ойыңызша, маңызды емес карталарды тастаңыз. Зират. Сұр құлпытас, мұңды ойылған қоршаулар, қаңырап бос қалды. Тіпті күндіз бұл жерде ыңғайсыз, әсіресе қазір. Жақында мұнда оғаш оқиғалар болды: жерлеу үйінің бір қызметкерінің қайтыс болуы және жұмыс ауысымының ортасында екінші оңның жұмбақ жоғалуы. Бұл кәсіпке темірдей жүйкесі бар, ойы терең, қажырлы көзқарасы қажет. Шерлок Холмс үшін бұл қарапайым, бірақ сіз ше?
Бастауыш! - бұл карталардағы ақпаратты пайдалана отырып, қылмысты бірлесіп шешуге болатын кооперативтік детективтік ойын. Алынған ақпаратты талдаңыз, қажет карталарды ашыңыз және сіздің ойыңызша, маңызды емес карталарды тастаңыз. Зират. Сұр құлпытас, мұңды ойылған қоршаулар, қаңырап бос қалды. Тіпті күндіз бұл жерде ыңғайсыз, әсіресе қазір. Жақында мұнда оғаш оқиғалар болды: жерлеу үйінің бір қызметкерінің қайтыс болуы және жұмыс ауысымының ортасында екінші оңның жұмбақ жоғалуы. Бұл кәсіпке темірдей жүйкесі бар, ойы терең, қажырлы көзқарасы қажет. Шерлок Холмс үшін бұл қарапайым, бірақ сіз ше?
DEBUG enable Num SQL queries:54 Num fetched rows:302 including array rows:15 Time of script run:0.17303013801575 Time of SQL queries:0.15271949768066 Timers out: Счетчик "Подгототовка страницы", время выполнения - 0.0029с Счетчик "ModIshopGood Good statistic", время выполнения - 0с Счетчик "ModIshopGood bread", время выполнения - 0.0008с Счетчик "ModIshopGood photos", время выполнения - 0.0095с Счетчик "ModIshopGood main data", время выполнения - 0.0025с Счетчик "ModIshopGood params", время выполнения - 0.0019с Счетчик "ModIshopGood Nalichie", время выполнения - 0.1389с Счетчик "ModIshopGood mklass", время выполнения - 0.0005с Счетчик "Start GetDeliveryList", время выполнения - 0с Счетчик "Get DeliveryList from cache", время выполнения - 0.0003с Счетчик "DeliveryList transforms", время выполнения - 0.0001с Счетчик "ModIshopGood delivery", время выполнения - 0.0001с Счетчик "Module=ishop", время выполнения - 0.1554с Счетчик "Block=stat", время выполнения - 0с Счетчик "Block=cssstylescard", время выполнения - 0с Счетчик "Block=headcardjs", время выполнения - 0с Счетчик "Block=header", время выполнения - 0.0001с Счетчик "Block=catalogtree", время выполнения - 0.0016с Счетчик "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='492bb68052cbf5e998917b7d073692c58b253fad' # Num rows 1Run time:Time of run:0.00048208236694336
SELECT new_link FROM leo_redirect WHERE old_link = "/ishop/good_71227656894/" AND active = 1 # Num rows 0Run time:Time of run:0.00024008750915527
SELECT geo_city FROM leo_clients_unregistered WHERE client_id=566935411 LIMIT 1; # Num rows 1Run time:Time of run:0.00028204917907715
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.00024294853210449
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.00014901161193848
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.0001671314239502
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.00018501281738281
SELECT index_id,title,domen
FROM leonardo_kz_ru.leo_index WHERE parent_index_id=2 AND alias
LIKE 'good_71227656894' LIMIT 1; # Num rows 0Run time:Time of run:0.00019001960754395
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.00023603439331055
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=22 # Num rows 1Run time:Time of run:0.00015091896057129
SELECT metatag FROM leonardo_kz_ru.leo_index WHERE index_id = 2 # Num rows 1Run time:Time of run:0.00018191337585449
SELECT personaldata FROM leo_clients_unregistered WHERE client_id = 566935411 # Num rows 1Run time:Time of run:0.00012993812561035
UPDATE leo_clients_unregistered SET personaldata = '{"exp2":"expS1"}' WHERE client_id = 566935411 # Num rows 1Run time:Time of run:0.00023198127746582
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=71227656894 ORDER BY f1; # Num rows 1Run time:Time of run:0.00035500526428223
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=114701382504 # Num rows 1Run time:Time of run:0.00040507316589355
SELECT card FROM leonardo_kz_test.leo_goods_cards_kz WHERE cardid='d71227656894' # Num rows 1Run time:Time of run:0.00025582313537598
SELECT id_city, dep_id FROM leo_shops WHERE work = 1 # Num rows 136Run time:Time of run:0.00053620338439941
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.00069689750671387
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Распродажа декупажной бумаги 2024" # Num rows 4Run time:Time of run:0.0043749809265137
SELECT id_good FROM leo_goods_params WHERE id_param=-5 AND value="Семь дней выгоды" # Num rows 85Run time:Time of run:0.0003359317779541
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=566935411 AND t1.discount_start<NOW() AND t1.discount_end>NOW(); # Num rows 0Run time:Time of run:0.00027918815612793
SELECT t2.FileName FROM images.detail_photo AS t2 WHERE DetailId=71227656894 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 2Run time:Time of run:0.00037908554077148
SELECT FileName FROM images.goods_photo WHERE GoodId=114701382504 AND PhotoQualityId<3 AND RoznAllow=1 ORDER BY GoodPriority DESC,TreePriority DESC,FileName ASC # Num rows 0Run time:Time of run:0.00023102760314941
SELECT videolink,preview FROM images.goods_video WHERE GoodId=114701382504 AND (DetailId=0 OR DetailId=71227656894) # Num rows 0Run time:Time of run:0.00016999244689941
SELECT * FROM leo_goods_params AS t1,leo_actions AS t2 WHERE t1.id_good=114701382504 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.0017240047454834
SELECT count(*) FROM `leo_details` AS t1, leo_goods_params AS t2 WHERE t1.`id_good`=t2.id_good AND t1.`id_detail` = 71227656894 AND t2.id_param=72250129794 # Num rows 1Run time:Time of run:0.00026583671569824
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=114701382504 GROUP BY t2.id_detail
ORDER BY t2.detailname ASC # Num rows 1Run time:Time of run:0.00025010108947754
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=114701382504 AND t1.id_param!=-5 ORDER BY t2.name,t1.value; # Num rows 22Run time:Time of run:0.0003659725189209
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=71227656894 ORDER BY t2.name,t1.value; # Num rows 2Run time:Time of run:0.00020813941955566
SELECT t2.filename, t2.id_purpose, t2.id_good, t2.id_detail, t2.filetype FROM images.goodfiles AS t2 WHERE (id_good = 114701382504 OR id_detail = 71227656894) AND t2.filename LIKE "%.pdf%" ORDER BY t2.filename # Num rows 1Run time:Time of run:0.00024008750915527
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=566935411; # Num rows 0Run time:Time of run:0.0003199577331543
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=566935411 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.00022387504577637
SELECT * FROM images.good_links WHERE id_good=114701382504 # Num rows 1Run time:Time of run:0.00017094612121582
SELECT * FROM images.good_links WHERE id_good=114701382504 # Num rows 1Run time:Time of run:0.00012898445129395
SELECT * FROM images.goodlinks WHERE id_goodlink = 114701382504 OR id_good=114701382504 # Num rows 3Run time:Time of run:0.038393020629883
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=114701382504 AND id_goodlink!=114701382504 AND linktype=3110748592 GROUP BY `id_goodlink`
UNION ALL
SELECT id_good AS id_goods,id_detail FROM images.goodlinks WHERE id_good!=114701382504 AND id_goodlink=114701382504 AND linktype=3110748592 GROUP BY `id_good`
)T GROUP BY id_goods # Num rows 3Run time:Time of run:0.096083164215088
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=82577967694 LIMIT 1; # Num rows 1Run time:Time of run:0.00033307075500488
SELECT count(*) FROM leo_goods_params WHERE `id_good` = 82577967694 AND id_param=65531636804 # Num rows 1Run time:Time of run:0.0001671314239502
SELECT SQL_NO_CACHE id_good,detailname,id_detail,prepic,detailsrating FROM leo_details WHERE id_good=82577967694 LIMIT 1; # Num rows 1Run time:Time of run:0.00016093254089355
SELECT SQL_NO_CACHE maxprice,shopnal,ishopnal FROM leo_details_price WHERE id_detail=82578099284 AND id_city=46 # Num rows 1Run time:Time of run:0.00013899803161621
SELECT value FROM leo_reviews_onpages_details WHERE id_detail=82578099284; # Num rows -1Run time:Time of run:0.00011801719665527
SELECT `rating` FROM `leo_reviews` WHERE `detail_id` = 82578099284 AND `status` = 1 # Num rows 0Run time:Time of run:0.00015497207641602
SELECT UNIX_TIMESTAMP(newtime) FROM leo_newdetails WHERE detail_id = 82578099284 # Num rows 1Run time:Time of run:0.00017380714416504
SELECT value FROM leo_reviews_onpages WHERE id_good=82577967694; # Num rows 1Run time:Time of run:0.00015783309936523
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 82577967694 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013399124145508
SELECT value FROM leo_reviews_onpages WHERE id_good=114701398484; # Num rows 1Run time:Time of run:0.00013303756713867
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114701398484 AND `status` = 1 # Num rows 0Run time:Time of run:0.00013995170593262
SELECT value FROM leo_reviews_onpages WHERE id_good=114713698274; # Num rows 1Run time:Time of run:0.00014185905456543
SELECT `rating` FROM `leo_reviews` WHERE `good_id` = 114713698274 AND `status` = 1 # Num rows 0Run time:Time of run:0.00012779235839844
SELECT * FROM images.goodlinks WHERE id_good=114701382504 # Num rows 3Run time:Time of run:0.00014495849609375
SELECT * FROM(
SELECT id_goodlink AS id_goods,id_detail FROM images.goodlinks WHERE id_good=114701382504 AND id_goodlink!=114701382504 AND linktype=105 GROUP BY `id_goodlink`
)T GROUP BY id_goods # Num rows 0Run time:Time of run:0.00019693374633789
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=71227656894 OR leo_mclasses_goods.id_good=leo_details.id_good) AND leo_details.id_detail=71227656894 GROUP BY leo_mclasses.id ORDER BY leo_mclasses.id DESC LIMIT 5; # Num rows 0Run time:Time of run:0.00049400329589844
SELECT html
FROM leonardo_kz_ru.leo_template WHERE template_id=21 # Num rows 1Run time:Time of run:0.00021815299987793
SELECT new_link FROM leo_canonical WHERE old_link = "/ishop/good_71227656894/" AND active = 1 # Num rows 0Run time:Time of run:0.00020098686218262