Query Metrics
7
Database Queries
7
Different statements
183.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.40 ms (81.99%) |
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 31583 383705 384419 391099 395218 396470 396821 398527 409713 414329 420006 423849 423928 423958 428797 429248 433995 438055 454332 457805 466503 467096 468062 468925 469106 470009 472065 472811 484152 487102 504359 505857 510015 510937 513136 514941 518590 518786 519625 527246 528613 529046 530144 530403 530698 533403 534619 535390 537538 542734 543021 546307 547781 548076 550946 557349 558100 558106 562903 565968 574630 575701 576746 579949 581040 583374 586364 594409 600980 602522 604849 608705 613769 614890 624116 630063 643669 650606 658469 660356 660364 661356 661359 667338 671078 673100 680690 691219 692712 710666 714042 729421 746092 747048 753583 754064 757207 762802 776890 779644 782978 785376 798784 802236 813460 813804 813822 816817 817554 817776 817813 818489 818621 819503 819862 824027 824502 828256 828260 828370 ] |
||||||||||||||||||||||||||||||
|
23.18 ms (12.64%) |
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 692712 710666 600980 785376 469106 398527 438055 505857 528613 661356 31583 547781 660364 658469 661359 602522 673100 548076 518590 691219 594409 423928 396470 813822 468925 530698 514941 550946 802236 608705 423849 428797 484152 510015 824502 816817 824027 828260 828256 537538 650606 660356 747048 753583 819862 813460 729421 535390 529046 518786 468062 467096 558106 409713 433995 429248 466503 533403 513136 472065 558100 575701 614890 586364 643669 624116 757207 776890 414329 504359 510937 423958 454332 530144 527246 487102 557349 542734 543021 565968 562903 680690 576746 630063 782978 472811 420006 470009 457805 383705 391099 818621 828370 671078 581040 613769 798784 746092 779644 818489 534619 714042 574630 817554 817776 817813 819503 813804 530403 546307 667338 762802 754064 396821 583374 384419 579949 604849 519625 395218 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.50%) |
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 31583 383705 384419 391099 395218 396470 396821 398527 409713 414329 420006 423849 423928 423958 428797 429248 433995 438055 454332 457805 466503 467096 468062 468925 469106 470009 472065 472811 484152 487102 504359 505857 510015 510937 513136 514941 518590 518786 519625 527246 528613 529046 530144 530403 530698 533403 534619 535390 537538 542734 543021 546307 547781 548076 550946 557349 558100 558106 562903 565968 574630 575701 576746 579949 581040 583374 586364 594409 600980 602522 604849 608705 613769 614890 624116 630063 643669 650606 658469 660356 660364 661356 661359 667338 671078 673100 680690 691219 692712 710666 714042 729421 746092 747048 753583 754064 757207 762802 776890 779644 782978 785376 798784 802236 813460 813804 813822 816817 817554 817776 817813 818489 818621 819503 819862 824027 824502 828256 828260 828370 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"glasses public"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"очкастая на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
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.