Query Metrics
7
Database Queries
7
Different statements
141.50 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.69 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.10 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"грубо жарит"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.11 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 581989 706909 686047 463083 564508 574295 598346 775741 565907 579379 650187 626380 502626 505572 712684 598344 597864 511673 756952 496303 516998 510812 553344 598871 663976 600013 592996 513832 562535 602439 640742 601641 520989 530765 598877 608541 470378 503428 559953 511674 721551 590194 481143 494174 581232 570736 535597 542975 650767 600290 482552 561115 557599 530681 544812 527966 468288 559486 625417 599957 790884 591334 809508 565423 520739 582323 632599 508425 519679 585113 548552 553054 429797 575828 599961 449425 516093 536403 525828 559142 523205 451866 540559 599835 653559 556741 543659 512050 630531 616996 ] |
||||||||||||||||||||||||||||||
| 4 | 3.06 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 429797 449425 451866 463083 468288 470378 481143 482552 494174 496303 502626 503428 505572 508425 510812 511673 511674 512050 513832 516093 516998 519679 520739 520989 523205 525828 527966 530681 530765 535597 536403 540559 542975 543659 544812 548552 553054 553344 556741 557599 559142 559486 559953 561115 562535 564508 565423 565907 570736 574295 575828 579379 581232 581989 582323 585113 590194 591334 592996 597864 598344 598346 598871 598877 599835 599957 599961 600013 600290 601641 602439 608541 616996 625417 626380 630531 632599 640742 650187 650767 653559 663976 686047 706909 712684 721551 756952 775741 790884 809508 ] |
||||||||||||||||||||||||||||||
| 5 | 114.50 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 429797 449425 451866 463083 468288 470378 481143 482552 494174 496303 502626 503428 505572 508425 510812 511673 511674 512050 513832 516093 516998 519679 520739 520989 523205 525828 527966 530681 530765 535597 536403 540559 542975 543659 544812 548552 553054 553344 556741 557599 559142 559486 559953 561115 562535 564508 565423 565907 570736 574295 575828 579379 581232 581989 582323 585113 590194 591334 592996 597864 598344 598346 598871 598877 599835 599957 599961 600013 600290 601641 602439 608541 616996 625417 626380 630531 632599 640742 650187 650767 653559 663976 686047 706909 712684 721551 756952 775741 790884 809508 ] |
||||||||||||||||||||||||||||||
| 6 | 1.54 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"груб секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.49 ms |
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.