Query Metrics
7
Database Queries
7
Different statements
153.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.78 ms (86.64%) |
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 540054 540055 540075 540104 540113 540117 540120 540121 540127 540136 540140 540156 540675 541194 541856 542180 542427 543678 544228 544231 546314 547406 547410 547442 549522 553695 554706 554708 554709 554734 554735 555261 555406 555438 557411 560900 561035 561043 561768 567496 579472 582505 584399 585208 600668 605248 607305 615830 621320 627858 628374 630519 630522 631439 632282 632649 633181 633780 634133 634363 640856 642025 643112 649447 650711 653691 666360 667450 669538 670806 673935 673944 674952 678144 686154 687778 691846 693930 693934 703735 711695 715621 717990 722075 732865 734846 737801 740265 740374 743689 743996 743997 744568 749025 749097 757218 769445 790112 793510 798755 798772 801819 802084 808277 814166 814221 814224 817881 819424 819807 825342 825824 825968 826186 826297 826321 826724 827188 827681 828836 ] |
||||||||||||||||||||||||||||||
|
10.23 ms (6.67%) |
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 678144 643112 540136 802084 740374 743997 757218 749097 607305 737801 825968 827188 717990 808277 732865 826297 540156 553695 667450 582505 627858 631439 541856 674952 630522 826724 817881 540120 547410 691846 722075 693934 634133 640856 793510 734846 628374 826186 819807 828836 540140 703735 579472 633181 798772 632282 814221 693930 743689 827681 540054 561043 650711 686154 555261 555406 801819 798755 621320 814166 549522 544231 554709 743996 744568 540121 541194 561035 543678 711695 615830 634363 740265 632649 642025 814224 554735 584399 544228 561768 673944 669538 585208 769445 749025 540055 540104 540117 567496 547442 666360 670806 555438 557411 630519 605248 790112 633780 825824 819424 825342 826321 540127 540075 540113 540675 554706 542427 560900 542180 554708 554734 653691 687778 649447 673935 715621 546314 547406 600668 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.07%) |
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 540054 540055 540075 540104 540113 540117 540120 540121 540127 540136 540140 540156 540675 541194 541856 542180 542427 543678 544228 544231 546314 547406 547410 547442 549522 553695 554706 554708 554709 554734 554735 555261 555406 555438 557411 560900 561035 561043 561768 567496 579472 582505 584399 585208 600668 605248 607305 615830 621320 627858 628374 630519 630522 631439 632282 632649 633181 633780 634133 634363 640856 642025 643112 649447 650711 653691 666360 667450 669538 670806 673935 673944 674952 678144 686154 687778 691846 693930 693934 703735 711695 715621 717990 722075 732865 734846 737801 740265 740374 743689 743996 743997 744568 749025 749097 757218 769445 790112 793510 798755 798772 801819 802084 808277 814166 814221 814224 817881 819424 819807 825342 825824 825968 826186 826297 826321 826724 827188 827681 828836 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl pissing"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк pissing"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк pissing"
]
|
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.