Query Metrics
7
Database Queries
7
Different statements
224.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.48 ms (87.97%) |
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 401880 410959 416819 417344 420769 425118 429793 446529 447152 457163 476753 494620 509805 518470 522133 522858 527412 527428 530493 530625 530630 530805 531157 531215 531225 531230 531254 531257 531272 532703 532741 532960 533949 534995 535584 535644 536249 536251 536262 536616 536650 536752 537659 537675 537903 537908 539239 540404 543917 544803 545441 550265 565096 583976 584022 597253 600194 628086 628093 632694 633444 633747 633768 634199 634207 639762 641667 644962 644964 647320 648499 648816 648871 649556 649578 649579 649970 651147 666874 666897 666903 670758 674952 674978 675021 676090 676107 676112 677672 677781 677801 678028 678052 678073 678089 678121 678127 678135 678141 678144 678161 678495 678517 679016 679029 679728 679799 679810 679816 680118 680203 684312 685714 695124 695126 702164 703836 704526 723620 731665 ] |
||||||||||||||||||||||||||||||
|
17.99 ms (8.01%) |
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 416819 723620 644962 447152 457163 522858 531157 531225 531230 531257 537908 539239 532741 532960 533949 522133 535644 536650 494620 509805 527428 536616 540404 544803 583976 647320 666874 674978 678144 678161 678517 679728 648499 649579 677672 677801 678028 678073 678121 679799 679816 702164 704526 648871 651147 666897 666903 675021 676107 684312 703836 565096 633747 634199 639762 597253 628086 628093 600194 634207 641667 731665 632694 633444 633768 401880 417344 420769 425118 518470 527412 530493 410959 429793 644964 476753 446529 531215 531272 536251 530625 530630 531254 532703 536249 536262 537675 537903 530805 534995 535584 536752 537659 545441 584022 543917 649970 674952 676090 677781 678052 678089 678141 679016 679810 648816 649556 670758 676112 678127 678495 679029 680203 695124 695126 649578 678135 680118 685714 550265 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.17%) |
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 401880 410959 416819 417344 420769 425118 429793 446529 447152 457163 476753 494620 509805 518470 522133 522858 527412 527428 530493 530625 530630 530805 531157 531215 531225 531230 531254 531257 531272 532703 532741 532960 533949 534995 535584 535644 536249 536251 536262 536616 536650 536752 537659 537675 537903 537908 539239 540404 543917 544803 545441 550265 565096 583976 584022 597253 600194 628086 628093 632694 633444 633747 633768 634199 634207 639762 641667 644962 644964 647320 648499 648816 648871 649556 649578 649579 649970 651147 666874 666897 666903 670758 674952 674978 675021 676090 676107 676112 677672 677781 677801 678028 678052 678073 678089 678121 678127 678135 678141 678144 678161 678495 678517 679016 679029 679728 679799 679810 679816 680118 680203 684312 685714 695124 695126 702164 703836 704526 723620 731665 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens bbc gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens bbc gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens bbc gangbang"
]
|
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.