birkir/results.md

## results.md

      
    Raw
  

              results.md
            
          
    List tickets


Laravel

Queries
select * from `categories` order by `position` asc
0.000440s
select * from `tickets` order by `created_at` desc
0.000350s
select `tickets`.*, `tickets_categories`.`category_id` as `pivot_category_id`, `tickets_categories`.`ticket_id` as `pivot_ticket_id` from `tickets` inner join `tickets_categories` on `tickets`.`id` = `tickets_categories`.`ticket_id` where `tickets_categories`.`category_id` = '41'
0.000440s
select `tickets`.*, `tickets_categories`.`category_id` as `pivot_category_id`, `tickets_categories`.`ticket_id` as `pivot_ticket_id` from `tickets` inner join `tickets_categories` on `tickets`.`id` = `tickets_categories`.`ticket_id` where `tickets_categories`.`category_id` = '42'
0.000330s
No Sub-requests
Total memory: -  733kB
Total time: -  29.15ms

Kohana

SQL queries
SELECT `ticket`.`id` AS `id`, `ticket`.`title` AS `title`, `ticket`.`message` AS `message`, `ticket`.`status` AS `status`, `ticket`.`user_id` AS `user_id`, `ticket`.`created_at` AS `created_at`, `ticket`.`deleted_at` AS `deleted_at` FROM `tickets` AS `ticket` WHERE `deleted_at` IS NULL ORDER BY `created_at` DESC
0.000165s (0.7813kB)
SELECT `category`.`id` AS `id`, `category`.`name` AS `name`, `category`.`position` AS `position` FROM `categories` AS `category` ORDER BY `position` ASC
0.000115s (0.7031kB)
SELECT COUNT(`ticket`.`id`) AS `records_found` FROM `tickets` AS `ticket` JOIN `tickets_categories` ON (`tickets_categories`.`ticket_id` = `ticket`.`id`) WHERE `tickets_categories`.`category_id` = '5' AND `deleted_at` IS NULL
0.000115s (0.7031kB)
SELECT COUNT(`ticket`.`id`) AS `records_found` FROM `tickets` AS `ticket` JOIN `tickets_categories` ON (`tickets_categories`.`ticket_id` = `ticket`.`id`) WHERE `tickets_categories`.`category_id` = '6' AND `deleted_at` IS NULL
0.000101s (0.7031kB)
Sub-requests:
/ticket/category: - 0.018342s
/category/list: - 0.002626s
Total memory - 2,754,30KB
Total time - 27.235ms

Show ticket


Laravel

Queries
select * from `tickets` where `tickets`.`id` = '92' limit 1
0.000420s
select `categories`.*, `tickets_categories`.`ticket_id` as `pivot_ticket_id`, `tickets_categories`.`category_id` as `pivot_category_id` from `categories` inner join `tickets_categories` on `categories`.`id` = `tickets_categories`.`category_id` where `tickets_categories`.`ticket_id` = '92'
0.000300s
select * from `users` where `users`.`id` = '10' limit
0.000250s
select * from `ticket_messages` where `ticket_messages`.`ticket_id` = '92'
0.000270s
select * from `users` where `users`.`id` = '10' limit 1
0.000210s
select * from `users` where `users`.`id` = '10' limit 1
0.000170s
select * from `users` where `users`.`id` = '10' limit 1
0.000330s
No Sub-requests
Total memory: - 712.37KB
Total time: - 23.95ms

Kohana

Queries
SELECT `ticket`.`id` AS `id`, `ticket`.`title` AS `title`, `ticket`.`message` AS `message`, `ticket`.`status` AS `status`, `ticket`.`user_id` AS `user_id`, `ticket`.`created_at` AS `created_at`, `ticket`.`deleted_at` AS `deleted_at` FROM `tickets` AS `ticket` WHERE `ticket`.`id` = '7' AND `deleted_at` IS NULL LIMIT 1
0.000120s (0.7813kB)
SHOW FULL COLUMNS FROM `ticket_messages`
0.000721s (0.7031kB)
SELECT `ticket_message`.`id` AS `id`, `ticket_message`.`ticket_id` AS `ticket_id`, `ticket_message`.`message` AS `message`, `ticket_message`.`user_id` AS `user_id`, `ticket_message`.`created_at` AS `created_at`, `ticket_message`.`deleted_at` AS `deleted_at` FROM `ticket_messages` AS `ticket_message` WHERE `ticket_message`.`ticket_id` = '7' AND `deleted_at` IS NULL ORDER BY `created_at` ASC
0.000096s (0.7031kB)
SELECT `category`.`id` AS `id`, `category`.`name` AS `name`, `category`.`position` AS `position` FROM `categories` AS `category` JOIN `tickets_categories` ON (`tickets_categories`.`category_id` = `category`.`id`) WHERE `tickets_categories`.`ticket_id` = '7'
0.000105s (0.7031kB)
SHOW FULL COLUMNS FROM `users`
0.000568s (0.7031kB)
SELECT `user`.`id` AS `id`, `user`.`name` AS `name`, `user`.`email` AS `email`, `user`.`password` AS `password`, `user`.`logins` AS `logins`, `user`.`last_login` AS `last_login` FROM `users` AS `user` WHERE `user`.`id` = '8' LIMIT 1
0.000083s (0.7031 kB)
No Sub-requests
Total memory: - 2,328.59kB
Total time: - 21.617ms