Query Metrics
7
Database Queries
7
Different statements
213.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.47 ms (87.05%) |
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 396242 396251 399023 400423 403496 424622 461645 470707 470735 470855 486201 491646 507351 507368 512883 523259 529125 543203 548548 548569 548582 548606 550130 550207 550505 551982 554415 554424 558273 559145 561833 566146 566719 566962 568041 574504 574777 575472 576043 581313 581564 585398 586308 589134 597195 597215 600316 604085 618645 618672 618882 618888 620791 623312 623574 623840 624864 645845 647297 647850 663854 664296 668857 675373 676536 683917 686054 689758 690126 692389 692641 692859 693039 693077 696991 701774 708457 708804 714464 714497 717892 720009 722706 722897 723492 735594 735844 736707 740821 741109 741639 743196 747858 748561 752523 754356 758033 758525 759639 766042 779523 786036 788582 789885 790242 798971 807689 809808 810665 812141 812153 814084 817022 817816 819698 821178 821578 821861 822167 824921 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (7.98%) |
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 743196 807689 741639 696991 809808 396242 399023 714497 574777 575472 400423 668857 623312 618882 722897 812141 470707 491646 529125 461645 554415 558273 561833 581564 550505 559145 566719 566962 675373 692859 663854 693077 554424 574504 581313 585398 623840 597215 600316 618645 618672 624864 589134 604085 810665 618888 758525 692389 548606 548548 566146 647850 623574 550207 403496 470855 722706 597195 788582 812153 723492 814084 817816 817022 821578 824921 821861 822167 486201 543203 686054 693039 708457 645845 717892 664296 683917 690126 692641 708804 720009 620791 786036 798971 789885 747858 748561 735844 736707 754356 766042 758033 735594 740821 779523 790242 550130 576043 551982 647297 759639 424622 701774 396251 507368 676536 752523 548569 548582 568041 714464 586308 741109 470735 507351 512883 523259 689758 819698 821178 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.43%) |
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 396242 396251 399023 400423 403496 424622 461645 470707 470735 470855 486201 491646 507351 507368 512883 523259 529125 543203 548548 548569 548582 548606 550130 550207 550505 551982 554415 554424 558273 559145 561833 566146 566719 566962 568041 574504 574777 575472 576043 581313 581564 585398 586308 589134 597195 597215 600316 604085 618645 618672 618882 618888 620791 623312 623574 623840 624864 645845 647297 647850 663854 664296 668857 675373 676536 683917 686054 689758 690126 692389 692641 692859 693039 693077 696991 701774 708457 708804 714464 714497 717892 720009 722706 722897 723492 735594 735844 736707 740821 741109 741639 743196 747858 748561 752523 754356 758033 758525 759639 766042 779523 786036 788582 789885 790242 798971 807689 809808 810665 812141 812153 814084 817022 817816 819698 821178 821578 821861 822167 824921 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small young girls"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая young девушк"
]
|
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.