Query Metrics
7
Database Queries
7
Different statements
176.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.12 ms (85.13%) |
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 418090 431922 464029 478979 483013 491178 510027 526667 530176 530199 532398 535802 546692 547239 552590 555613 557218 564330 564343 565741 573260 574174 577054 579667 579998 581179 588481 592160 595155 601167 607224 610696 614370 619005 623484 627114 627860 635419 637249 638182 639291 644543 659471 663358 668948 697223 707519 709207 709343 710020 710105 710843 712188 713670 715484 721671 723242 724972 731261 733412 734295 734699 734706 735036 738922 741027 747213 748109 748731 750869 752306 752915 752984 753132 753779 755057 757248 757308 758168 759083 759341 759521 763389 763390 763393 763397 763748 770891 774803 778712 781255 785977 787133 787785 788135 788259 788265 788271 789244 790216 790221 790609 790821 790943 792556 793789 797249 797266 799717 803228 803713 805356 810656 811194 811322 813791 814509 816587 827522 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (8.74%) |
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 546692 610696 637249 592160 635419 790943 803228 805356 788271 790221 750869 759521 788135 811322 752306 763389 763390 781255 785977 532398 510027 710020 789244 581179 619005 595155 826136 535802 483013 491178 552590 663358 707519 588481 623484 627114 799717 788259 757248 792556 724972 759341 418090 813791 827522 574174 668948 565741 579998 811194 790216 733412 735036 752915 770891 752984 763397 747213 734699 738922 753779 763748 607224 614370 644543 790821 464029 755057 758168 431922 555613 710105 530176 530199 547239 564330 579667 557218 573260 659471 697223 721671 710843 639291 638182 774803 797249 753132 790609 797266 803713 731261 734706 748109 734295 748731 741027 709207 713670 723242 793789 814509 816587 478979 526667 577054 709343 712188 564343 601167 627860 810656 778712 788265 759083 763393 787133 757308 715484 787785 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.53%) |
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 418090 431922 464029 478979 483013 491178 510027 526667 530176 530199 532398 535802 546692 547239 552590 555613 557218 564330 564343 565741 573260 574174 577054 579667 579998 581179 588481 592160 595155 601167 607224 610696 614370 619005 623484 627114 627860 635419 637249 638182 639291 644543 659471 663358 668948 697223 707519 709207 709343 710020 710105 710843 712188 713670 715484 721671 723242 724972 731261 733412 734295 734699 734706 735036 738922 741027 747213 748109 748731 750869 752306 752915 752984 753132 753779 755057 757248 757308 758168 759083 759341 759521 763389 763390 763393 763397 763748 770891 774803 778712 781255 785977 787133 787785 788135 788259 788265 788271 789244 790216 790221 790609 790821 790943 792556 793789 797249 797266 799717 803228 803713 805356 810656 811194 811322 813791 814509 816587 827522 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big game"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие игр"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
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.