Query Metrics
7
Database Queries
7
Different statements
145.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.21 ms (83.95%) |
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 233457 388364 396350 397848 397870 398200 401218 410686 441562 463328 478454 485649 485995 493681 495059 516044 529337 532763 534094 536213 537665 544878 552664 560949 564521 564559 566767 575341 578478 583510 587543 591931 593213 593594 597732 601509 604171 604240 614923 623420 635578 641126 646624 654922 656569 661991 671049 677021 677203 680143 680302 689146 693103 693509 702630 707323 711112 715436 715652 720680 720888 724523 724978 728262 734967 734969 735073 736218 737525 740094 742797 743278 748825 750247 753449 756160 756666 756986 757599 759795 760249 761597 764245 764817 764820 764879 765376 765398 765412 765952 766337 768715 769038 769040 769878 770326 771607 776999 777637 778133 778215 778951 781052 781331 781568 783364 784209 785491 790446 791200 792092 792989 794368 794373 796153 805733 806617 807103 812014 828555 ] |
||||||||||||||||||||||||||||||
|
12.58 ms (8.65%) |
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 757599 765412 742797 748825 765376 734969 735073 737525 764245 715652 776999 781568 794373 410686 552664 623420 720680 711112 656569 689146 720888 778133 790446 791200 778951 792989 806617 756160 784209 756666 768715 769038 724523 728262 769040 771607 777637 778215 781331 396350 397848 388364 401218 485995 478454 536213 516044 537665 583510 560949 564559 578478 646624 654922 671049 680143 693103 677021 661991 677203 680302 693509 707323 597732 635578 591931 593594 614923 593213 604171 587543 601509 604240 781052 724978 740094 743278 750247 769878 794368 805733 812014 736218 756986 760249 761597 764820 764879 765952 764817 753449 765398 770326 734967 759795 766337 702630 715436 783364 785491 792092 796153 807103 463328 398200 441562 485649 641126 233457 397870 828555 493681 529337 532763 495059 534094 566767 544878 564521 575341 ] |
||||||||||||||||||||||||||||||
|
3.20 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 233457 388364 396350 397848 397870 398200 401218 410686 441562 463328 478454 485649 485995 493681 495059 516044 529337 532763 534094 536213 537665 544878 552664 560949 564521 564559 566767 575341 578478 583510 587543 591931 593213 593594 597732 601509 604171 604240 614923 623420 635578 641126 646624 654922 656569 661991 671049 677021 677203 680143 680302 689146 693103 693509 702630 707323 711112 715436 715652 720680 720888 724523 724978 728262 734967 734969 735073 736218 737525 740094 742797 743278 748825 750247 753449 756160 756666 756986 757599 759795 760249 761597 764245 764817 764820 764879 765376 765398 765412 765952 766337 768715 769038 769040 769878 770326 771607 776999 777637 778133 778215 778951 781052 781331 781568 783364 784209 785491 790446 791200 792092 792989 794368 794373 796153 805733 806617 807103 812014 828555 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в жопу лучше"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.