Търсене на постове

Вход

Начало Потребители Групи

Търсене на постове: #Hierarchical

t0m3kk

Managing #Hierarchical Data in #MySQL - Преди няколко дни един колега ми обясняваше модела и сега зачетох и статията, доста доволно

Коментирай · Oct 28 2012, 20:49 · Сподели

Търси за

Тип постове

От потребител В група Дата

от
до

Facebook

DB Queries: 10 (1.5228s) | CACHE Queries: 8 (0.0009s) | Script Execution Time: 1.527 | Memory usage: 0.88MB | Server Load Average: 0.27, 0.13, 0.1

0.00026	SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00035	SELECT id, type, data FROM posts_attachments WHERE post_id="1436538" LIMIT 1
0.97087	SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%Hierarchical%") AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15
0.46615	SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%Hierarchical%") AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00032	SELECT id FROM groups WHERE is_public=0
0.08276	SELECT post_id FROM posts_comments WHERE message LIKE "%Hierarchical%"
0.00026	SELECT id FROM searches WHERE user_id="" AND search_key="c81c4bb9f25c209cafe018d46720d0df" LIMIT 1
0.00025	SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1
0.00028	SELECT * FROM settings
0.00131	CONNECT 49.12.223.183:9906