Query Metrics
7
Database Queries
7
Different statements
153.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.84 ms (86.36%) |
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 151132 230946 249009 387285 391667 392021 392025 394451 396073 396933 397941 398269 400531 400719 401352 402370 402599 402788 403414 412139 416455 417844 419616 421518 421831 424164 428035 429867 435471 435559 435580 435933 435939 438580 438858 443169 443420 443975 448053 449764 452225 452958 455539 457401 459379 464964 466294 468142 468270 470691 470697 473262 475777 477950 480115 481624 485512 489680 494647 504189 506466 507638 508913 513632 515313 515976 517317 519372 521531 524690 525130 525438 527326 527467 554226 555040 561124 561291 564203 584690 600121 608174 609540 609605 620441 624751 625017 636062 654201 663747 664317 668815 704019 704298 708701 723239 737186 742297 743788 743964 757480 768584 773463 775256 777327 778847 779420 779749 779780 782061 785440 792195 794343 800175 801988 804353 809411 810414 811570 ] |
||||||||||||||||||||||||||||||
|
12.52 ms (8.14%) |
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 708701 723239 663747 704298 561124 600121 608174 620441 624751 625017 636062 779780 782061 786867 794343 800175 801988 792195 809411 768584 810414 743788 737186 742297 773463 743964 757480 704019 777327 778847 779420 779749 785440 804353 811570 151132 392025 403414 452225 452958 475777 394451 398269 392021 416455 249009 387285 396933 400531 401352 419616 464964 506466 508913 513632 517317 515976 609605 564203 396073 428035 435471 443420 449764 468142 554226 584690 555040 561291 654201 609540 438858 466294 421831 429867 524690 507638 519372 668815 400719 504189 402788 435933 417844 468270 459379 470697 481624 494647 515313 480115 775256 443169 455539 473262 477950 443975 470691 521531 489680 485512 525130 525438 527326 527467 664317 230946 391667 397941 402370 402599 421518 424164 435939 438580 412139 435559 435580 448053 457401 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.39%) |
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 151132 230946 249009 387285 391667 392021 392025 394451 396073 396933 397941 398269 400531 400719 401352 402370 402599 402788 403414 412139 416455 417844 419616 421518 421831 424164 428035 429867 435471 435559 435580 435933 435939 438580 438858 443169 443420 443975 448053 449764 452225 452958 455539 457401 459379 464964 466294 468142 468270 470691 470697 473262 475777 477950 480115 481624 485512 489680 494647 504189 506466 507638 508913 513632 515313 515976 517317 519372 521531 524690 525130 525438 527326 527467 554226 555040 561124 561291 564203 584690 600121 608174 609540 609605 620441 624751 625017 636062 654201 663747 664317 668815 704019 704298 708701 723239 737186 742297 743788 743964 757480 768584 773463 775256 777327 778847 779420 779749 779780 782061 785440 792195 794343 800175 801988 804353 809411 810414 811570 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette wife"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая жен"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая жен"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.85%) |
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.