Query Metrics
7
Database Queries
7
Different statements
136.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.79 ms (86.91%) |
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 31602 154512 159036 280493 321277 335978 381939 382630 389213 390949 396790 401873 413641 420208 443406 448907 462810 530749 533816 533820 536521 536706 537312 537332 545962 547033 548516 553429 555021 565199 567546 574711 575897 576599 578748 595508 618343 623969 624403 634855 634866 634868 637249 637978 643051 648111 648579 651116 651253 660375 664284 665374 668792 671554 675534 680630 687206 689584 690394 694394 705256 707360 714169 714176 714180 714399 715260 715267 715268 715419 715448 716318 719242 719255 720036 728238 729076 730175 732598 734073 736760 739874 739895 740172 740955 740964 743784 745312 747739 751370 751502 752924 758591 765080 769334 769410 774098 774142 778486 781811 788049 788319 788858 792820 793409 797314 801020 801854 803219 804506 805320 805321 806312 806599 807222 807851 811865 812079 812407 814538 ] |
||||||||||||||||||||||||||||||
|
9.26 ms (6.77%) |
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 728238 752924 715419 715448 807851 671554 792820 806599 734073 321277 390949 443406 536706 530749 533816 547033 714176 720036 687206 714169 714180 651253 664284 665374 680630 707360 618343 634868 793409 740172 740955 715260 719242 745312 335978 280493 31602 536521 651116 637249 801854 765080 751370 716318 801020 807222 413641 660375 154512 159036 381939 389213 396790 420208 814538 448907 462810 533820 537312 537332 548516 553429 575897 574711 565199 576599 578748 668792 694394 714399 648579 690394 648111 675534 689584 705256 715267 555021 567546 624403 634855 634866 637978 595508 623969 643051 778486 788049 812407 788858 803219 804506 811865 736760 805320 747739 769334 774142 769410 774098 729076 740964 743784 751502 758591 788319 797314 806312 401873 382630 715268 805321 781811 545962 719255 730175 739895 732598 739874 812079 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.89%) |
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 31602 154512 159036 280493 321277 335978 381939 382630 389213 390949 396790 401873 413641 420208 443406 448907 462810 530749 533816 533820 536521 536706 537312 537332 545962 547033 548516 553429 555021 565199 567546 574711 575897 576599 578748 595508 618343 623969 624403 634855 634866 634868 637249 637978 643051 648111 648579 651116 651253 660375 664284 665374 668792 671554 675534 680630 687206 689584 690394 694394 705256 707360 714169 714176 714180 714399 715260 715267 715268 715419 715448 716318 719242 719255 720036 728238 729076 730175 732598 734073 736760 739874 739895 740172 740955 740964 743784 745312 747739 751370 751502 752924 758591 765080 769334 769410 774098 774142 778486 781811 788049 788319 788858 792820 793409 797314 801020 801854 803219 804506 805320 805321 806312 806599 807222 807851 811865 812079 812407 814538 ] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные большие"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge big"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (1.04%) |
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.