Query Metrics
7
Database Queries
7
Different statements
169.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.28 ms (83.28%) |
1 |
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 27777 38313 190903 372346 382378 382484 382884 382979 393735 396734 397158 399022 402254 403049 411913 430081 461961 470800 472235 476409 479710 488306 488311 491023 504456 512046 515110 515111 517073 520268 520774 523802 523822 538868 548573 550443 550662 556408 567145 568575 568579 570076 571201 586629 589579 594964 596915 600121 605610 606491 607167 607203 617435 621664 624464 637061 646783 649084 663393 663932 665287 667472 667490 668453 675537 676445 676528 677011 678802 681187 684582 696273 696966 696977 696978 700660 701299 708802 712804 712830 712896 716043 722652 722665 722672 732135 732422 732457 734611 735516 735587 735839 743034 743118 743126 743132 744278 744315 745818 747355 759569 759609 759645 759647 759649 766020 767959 776878 778549 778602 783885 788471 788749 789228 789806 800249 812132 812137 819963 827117 ] |
||||||||||||||||||||||||||||||
|
18.32 ms (10.80%) |
1 |
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 396734 38313 430081 461961 517073 570076 520774 567145 470800 675537 586629 382979 523802 550443 568575 568579 596915 716043 382378 402254 668453 607167 399022 827117 488311 678802 722652 677011 776878 800249 744315 735587 747355 778602 403049 550662 393735 27777 649084 712804 667472 637061 789228 743118 382884 819963 515110 515111 663932 667490 701299 676445 696978 712830 624464 605610 589579 743034 789806 766020 732422 732457 735516 743126 812132 523822 491023 488306 556408 676528 663393 696273 646783 684582 600121 783885 788471 788749 759647 744278 759649 696966 700660 708802 479710 722665 606491 548573 722672 696977 778549 190903 372346 382484 512046 538868 607203 735839 759645 767959 571201 594964 397158 411913 665287 681187 712896 732135 734611 745818 743132 759569 759609 617435 812137 520268 476409 504456 472235 621664 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.56%) |
1 |
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 27777 38313 190903 372346 382378 382484 382884 382979 393735 396734 397158 399022 402254 403049 411913 430081 461961 470800 472235 476409 479710 488306 488311 491023 504456 512046 515110 515111 517073 520268 520774 523802 523822 538868 548573 550443 550662 556408 567145 568575 568579 570076 571201 586629 589579 594964 596915 600121 605610 606491 607167 607203 617435 621664 624464 637061 646783 649084 663393 663932 665287 667472 667490 668453 675537 676445 676528 677011 678802 681187 684582 696273 696966 696977 696978 700660 701299 708802 712804 712830 712896 716043 722652 722665 722672 732135 732422 732457 734611 735516 735587 735839 743034 743118 743126 743132 744278 744315 745818 747355 759569 759609 759645 759647 759649 766020 767959 776878 778549 778602 783885 788471 788749 789228 789806 800249 812132 812137 819963 827117 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"деды ебут дедов"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старый секс старый"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"старый секс старый"
]
|
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.