Загрузи свое задание и получай пополнение мобильного!

Завдання для самоперевірки № 5
Загрузи свой ответ и выигрывай пополнение мобильного!

Рейтинг пользователей

Пока еще никто из пользователей не набрал больше 50 баллов.

Реклама
Мы ВКонтакте
Общий отчет (Время: 1.00759с, Память: 1,972Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SELECT MAX(updated) FROM book WHERE book_id = 81) 3 0.07643 0.02548 0.02542 0.02558
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`book_id` AS `t0_c1`, `t`.`root` AS `t0_c2`, `t`.`lft` AS `t0_c3`, `t`.`rgt` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`title_slug` AS `t0_c7`, `t`.`answers` AS `t0_c8`, `bookAnswers`.`id` AS `t1_c0`, `bookAnswers`.`book_content_id` AS `t1_c1`, `bookAnswers`.`account_id` AS `t1_c2`, `bookAnswers`.`position` AS `t1_c3`, `bookAnswers`.`approved` AS `t1_c4`, `bookAnswers`.`task_num` AS `t1_c5`, `bookAnswers`.`filename` AS `t1_c6`, `bookAnswers`.`views` AS `t1_c7`, `bookAnswers`.`status` AS `t1_c8`, `bookAnswers`.`size` AS `t1_c9`, `bookAnswers`.`added` AS `t1_c10`, `bookAnswers`.`admin_id` AS `t1_c11`, `bookAnswers`.`unique` AS `t1_c12`, `bookAnswers`.`hide` AS `t1_c13`, `account`.`account_id` AS `t2_c0`, `account`.`email` AS `t2_c1`, `account`.`login` AS `t2_c2`, `account`.`password` AS `t2_c3`, `account`.`salt` AS `t2_c4`, `account`.`verify_code` AS `t2_c5`, `account`.`status` AS `t2_c6`, `account`.`email_status` AS `t2_c7`, `account`.`rating` AS `t2_c8`, `account`.`phone_code` AS `t2_c9`, `account`.`phone` AS `t2_c10`, `account`.`balance` AS `t2_c11`, `account`.`balance_to_out` AS `t2_c12`, `account`.`reg_ip` AS `t2_c13`, `account`.`reg_date` AS `t2_c14`, `account`.`login_ip` AS `t2_c15`, `account`.`login_date` AS `t2_c16`, `account`.`activity_date` AS `t2_c17`, `accountProfile`.`id` AS `t3_c0`, `accountProfile`.`account_id` AS `t3_c1`, `accountProfile`.`first_name` AS `t3_c2`, `accountProfile`.`last_name` AS `t3_c3`, `accountProfile`.`sex` AS `t3_c4`, `accountProfile`.`birthday` AS `t3_c5`, `accountProfile`.`age` AS `t3_c6`, `accountProfile`.`city_id` AS `t3_c7`, `accountProfile`.`school_id` AS `t3_c8`, `accountProfile`.`family_status` AS `t3_c9`, `accountProfile`.`family_status_with` AS `t3_c10`, `book`.`book_id` AS `t4_c0`, `book`.`lang_id` AS `t4_c1`, `book`.`book_title` AS `t4_c2`, `book`.`book_title_slug` AS `t4_c3`, `book`.`cover_image` AS `t4_c4`, `book`.`description` AS `t4_c5`, `book`.`class_id` AS `t4_c6`, `book`.`subject_id` AS `t4_c7`, `book`.`book_edition` AS `t4_c8`, `book`.`book_year` AS `t4_c9`, `book`.`book_pages` AS `t4_c10`, `book`.`pages` AS `t4_c11`, `book`.`answers` AS `t4_c12`, `book`.`bad_answers` AS `t4_c13`, `book`.`with_answer_nums` AS `t4_c14`, `book`.`modal_views` AS `t4_c15`, `book`.`admin_id` AS `t4_c16`, `book`.`hide` AS `t4_c17`, `book`.`added` AS `t4_c18`, `book`.`updated` AS `t4_c19`, `class`.`class_id` AS `t5_c0`, `class`.`class_number` AS `t5_c1`, `bookAuthors`.`book_author_id` AS `t6_c0`, `bookAuthors`.`book_id` AS `t6_c1`, `bookAuthors`.`author_id` AS `t6_c2`, `author`.`author_id` AS `t7_c0`, `author`.`author_name` AS `t7_c1`, `subject`.`subject_id` AS `t8_c0`, `subject`.`subject_name` AS `t8_c1`, `subject`.`subject_name_slug` AS `t8_c2`, `subject`.`subject_declension` AS `t8_c3` FROM `book_content` `t` LEFT OUTER JOIN `book_answer` `bookAnswers` ON (`bookAnswers`.`book_content_id`=`t`.`id`) LEFT OUTER JOIN `account` `account` ON (`bookAnswers`.`account_id`=`account`.`account_id`) LEFT OUTER JOIN `account_profile` `accountProfile` ON (`accountProfile`.`account_id`=`account`.`account_id`) LEFT OUTER JOIN `book` `book` ON (`t`.`book_id`=`book`.`book_id`) LEFT OUTER JOIN `class_number` `class` ON (`book`.`class_id`=`class`.`class_id`) LEFT OUTER JOIN `book_author` `bookAuthors` ON (`bookAuthors`.`book_id`=`book`.`book_id`) LEFT OUTER JOIN `author` `author` ON (`bookAuthors`.`author_id`=`author`.`author_id`) LEFT OUTER JOIN `subject` `subject` ON (`book`.`subject_id`=`subject`.`subject_id`) WHERE ((`t`.`lft`>1 AND `t`.`rgt`<10) AND (`t`.`root`=:ycp3)) AND (bookAnswers.account_id IS NULL OR (bookAnswers.account_id IS NOT NULL AND bookAnswers.approved IS NOT NULL)) ORDER BY `t`.`lft`. Bound with :ycp3='2846') 1 0.05298 0.05298 0.05298 0.05298
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`book_id` AS `t0_c1`, `t`.`root` AS `t0_c2`, `t`.`lft` AS `t0_c3`, `t`.`rgt` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`title_slug` AS `t0_c7`, `t`.`answers` AS `t0_c8`, `book`.`book_id` AS `t1_c0`, `book`.`lang_id` AS `t1_c1`, `book`.`book_title` AS `t1_c2`, `book`.`book_title_slug` AS `t1_c3`, `book`.`cover_image` AS `t1_c4`, `book`.`description` AS `t1_c5`, `book`.`class_id` AS `t1_c6`, `book`.`subject_id` AS `t1_c7`, `book`.`book_edition` AS `t1_c8`, `book`.`book_year` AS `t1_c9`, `book`.`book_pages` AS `t1_c10`, `book`.`pages` AS `t1_c11`, `book`.`answers` AS `t1_c12`, `book`.`bad_answers` AS `t1_c13`, `book`.`with_answer_nums` AS `t1_c14`, `book`.`modal_views` AS `t1_c15`, `book`.`admin_id` AS `t1_c16`, `book`.`hide` AS `t1_c17`, `book`.`added` AS `t1_c18`, `book`.`updated` AS `t1_c19`, `class`.`class_id` AS `t2_c0`, `class`.`class_number` AS `t2_c1`, `bookAuthors`.`book_author_id` AS `t3_c0`, `bookAuthors`.`book_id` AS `t3_c1`, `bookAuthors`.`author_id` AS `t3_c2`, `author`.`author_id` AS `t4_c0`, `author`.`author_name` AS `t4_c1`, `subject`.`subject_id` AS `t5_c0`, `subject`.`subject_name` AS `t5_c1`, `subject`.`subject_name_slug` AS `t5_c2`, `subject`.`subject_declension` AS `t5_c3`, `bookAnswers`.`id` AS `t6_c0`, `bookAnswers`.`book_content_id` AS `t6_c1`, `bookAnswers`.`account_id` AS `t6_c2`, `bookAnswers`.`position` AS `t6_c3`, `bookAnswers`.`approved` AS `t6_c4`, `bookAnswers`.`task_num` AS `t6_c5`, `bookAnswers`.`filename` AS `t6_c6`, `bookAnswers`.`views` AS `t6_c7`, `bookAnswers`.`status` AS `t6_c8`, `bookAnswers`.`size` AS `t6_c9`, `bookAnswers`.`added` AS `t6_c10`, `bookAnswers`.`admin_id` AS `t6_c11`, `bookAnswers`.`unique` AS `t6_c12`, `bookAnswers`.`hide` AS `t6_c13` FROM `book_content` `t` LEFT OUTER JOIN `book` `book` ON (`t`.`book_id`=`book`.`book_id`) LEFT OUTER JOIN `class_number` `class` ON (`book`.`class_id`=`class`.`class_id`) LEFT OUTER JOIN `book_author` `bookAuthors` ON (`bookAuthors`.`book_id`=`book`.`book_id`) LEFT OUTER JOIN `author` `author` ON (`bookAuthors`.`author_id`=`author`.`author_id`) LEFT OUTER JOIN `subject` `subject` ON (`book`.`subject_id`=`subject`.`subject_id`) LEFT OUTER JOIN `book_answer` `bookAnswers` ON (`bookAnswers`.`book_content_id`=`t`.`id`) WHERE (t.book_id = :book_id AND book.hide = 0 AND t.id = :id). Bound with :book_id='81', :id='2846') 1 0.02791 0.02791 0.02791 0.02791
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `account`) 1 0.02691 0.02691 0.02691 0.02691
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `book`) 1 0.02679 0.02679 0.02679 0.02679
system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`book_id` AS `t0_c1`, `t`.`root` AS `t0_c2`, `t`.`lft` AS `t0_c3`, `t`.`rgt` AS `t0_c4`, `t`.`level` AS `t0_c5`, `t`.`title` AS `t0_c6`, `t`.`title_slug` AS `t0_c7`, `t`.`answers` AS `t0_c8`, `bookAnswers`.`id` AS `t1_c0`, `bookAnswers`.`book_content_id` AS `t1_c1`, `bookAnswers`.`account_id` AS `t1_c2`, `bookAnswers`.`position` AS `t1_c3`, `bookAnswers`.`approved` AS `t1_c4`, `bookAnswers`.`task_num` AS `t1_c5`, `bookAnswers`.`filename` AS `t1_c6`, `bookAnswers`.`views` AS `t1_c7`, `bookAnswers`.`status` AS `t1_c8`, `bookAnswers`.`size` AS `t1_c9`, `bookAnswers`.`added` AS `t1_c10`, `bookAnswers`.`admin_id` AS `t1_c11`, `bookAnswers`.`unique` AS `t1_c12`, `bookAnswers`.`hide` AS `t1_c13`, `account`.`account_id` AS `t2_c0`, `account`.`email` AS `t2_c1`, `account`.`login` AS `t2_c2`, `account`.`password` AS `t2_c3`, `account`.`salt` AS `t2_c4`, `account`.`verify_code` AS `t2_c5`, `account`.`status` AS `t2_c6`, `account`.`email_status` AS `t2_c7`, `account`.`rating` AS `t2_c8`, `account`.`phone_code` AS `t2_c9`, `account`.`phone` AS `t2_c10`, `account`.`balance` AS `t2_c11`, `account`.`balance_to_out` AS `t2_c12`, `account`.`reg_ip` AS `t2_c13`, `account`.`reg_date` AS `t2_c14`, `account`.`login_ip` AS `t2_c15`, `account`.`login_date` AS `t2_c16`, `account`.`activity_date` AS `t2_c17`, `accountProfile`.`id` AS `t3_c0`, `accountProfile`.`account_id` AS `t3_c1`, `accountProfile`.`first_name` AS `t3_c2`, `accountProfile`.`last_name` AS `t3_c3`, `accountProfile`.`sex` AS `t3_c4`, `accountProfile`.`birthday` AS `t3_c5`, `accountProfile`.`age` AS `t3_c6`, `accountProfile`.`city_id` AS `t3_c7`, `accountProfile`.`school_id` AS `t3_c8`, `accountProfile`.`family_status` AS `t3_c9`, `accountProfile`.`family_status_with` AS `t3_c10`, `book`.`book_id` AS `t4_c0`, `book`.`lang_id` AS `t4_c1`, `book`.`book_title` AS `t4_c2`, `book`.`book_title_slug` AS `t4_c3`, `book`.`cover_image` AS `t4_c4`, `book`.`description` AS `t4_c5`, `book`.`class_id` AS `t4_c6`, `book`.`subject_id` AS `t4_c7`, `book`.`book_edition` AS `t4_c8`, `book`.`book_year` AS `t4_c9`, `book`.`book_pages` AS `t4_c10`, `book`.`pages` AS `t4_c11`, `book`.`answers` AS `t4_c12`, `book`.`bad_answers` AS `t4_c13`, `book`.`with_answer_nums` AS `t4_c14`, `book`.`modal_views` AS `t4_c15`, `book`.`admin_id` AS `t4_c16`, `book`.`hide` AS `t4_c17`, `book`.`added` AS `t4_c18`, `book`.`updated` AS `t4_c19`, `class`.`class_id` AS `t5_c0`, `class`.`class_number` AS `t5_c1`, `bookAuthors`.`book_author_id` AS `t6_c0`, `bookAuthors`.`book_id` AS `t6_c1`, `bookAuthors`.`author_id` AS `t6_c2`, `author`.`author_id` AS `t7_c0`, `author`.`author_name` AS `t7_c1`, `subject`.`subject_id` AS `t8_c0`, `subject`.`subject_name` AS `t8_c1`, `subject`.`subject_name_slug` AS `t8_c2`, `subject`.`subject_declension` AS `t8_c3` FROM `book_content` `t` LEFT OUTER JOIN `book_answer` `bookAnswers` ON (`bookAnswers`.`book_content_id`=`t`.`id`) LEFT OUTER JOIN `account` `account` ON (`bookAnswers`.`account_id`=`account`.`account_id`) LEFT OUTER JOIN `account_profile` `accountProfile` ON (`accountProfile`.`account_id`=`account`.`account_id`) LEFT OUTER JOIN `book` `book` ON (`t`.`book_id`=`book`.`book_id`) LEFT OUTER JOIN `class_number` `class` ON (`book`.`class_id`=`class`.`class_id`) LEFT OUTER JOIN `book_author` `bookAuthors` ON (`bookAuthors`.`book_id`=`book`.`book_id`) LEFT OUTER JOIN `author` `author` ON (`bookAuthors`.`author_id`=`author`.`author_id`) LEFT OUTER JOIN `subject` `subject` ON (`book`.`subject_id`=`subject`.`subject_id`) WHERE (t.book_id = :book_id AND t.id = :contentId) AND (bookAnswers.account_id IS NULL OR (bookAnswers.account_id IS NOT NULL AND bookAnswers.approved IS NOT NULL)) ORDER BY t.root, t.lft. Bound with :book_id='81', :contentId='2846') 1 0.02671 0.02671 0.02671 0.02671
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `book_answer`) 1 0.02658 0.02658 0.02658 0.02658
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `book_content`) 1 0.02652 0.02652 0.02652 0.02652
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `subject`) 1 0.02628 0.02628 0.02628 0.02628
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `book_author`) 1 0.02626 0.02626 0.02626 0.02626
system.db.CDbCommand.query(SELECT * FROM `book_content` `t` WHERE (`t`.`lft`<1 AND `t`.`rgt`>10) AND (`t`.`root`=:ycp0) ORDER BY `t`.`lft`. Bound with :ycp0='2846') 1 0.02624 0.02624 0.02624 0.02624
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `class_number`) 1 0.02618 0.02618 0.02618 0.02618
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `author`) 1 0.02615 0.02615 0.02615 0.02615
system.db.CDbCommand.query(SELECT * FROM `book_content` `t` WHERE `t`.`id`=:yp0 LIMIT 1. Bound with :yp0='2846') 1 0.02613 0.02613 0.02613 0.02613
system.db.CDbCommand.query(SELECT COUNT(*) FROM `book_content` `t` WHERE ((`t`.`lft`>1 AND `t`.`rgt`<10) AND (`t`.`level`<=2)) AND (`t`.`root`=:ycp1). Bound with :ycp1='2846') 1 0.02603 0.02603 0.02603 0.02603
system.db.CDbCommand.query(SELECT * FROM `book_content` `t` WHERE (`t`.`lft`<1 AND `t`.`rgt`>10) AND (`t`.`root`=:ycp2) ORDER BY `t`.`lft`. Bound with :ycp2='2846') 1 0.02602 0.02602 0.02602 0.02602
system.db.CDbCommand.query(SELECT MAX(updated) m, COUNT(id) c FROM account_rating_stat) 1 0.02602 0.02602 0.02602 0.02602
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `account_profile`) 1 0.02585 0.02585 0.02585 0.02585
system.db.CDbCommand.query(SHOW CREATE TABLE `book`) 1 0.02579 0.02579 0.02579 0.02579
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `account_rating_stat`) 1 0.02577 0.02577 0.02577 0.02577
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `account_avatar`) 1 0.02577 0.02577 0.02577 0.02577
system.db.CDbCommand.query(SHOW CREATE TABLE `book_answer`) 1 0.02576 0.02576 0.02576 0.02576
system.db.CDbCommand.query(SHOW CREATE TABLE `book_content`) 1 0.02571 0.02571 0.02571 0.02571
system.db.CDbCommand.query(SHOW CREATE TABLE `account`) 1 0.02570 0.02570 0.02570 0.02570
system.db.CDbCommand.query(SHOW CREATE TABLE `book_author`) 1 0.02566 0.02566 0.02566 0.02566
system.db.CDbCommand.query(SHOW CREATE TABLE `subject`) 1 0.02564 0.02564 0.02564 0.02564
system.db.CDbCommand.query(SHOW CREATE TABLE `author`) 1 0.02561 0.02561 0.02561 0.02561
system.db.CDbCommand.query(SHOW CREATE TABLE `class_number`) 1 0.02561 0.02561 0.02561 0.02561
system.db.CDbCommand.query(SHOW CREATE TABLE `account_profile`) 1 0.02560 0.02560 0.02560 0.02560
system.db.CDbCommand.query(SHOW CREATE TABLE `account_rating_stat`) 1 0.02553 0.02553 0.02553 0.02553
system.db.CDbCommand.query(SHOW CREATE TABLE `account_avatar`) 1 0.02549 0.02549 0.02549 0.02549