Query Metrics
7
Database Queries
7
Different statements
174.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.57 ms (85.21%) |
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 69950 401103 417238 418761 426029 428335 428484 432618 434531 441047 441518 443037 461767 467935 477007 496477 504014 506292 528028 533193 535250 547434 553660 558060 565525 566858 586973 591923 593985 604320 609422 635450 636505 646525 651636 655132 670915 678491 680346 680454 697203 700760 701470 709372 710018 715521 715807 716014 720122 726232 726621 727578 727737 727785 727792 727859 728779 730407 731088 737079 740871 742735 744061 746207 747250 748805 760877 761480 763510 765547 767086 767159 767269 768388 768727 769906 775054 775203 775228 779264 779768 783980 786542 787650 788610 791403 791815 793232 793913 794403 796031 796150 796154 796661 800638 801924 802012 804335 804339 805241 809666 809740 809907 810100 810298 812014 816607 819334 820129 820749 823867 823909 824036 824049 824065 824454 824817 826453 827482 828399 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (8.39%) |
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 553660 680454 720122 558060 593985 775228 796150 740871 726621 742735 809666 432618 467935 461767 477007 418761 827482 824036 826453 535250 787650 761480 748805 651636 701470 812014 747250 726232 727737 765547 737079 700760 715807 796661 810298 441518 417238 816607 819334 824049 496477 506292 533193 566858 678491 697203 655132 670915 680346 547434 635450 586973 591923 604320 609422 775054 796154 804339 805241 796031 804335 768727 791403 793232 800638 727859 763510 768388 730407 760877 769906 727792 728779 767086 767159 767269 727785 710018 775203 783980 791815 441047 401103 426029 428484 428335 443037 716014 779768 786542 434531 528028 565525 788610 69950 823909 715521 731088 727578 646525 636505 801924 793913 809740 810100 746207 709372 779264 794403 802012 809907 824454 504014 744061 820129 823867 824065 820749 824817 828399 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.01%) |
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 69950 401103 417238 418761 426029 428335 428484 432618 434531 441047 441518 443037 461767 467935 477007 496477 504014 506292 528028 533193 535250 547434 553660 558060 565525 566858 586973 591923 593985 604320 609422 635450 636505 646525 651636 655132 670915 678491 680346 680454 697203 700760 701470 709372 710018 715521 715807 716014 720122 726232 726621 727578 727737 727785 727792 727859 728779 730407 731088 737079 740871 742735 744061 746207 747250 748805 760877 761480 763510 765547 767086 767159 767269 768388 768727 769906 775054 775203 775228 779264 779768 783980 786542 787650 788610 791403 791815 793232 793913 794403 796031 796150 796154 796661 800638 801924 802012 804335 804339 805241 809666 809740 809907 810100 810298 812014 816607 819334 820129 820749 823867 823909 824036 824049 824065 824454 824817 826453 827482 828399 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother creampie"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин creampie"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин creampie"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.01%) |
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.