Query Metrics
7
Database Queries
7
Different statements
165.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.08 ms (82.64%) |
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 382083 413095 415496 423260 429272 446260 447955 455841 458414 462689 476387 492239 492679 501865 504546 508818 508841 513304 516261 520629 532753 533760 536687 536766 536789 539938 545521 559868 564443 564597 565279 566158 569453 575094 575210 575514 575734 576058 576380 576415 579668 589268 589484 591077 594173 594929 597061 598646 605338 611565 611933 612207 612946 615796 620912 621054 622540 628090 633733 634510 638985 644078 644956 645905 647850 651872 664274 665027 671832 673371 680141 696690 705713 714761 715722 717745 718236 719143 720001 720384 721556 722596 725564 726789 728174 729864 730261 730369 731416 732420 732425 735821 735846 736400 737416 741966 742031 744628 745401 746423 747558 747604 747855 749116 754141 755252 756521 757098 758986 760034 763349 765710 766851 775018 785021 786768 786998 804751 811742 826327 ] |
||||||||||||||||||||||||||||||
|
18.80 ms (11.33%) |
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 539938 533760 564443 647850 628090 634510 638985 605338 447955 423260 413095 559868 680141 705713 720001 645905 651872 714761 721556 664274 696690 717745 621054 597061 620912 622540 785021 811742 786768 745401 749116 757098 763349 729864 730261 756521 728174 735846 726789 730369 736400 737416 747558 747855 755252 731416 744628 746423 719143 775018 786998 382083 429272 415496 458414 576058 565279 569453 575210 545521 564597 594929 594173 462689 476387 513304 516261 504546 492679 501865 492239 508818 508841 591077 532753 536766 536687 536789 633733 598646 644956 826327 520629 566158 665027 671832 718236 673371 720384 722596 579668 611565 589268 612207 612946 615796 644078 804751 747604 758986 760034 765710 766851 732425 741966 742031 725564 732420 735821 754141 611933 715722 589484 455841 446260 575094 575514 576415 576380 575734 ] |
||||||||||||||||||||||||||||||
|
2.92 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 382083 413095 415496 423260 429272 446260 447955 455841 458414 462689 476387 492239 492679 501865 504546 508818 508841 513304 516261 520629 532753 533760 536687 536766 536789 539938 545521 559868 564443 564597 565279 566158 569453 575094 575210 575514 575734 576058 576380 576415 579668 589268 589484 591077 594173 594929 597061 598646 605338 611565 611933 612207 612946 615796 620912 621054 622540 628090 633733 634510 638985 644078 644956 645905 647850 651872 664274 665027 671832 673371 680141 696690 705713 714761 715722 717745 718236 719143 720001 720384 721556 722596 725564 726789 728174 729864 730261 730369 731416 732420 732425 735821 735846 736400 737416 741966 742031 744628 745401 746423 747558 747604 747855 749116 754141 755252 756521 757098 758986 760034 763349 765710 766851 775018 785021 786768 786998 804751 811742 826327 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг старый"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кастинг с дедушкой"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг старый"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.