Query Metrics
7
Database Queries
7
Different statements
202.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.80 ms (88.40%) |
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 395735 401757 402597 406724 420254 420853 420877 423516 427487 427544 432743 432745 440274 440414 440580 440895 440902 440939 440967 443166 451629 457146 458443 462681 464800 464853 465540 487987 492112 492222 499083 505725 513817 520790 537958 541755 552697 558582 559996 560966 562225 564557 577678 581384 586853 593589 598623 599072 604221 610121 610434 610517 610522 610526 614880 615841 620115 626688 627308 631117 633455 636951 639040 639279 647060 647602 647611 665831 668083 668097 670084 674127 678903 685070 685843 691170 702165 707569 712393 713676 715593 717876 719225 719640 721249 721978 724048 727882 731382 732579 732822 735005 736470 748334 757715 758208 760214 761030 761531 769291 772517 775813 776320 784288 786048 789437 793075 793727 794381 795686 796183 796194 800975 801290 807419 818835 820164 823359 824320 824868 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (7.07%) |
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 627308 807419 395735 735005 732579 552697 715593 564557 610522 758208 727882 707569 820164 721978 719225 801290 784288 748334 757715 440580 581384 824320 499083 665831 685843 793075 796183 761531 796194 631117 717876 724048 761030 465540 464853 562225 647060 615841 401757 457146 427487 560966 610434 626688 712393 427544 440902 633455 760214 670084 487987 823359 402597 559996 795686 818835 674127 793727 423516 537958 599072 604221 505725 647611 719640 440414 702165 440939 492222 775813 558582 732822 731382 432743 451629 577678 420254 440274 432745 721249 639040 776320 794381 736470 593589 824868 713676 586853 420853 691170 492112 668097 800975 541755 598623 610517 636951 789437 678903 406724 462681 614880 464800 610526 420877 520790 513817 668083 610121 620115 786048 772517 639279 443166 440967 769291 458443 440895 647602 685070 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.18%) |
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 395735 401757 402597 406724 420254 420853 420877 423516 427487 427544 432743 432745 440274 440414 440580 440895 440902 440939 440967 443166 451629 457146 458443 462681 464800 464853 465540 487987 492112 492222 499083 505725 513817 520790 537958 541755 552697 558582 559996 560966 562225 564557 577678 581384 586853 593589 598623 599072 604221 610121 610434 610517 610522 610526 614880 615841 620115 626688 627308 631117 633455 636951 639040 639279 647060 647602 647611 665831 668083 668097 670084 674127 678903 685070 685843 691170 702165 707569 712393 713676 715593 717876 719225 719640 721249 721978 724048 727882 731382 732579 732822 735005 736470 748334 757715 758208 760214 761030 761531 769291 772517 775813 776320 784288 786048 789437 793075 793727 794381 795686 796183 796194 800975 801290 807419 818835 820164 823359 824320 824868 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal real sex"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал real секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал real секс"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.72%) |
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.