Query Metrics
7
Database Queries
7
Different statements
149.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.43 ms (85.48%) |
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 37057 183126 328609 371061 378309 382788 389198 396730 397074 417469 420614 446340 446345 459325 498821 505630 529887 533308 536186 552951 554072 560456 561265 584615 589966 591626 597600 597660 601096 604079 609452 611547 624329 630465 630873 638567 644307 648279 656544 665939 666850 668389 673580 686034 687594 692495 693219 694908 696248 698286 700917 703982 704114 705683 709935 710685 711005 713178 714663 718108 719817 720051 723787 725757 729160 732442 732476 732888 734049 735810 735848 735951 739146 739720 741064 741682 744991 746470 746999 748437 750884 754923 755318 755387 756510 759362 764175 766166 772272 778067 780855 783935 784703 785661 785691 789094 790815 791752 791753 792556 793243 795719 800161 804024 807655 807697 810129 810355 810551 812078 812470 812501 813444 817761 817965 818419 820698 820990 822279 822888 ] |
||||||||||||||||||||||||||||||
|
11.54 ms (7.74%) |
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 498821 536186 584615 560456 554072 656544 694908 713178 624329 630465 591626 597600 601096 789094 785691 790815 795719 813444 735810 772272 783935 791752 807697 812501 735848 755318 754923 759362 764175 735951 756510 734049 698286 793243 389198 529887 37057 446345 459325 533308 709935 719817 589966 739146 755387 729160 732442 417469 382788 183126 328609 378309 420614 817761 818419 820698 822888 820990 817965 822279 561265 648279 692495 704114 710685 720051 665939 668389 693219 700917 711005 673580 687594 696248 718108 604079 609452 611547 630873 638567 778067 780855 791753 785661 792556 807655 810129 810355 810551 812078 812470 732476 741682 744991 746999 750884 723787 732888 766166 725757 741064 746470 739720 748437 644307 784703 800161 804024 446340 666850 371061 396730 397074 505630 552951 686034 705683 703982 714663 597660 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (2.10%) |
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 37057 183126 328609 371061 378309 382788 389198 396730 397074 417469 420614 446340 446345 459325 498821 505630 529887 533308 536186 552951 554072 560456 561265 584615 589966 591626 597600 597660 601096 604079 609452 611547 624329 630465 630873 638567 644307 648279 656544 665939 666850 668389 673580 686034 687594 692495 693219 694908 696248 698286 700917 703982 704114 705683 709935 710685 711005 713178 714663 718108 719817 720051 723787 725757 729160 732442 732476 732888 734049 735810 735848 735951 739146 739720 741064 741682 744991 746470 746999 748437 750884 754923 755318 755387 756510 759362 764175 766166 772272 778067 780855 783935 784703 785661 785691 789094 790815 791752 791753 792556 793243 795719 800161 804024 807655 807697 810129 810355 810551 812078 812470 812501 813444 817761 817965 818419 820698 820990 822279 822888 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls black"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк black"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк black"
]
|
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.