Query Metrics
7
Database Queries
7
Different statements
162.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.05 ms (84.41%) |
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 384902 389093 410786 420009 420882 427092 437274 443489 444245 455140 459278 461321 463178 465839 466551 468985 469682 473291 480673 481140 482490 482846 483259 486978 488322 489371 511584 512714 514352 523297 523299 523627 524536 528132 530404 533055 535609 535921 543752 543955 544939 545646 546327 547818 547837 548288 550575 551158 551189 552326 559247 568709 570507 571861 572504 574926 575278 589378 602346 603437 605912 623706 626824 627668 644048 652858 652863 673100 681507 686527 691474 695334 695381 695412 695424 699666 710350 719880 719883 726851 729926 735360 735907 739436 743615 755124 755868 757036 757309 759157 759371 762517 766303 768968 769139 769316 776369 777604 777623 778611 778949 786490 787751 788120 791286 795913 795943 795952 795961 802259 811904 819103 819790 819804 825613 825738 825860 827681 828028 828365 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (8.72%) |
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 575278 623706 778949 795913 729926 469682 468985 483259 572504 550575 570507 743615 444245 473291 463178 482846 514352 461321 551158 551189 681507 410786 437274 443489 455140 465839 523299 523297 488322 512714 626824 788120 528132 389093 482490 552326 589378 420009 427092 459278 481140 466551 511584 524536 486978 420882 568709 819103 825860 819790 819804 825738 825613 828028 828365 827681 523627 530404 535921 533055 535609 545646 547837 571861 543752 548288 543955 546327 686527 699666 652858 691474 695424 710350 652863 673100 695334 695381 719883 547818 603437 605912 644048 627668 777604 786490 791286 795952 776369 777623 795961 755124 755868 769139 795943 726851 762517 735360 757309 759371 769316 759157 766303 768968 602346 719880 778611 811904 384902 544939 695412 574926 787751 757036 735907 802259 559247 739436 480673 489371 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.76%) |
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 384902 389093 410786 420009 420882 427092 437274 443489 444245 455140 459278 461321 463178 465839 466551 468985 469682 473291 480673 481140 482490 482846 483259 486978 488322 489371 511584 512714 514352 523297 523299 523627 524536 528132 530404 533055 535609 535921 543752 543955 544939 545646 546327 547818 547837 548288 550575 551158 551189 552326 559247 568709 570507 571861 572504 574926 575278 589378 602346 603437 605912 623706 626824 627668 644048 652858 652863 673100 681507 686527 691474 695334 695381 695412 695424 699666 710350 719880 719883 726851 729926 735360 735907 739436 743615 755124 755868 757036 757309 759157 759371 762517 766303 768968 769139 769316 776369 777604 777623 778611 778949 786490 787751 788120 791286 795913 795943 795952 795961 802259 811904 819103 819790 819804 825613 825738 825860 827681 828028 828365 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск на улиц"
]
|
||||||||||||||||||||||||||||||
|
2.22 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian public"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
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.