Query Metrics
7
Database Queries
7
Different statements
179.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.83 ms (84.75%) |
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 33459 130105 341675 396358 396600 400965 401629 407357 408460 408601 413944 416351 416819 417999 420139 420768 421003 421093 429943 432243 437519 443480 447152 447560 457077 457163 457293 464188 478033 480420 488551 491263 494620 497776 500913 502703 509805 510270 512453 522130 522133 522858 527428 528886 530492 530650 530851 531157 531194 531225 531230 531257 532960 532984 534987 536616 536618 536631 536650 537675 537896 537908 537928 537988 540404 542975 543872 563992 578406 583960 586587 600194 601623 617410 628082 628087 630542 632687 633747 633749 634122 634207 634556 636286 637125 638576 642000 644273 644962 647322 647638 648499 648846 649579 650333 651051 651147 666872 674975 676022 676025 676066 676107 676111 677307 677781 677801 678028 678073 678127 678161 679728 679744 679816 696203 704526 720340 723620 732262 805288 ] |
||||||||||||||||||||||||||||||
|
18.13 ms (10.12%) |
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 563992 648846 650333 676111 679744 651051 676066 637125 636286 601623 632687 805288 396358 457077 417999 478033 480420 401629 407357 457293 512453 488551 497776 510270 674975 421093 630542 720340 732262 537675 537928 583960 677781 678127 617410 633749 628087 628082 676022 677307 586587 130105 341675 33459 396600 400965 408460 408601 413944 432243 437519 420768 421003 443480 420139 429943 416351 416819 723620 644962 447152 457163 464188 491263 522858 531157 531225 531230 531257 536618 537908 500913 502703 522130 528886 530650 532960 534987 522133 530492 536631 536650 494620 509805 527428 530851 531194 532984 536616 537896 537988 540404 542975 543872 578406 666872 678161 679728 648499 649579 676025 677801 678028 678073 679816 696203 704526 647322 647638 651147 676107 633747 644273 638576 642000 634122 600194 634207 634556 447560 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.62%) |
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 33459 130105 341675 396358 396600 400965 401629 407357 408460 408601 413944 416351 416819 417999 420139 420768 421003 421093 429943 432243 437519 443480 447152 447560 457077 457163 457293 464188 478033 480420 488551 491263 494620 497776 500913 502703 509805 510270 512453 522130 522133 522858 527428 528886 530492 530650 530851 531157 531194 531225 531230 531257 532960 532984 534987 536616 536618 536631 536650 537675 537896 537908 537928 537988 540404 542975 543872 563992 578406 583960 586587 600194 601623 617410 628082 628087 630542 632687 633747 633749 634122 634207 634556 636286 637125 638576 642000 644273 644962 647322 647638 648499 648846 649579 650333 651051 651147 666872 674975 676022 676025 676066 676107 676111 677307 677781 677801 678028 678073 678127 678161 679728 679744 679816 696203 704526 720340 723620 732262 805288 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen hardcore bbc"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen хардкор bbc"
]
|
||||||||||||||||||||||||||||||
|
1.14 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen хардкор bbc"
]
|
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.