SHOW FULL COLUMNS FROM `py_reptile` [ RunTime:0.002493s ]
SELECT `author` FROM `py_reptile` WHERE `author` LIKE '%' AND `author` IS NOT NULL LIMIT 10 [ RunTime:0.001002s ]
SHOW FULL COLUMNS FROM `lylme_groups` [ RunTime:0.001225s ]
SELECT * FROM `lylme_groups` ORDER BY `group_order` [ RunTime:0.000915s ]
SELECT `ID`,Title as name,Icon as icon,gpt_store_link as url FROM `py_reptile` ORDER BY RAND() LIMIT 100 [ RunTime:0.509745s ]
SHOW FULL COLUMNS FROM `lylme_links` [ RunTime:0.001692s ]
SELECT * FROM `lylme_links` WHERE `group_id` = 2 AND `link_status` = 1 [ RunTime:0.001002s ]
SELECT * FROM `lylme_links` WHERE `group_id` = 3 AND `link_status` = 1 [ RunTime:0.000945s ]
SELECT * FROM `lylme_links` WHERE `group_id` = 4 AND `link_status` = 1 [ RunTime:0.000794s ]
SELECT * FROM `lylme_links` WHERE `group_id` = 5 AND `link_status` = 1 [ RunTime:0.000740s ]
SHOW FULL COLUMNS FROM `lylme_tags` [ RunTime:0.001165s ]
SELECT * FROM `lylme_tags` [ RunTime:0.000540s ]
SHOW FULL COLUMNS FROM `lylme_sou` [ RunTime:0.000973s ]
SELECT * FROM `lylme_sou` ORDER BY `sou_order` [ RunTime:0.000719s ]
SELECT DISTINCT COUNT(*) AS think_count FROM `py_reptile` LIMIT 1 [ RunTime:0.038539s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `py_reptile` GROUP BY `author`,`author_website` HAVING COUNT(*) > 1 ) `_group_count_` LIMIT 1 [ RunTime:0.157401s ]
SELECT author,author_website, COUNT(*) as count FROM `py_reptile` GROUP BY `author`,`author_website` HAVING COUNT(*) > 1 LIMIT 1100,20 [ RunTime:0.143007s ]