• News

Nuova funzione per il sito!

pubblicato il
nuova funzione
(default) 4 queries took 43 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `posts` AS `Post` LEFT JOIN `categories` AS `Category` ON (`Post`.`category_id` = `Category`.`id`) WHERE `Post`.`category_id` = 1 AND `published` = 1 116
2SELECT `Post`.`id`, `Post`.`user_id`, `Post`.`title`, `Post`.`text`, `Post`.`imgpath`, `Post`.`url`, `Post`.`date`, `Post`.`updated`, `Post`.`subtitle`, `Post`.`published`, `Post`.`home`, `Post`.`category_id`, `Category`.`id`, `Category`.`name` FROM `posts` AS `Post` LEFT JOIN `categories` AS `Category` ON (`Post`.`category_id` = `Category`.`id`) WHERE `Post`.`category_id` = 1 AND `published` = 1 ORDER BY `Post`.`id` desc LIMIT 900, 201116
3SELECT `Category`.`name`, `Category`.`id` FROM `categories` AS `Category` WHERE `Category`.`id` = 1 LIMIT 1114
4SELECT `Post`.`id`, `Post`.`category_id` FROM `posts` AS `Post` WHERE `Post`.`category_id` = (1) 90290217
(phpbb3) 1 query took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 2 113