Query Metrics
7
Database Queries
7
Different statements
606.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
412.48 ms (68.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
168.09 ms (27.74%) |
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 15162 32678 382188 393061 395405 395578 397714 399710 401930 406488 409893 413569 416226 417878 420084 425395 430762 458098 458913 459668 460261 464145 465106 465652 468704 469001 469986 471827 480137 519810 523573 532487 535841 543154 544779 547080 548102 564304 564392 568228 573308 574117 583953 584731 585270 586692 590794 591936 595279 595965 595969 596116 599876 600832 602070 604457 604468 604495 604510 604527 604531 604556 604681 606858 607126 610029 610201 612182 614990 622716 630898 630955 633428 633755 634209 634552 634553 636576 647629 649187 649857 649964 655832 674043 681297 687881 694632 699347 700169 704187 708279 708923 715371 718945 720030 720116 720306 724266 727597 732549 732868 733405 737159 737177 744598 744601 744632 744665 747745 752939 756228 772815 787738 789516 800297 800703 802462 803473 807763 813448 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (2.71%) |
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 519810 523573 532487 535841 460261 464145 465106 468704 469001 469986 544779 564392 547080 548102 574117 584731 543154 564304 583953 649857 649964 681297 704187 649187 655832 687881 700169 708923 720116 647629 674043 694632 699347 708279 715371 718945 720306 568228 573308 585270 590794 596116 604457 604531 604681 607126 622716 591936 602070 604495 610029 614990 634553 636576 586692 599876 600832 610201 633755 634209 634552 595279 595965 595969 604510 604527 612182 630898 802462 803473 800297 800703 807763 727597 752939 756228 772815 787738 789516 813448 724266 733405 744632 737159 737177 744601 732549 732868 744598 744665 747745 604468 604556 606858 630955 633428 720030 15162 382188 395578 409893 413569 416226 458098 458913 459668 393061 399710 401930 417878 465652 471827 480137 32678 395405 397714 406488 420084 425395 430762 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (0.53%) |
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 15162 32678 382188 393061 395405 395578 397714 399710 401930 406488 409893 413569 416226 417878 420084 425395 430762 458098 458913 459668 460261 464145 465106 465652 468704 469001 469986 471827 480137 519810 523573 532487 535841 543154 544779 547080 548102 564304 564392 568228 573308 574117 583953 584731 585270 586692 590794 591936 595279 595965 595969 596116 599876 600832 602070 604457 604468 604495 604510 604527 604531 604556 604681 606858 607126 610029 610201 612182 614990 622716 630898 630955 633428 633755 634209 634552 634553 636576 647629 649187 649857 649964 655832 674043 681297 687881 694632 699347 700169 704187 708279 708923 715371 718945 720030 720116 720306 724266 727597 732549 732868 733405 737159 737177 744598 744601 744632 744665 747745 752939 756228 772815 787738 789516 800297 800703 802462 803473 807763 813448 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc cock"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc cock"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc cock"
]
|
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.