Database_MySQLi_Result Object ( [_internal_row:protected] => 0 [_query:protected] => SELECT `oc2_p`.*, (SELECT COUNT("id_post") FROM `oc2_posts` AS `oc2_pc` WHERE `oc2_pc`.`id_post_parent` = oc2_p.id_post AND `oc2_pc`.`id_forum` = '1' AND `oc2_pc`.`status` = 1 GROUP BY `oc2_pc`.`id_post_parent`) AS `count_replies`, (SELECT `oc2_ps`.`created` FROM `oc2_posts` AS `oc2_ps` WHERE `oc2_ps`.`id_post` = oc2_p.id_post OR `oc2_ps`.`id_post_parent` = oc2_p.id_post AND `oc2_ps`.`id_forum` = '1' AND `oc2_ps`.`status` = 1 ORDER BY `oc2_ps`.`created` DESC LIMIT 1) AS `last_message` FROM `oc2_posts` AS `oc2_p` WHERE `id_post_parent` IS NULL AND `id_forum` = '1' AND `status` = 1 ORDER BY `last_message` DESC LIMIT 10 OFFSET 0 [_result:protected] => mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 10 [type] => 0 ) [_total_rows:protected] => 10 [_current_row:protected] => 0 [_as_object:protected] => 1 [_object_params:protected] => ) test - Форум - Доска объявлений

Поделиться


Profiler

Database (default) 0.129882 s
9.6875 kB
Исходный пункт Min Max Average Всего
SELECT `group_name`, `config_key`, `config_value` FROM `oc2_config` ORDER BY `group_name` ASC, `config_key` ASC (1)
0.001259 s
0.001259 s
0.001259 s
0.001259 s
0.8125 kB
0.8125 kB
0.8125 kB
0.8125 kB
SELECT `oc2_`.`id_crontab` AS `id_crontab`, `oc2_`.`name` AS `name`, `oc2_`.`period` AS `period`, `oc2_`.`callback` AS `callback`, `oc2_`.`params` AS `params`, `oc2_`.`description` AS `description`, `oc2_`.`date_created` AS `date_created`, `oc2_`.`date_started` AS `date_started`, `oc2_`.`date_finished` AS `date_finished`, `oc2_`.`date_next` AS `date_next`, `oc2_`.`times_executed` AS `times_executed`, `oc2_`.`output` AS `output`, `oc2_`.`running` AS `running`, `oc2_`.`active` AS `active` FROM `oc2_crontab` AS `oc2_` WHERE `active` = 1 AND (`date_next` <= '2024-04-20 13:13:21' OR `date_next` IS NULL) (1)
0.000440 s
0.000440 s
0.000440 s
0.000440 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SELECT `oc2_category`.`id_category` AS `id_category`, `oc2_category`.`name` AS `name`, `oc2_category`.`order` AS `order`, `oc2_category`.`created` AS `created`, `oc2_category`.`id_category_parent` AS `id_category_parent`, `oc2_category`.`parent_deep` AS `parent_deep`, `oc2_category`.`seoname` AS `seoname`, `oc2_category`.`description` AS `description`, `oc2_category`.`price` AS `price`, `oc2_category`.`last_modified` AS `last_modified`, `oc2_category`.`has_image` AS `has_image` FROM `oc2_categories` AS `oc2_category` WHERE `seoname` IS NULL LIMIT 1 (1)
0.000367 s
0.000367 s
0.000367 s
0.000367 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SHOW FULL COLUMNS FROM `oc2_ads` (1)
0.000864 s
0.000864 s
0.000864 s
0.000864 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SELECT `oc2_location`.`id_location` AS `id_location`, `oc2_location`.`name` AS `name`, `oc2_location`.`order` AS `order`, `oc2_location`.`id_location_parent` AS `id_location_parent`, `oc2_location`.`parent_deep` AS `parent_deep`, `oc2_location`.`seoname` AS `seoname`, `oc2_location`.`description` AS `description`, `oc2_location`.`last_modified` AS `last_modified`, `oc2_location`.`has_image` AS `has_image`, `oc2_location`.`latitude` AS `latitude`, `oc2_location`.`longitude` AS `longitude`, `oc2_location`.`id_geoname` AS `id_geoname`, `oc2_location`.`fcodename_geoname` AS `fcodename_geoname` FROM `oc2_locations` AS `oc2_location` WHERE `seoname` IS NULL LIMIT 1 (1)
0.000247 s
0.000247 s
0.000247 s
0.000247 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SELECT `oc2_forum`.`id_forum` AS `id_forum`, `oc2_forum`.`name` AS `name`, `oc2_forum`.`order` AS `order`, `oc2_forum`.`created` AS `created`, `oc2_forum`.`id_forum_parent` AS `id_forum_parent`, `oc2_forum`.`parent_deep` AS `parent_deep`, `oc2_forum`.`seoname` AS `seoname`, `oc2_forum`.`description` AS `description` FROM `oc2_forums` AS `oc2_forum` WHERE `seoname` = 'test' LIMIT 1 (2)
0.000366 s
0.000822 s
0.000594 s
0.001188 s
0.6563 kB
0.6563 kB
0.6563 kB
1.3125 kB
SELECT COUNT("id_post") AS `count` FROM `oc2_posts` AS `oc2_p` WHERE `id_post_parent` IS NULL AND `id_forum` = '1' (1)
0.000610 s
0.000610 s
0.000610 s
0.000610 s
1.6563 kB
1.6563 kB
1.6563 kB
1.6563 kB
SELECT `oc2_p`.*, (SELECT COUNT("id_post") FROM `oc2_posts` AS `oc2_pc` WHERE `oc2_pc`.`id_post_parent` = oc2_p.id_post AND `oc2_pc`.`id_forum` = '1' AND `oc2_pc`.`status` = 1 GROUP BY `oc2_pc`.`id_post_parent`) AS `count_replies`, (SELECT `oc2_ps`.`created` FROM `oc2_posts` AS `oc2_ps` WHERE `oc2_ps`.`id_post` = oc2_p.id_post OR `oc2_ps`.`id_post_parent` = oc2_p.id_post AND `oc2_ps`.`id_forum` = '1' AND `oc2_ps`.`status` = 1 ORDER BY `oc2_ps`.`created` DESC LIMIT 1) AS `last_message` FROM `oc2_posts` AS `oc2_p` WHERE `id_post_parent` IS NULL AND `id_forum` = '1' AND `status` = 1 ORDER BY `last_message` DESC LIMIT 10 OFFSET 0 (1)
0.102866 s
0.102866 s
0.102866 s
0.102866 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SELECT `oc2_c`.`id_category`, COUNT("a.id_ad") AS `count` FROM `oc2_categories` AS `oc2_c` JOIN `oc2_ads` AS `oc2_a` USING (`id_category`) WHERE `oc2_a`.`id_category` = oc2_c.id_category AND IF(0 <> 0, DATE_ADD( published, INTERVAL 0 DAY), DATE_ADD( NOW(), INTERVAL 1 DAY)) > '2024-04-20 13:13:21' AND `oc2_a`.`status` = 1 GROUP BY `oc2_c`.`id_category` ORDER BY `oc2_c`.`order` ASC (1)
0.021276 s
0.021276 s
0.021276 s
0.021276 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SELECT `oc2_category`.`id_category` AS `id_category`, `oc2_category`.`name` AS `name`, `oc2_category`.`order` AS `order`, `oc2_category`.`created` AS `created`, `oc2_category`.`id_category_parent` AS `id_category_parent`, `oc2_category`.`parent_deep` AS `parent_deep`, `oc2_category`.`seoname` AS `seoname`, `oc2_category`.`description` AS `description`, `oc2_category`.`price` AS `price`, `oc2_category`.`last_modified` AS `last_modified`, `oc2_category`.`has_image` AS `has_image` FROM `oc2_categories` AS `oc2_category` WHERE `oc2_category`.`id_category` = '2' LIMIT 1 (1)
0.000246 s
0.000246 s
0.000246 s
0.000246 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SELECT `oc2_category`.`id_category` AS `id_category`, `oc2_category`.`name` AS `name`, `oc2_category`.`order` AS `order`, `oc2_category`.`created` AS `created`, `oc2_category`.`id_category_parent` AS `id_category_parent`, `oc2_category`.`parent_deep` AS `parent_deep`, `oc2_category`.`seoname` AS `seoname`, `oc2_category`.`description` AS `description`, `oc2_category`.`price` AS `price`, `oc2_category`.`last_modified` AS `last_modified`, `oc2_category`.`has_image` AS `has_image` FROM `oc2_categories` AS `oc2_category` WHERE `id_category` != 1 AND `parent_deep` IN (0, 1) ORDER BY `order` ASC (1)
0.000267 s
0.000267 s
0.000267 s
0.000267 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
SELECT `oc2_category`.`id_category` AS `id_category`, `oc2_category`.`name` AS `name`, `oc2_category`.`order` AS `order`, `oc2_category`.`created` AS `created`, `oc2_category`.`id_category_parent` AS `id_category_parent`, `oc2_category`.`parent_deep` AS `parent_deep`, `oc2_category`.`seoname` AS `seoname`, `oc2_category`.`description` AS `description`, `oc2_category`.`price` AS `price`, `oc2_category`.`last_modified` AS `last_modified`, `oc2_category`.`has_image` AS `has_image` FROM `oc2_categories` AS `oc2_category` WHERE `id_category_parent` = '2' AND `id_category` != '2' LIMIT 1 (1)
0.000252 s
0.000252 s
0.000252 s
0.000252 s
0.6563 kB
0.6563 kB
0.6563 kB
0.6563 kB
Kohana 0.009747 s
143.1016 kB
Исходный пункт Min Max Average Всего
find_file (219)
0.000010 s
0.000099 s
0.000045 s
0.009747 s
0.4922 kB
2.8125 kB
0.6534 kB
143.1016 kB
Requests 1.033658 s
2,798.4141 kB
Исходный пункт Min Max Average Всего
"forum/test" (1)
1.034677 s
1.034677 s
1.034677 s
1.034677 s
2,811.2344 kB
2,811.2344 kB
2,811.2344 kB
2,811.2344 kB
Запуск приложения (1) 1.227377 s 1.227377 s 1.227377 s 1.227377 s
6,348.4609 kB 6,348.4609 kB 6,348.4609 kB 6,348.4609 kB

Окружающая среда

Включённые файлы (190)

Загруженые расширения (71)

$_SESSION

$_SERVER