Query Metrics
7
Database Queries
7
Different statements
175.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.76 ms (87.43%) |
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 37730 193890 386324 393972 395542 411817 441241 457155 494892 514470 528875 530930 534123 534795 539500 541306 543242 543922 545254 558996 564391 566883 567570 579872 583529 591895 603288 609452 623452 625245 629072 630637 654353 665505 666861 667682 669435 678192 678651 683932 685680 688016 689945 692100 694324 701000 709834 710949 716482 718119 718143 718518 718867 719854 721276 721388 722712 724935 730736 734698 751106 753203 757324 758050 758066 758951 759399 763558 763959 766483 767333 771400 771437 777889 778482 778800 779105 779542 780252 780849 782284 783065 783084 784024 785815 785931 787658 789478 790861 791168 791965 792994 793732 795475 796044 796172 797074 801327 801337 801614 804037 804307 804463 808433 808761 809877 810148 810671 810989 811028 812171 812639 812840 813337 813795 813888 816134 821923 823422 824451 ] |
||||||||||||||||||||||||||||||
|
13.02 ms (7.40%) |
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 757324 758050 763959 771437 603288 701000 710949 718119 721276 721388 777889 790861 792994 795475 801337 801614 804037 809877 812171 813337 411817 393972 530930 804307 724935 629072 719854 810148 386324 514470 543242 583529 692100 558996 810989 778482 783065 789478 766483 793732 395542 816134 813888 823422 824451 528875 566883 545254 564391 716482 665505 678192 678651 683932 722712 623452 609452 779542 780252 780849 784024 796044 808761 811028 779105 791965 797074 804463 810671 730736 753203 767333 791168 796172 801327 808433 751106 763558 758066 759399 718518 718867 778800 785815 37730 193890 441241 813795 821923 457155 494892 534795 534123 539500 567570 543922 541306 654353 669435 685680 694324 709834 718143 666861 667682 688016 689945 579872 591895 630637 625245 785931 812639 782284 812840 734698 758951 771400 783084 787658 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.45%) |
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 37730 193890 386324 393972 395542 411817 441241 457155 494892 514470 528875 530930 534123 534795 539500 541306 543242 543922 545254 558996 564391 566883 567570 579872 583529 591895 603288 609452 623452 625245 629072 630637 654353 665505 666861 667682 669435 678192 678651 683932 685680 688016 689945 692100 694324 701000 709834 710949 716482 718119 718143 718518 718867 719854 721276 721388 722712 724935 730736 734698 751106 753203 757324 758050 758066 758951 759399 763558 763959 766483 767333 771400 771437 777889 778482 778800 779105 779542 780252 780849 782284 783065 783084 784024 785815 785931 787658 789478 790861 791168 791965 792994 793732 795475 796044 796172 797074 801327 801337 801614 804037 804307 804463 808433 808761 809877 810148 810671 810989 811028 812171 812639 812840 813337 813795 813888 816134 821923 823422 824451 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"horny fuck"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"horny секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"horny секс"
]
|
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.