Query Metrics
7
Database Queries
7
Different statements
156.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.16 ms (81.36%) |
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 24855 123789 150487 157194 387285 388365 389639 390734 391287 392600 396312 409938 428080 439488 439659 439667 439724 439746 439752 439813 439816 440693 440801 440871 440947 440997 441000 451499 453833 465540 466899 468373 478378 483649 483656 493177 495813 496873 513663 523845 531390 533635 533734 535439 536456 536457 543694 549221 550824 551863 555103 565724 570972 579510 587741 588235 588391 591977 593542 616594 617812 620480 648005 666361 667011 695380 705359 705449 709545 709654 714309 715142 717927 724086 725030 725180 726172 726539 726934 726974 726996 727754 728170 728266 733073 734332 740882 742352 742747 743806 756551 758766 759905 759929 759950 761030 761596 762381 764144 765547 767180 773271 790781 794759 795301 796048 796116 796148 796158 797358 801254 802132 802136 802142 817293 817555 826346 827147 827484 827537 ] |
||||||||||||||||||||||||||||||
|
17.20 ms (11.01%) |
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 726539 705359 389639 549221 591977 439752 483649 483656 523845 493177 535439 536456 533734 726996 409938 796158 802142 801254 767180 466899 648005 587741 761596 388365 440871 827484 513663 705449 802132 725030 743806 765547 761030 465540 588235 439488 790781 759929 817555 533635 728266 733073 531390 796048 764144 826346 496873 390734 478378 536457 714309 451499 440801 796148 726934 24855 440947 555103 617812 709545 709654 742747 396312 440997 817293 579510 666361 667011 794759 758766 759950 756551 759905 773271 728170 715142 150487 391287 439816 441000 565724 157194 439724 439746 387285 593542 797358 724086 795301 468373 620480 439667 616594 740882 727754 392600 827147 827537 543694 726172 762381 742352 495813 123789 734332 695380 717927 588391 428080 570972 551863 439659 440693 439813 453833 550824 802136 725180 726974 796116 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.03%) |
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 24855 123789 150487 157194 387285 388365 389639 390734 391287 392600 396312 409938 428080 439488 439659 439667 439724 439746 439752 439813 439816 440693 440801 440871 440947 440997 441000 451499 453833 465540 466899 468373 478378 483649 483656 493177 495813 496873 513663 523845 531390 533635 533734 535439 536456 536457 543694 549221 550824 551863 555103 565724 570972 579510 587741 588235 588391 591977 593542 616594 617812 620480 648005 666361 667011 695380 705359 705449 709545 709654 714309 715142 717927 724086 725030 725180 726172 726539 726934 726974 726996 727754 728170 728266 733073 734332 740882 742352 742747 743806 756551 758766 759905 759929 759950 761030 761596 762381 764144 765547 767180 773271 790781 794759 795301 796048 796116 796148 796158 797358 801254 802132 802136 802142 817293 817555 826346 827147 827484 827537 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur mature milf"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск mature milf"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск mature milf"
]
|
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.