DELETE FROM `avzer_core`.`sys_session` WHERE (`app_name` = 'resource') AND (`updated` < '1791604702'); (0.0002591609954834) DSN: host=192.168.31.211;port=3306;dbname=avzer_core;charset=utf8mb4
SELECT `feedback_type`.`id`, `feedback_type`.`site_id`, `feedback_type`.`web_id`, `feedback_type`.`handle`, `feedback_type`.`name`, `feedback_type`.`setting`, `feedback_type`.`state` FROM `avzer_core`.`feedback_type` WHERE (`web_id` = '10') AND (`state` > '0') AND (`id` IN('2', '6', '1')); (0.00031685829162598) DSN: host=192.168.31.211;port=3306;dbname=avzer_core;charset=utf8mb4
SELECT `site_page`.`id`, `site_page`.`site_id`, `site_page`.`web_id`, `site_page`.`lang`, `site_page`.`number`, `site_page`.`handle`, `site_page`.`title`, `site_page`.`editor_id`, `site_page`.`content`, `site_page`.`keywords`, `site_page`.`attributes`, `site_page`.`attachments`, `site_page`.`state`, `site_page`.`created` FROM `avzer_core`.`site_page` WHERE (`web_id` = '10') AND (`handle` IN('dmca', 'privacy-policy', 'aboutus')) AND (`state` = '1'); (0.00035691261291504) DSN: host=192.168.31.211;port=3306;dbname=avzer_core;charset=utf8mb4
RESOURCE [mysql 8.4.11] / QTY: 16 / ELAPSED: 444.98181343079 ms
SELECT `genre`.`id`, `genre`.`parent_id`, `genre`.`site_id`, `genre`.`web_id`, `genre`.`handle`, `genre`.`name`, `genre`.`setting`, `genre`.`level_id`, `genre`.`state` FROM `avzer_resource`.`genre` WHERE (`web_id` = '10') AND (`parent_id` = '0') AND (`state` > '0'); (0.00047397613525391) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `attribute`.`id` FROM `avzer_resource`.`attribute` WHERE (`web_id` = '10'); (0.00035214424133301) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `item`.`id`, `item`.`site_id`, `item`.`web_id`, `item`.`guid`, `item`.`handle`, `item`.`category_id`, `item`.`cover`, `item`.`images`, `item`.`setting`, `item`.`state`, `item`.`datetime`, `item`.`created`, `item`.`updated`, (SELECT 0) AS `is_favorite`, `text`.`name`, `text`.`description`, `text`.`data`, `rating`.`rating`, `rating`.`rating_sum`, `rating`.`rated`, `rating`.`popularity`, `rating`.`liked`, `rating`.`shared`, `rating`.`views`, `rating`.`comments`, `rating`.`rate` FROM `avzer_resource`.`item` LEFT JOIN `avzer_resource`.`item_text` AS `text` ON `item`.`id` = `text`.`item_id` LEFT JOIN `avzer_resource`.`item_rating` AS `rating` ON `item`.`id` = `rating`.`item_id` AND `rating`.`metadata_id` = 0 WHERE (`item`.`web_id` = '10') AND (`item`.`state` >= '1') AND (`item`.`guid` = '6338732') GROUP BY `item`.`id`, `item`.`site_id`, `item`.`web_id`, `item`.`guid`, `item`.`handle`, `item`.`category_id`, `item`.`cover`, `item`.`images`, `item`.`setting`, `item`.`state`, `item`.`datetime`, `item`.`created`, `item`.`updated`, `text`.`name`, `text`.`description`, `text`.`data`, `rating`.`rating`, `rating`.`rating_sum`, `rating`.`rated`, `rating`.`popularity`, `rating`.`liked`, `rating`.`shared`, `rating`.`views`, `rating`.`comments`, `rating`.`rate` LIMIT 1; (0.0004279613494873) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `item_name`.`name` FROM `avzer_resource`.`item_name` WHERE (`item_id` = '1434194') AND (`type_id` IN('0', '2', '3')); (0.0010969638824463) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `album`.`id`, `album`.`site_id`, `album`.`web_id`, `album`.`type_id`, `album`.`guid`, `album`.`handle`, `album`.`cover`, `album`.`name`, `album`.`state`, `album`.`setting`, `album`.`data`, `album`.`created`, `album`.`updated` FROM `avzer_resource`.`album` WHERE (`web_id` = '10') AND (`type_id` = '2') AND (`id` IN(SELECT `item_album`.`album_id` FROM `avzer_resource`.`item_album` WHERE (`item_id` = '1434194'))) AND (`state` > '0') LIMIT 1; (0.00049495697021484) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT (SELECT JSON_ARRAYAGG(`id`) FROM (SELECT `item`.`id` FROM `avzer_resource`.`item` LEFT JOIN `avzer_resource`.`item_rating` AS `rating` ON `item`.`id` = `rating`.`item_id` AND `rating`.`metadata_id` = 0 WHERE (`item`.`web_id` = '10') AND (`item`.`state` >= '1') AND (`item`.`id` IN(SELECT `item_genre`.`item_id` FROM `avzer_resource`.`item_genre` WHERE (`genre_id` = '17147'))) AND (`item`.`category_id` = '11') AND (`item`.`id` != '1434194') GROUP BY `item`.`id` ORDER BY RAND() ASC LIMIT 8) AS `_relations`) AS `relations`, (SELECT JSON_ARRAYAGG(`id`) FROM (SELECT `item`.`id` FROM `avzer_resource`.`item` LEFT JOIN `avzer_resource`.`item_rating` AS `rating` ON `item`.`id` = `rating`.`item_id` AND `rating`.`metadata_id` = 0 WHERE (`item`.`web_id` = '10') AND (`item`.`state` >= '1') GROUP BY `item`.`id` LIMIT 16) AS `_series`) AS `series`; (0.43716287612915) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `item`.`id`, `item`.`site_id`, `item`.`web_id`, `item`.`guid`, `item`.`handle`, `item`.`category_id`, `item`.`cover`, `item`.`state`, `item`.`datetime`, `item`.`created`, `item`.`updated`, (SELECT 0) AS `is_favorite`, `text`.`name`, `text`.`description`, `text`.`data`, `rating`.`rating`, `rating`.`rating_sum`, `rating`.`rated`, `rating`.`popularity`, `rating`.`liked`, `rating`.`shared`, `rating`.`views`, `rating`.`comments`, `rating`.`rate` FROM `avzer_resource`.`item` LEFT JOIN `avzer_resource`.`item_text` AS `text` ON `item`.`id` = `text`.`item_id` LEFT JOIN `avzer_resource`.`item_rating` AS `rating` ON `item`.`id` = `rating`.`item_id` AND `rating`.`metadata_id` = 0 WHERE (`item`.`web_id` = '10') AND (`item`.`state` >= '1') AND (`item`.`id` IN('1408065', '1441656', '1417236', '1412165', '1408268', '1419157', '1413522', '1400997', '1397143', '1397144', '1397146', '1397149', '1397150', '1397151', '1397152', '1397153', '1397155', '1397156', '1397157', '1397159', '1397160', '1397161', '1397162', '1397163')) GROUP BY `item`.`id`, `item`.`site_id`, `item`.`web_id`, `item`.`guid`, `item`.`handle`, `item`.`category_id`, `item`.`cover`, `item`.`state`, `item`.`datetime`, `item`.`created`, `item`.`updated`, `text`.`name`, `text`.`description`, `text`.`data`, `rating`.`rating`, `rating`.`rating_sum`, `rating`.`rated`, `rating`.`popularity`, `rating`.`liked`, `rating`.`shared`, `rating`.`views`, `rating`.`comments`, `rating`.`rate` ORDER BY FIELD(item.id, 1408065, 1441656, 1417236, 1412165, 1408268, 1419157, 1413522, 1400997, 1397143, 1397144, 1397146, 1397149, 1397150, 1397151, 1397152, 1397153, 1397155, 1397156, 1397157, 1397159, 1397160, 1397161, 1397162, 1397163) ASC; (0.0012860298156738) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `resource_index`.`source_id`, COUNT(1) AS `total` FROM `avzer_resource`.`resource_index` WHERE (`item_id` = '1434194') GROUP BY `source_id`; (0.00092601776123047) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT COUNT(1) AS `system_row_count` FROM `avzer_resource`.`resource_index` AS `resource` LEFT JOIN `avzer_resource`.`resource_text_e` AS `text` ON `resource`.`id` = `text`.`resource_id` WHERE (`resource`.`item_id` = '1434194'); (0.00027108192443848) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `resource`.`id`, `resource`.`guid`, `resource`.`web_id`, `resource`.`handle`, `resource`.`item_id`, `resource`.`source_id`, `resource`.`size`, `resource`.`setting`, `resource`.`query`, `resource`.`data`, `resource`.`state`, `resource`.`datetime`, `resource`.`created`, `resource`.`updated`, `text`.`title`, `text`.`hash`, `text`.`content` FROM `avzer_resource`.`resource_index` AS `resource` LEFT JOIN `avzer_resource`.`resource_text_e` AS `text` ON `resource`.`id` = `text`.`resource_id` WHERE (`resource`.`item_id` = '1434194') ORDER BY `resource`.`updated` DESC, `resource`.`id` DESC LIMIT 30; (0.00031590461730957) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT COUNT(1) AS `system_row_count` FROM `avzer_resource`.`item_comment` WHERE (`item_id` = '1434194') AND (`state` > '0'); (0.00024890899658203) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SELECT `category`.`id`, `category`.`parent_id`, `category`.`site_id`, `category`.`web_id`, `category`.`handle`, `category`.`name`, `category`.`sort`, `category`.`state`, `category`.`setting` FROM `avzer_resource`.`category` WHERE (`web_id` = '10') AND (`state` > '0') AND (`id` IN('11', '12')); (0.00032186508178711) DSN: host=192.168.31.211;port=3306;dbname=avzer_resource;charset=utf8mb4
SEARCH [mysql 8.4.11] / QTY: 2 / ELAPSED: 0.94199180603027 ms