Query Metrics
7
Database Queries
7
Different statements
392.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.92 ms (52.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
157.35 ms (40.11%) |
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 95673 382960 405020 408613 414259 414268 440016 440032 441232 443243 444684 446778 447144 451609 451758 452637 452843 460535 475646 486767 488713 507314 507696 508909 513794 523312 530377 530623 530627 531183 531193 532658 532726 532847 532981 533369 533519 534023 534532 534536 534544 534551 535001 536266 536287 536292 536344 537675 537863 537906 537986 541135 542524 544833 545407 546829 548458 550298 571192 599847 606275 613032 617429 625412 628110 629963 630798 631178 632623 632687 634786 636288 636985 639729 639759 639782 642742 643100 649497 650187 651090 653028 661900 666875 669073 677671 678099 678514 678529 691984 693925 693926 705119 713195 715670 715750 717523 722520 724109 728215 740251 740523 742363 748961 758599 770405 784066 784236 788788 788922 790219 790234 794307 801275 801975 808327 810914 816094 819218 ] |
||||||||||||||||||||||||||||||
|
22.73 ms (5.79%) |
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 740251 770405 414259 650187 536266 678099 537863 533369 629963 532658 507314 530627 508909 639759 631178 446778 452637 475646 531193 642742 788788 634786 414268 625412 408613 653028 661900 722520 630798 794307 784236 740523 758599 784066 534551 693926 649497 451609 678514 678529 530377 444684 816094 451758 513794 713195 628110 405020 441232 488713 533519 606275 486767 443243 447144 452843 536287 523312 532726 536344 537986 507696 531183 537906 530623 532981 536292 545407 677671 715670 617429 636288 807580 808327 632687 460535 550298 542524 599847 636985 819218 534532 535001 546829 548458 571192 691984 715750 669073 705119 613032 788922 724109 810914 742363 728215 534023 95673 440032 440016 651090 693925 544833 643100 748961 632623 639729 541135 717523 639782 801975 801275 790219 537675 790234 532847 666875 382960 534536 534544 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.55%) |
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 95673 382960 405020 408613 414259 414268 440016 440032 441232 443243 444684 446778 447144 451609 451758 452637 452843 460535 475646 486767 488713 507314 507696 508909 513794 523312 530377 530623 530627 531183 531193 532658 532726 532847 532981 533369 533519 534023 534532 534536 534544 534551 535001 536266 536287 536292 536344 537675 537863 537906 537986 541135 542524 544833 545407 546829 548458 550298 571192 599847 606275 613032 617429 625412 628110 629963 630798 631178 632623 632687 634786 636288 636985 639729 639759 639782 642742 643100 649497 650187 651090 653028 661900 666875 669073 677671 678099 678514 678529 691984 693925 693926 705119 713195 715670 715750 717523 722520 724109 728215 740251 740523 742363 748961 758599 770405 784066 784236 788788 788922 790219 790234 794307 801275 801975 808327 810914 816094 819218 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme double fisting"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор double фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор double фистинг"
]
|
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.