Query Metrics
7
Database Queries
7
Different statements
160.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.05 ms (86.77%) |
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 392068 409759 421491 459730 489321 511241 511352 525182 536508 553831 561181 565939 569265 569802 572642 573249 579642 584640 585166 587268 588481 588885 590661 593056 599464 601464 605954 608423 616438 617755 618143 621592 625623 630425 635279 636628 650572 651177 656192 662839 671231 678643 680237 682179 683006 683698 684886 705383 709587 715391 731642 746708 755577 757122 764367 764615 765679 767672 767871 772255 777805 778163 778927 779364 779421 779429 779909 781348 785350 785842 787419 787985 788445 788465 789122 789140 789474 790490 791412 791643 791833 792051 792402 792467 793026 793905 793920 794112 795094 796490 797314 797477 797558 798039 799298 799897 799996 800772 800788 801692 801717 801932 801987 802169 803678 804510 804807 806118 807370 807377 807661 809716 809962 810544 810670 812443 813098 813472 ] |
||||||||||||||||||||||||||||||
|
12.46 ms (7.78%) |
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 459730 489321 511241 511352 525182 536508 561181 573249 584640 553831 565939 569802 662839 671231 682179 650572 678643 683006 683698 651177 656192 680237 684886 715391 569265 572642 579642 588481 601464 636628 585166 588885 625623 587268 593056 608423 616438 618143 635279 590661 599464 605954 617755 621592 778927 792051 792467 794112 797558 801932 802169 806118 807377 810544 812443 781348 787985 789122 789140 789474 791643 795094 799298 800772 800788 803678 813098 813472 785842 787419 788445 793920 796490 797477 798039 799996 801692 801987 804510 807661 809716 810670 731642 772255 746708 755577 764367 767672 767871 764615 765679 768119 776323 777805 778163 779364 779421 779429 779909 785350 788465 790490 791412 791833 792402 793026 793905 797314 799897 801717 804807 807370 809962 705383 709587 630425 757122 392068 421491 409759 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.27%) |
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 392068 409759 421491 459730 489321 511241 511352 525182 536508 553831 561181 565939 569265 569802 572642 573249 579642 584640 585166 587268 588481 588885 590661 593056 599464 601464 605954 608423 616438 617755 618143 621592 625623 630425 635279 636628 650572 651177 656192 662839 671231 678643 680237 682179 683006 683698 684886 705383 709587 715391 731642 746708 755577 757122 764367 764615 765679 767672 767871 772255 777805 778163 778927 779364 779421 779429 779909 781348 785350 785842 787419 787985 788445 788465 789122 789140 789474 790490 791412 791643 791833 792051 792402 792467 793026 793905 793920 794112 795094 796490 797314 797477 797558 798039 799298 799897 799996 800772 800788 801692 801717 801932 801987 802169 803678 804510 804807 806118 807370 807377 807661 809716 809962 810544 810670 812443 813098 813472 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot pov"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot пов"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot пов"
]
|
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.