Query Metrics
7
Database Queries
7
Different statements
152.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.34 ms (82.02%) |
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 193761 390947 391287 391477 391921 392013 392021 392025 397898 400859 411414 420376 423905 423966 427148 429953 433372 442057 443118 443968 444126 450285 455118 455969 455998 456045 456049 457359 458193 460143 460433 460754 464533 467914 472392 476494 477937 483656 491211 492419 496873 498130 498441 499051 501517 503472 507269 509176 509264 509651 514041 520810 530066 532503 543943 544054 549719 561333 573297 582182 590333 590464 591913 591977 595316 601539 659200 660276 675582 700121 714489 714517 715935 724486 725217 725515 725517 725652 726554 726970 727048 731036 731093 731099 735834 735875 735959 738849 740213 740961 741339 741766 745949 745950 746592 749959 752732 756244 758176 758313 759759 761726 763982 768896 791099 791879 792601 792607 793613 794173 794864 794876 794900 795132 797358 803433 819346 824068 824531 827936 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (10.09%) |
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 391921 443968 455998 501517 509264 503472 499051 514041 498130 520810 496873 591977 391477 467914 400859 456045 460754 391287 423966 456049 433372 483656 498441 423905 427148 824068 819346 824531 827936 491211 492419 509176 507269 532503 530066 543943 544054 549719 573297 659200 715935 660276 675582 700121 714489 714517 561333 582182 590464 595316 590333 591913 601539 794876 795132 797358 791879 793613 794864 724486 725217 725517 725652 731036 735959 752732 792601 794900 731093 735875 740213 741339 745950 749959 756244 758313 761726 726970 727048 731099 738849 745949 759759 726554 735834 740961 741766 746592 758176 763982 725515 768896 791099 792607 794173 803433 392025 397898 429953 457359 476494 193761 390947 392021 442057 477937 392013 455118 450285 458193 472392 509651 444126 411414 420376 443118 464533 460433 455969 460143 ] |
||||||||||||||||||||||||||||||
|
3.59 ms (2.35%) |
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 193761 390947 391287 391477 391921 392013 392021 392025 397898 400859 411414 420376 423905 423966 427148 429953 433372 442057 443118 443968 444126 450285 455118 455969 455998 456045 456049 457359 458193 460143 460433 460754 464533 467914 472392 476494 477937 483656 491211 492419 496873 498130 498441 499051 501517 503472 507269 509176 509264 509651 514041 520810 530066 532503 543943 544054 549719 561333 573297 582182 590333 590464 591913 591977 595316 601539 659200 660276 675582 700121 714489 714517 715935 724486 725217 725515 725517 725652 726554 726970 727048 731036 731093 731099 735834 735875 735959 738849 740213 740961 741339 741766 745949 745950 746592 749959 752732 756244 758176 758313 759759 761726 763982 768896 791099 791879 792601 792607 793613 794173 794864 794876 794900 795132 797358 803433 819346 824068 824531 827936 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian chubby milf"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск chubby milf"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск chubby milf"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.