Query Metrics
7
Database Queries
7
Different statements
117.19 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.46 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.74 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young russian double"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.73 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 696997 809668 466218 471405 419517 508839 484678 474693 558131 558601 597963 549799 443764 401916 443334 422342 424433 443777 474678 474680 474696 477730 484629 484651 484668 480059 539010 564542 542794 567337 807327 424428 474652 429898 466369 474661 470527 484690 484705 505040 481134 443758 470028 474686 484724 484656 484750 484485 531120 443791 443822 473780 429449 477439 461569 511749 517841 484624 505048 485246 419546 424469 474654 446894 506056 512384 484696 567338 436032 460739 474702 504098 494567 650155 484739 454102 609196 602945 476797 474689 541866 639258 621988 474663 506047 518468 452018 533746 527902 ] |
||||||||||||||||||||||||||||||
| 4 | 2.35 ms |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 401916 419517 419546 422342 424428 424433 424469 429449 429898 436032 443334 443758 443764 443777 443791 443822 446894 452018 454102 460739 461569 466218 466369 470028 470527 471405 473780 474652 474654 474661 474663 474678 474680 474686 474689 474693 474696 474702 476797 477439 477730 480059 481134 484485 484624 484629 484651 484656 484668 484678 484690 484696 484705 484724 484739 484750 485246 494567 504098 505040 505048 506047 506056 508839 511749 512384 517841 518468 527902 531120 533746 539010 541866 542794 549799 558131 558601 564542 567337 567338 597963 602945 609196 621988 639258 650155 696997 807327 809668 ] |
||||||||||||||||||||||||||||||
| 5 | 91.45 ms |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 401916 419517 419546 422342 424428 424433 424469 429449 429898 436032 443334 443758 443764 443777 443791 443822 446894 452018 454102 460739 461569 466218 466369 470028 470527 471405 473780 474652 474654 474661 474663 474678 474680 474686 474689 474693 474696 474702 476797 477439 477730 480059 481134 484485 484624 484629 484651 484656 484668 484678 484690 484696 484705 484724 484739 484750 485246 494567 504098 505040 505048 506047 506056 508839 511749 512384 517841 518468 527902 531120 533746 539010 541866 542794 549799 558131 558601 564542 567337 567338 597963 602945 609196 621988 639258 650155 696997 807327 809668 ] |
||||||||||||||||||||||||||||||
| 6 | 1.83 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young русск double"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.64 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young русск double"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.