Query Metrics
7
Database Queries
7
Different statements
160.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.60 ms (85.76%) |
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 25053 85792 182526 325910 348234 388254 388716 398492 400947 401368 431516 491626 509501 518473 519273 522345 530256 530377 531137 533363 533594 533717 534020 534269 534544 538925 539533 540511 541774 545605 547477 548474 550852 551057 552597 553272 557158 557210 567396 580159 586294 588265 596292 600257 621066 625694 628380 630869 634134 634208 634818 639334 640917 644309 644952 644995 649151 650316 651082 651306 652831 652885 660299 665197 665973 666732 666868 668144 669046 670773 673719 677088 680195 681045 681053 683183 689305 692453 693628 694447 695249 698537 698597 699751 703062 705519 705520 706936 708144 711997 718983 719057 719335 720236 723660 738824 748529 750081 760240 769584 787379 797908 799582 814893 815557 815723 815927 816015 816211 816222 816317 816568 817173 817446 818309 820765 820768 821877 824423 825221 ] |
||||||||||||||||||||||||||||||
|
12.67 ms (7.90%) |
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 388254 815557 815927 820765 824423 519273 539533 538925 534544 530256 533717 551057 711997 677088 681053 698597 705520 720236 665197 673719 694447 719057 644309 621066 797908 799582 760240 769584 748529 738824 750081 703062 706936 718983 787379 182526 348234 530377 518473 540511 533363 541774 545605 553272 680195 650316 666868 634134 634818 639334 628380 630869 588265 600257 634208 522345 85792 325910 25053 388716 398492 401368 400947 431516 815723 817446 644952 644995 723660 818309 821877 814893 816015 816317 816568 825221 816211 816222 817173 820768 509501 534020 531137 533594 534269 491626 548474 567396 580159 552597 547477 550852 557158 651082 668144 669046 670773 681045 692453 699751 649151 652831 665973 683183 689305 705519 651306 652885 660299 666732 693628 695249 698537 708144 719335 557210 586294 596292 625694 640917 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.93%) |
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 25053 85792 182526 325910 348234 388254 388716 398492 400947 401368 431516 491626 509501 518473 519273 522345 530256 530377 531137 533363 533594 533717 534020 534269 534544 538925 539533 540511 541774 545605 547477 548474 550852 551057 552597 553272 557158 557210 567396 580159 586294 588265 596292 600257 621066 625694 628380 630869 634134 634208 634818 639334 640917 644309 644952 644995 649151 650316 651082 651306 652831 652885 660299 665197 665973 666732 666868 668144 669046 670773 673719 677088 680195 681045 681053 683183 689305 692453 693628 694447 695249 698537 698597 699751 703062 705519 705520 706936 708144 711997 718983 719057 719335 720236 723660 738824 748529 750081 760240 769584 787379 797908 799582 814893 815557 815723 815927 816015 816211 816222 816317 816568 817173 817446 818309 820765 820768 821877 824423 825221 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"двойное брюнетки"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"двойн черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.