Query Metrics
7
Database Queries
7
Different statements
143.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.39 ms (84.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 436588 444608 446060 451333 452277 452334 455963 457392 460559 460560 461800 462654 464227 467738 492167 495049 497648 499120 500377 505869 505870 508394 511046 517371 524133 525027 526446 533102 542628 552353 553432 560438 563170 566651 567558 573514 575037 579471 579561 585256 586201 586211 586244 586245 586274 588236 590375 595031 599466 601204 602762 605671 613606 617262 617614 620121 623180 623232 625724 626119 626872 627782 630662 643936 644119 644186 650646 661914 662117 664650 666470 667999 674604 678644 681950 682734 691138 695800 698015 700590 708095 710188 710667 711782 711805 713908 718699 719287 724713 743831 744484 752472 755627 757724 758232 763442 765886 767399 772157 772753 782198 782536 785507 793879 795636 798221 798819 799171 799209 799260 799574 802287 802883 804327 804894 805182 807584 813328 814233 ] |
||||||||||||||||||||||||||||||
|
12.15 ms (8.48%) |
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 500377 505869 814233 700590 710188 713908 650646 664650 695800 698015 711782 719287 585256 588236 643936 782536 799209 813328 799171 772157 782198 793879 743831 765886 766431 763442 617262 711805 452277 460559 495049 511046 573514 566651 678644 661914 599466 586244 757724 755627 772753 630662 497648 617614 524133 455963 436588 452334 457392 460560 526446 505870 517371 525027 560438 542628 579471 666470 674604 691138 563170 601204 590375 626872 644186 586274 623180 626119 586201 602762 605671 798819 758232 613606 446060 461800 467738 451333 499120 492167 579561 620121 508394 533102 662117 681950 718699 667999 682734 708095 567558 586211 644119 595031 623232 627782 799574 805182 785507 795636 802287 807584 799260 744484 724713 752472 767399 710667 798221 802883 804327 464227 552353 575037 553432 462654 586245 625724 804894 444608 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.76%) |
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 436588 444608 446060 451333 452277 452334 455963 457392 460559 460560 461800 462654 464227 467738 492167 495049 497648 499120 500377 505869 505870 508394 511046 517371 524133 525027 526446 533102 542628 552353 553432 560438 563170 566651 567558 573514 575037 579471 579561 585256 586201 586211 586244 586245 586274 588236 590375 595031 599466 601204 602762 605671 613606 617262 617614 620121 623180 623232 625724 626119 626872 627782 630662 643936 644119 644186 650646 661914 662117 664650 666470 667999 674604 678644 681950 682734 691138 695800 698015 700590 708095 710188 710667 711782 711805 713908 718699 719287 724713 743831 744484 752472 755627 757724 758232 763442 765886 767399 772157 772753 782198 782536 785507 793879 795636 798221 798819 799171 799209 799260 799574 802287 802883 804327 804894 805182 807584 813328 814233 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"neighbor wife"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"neighbor жен"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"neighbor жен"
]
|
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.