<?php SELECT `t0`.`name` AS `t0_c0`, `t0`.`slug` AS `t0_c1`, `t0`.`post_count` AS `t0_c2`, `t0`.`order_id` AS `t0_c3`, `t0`.`status` AS `t0_c4`, `t0`.`permission` AS `t0_c5`, `t0`.`exposition` AS `t0_c6`, `t0`.`created_at` AS `t0_c7`, `t0`.`updated_at` AS `t0_c8`, `t0`.`id` AS `t0_c9` FROM `categories` AS `t0` WHERE `t0`.`exposition` = 'gallery' OR `t0`.`exposition` = 'all' ORDER BY `t0`.`order_id` ASC Connection name: default Speed: 0.382 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 14 (Using where; Using filesort) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: APPPATH/classes/controller/base/backend.php, line 45 File: APPPATH/classes/controller/base/template.php, line 97 File: APPPATH/classes/controller/base/backend.php, line 10 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 9 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/gallery.php, line 9 File: COREPATH/classes/request.php, line 481 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`username` AS `t0_c1`, `t0`.`email` AS `t0_c2`, `t0`.`group_id` AS `t0_c3`, `t0`.`password` AS `t0_c4`, `t0`.`last_login` AS `t0_c5`, `t0`.`previous_login` AS `t0_c6`, `t0`.`login_hash` AS `t0_c7`, `t0`.`user_id` AS `t0_c8`, `t0`.`created_at` AS `t0_c9`, `t0`.`updated_at` AS `t0_c10`, `t1`.`id` AS `t1_c0`, `t1`.`parent_id` AS `t1_c1`, `t1`.`key` AS `t1_c2`, `t1`.`value` AS `t1_c3`, `t1`.`user_id` AS `t1_c4`, `t1`.`created_at` AS `t1_c5`, `t1`.`updated_at` AS `t1_c6` FROM (SELECT `t0`.`id`, `t0`.`username`, `t0`.`email`, `t0`.`group_id`, `t0`.`password`, `t0`.`last_login`, `t0`.`previous_login`, `t0`.`login_hash`, `t0`.`user_id`, `t0`.`created_at`, `t0`.`updated_at` FROM `users` AS `t0` WHERE `t0`.`username` = 'Laurent' LIMIT 1) AS `t0` LEFT JOIN `users_metadata` AS `t1` ON (`t0`.`id` = `t1`.`parent_id`) Connection name: default Speed: 0.289 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t1 · Type: ALL · Rows: 2 (Using where) · Query: DERIVED on t0 · Possible keys: username · Key Used: username · Type: ref · Rows: 1 (Using index condition) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/query.php, line 1641 File: PKGPATH/auth/classes/auth/login/ormauth.php, line 682 File: PKGPATH/auth/classes/auth/login/driver.php, line 72 File: PKGPATH/auth/classes/auth.php, line 210 File: PKGPATH/auth/classes/auth.php, line 69 File: COREPATH/classes/autoloader.php, line 377 File: COREPATH/classes/autoloader.php, line 249 File: APPPATH/classes/controller/base/backend.php, line 13 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 9 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/gallery.php, line 9 File: COREPATH/classes/request.php, line 481 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`name` AS `t0_c0`, `t0`.`summary` AS `t0_c1`, `t0`.`order_id` AS `t0_c2`, `t0`.`status` AS `t0_c3`, `t0`.`permission` AS `t0_c4`, `t0`.`featured` AS `t0_c5`, `t0`.`created_at` AS `t0_c6`, `t0`.`updated_at` AS `t0_c7`, `t0`.`edit` AS `t0_c8`, `t0`.`id` AS `t0_c9` FROM `project_menus` AS `t0` ORDER BY `t0`.`order_id` ASC Connection name: default Speed: 0.193 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 8 (Using filesort) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 612 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '8' Connection name: default Speed: 0.352 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '9' Connection name: default Speed: 0.289 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '10' Connection name: default Speed: 0.276 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '1' Connection name: default Speed: 0.340 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '2' Connection name: default Speed: 0.303 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '3' Connection name: default Speed: 0.301 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '12' Connection name: default Speed: 0.312 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`id` AS `t0_c0`, `t0`.`menu_id` AS `t0_c1`, `t0`.`key` AS `t0_c2`, `t0`.`value` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `project_menus_metadata` AS `t0` WHERE `t0`.`menu_id` = '11' Connection name: default Speed: 0.223 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 451 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: PKGPATH/orm/classes/hasmany.php, line 72 File: PKGPATH/orm/classes/model.php, line 1214 File: PKGPATH/orm/classes/model.php, line 1050 File: PKGPATH/orm/classes/model.php, line 2319 File: PKGPATH/orm/classes/model.php, line 1222 File: PKGPATH/orm/classes/model.php, line 1050 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 616 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT COUNT(DISTINCT `t0`.`id`) AS count_result FROM `posts` AS `t0` LEFT JOIN `categories_posts` AS `t1_through` ON (`t0`.`id` = `t1_through`.`post_id`) LEFT JOIN `categories` AS `t1` ON (`t1_through`.`category_id` = `t1`.`id`) WHERE `t1`.`id` = '5' ORDER BY `t0`.`created_at` DESC Connection name: default Speed: 0.157 ms Query analysis: · Query: SIMPLE on t1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 (Using index) · Query: SIMPLE on t1_through · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 2 (Using where; Using index) · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1676 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 660 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92 SELECT `t0`.`module` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`slug` AS `t0_c2`, `t0`.`summary` AS `t0_c3`, `t0`.`content` AS `t0_c4`, `t0`.`category_id` AS `t0_c5`, `t0`.`order_id` AS `t0_c6`, `t0`.`user_id` AS `t0_c7`, `t0`.`status` AS `t0_c8`, `t0`.`permission` AS `t0_c9`, `t0`.`featured` AS `t0_c10`, `t0`.`locked` AS `t0_c11`, `t0`.`allow_comments` AS `t0_c12`, `t0`.`created_at` AS `t0_c13`, `t0`.`updated_at` AS `t0_c14`, `t0`.`edit` AS `t0_c15`, `t0`.`id` AS `t0_c16`, `t1_through`.`category_id`, `t1_through`.`post_id`, `t1`.`name` AS `t1_c0`, `t1`.`slug` AS `t1_c1`, `t1`.`post_count` AS `t1_c2`, `t1`.`order_id` AS `t1_c3`, `t1`.`status` AS `t1_c4`, `t1`.`permission` AS `t1_c5`, `t1`.`exposition` AS `t1_c6`, `t1`.`created_at` AS `t1_c7`, `t1`.`updated_at` AS `t1_c8`, `t1`.`id` AS `t1_c9` FROM (SELECT `t0`.`module`, `t0`.`name`, `t0`.`slug`, `t0`.`summary`, `t0`.`content`, `t0`.`category_id`, `t0`.`order_id`, `t0`.`user_id`, `t0`.`status`, `t0`.`permission`, `t0`.`featured`, `t0`.`locked`, `t0`.`allow_comments`, `t0`.`created_at`, `t0`.`updated_at`, `t0`.`edit`, `t0`.`id` FROM `posts` AS `t0` ORDER BY `t0`.`order_id` ASC LIMIT 5 OFFSET 0) AS `t0` LEFT JOIN `categories_posts` AS `t1_through` ON (`t0`.`id` = `t1_through`.`post_id`) LEFT JOIN `categories` AS `t1` ON (`t1_through`.`category_id` = `t1`.`id`) WHERE `t1`.`id` = '5' ORDER BY `t0`.`order_id` ASC Connection name: default Speed: 0.266 ms Query analysis: · Query: PRIMARY on t1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: PRIMARY on t1_through · Possible keys: PRIMARY · Key Used: PRIMARY · Type: ref · Rows: 2 (Using where; Using index) · Query: PRIMARY on <derived2> · Type: ALL · Rows: 5 (Using where; Using join buffer (Block Nested Loop)) · Query: DERIVED on t0 · Type: ALL · Rows: 18 (Using filesort) Call trace for this query: File: PKGPATH/orm/classes/query.php, line 1564 File: /Users/efxair/sites/clients/efxdesign/fuelphp/modules/media/classes/controller/backend/post.php, line 672 File: COREPATH/base56.php, line 37 File: COREPATH/classes/controller/hybrid.php, line 81 File: COREPATH/classes/request.php, line 483 File: DOCROOT/index.php, line 71 File: DOCROOT/index.php, line 92