Query Metrics
7
Database Queries
7
Different statements
160.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.87 ms (82.92%) |
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 326039 381940 385104 395556 411833 419544 419594 420540 430923 439569 452045 454206 458715 459620 462557 465342 465860 466181 466897 468934 474108 474391 475080 477185 477715 478446 484470 484584 485695 486581 490944 491209 495420 496056 502002 502029 502718 502743 503961 505107 509206 512999 520696 523902 524987 525484 534851 535532 536586 539480 546939 549767 549964 556842 557540 557998 561131 563434 571240 575815 576651 576678 581383 584810 585958 590850 593743 595842 595992 599327 605576 606791 619482 628693 646833 650494 661568 663501 664833 665384 668943 673365 681857 684934 689012 724479 726552 726836 727022 729091 729217 730934 735376 737167 737180 737863 741738 742860 743811 744632 748239 748892 755468 756816 759877 775890 785434 790218 793703 796271 801210 801356 802107 802741 803081 804194 807332 807760 811182 820679 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (10.33%) |
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 807760 729217 730934 748892 724479 737180 737863 755468 735376 756816 775890 785434 802107 804194 811182 462557 419594 458715 459620 549767 557540 576651 681857 575815 606791 790218 381940 505107 520696 486581 395556 326039 439569 820679 474108 478446 452045 534851 535532 539480 556842 584810 557998 646833 650494 661568 663501 664833 665384 684934 673365 689012 546939 549964 563434 599327 595842 595992 619482 801210 801356 807332 803081 737167 759877 726552 744632 742860 743811 726836 727022 793703 802741 419544 466181 430923 502002 509206 496056 512999 475080 477185 524987 502743 668943 590850 503961 502029 485695 748239 420540 465342 465860 523902 502718 468934 628693 477715 466897 491209 490944 385104 796271 729091 741738 411833 484470 474391 484584 454206 525484 536586 495420 576678 561131 581383 571240 605576 585958 593743 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.20%) |
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 326039 381940 385104 395556 411833 419544 419594 420540 430923 439569 452045 454206 458715 459620 462557 465342 465860 466181 466897 468934 474108 474391 475080 477185 477715 478446 484470 484584 485695 486581 490944 491209 495420 496056 502002 502029 502718 502743 503961 505107 509206 512999 520696 523902 524987 525484 534851 535532 536586 539480 546939 549767 549964 556842 557540 557998 561131 563434 571240 575815 576651 576678 581383 584810 585958 590850 593743 595842 595992 599327 605576 606791 619482 628693 646833 650494 661568 663501 664833 665384 668943 673365 681857 684934 689012 724479 726552 726836 727022 729091 729217 730934 735376 737167 737180 737863 741738 742860 743811 744632 748239 748892 755468 756816 759877 775890 785434 790218 793703 796271 801210 801356 802107 802741 803081 804194 807332 807760 811182 820679 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"kissing зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kissing mature woman"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"kissing зрелая женщин"
]
|
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.