Query Metrics
7
Database Queries
7
Different statements
160.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.15 ms (83.66%) |
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 3973 190903 385913 386202 389611 393741 400439 400453 411959 412083 413114 418495 418998 429086 430081 444636 444834 445037 445058 446886 461961 464275 464288 465099 466154 467330 470561 472235 476955 482794 492002 504456 505622 511018 512869 515116 515128 515175 515177 515193 515194 515195 515717 520717 520723 520774 521772 521779 523008 523822 526135 529125 541332 546692 550439 550443 550609 557274 557304 559044 561321 565537 566981 567146 567166 571383 599548 607173 608042 609647 613465 615433 615444 617722 623350 624858 631957 632298 644697 646826 650432 651165 663910 664302 665238 667472 684582 696972 700544 700659 709578 712804 712923 716482 722706 722913 722916 726144 727698 732116 732120 732422 732466 733172 734679 735800 741646 743120 743134 744319 748145 759658 759660 766016 775972 778614 781839 788647 814122 825184 ] |
||||||||||||||||||||||||||||||
|
17.15 ms (10.70%) |
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 664302 663910 400439 476955 3973 716482 559044 727698 735800 393741 700659 523822 766016 775972 561321 515717 734679 411959 418998 446886 565537 722706 743120 733172 744319 644697 413114 400453 732116 665238 541332 632298 550439 429086 482794 515195 523008 418495 466154 515116 631957 567166 550609 430081 190903 515128 567146 557274 470561 521772 512869 748145 712923 700544 445058 743134 520717 571383 550443 617722 608042 520723 781839 412083 444636 521779 461961 520774 385913 613465 788647 504456 623350 599548 515177 511018 778614 759658 526135 712804 667472 609647 444834 472235 515194 684582 732422 465099 467330 515175 529125 464288 624858 722916 445037 646826 615444 505622 759660 386202 709578 651165 650432 615433 732466 741646 726144 732120 515193 464275 492002 557304 722913 607173 546692 566981 696972 389611 825184 814122 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.55%) |
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 3973 190903 385913 386202 389611 393741 400439 400453 411959 412083 413114 418495 418998 429086 430081 444636 444834 445037 445058 446886 461961 464275 464288 465099 466154 467330 470561 472235 476955 482794 492002 504456 505622 511018 512869 515116 515128 515175 515177 515193 515194 515195 515717 520717 520723 520774 521772 521779 523008 523822 526135 529125 541332 546692 550439 550443 550609 557274 557304 559044 561321 565537 566981 567146 567166 571383 599548 607173 608042 609647 613465 615433 615444 617722 623350 624858 631957 632298 644697 646826 650432 651165 663910 664302 665238 667472 684582 696972 700544 700659 709578 712804 712923 716482 722706 722913 722916 726144 727698 732116 732120 732422 732466 733172 734679 735800 741646 743120 743134 744319 748145 759658 759660 766016 775972 778614 781839 788647 814122 825184 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits grandfather"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ старый"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
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.