FuelPHP Bin
Sign in
Url:
Fork
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`address` AS `t0_c2`, `t0`.`cell` AS `t0_c3`, `t0`.`email` AS `t0_c4`, `t0`.`status` AS `t0_c5`, `t0`.`created_at` AS `t0_c6`, `t0`.`updated_at` AS `t0_c7`, `t1`.`id` AS `t1_c0`, `t1`.`parent` AS `t1_c1`, `t1`.`name` AS `t1_c2`, `t1`.`created_at` AS `t1_c3`, `t1`.`updated_at` AS `t1_c4`, `t2`.`id` AS `t2_c0`, `t2`.`institution` AS `t2_c1`, `t2`.`std` AS `t2_c2`, `t2`.`name` AS `t2_c3`, `t2`.`gender` AS `t2_c4`, `t2`.`cell` AS `t2_c5`, `t2`.`email` AS `t2_c6`, `t2`.`status` AS `t2_c7`, `t2`.`created_at` AS `t2_c8`, `t2`.`updated_at` AS `t2_c9`, `t3`.`id` AS `t3_c0`, `t3`.`parent` AS `t3_c1`, `t3`.`name` AS `t3_c2`, `t3`.`created_at` AS `t3_c3`, `t3`.`updated_at` AS `t3_c4` FROM (SELECT `t0`.`id`, `t0`.`name`, `t0`.`address`, `t0`.`cell`, `t0`.`email`, `t0`.`status`, `t0`.`created_at`, `t0`.`updated_at` FROM `institutions` AS `t0` WHERE `t0`.`id` = '1' LIMIT 1) AS `t0` LEFT JOIN `stds` AS `t1` ON (`t0`.`id` = `t1`.`parent`) LEFT JOIN `students` AS `t2` ON (`t0`.`id` = `t2`.`institution`) LEFT JOIN `stds` AS `t3` ON (`t2`.`std` = `t3`.`id`) WHERE `t3`.`id` = '10' Connection name: default Speed: 15.600 ms Query analysis: · Query: PRIMARY on <derived2> · Type: system · Rows: 1 · Query: PRIMARY on t3 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: PRIMARY on t2 · Type: ALL · Rows: 6 (Using where) · Query: PRIMARY on t1 · Type: ALL · Rows: 8 (Using where; Using join buffer (Block Nested Loop)) · Query: DERIVED on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query: File: D:/xampp/htdocs/total.dev/fuel/packages/orm/classes/query.php, line 1293 File: D:/xampp/htdocs/total.dev/fuel/packages/orm/classes/query.php, line 1365 File: D:/xampp/htdocs/total.dev/fuel/app/classes/controller/backend/students.php, line 28 File: D:/xampp/htdocs/total.dev/fuel/core/classes/request.php, line 443 File: D:/xampp/htdocs/total.dev/public/index.php, line 71 File: D:/xampp/htdocs/total.dev/public/index.php, line 92