Re: замена http в тексте на ссылки угу ((( как шмогла ((( я не умею писать сложные запросы ((((( могу конечно пол дня проебаться и написать.....но сходу никак (((( ну а так да, ты прав, надо оптимизировать....возможно много лишнего и ненужного тяну, типа просмотров, рейтинга и прочего....
Re: замена http в тексте на ссылки запросы давай поглядим. =) собери запросы и время выполнения в массив, посмотрим че там.
Re: замена http в тексте на ссылки сюда тебе их выложить? я как ссылку не дам, как пару проверок на инъекции через форму поиска получаю 100% )
Re: замена http в тексте на ссылки да я не столько взлома боюсь, как того что вы меня заклюете нафик с потрохами )))) Добавлено спустя 27 минут 11 секунд: ну...вобщем я собрал.....но даже мне страшно выкладывать (((( меня не то что клевать, меня пиздить ногами надо ((((
Re: замена http в тексте на ссылки ну, нате, первая сотня ) Код (Text): [0] => SET NAMES utf8 [1] => SELECT * FROM `prefix_structure` WHERE true ORDER BY parent_id, order_number [2] => SELECT * FROM `prefix_structure` WHERE id='index' LIMIT 1 [3] => SELECT * FROM prefix_stat_domain [4] => SELECT * FROM prefix_stat_robot [5] => SELECT * FROM prefix_stat_partner_eregs [6] => SELECT * FROM prefix_stat_partner_eregs [7] => INSERT INTO prefix_stat_uri (IDUri, uri, tstc) VALUES (0, '/', UNIX_TIMESTAMP()) [8] => INSERT INTO prefix_stat_host (IDHost, IDPartner, IDReferer, IDUri, IDSearch, IDWord, IDSess, ip, iplong, tstc) VALUES (0, '0', '0', '32249', '0', '0', '3ac0e2b4043fe642cf7eabe926a32625', '95.24.114.217', '1595437785', UNIX_TIMESTAMP()) [9] => SELECT id, parent_id, serialize FROM `prefix_structure` WHERE id='index' LIMIT 1 [10] => SELECT id, parent_id, serialize FROM `prefix_structure` WHERE id='index' LIMIT 1 [11] => SELECT id,parent_id FROM `prefix_modules` WHERE parent_id IS NOT NULL [12] => SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [13] => SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [14] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [15] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 3 ORDER BY `order` [16] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [17] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=11 AND items.`available`=1 [18] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=15 AND items.`available`=1 [19] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=18 AND items.`available`=1 [20] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=23 AND items.`available`=1 [21] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=24 AND items.`available`=1 [22] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [23] => SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [24] => SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [25] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [26] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 9 ORDER BY `order` [27] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [28] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=10 AND items.`available`=1 [29] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=26 AND items.`available`=1 [30] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=29 AND items.`available`=1 [31] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [32] => SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [33] => SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [34] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [35] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 1 ORDER BY `order` [36] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 2 ORDER BY `order` [37] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 5 ORDER BY `order` [38] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 19 ORDER BY `order` [39] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 4 ORDER BY `order` [40] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 6 ORDER BY `order` [41] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 7 ORDER BY `order` [42] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 8 ORDER BY `order` [43] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 12 ORDER BY `order` [44] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 13 ORDER BY `order` [45] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 14 ORDER BY `order` [46] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 20 ORDER BY `order` [47] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 21 ORDER BY `order` [48] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 25 ORDER BY `order` [49] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 27 ORDER BY `order` [50] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 28 ORDER BY `order` [51] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [52] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=2 AND items.`available`=1 [53] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=5 AND items.`available`=1 [54] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=19 AND items.`available`=1 [55] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=4 AND items.`available`=1 [56] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=6 AND items.`available`=1 [57] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=7 AND items.`available`=1 [58] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=8 AND items.`available`=1 [59] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=12 AND items.`available`=1 [60] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=13 AND items.`available`=1 [61] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=14 AND items.`available`=1 [62] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=20 AND items.`available`=1 [63] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=21 AND items.`available`=1 [64] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=25 AND items.`available`=1 [65] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=27 AND items.`available`=1 [66] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=28 AND items.`available`=1 [67] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [68] => SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [69] => SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [70] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [71] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 16 ORDER BY `order` [72] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 17 ORDER BY `order` [73] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 22 ORDER BY `order` [74] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [75] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=17 AND items.`available`=1 [76] => SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=22 AND items.`available`=1 [77] => SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [78] => SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [79] => SELECT * FROM `prefix_catalog_catalog1_inner_filters` WHERE `stringid` ="last_index" LIMIT 1 [80] => SELECT * FROM `prefix_catalog_item_props` WHERE `module_id` = "catalog1" AND (`group_id`=0) ORDER BY `order`, `name_full` [81] => SELECT COUNT(*) AS count FROM prefix_catalog_catalog1_items AS items WHERE ( items.`available`=1 ) AND (true ) [82] => SELECT items.id , items.name, items.description, items.exemple_code, items.code, items.application, items.author, items.url, items.source, items.date, items.demo, items.demo_file, items.viplata, items.tag1, items.tag2, items.tag3,items.vote, items.rating FROM prefix_catalog_catalog1_items AS items WHERE ( items.`available`=1 ) AND (true ) order by id desc LIMIT 0, 24 [83] => SELECT * FROM `prefix_catalog_item_props` WHERE `module_id` = "catalog1" AND (`group_id`=0) ORDER BY `order`,`name_full` [84] => SELECT * FROM `prefix_modules` WHERE id='catalog1' LIMIT 1 [85] => SELECT * FROM `prefix_modules` WHERE id='catalog' LIMIT 1 [86] => SELECT MIN(cat_id) FROM `prefix_catalog_catalog1_item2cat` WHERE `item_id`=77 [87] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `id`=1 LIMIT 1 [88] => SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/index.html?snipid=77' LIMIT 1 [89] => SELECT COUNT(*) AS count FROM `prefix_tree_comments` WHERE `page_sub_id`='snipid=77,' AND `available` = 1 LIMIT 1 [90] => SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/catalog.html?snipid=77' LIMIT 1 [91] => SELECT * FROM `prefix_modules` WHERE id='catalog1' LIMIT 1 [92] => SELECT * FROM `prefix_modules` WHERE id='catalog' LIMIT 1 [93] => SELECT MIN(cat_id) FROM `prefix_catalog_catalog1_item2cat` WHERE `item_id`=76 [94] => SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `id`=9 LIMIT 1 [95] => SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/index.html?snipid=76' LIMIT 1 [96] => SELECT COUNT(*) AS count FROM `prefix_tree_comments` WHERE `page_sub_id`='snipid=76,' AND `available` = 1 LIMIT 1 [97] => SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/catalog.html?snipid=76' LIMIT 1 [98] => SELECT * FROM `prefix_modules` WHERE id='catalog1' LIMIT 1 [99] => SELECT * FROM `prefix_modules` WHERE id='catalog' LIMIT 1 [100] => SELECT MIN(cat_id) FROM `prefix_catalog_catalog1_item2cat` WHERE `item_id`=75
Re: замена http в тексте на ссылки а время, время?! Добавлено спустя 20 секунд: запрос, время, количество строк в результате покаж =)
Re: замена http в тексте на ссылки т.е. по каждому запросу посмотреть время? и сколько строк выгребается? а кол-во строк зачем?
хм....да дело було не в бобине.....смотрите Код (Text): [0] => common time: 4.79221343994E-5 time: 4.79221343994E-5 rows: 0 query: SET NAMES utf8 [1] => common time: 9.48905944824E-5 time: 4.6968460083E-5 rows: 19 query: SELECT * FROM `prefix_structure` WHERE true ORDER BY parent_id, order_number [2] => common time: 0.000123977661133 time: 2.90870666504E-5 rows: 1 query: SELECT * FROM `prefix_structure` WHERE id='index' LIMIT 1 [3] => common time: 0.000149965286255 time: 2.59876251221E-5 rows: 0 query: SELECT * FROM prefix_stat_domain [4] => common time: 0.000207901000977 time: 5.79357147217E-5 rows: 330 query: SELECT * FROM prefix_stat_robot [5] => common time: 0.000234842300415 time: 2.69412994385E-5 rows: 10 query: SELECT * FROM prefix_stat_partner_eregs [6] => common time: 0.000267744064331 time: 3.2901763916E-5 rows: 10 query: SELECT * FROM prefix_stat_partner_eregs [7] => common time: 0.00205564498901 time: 0.00178790092468 rows: 1 query: INSERT INTO prefix_stat_uri (IDUri, uri, tstc) VALUES (0, '/', UNIX_TIMESTAMP()) [8] => common time: 0.00222158432007 time: 0.000165939331055 rows: 1 query: INSERT INTO prefix_stat_host (IDHost, IDPartner, IDReferer, IDUri, IDSearch, IDWord, IDSess, ip, iplong, tstc) VALUES (0, '0', '0', '32535', '0', '0', '3ac0e2b4043fe642cf7eabe926a32625', '95.24.113.189', '1595437501', UNIX_TIMESTAMP()) [9] => common time: 0.00225162506104 time: 3.00407409668E-5 rows: 1 query: SELECT id, parent_id, serialize FROM `prefix_structure` WHERE id='index' LIMIT 1 [10] => common time: 0.00227761268616 time: 2.59876251221E-5 rows: 1 query: SELECT id, parent_id, serialize FROM `prefix_structure` WHERE id='index' LIMIT 1 [11] => common time: 0.00230360031128 time: 2.59876251221E-5 rows: 16 query: SELECT id,parent_id FROM `prefix_modules` WHERE parent_id IS NOT NULL [12] => common time: 0.00234055519104 time: 3.69548797607E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [13] => common time: 0.00240969657898 time: 6.91413879395E-5 rows: 1 query: SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [14] => common time: 0.0024425983429 time: 3.2901763916E-5 rows: 29 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [15] => common time: 0.00247263908386 time: 3.00407409668E-5 rows: 5 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 3 ORDER BY `order` [16] => common time: 0.0025007724762 time: 2.8133392334E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [17] => common time: 0.00253486633301 time: 3.40938568115E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=11 AND items.`available`=1 [18] => common time: 0.0025589466095 time: 2.40802764893E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=15 AND items.`available`=1 [19] => common time: 0.00258278846741 time: 2.38418579102E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=18 AND items.`available`=1 [20] => common time: 0.00260496139526 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=23 AND items.`available`=1 [21] => common time: 0.00262689590454 time: 2.19345092773E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=24 AND items.`available`=1 [22] => common time: 0.00265097618103 time: 2.40802764893E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [23] => common time: 0.002690076828 time: 3.91006469727E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [24] => common time: 0.00271701812744 time: 2.69412994385E-5 rows: 1 query: SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [25] => common time: 0.00274515151978 time: 2.8133392334E-5 rows: 29 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [26] => common time: 0.00277018547058 time: 2.50339508057E-5 rows: 3 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 9 ORDER BY `order` [27] => common time: 0.00279402732849 time: 2.38418579102E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [28] => common time: 0.00281620025635 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=10 AND items.`available`=1 [29] => common time: 0.00284123420715 time: 2.50339508057E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=26 AND items.`available`=1 [30] => common time: 0.00286316871643 time: 2.19345092773E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=29 AND items.`available`=1 [31] => common time: 0.00288724899292 time: 2.40802764893E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [32] => common time: 0.00291514396667 time: 2.78949737549E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [33] => common time: 0.0029411315918 time: 2.59876251221E-5 rows: 1 query: SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [34] => common time: 0.00297904014587 time: 3.79085540771E-5 rows: 29 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [35] => common time: 0.00300598144531 time: 2.69412994385E-5 rows: 14 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 1 ORDER BY `order` [36] => common time: 0.0030369758606 time: 3.09944152832E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 2 ORDER BY `order` [37] => common time: 0.00306081771851 time: 2.38418579102E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 5 ORDER BY `order` [38] => common time: 0.00308585166931 time: 2.50339508057E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 19 ORDER BY `order` [39] => common time: 0.00311803817749 time: 3.21865081787E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 4 ORDER BY `order` [40] => common time: 0.0031430721283 time: 2.50339508057E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 6 ORDER BY `order` [41] => common time: 0.00316596031189 time: 2.28881835938E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 7 ORDER BY `order` [42] => common time: 0.00318884849548 time: 2.28881835938E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 8 ORDER BY `order` [43] => common time: 0.00321173667908 time: 2.28881835938E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 12 ORDER BY `order` [44] => common time: 0.00323390960693 time: 2.21729278564E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 13 ORDER BY `order` [45] => common time: 0.00325584411621 time: 2.19345092773E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 14 ORDER BY `order` [46] => common time: 0.00327777862549 time: 2.19345092773E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 20 ORDER BY `order` [47] => common time: 0.00329971313477 time: 2.19345092773E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 21 ORDER BY `order` [48] => common time: 0.00332188606262 time: 2.21729278564E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 25 ORDER BY `order` [49] => common time: 0.0033438205719 time: 2.19345092773E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 27 ORDER BY `order` [50] => common time: 0.00336599349976 time: 2.21729278564E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 28 ORDER BY `order` [51] => common time: 0.00338912010193 time: 2.31266021729E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [52] => common time: 0.00341320037842 time: 2.40802764893E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=2 AND items.`available`=1 [53] => common time: 0.00343632698059 time: 2.31266021729E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=5 AND items.`available`=1 [54] => common time: 0.00345849990845 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=19 AND items.`available`=1 [55] => common time: 0.00348448753357 time: 2.59876251221E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=4 AND items.`available`=1 [56] => common time: 0.00350666046143 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=6 AND items.`available`=1 [57] => common time: 0.0035297870636 time: 2.31266021729E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=7 AND items.`available`=1 [58] => common time: 0.00355172157288 time: 2.19345092773E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=8 AND items.`available`=1 [59] => common time: 0.00357389450073 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=12 AND items.`available`=1 [60] => common time: 0.00359606742859 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=13 AND items.`available`=1 [61] => common time: 0.00361919403076 time: 2.31266021729E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=14 AND items.`available`=1 [62] => common time: 0.00364136695862 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=20 AND items.`available`=1 [63] => common time: 0.00366544723511 time: 2.40802764893E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=21 AND items.`available`=1 [64] => common time: 0.00368857383728 time: 2.31266021729E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=25 AND items.`available`=1 [65] => common time: 0.00371074676514 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=27 AND items.`available`=1 [66] => common time: 0.00373268127441 time: 2.19345092773E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=28 AND items.`available`=1 [67] => common time: 0.0037567615509 time: 2.40802764893E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [68] => common time: 0.00378274917603 time: 2.59876251221E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [69] => common time: 0.00380563735962 time: 2.28881835938E-5 rows: 1 query: SELECT `id` FROM `prefix_catalog_catalog1_cats` WHERE `is_default`=1 LIMIT 1 [70] => common time: 0.00383162498474 time: 2.59876251221E-5 rows: 29 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE true [71] => common time: 0.00385475158691 time: 2.31266021729E-5 rows: 2 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 16 ORDER BY `order` [72] => common time: 0.00387668609619 time: 2.19345092773E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 17 ORDER BY `order` [73] => common time: 0.00389766693115 time: 2.09808349609E-5 rows: 0 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `parent_id` = 22 ORDER BY `order` [74] => common time: 0.00391960144043 time: 2.19345092773E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [75] => common time: 0.00394248962402 time: 2.28881835938E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=17 AND items.`available`=1 [76] => common time: 0.00396466255188 time: 2.21729278564E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_catalog_catalog1_item2cat` AS i2c LEFT JOIN `prefix_catalog_catalog1_items` AS `items` ON i2c.item_id=items.id WHERE i2c.cat_id=22 AND items.`available`=1 [77] => common time: 0.00398755073547 time: 2.28881835938E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats_props` WHERE true [78] => common time: 0.0040123462677 time: 2.47955322266E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE `id`='catalog1' LIMIT 1 [79] => common time: 0.00403738021851 time: 2.50339508057E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_inner_filters` WHERE `stringid` ="last_index" LIMIT 1 [80] => common time: 0.00406622886658 time: 2.88486480713E-5 rows: 15 query: SELECT * FROM `prefix_catalog_item_props` WHERE `module_id` = "catalog1" AND (`group_id`=0) ORDER BY `order`, `name_full` [81] => common time: 0.00409030914307 time: 2.40802764893E-5 rows: 1 query: SELECT COUNT(*) AS count FROM prefix_catalog_catalog1_items AS items WHERE ( items.`available`=1 ) AND (true ) [82] => common time: 0.00415539741516 time: 6.50882720947E-5 rows: 24 query: SELECT items.id , items.name, items.description, items.exemple_code, items.code, items.application, items.author, items.url, items.source, items.date, items.demo, items.demo_file, items.viplata, items.tag1, items.tag2, items.tag3,items.vote, items.rating FROM prefix_catalog_catalog1_items AS items WHERE ( items.`available`=1 ) AND (true ) order by id desc LIMIT 0, 24 [83] => common time: 0.00419330596924 time: 3.79085540771E-5 rows: 15 query: SELECT * FROM `prefix_catalog_item_props` WHERE `module_id` = "catalog1" AND (`group_id`=0) ORDER BY `order`,`name_full` [84] => common time: 0.00425720214844 time: 6.38961791992E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE id='catalog1' LIMIT 1 [85] => common time: 0.00428533554077 time: 2.8133392334E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE id='catalog' LIMIT 1 [86] => common time: 0.00431132316589 time: 2.59876251221E-5 rows: 1 query: SELECT MIN(cat_id) FROM `prefix_catalog_catalog1_item2cat` WHERE `item_id`=77 [87] => common time: 0.00433731079102 time: 2.59876251221E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `id`=1 LIMIT 1 [88] => common time: 0.00458526611328 time: 0.000247955322266 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/index.html?snipid=77' LIMIT 1 [89] => common time: 0.00461220741272 time: 2.69412994385E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_tree_comments` WHERE `page_sub_id`='snipid=77,' AND `available` = 1 LIMIT 1 [90] => common time: 0.00482225418091 time: 0.000210046768188 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/catalog.html?snipid=77' LIMIT 1 [91] => common time: 0.00486516952515 time: 4.29153442383E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE id='catalog1' LIMIT 1 [92] => common time: 0.00489330291748 time: 2.8133392334E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE id='catalog' LIMIT 1 [93] => common time: 0.00492024421692 time: 2.69412994385E-5 rows: 1 query: SELECT MIN(cat_id) FROM `prefix_catalog_catalog1_item2cat` WHERE `item_id`=76 [94] => common time: 0.00494623184204 time: 2.59876251221E-5 rows: 1 query: SELECT * FROM `prefix_catalog_catalog1_cats` WHERE `id`=9 LIMIT 1 [95] => common time: 0.00513625144958 time: 0.000190019607544 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/index.html?snipid=76' LIMIT 1 [96] => common time: 0.00516033172607 time: 2.40802764893E-5 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_tree_comments` WHERE `page_sub_id`='snipid=76,' AND `available` = 1 LIMIT 1 [97] => common time: 0.00536632537842 time: 0.000205993652344 rows: 1 query: SELECT COUNT(*) AS count FROM `prefix_stat_uri` WHERE `uri`='/catalog.html?snipid=76' LIMIT 1 [98] => common time: 0.00540852546692 time: 4.2200088501E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE id='catalog1' LIMIT 1 [99] => common time: 0.00543546676636 time: 2.69412994385E-5 rows: 1 query: SELECT * FROM `prefix_modules` WHERE id='catalog' LIMIT 1 [100] => common time: 0.00546264648438 time: 2.71797180176E-5 rows: 1 query: SELECT MIN(cat_id) FROM `prefix_catalog_catalog1_item2cat` WHERE `item_id`=75 и вот последний запрос Код (Text): [259] => common time: 0.0242805480957 time: 5.48362731934E-5 rows: 1 query: SELECT `id_modul`, `text_php` FROM `prefix_evalmod` WHERE `id_modul` = 'evalmod1' LIMIT 0,1 итого, на все 260 запросов в БД время уходит 0.0242805480957 а чего ж у меня еще так тормозить то может???? чет я расстроился прям ((((
Dmitriy A. Arteshuk обрати внимание, куча запросов одинаковых по сути. а часто и один в один. это реально запросы одинаковые выполняются или твой счетчик запросов глючит)) -начни с того что избавься от запросов-дубликатов. раз один раз уже из таблицы чтото вытащил, то зачем второй раз это же тащить? -далее нужен более глубокий анализ. на предмет того что реально нужно показать на страницы, и что реально тянется из бд. возможно тянется лишнее. или опять же можно вытащить разом. а потом уже раскидать с пом php куда надо. - и только когда сделаешь это, можно начинать смотреть ОПТИМАЛЬНОСТЬ оставшихся запросов, и начать оптимизацию. хотя там думаю, будет достаточно добавить нужные индексы. переписывать запросы будет дороже по времени.
runcore - реально одинаковые, да, я их вижу делаю локальную копию, сажусь ковырять. ЗЫ денюжка дошла?
Ну...поехали оптимизировать, начнем с конца ) Код (PHP): $hour = mktime() - 60*60*24; // люди $sql_p = "SELECT COUNT(DISTINCT IDSess) FROM ".$kernel->pub_prefix_get()."_stat_host WHERE `tstc` > '".$hour."' AND `f_people` = 1"; $result_p = mysql_fetch_assoc($kernel->runSQL($sql_p)); // роботы $sql_r = "SELECT COUNT(DISTINCT IDSess) FROM ".$kernel->pub_prefix_get()."_stat_host WHERE `tstc` > '".$hour."' AND `f_people` = 0"; $result_r = mysql_fetch_assoc($kernel->runSQL($sql_r)); // online $hour_on = mktime() - 60*15; $sql_on = "SELECT COUNT(DISTINCT IDSess) FROM ".$kernel->pub_prefix_get()."_stat_host WHERE `tstc` > '".$hour_on."' "; $result_on = mysql_fetch_assoc($kernel->runSQL($sql_on)); так я тащу кол-во людей и ботов за сутки и пользователей "онлайн" из БД $result_p['COUNT(DISTINCT IDSess)'] $result_r['COUNT(DISTINCT IDSess)'] $result_on['COUNT(DISTINCT IDSess)'] тут у меня соответственно все эти значения. чую тут и одного запроса за глаза....поможете оптимизировать? время выполнения этого куска кода 0.00306296348572сек ерунда вроде, но начнем с малого и простого )
Код (Text): $sql_p = "SELECT COUNT(DISTINCT IDSess) FROM ".$kernel->pub_prefix_get()."_stat_host WHERE `tstc` > '".$hour."' AND `f_people` = 1"; $result_p = mysql_fetch_assoc($kernel->runSQL($sql_p)); // роботы $sql_r = "SELECT COUNT(DISTINCT IDSess) FROM ".$kernel->pub_prefix_get()."_stat_host WHERE `tstc` > '".$hour."' AND `f_people` = 0"; $result_r = mysql_fetch_assoc($kernel->runSQL($sql_r)); Вот эти два можно GROUP BY объединить а 3 все равно будет) там ж условие иное Добавлено спустя 55 секунд: tstc и это поле хорошо бы индексом сделать)
оптимизировать надо то, что на каждой странице делается. а не то, что ты выбираешь ради статистики раз в сутки.
Понажимайте "обновить" побыстрому, раз 10, и Ваш сайт ляжет. "Ручной DDoS" - пяток запросов в секунду и кранты. п.с. Это по поводу "оптимизировать", что и как.