Query Metrics
7
Database Queries
7
Different statements
188.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.33 ms (88.80%) |
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 540101 540104 540117 540120 540121 540127 540136 540140 540156 540174 540675 542180 542427 543678 544228 544231 546314 547406 547410 547413 547442 553695 554381 554706 554708 554721 555214 555261 555301 555406 555438 555616 555745 555967 556000 557411 560900 561035 561044 561049 561055 562493 563976 567496 579472 582505 584399 585208 585331 590226 600668 605248 606230 615830 618309 627858 630519 632282 633181 634363 636439 640861 643699 649447 650711 651815 661645 666057 666087 666360 667450 669538 673935 686154 687778 693934 703733 703735 711695 722075 732865 734351 734415 737801 740265 742097 743689 743997 744496 757218 790112 794998 798755 798772 801819 801823 804424 808277 810089 814221 819807 823768 824485 824493 824800 825793 826098 826099 826297 826321 826408 826491 826724 826956 827280 827401 828836 ] |
||||||||||||||||||||||||||||||
|
10.87 ms (5.77%) |
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 554381 561049 561055 556000 554721 585331 824800 826099 555967 555616 693934 825793 827401 808277 732865 826724 823768 540120 540136 547410 722075 643699 618309 734351 743997 757218 540156 553695 650711 686154 555261 582505 627858 824485 826491 540054 562493 667450 555406 737801 540140 666360 703735 666087 579472 630519 801823 819807 540055 540104 540117 567496 547442 555438 557411 605248 633181 590226 632282 540121 561035 543678 615830 634363 826098 828836 826297 801819 798755 661645 826956 540101 540174 547413 555745 636439 640861 734415 742097 744496 743689 540075 540675 542427 561044 584399 542180 544228 544231 554708 563976 666057 669538 687778 649447 651815 673935 546314 547406 555214 555301 600668 606230 703733 560900 585208 814221 827280 711695 804424 794998 740265 810089 790112 798772 826408 824493 826321 540127 554706 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.70%) |
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 540101 540104 540117 540120 540121 540127 540136 540140 540156 540174 540675 542180 542427 543678 544228 544231 546314 547406 547410 547413 547442 553695 554381 554706 554708 554721 555214 555261 555301 555406 555438 555616 555745 555967 556000 557411 560900 561035 561044 561049 561055 562493 563976 567496 579472 582505 584399 585208 585331 590226 600668 605248 606230 615830 618309 627858 630519 632282 633181 634363 636439 640861 643699 649447 650711 651815 661645 666057 666087 666360 667450 669538 673935 686154 687778 693934 703733 703735 711695 722075 732865 734351 734415 737801 740265 742097 743689 743997 744496 757218 790112 794998 798755 798772 801819 801823 804424 808277 810089 814221 819807 823768 824485 824493 824800 825793 826098 826099 826297 826321 826408 826491 826724 826956 827280 827401 828836 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pissing"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск pissing"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
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.