Query Metrics
7
Database Queries
7
Different statements
215.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.77 ms (89.16%) |
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 78887 187800 370755 388154 393072 401130 425321 426531 440312 440947 441000 448711 452008 454204 454218 454430 454437 456860 459647 460186 460607 463841 466318 469321 470936 471885 471975 474861 489938 503829 505089 505675 514681 524362 525479 536656 604494 607064 629354 707428 709359 724286 725030 725041 726330 726574 726576 726585 726698 727925 728248 728254 728295 731815 732344 733091 740616 740991 741691 741700 741751 742706 744204 745007 745844 745952 748146 748522 752627 755369 758427 759629 762669 765302 766690 772104 772549 772578 774331 774761 781646 782252 782429 785434 785922 788192 789325 789532 790976 794319 797272 798051 799004 799364 799640 800418 800508 801077 801587 801910 803298 803357 803669 803835 804194 804983 806959 807534 808035 808518 808541 808544 808667 809364 811098 811401 811407 813243 816012 825979 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (6.60%) |
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 790976 794319 797272 799364 799640 800418 801587 801910 803357 808541 808544 811407 774761 782429 788192 789325 789532 798051 800508 809364 811401 813243 725030 726698 733091 741751 744204 748146 772578 803669 807534 811098 726330 727925 728248 728295 741691 741700 748522 755369 774331 724286 725041 726576 726585 728254 731815 740616 742706 745007 745844 745952 765302 772104 759629 762669 772549 726574 732344 740991 752627 758427 766690 604494 629354 707428 709359 781646 782252 785434 785922 799004 801077 803298 803835 804194 804983 806959 808035 808518 808667 78887 459647 393072 440947 471975 456860 388154 440312 466318 505089 816012 825979 607064 187800 370755 401130 425321 426531 441000 448711 454218 454437 469321 470936 471885 454204 460186 460607 463841 452008 454430 474861 489938 505675 514681 525479 536656 503829 524362 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.31%) |
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 78887 187800 370755 388154 393072 401130 425321 426531 440312 440947 441000 448711 452008 454204 454218 454430 454437 456860 459647 460186 460607 463841 466318 469321 470936 471885 471975 474861 489938 503829 505089 505675 514681 524362 525479 536656 604494 607064 629354 707428 709359 724286 725030 725041 726330 726574 726576 726585 726698 727925 728248 728254 728295 731815 732344 733091 740616 740991 741691 741700 741751 742706 744204 745007 745844 745952 748146 748522 752627 755369 758427 759629 762669 765302 766690 772104 772549 772578 774331 774761 781646 782252 782429 785434 785922 788192 789325 789532 790976 794319 797272 798051 799004 799364 799640 800418 800508 801077 801587 801910 803298 803357 803669 803835 804194 804983 806959 807534 808035 808518 808541 808544 808667 809364 811098 811401 811407 813243 816012 825979 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaved mature"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бритая mature"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бритая mature"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.64%) |
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.