Query Metrics
7
Database Queries
7
Different statements
167.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.28 ms (84.97%) |
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 382960 387218 410272 414357 426511 441074 441081 441095 444645 451609 461924 467608 475647 475649 478512 481904 483730 486776 502796 505138 508891 510812 514220 522187 530503 530625 530630 530791 531272 532658 533375 533717 533942 534532 534536 534544 535001 535620 536249 536413 536783 537675 540504 541849 545453 546829 547856 548458 550264 554530 571192 574458 583936 586402 599861 599875 599958 600312 601535 601585 606275 613032 617428 619703 620794 625783 630869 632046 632588 632636 632654 632657 633748 634773 636309 639027 639706 639718 639762 639802 640740 642018 647885 647914 649546 650187 651674 656568 666550 666871 666872 666876 666880 666894 666904 669073 674943 676097 678141 678514 678529 679016 679029 691984 696216 705119 708441 715750 724109 728215 729691 739558 742363 782836 788922 790234 806580 809122 810914 819218 ] |
||||||||||||||||||||||||||||||
|
16.05 ms (9.59%) |
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 532658 533942 535620 666872 696216 666550 647885 647914 606275 632654 639762 639802 639706 639027 634773 819218 534532 535001 546829 548458 571192 691984 715750 669073 705119 613032 782836 788922 724109 810914 742363 728215 387218 441095 478512 483730 510812 514220 475647 650187 574458 599958 586402 441081 441074 451609 502796 414357 444645 410272 531272 530625 530630 530791 536249 537675 541849 678141 678514 679029 676097 678529 708441 599861 790234 806580 617428 620794 467608 649546 481904 530503 533375 540504 583936 656568 666904 679016 666871 666876 642018 600312 632657 599875 632588 632636 619703 632046 639718 601535 633748 636309 382960 534536 534544 533717 545453 547856 550264 809122 729691 739558 486776 505138 536413 508891 522187 475649 554530 601585 625783 640740 461924 426511 536783 651674 666880 666894 674943 630869 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.25%) |
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 382960 387218 410272 414357 426511 441074 441081 441095 444645 451609 461924 467608 475647 475649 478512 481904 483730 486776 502796 505138 508891 510812 514220 522187 530503 530625 530630 530791 531272 532658 533375 533717 533942 534532 534536 534544 535001 535620 536249 536413 536783 537675 540504 541849 545453 546829 547856 548458 550264 554530 571192 574458 583936 586402 599861 599875 599958 600312 601535 601585 606275 613032 617428 619703 620794 625783 630869 632046 632588 632636 632654 632657 633748 634773 636309 639027 639706 639718 639762 639802 640740 642018 647885 647914 649546 650187 651674 656568 666550 666871 666872 666876 666880 666894 666904 669073 674943 676097 678141 678514 678529 679016 679029 691984 696216 705119 708441 715750 724109 728215 729691 739558 742363 782836 788922 790234 806580 809122 810914 819218 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting double"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг double"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг double"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.91%) |
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.