Query Metrics
7
Database Queries
7
Different statements
180.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.41 ms (84.76%) |
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 79765 151180 388765 391062 395463 400715 400864 404125 417429 427179 427449 443373 453530 453603 454861 461973 462579 466936 469898 470703 485489 495159 503917 503949 507009 510586 520750 524023 530347 545959 548401 548670 557422 558320 566081 571150 579488 586034 586185 595470 595864 595925 604425 606582 617363 618528 621593 625815 626330 627171 628811 633665 644708 652667 653300 658224 658225 662436 686795 714477 714851 716326 716392 716396 718399 726703 726876 731080 731111 731432 735524 737910 738257 738623 738970 740084 741114 745386 753993 754967 759634 760214 760218 761170 765710 765763 765904 765907 766644 771874 774927 776138 782664 783562 784925 789874 789877 793436 795092 796123 797216 798992 799791 801644 807331 810533 819212 821829 821834 821855 821860 825054 825158 825500 825563 825661 825693 825781 825835 826672 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (9.17%) |
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 718399 652667 789874 783562 795092 760214 765710 766644 798992 807331 765904 760218 761170 796123 395463 404125 417429 443373 454861 151180 427179 427449 507009 510586 503949 653300 571150 595470 621593 625815 716396 801644 461973 466936 453603 462579 469898 503917 520750 524023 782664 731080 731111 388765 628811 797216 566081 825835 825158 79765 391062 400864 400715 821860 826672 825500 819212 825054 825781 825563 825661 825693 821829 821834 821855 453530 485489 470703 530347 495159 548401 558320 579488 557422 662436 714477 658224 686795 714851 716326 716392 658225 545959 548670 595925 617363 586034 586185 595864 604425 606582 626330 633665 644708 776138 793436 799791 810533 774927 789877 726703 737910 738257 740084 784925 731432 754967 759634 726876 738623 738970 735524 745386 765763 771874 741114 753993 765907 618528 627171 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.20%) |
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 79765 151180 388765 391062 395463 400715 400864 404125 417429 427179 427449 443373 453530 453603 454861 461973 462579 466936 469898 470703 485489 495159 503917 503949 507009 510586 520750 524023 530347 545959 548401 548670 557422 558320 566081 571150 579488 586034 586185 595470 595864 595925 604425 606582 617363 618528 621593 625815 626330 627171 628811 633665 644708 652667 653300 658224 658225 662436 686795 714477 714851 716326 716392 716396 718399 726703 726876 731080 731111 731432 735524 737910 738257 738623 738970 740084 741114 745386 753993 754967 759634 760214 760218 761170 765710 765763 765904 765907 766644 771874 774927 776138 782664 783562 784925 789874 789877 793436 795092 796123 797216 798992 799791 801644 807331 810533 819212 821829 821834 821855 821860 825054 825158 825500 825563 825661 825693 825781 825835 826672 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur young old"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск young old"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск young old"
]
|
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.