Query Metrics
7
Database Queries
7
Different statements
207.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.03 ms (87.71%) |
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 545507 546843 546857 546887 549253 549358 549787 550357 551949 552495 554124 554245 554466 555356 555942 558508 559586 559855 560149 560174 561913 562049 562955 562975 563170 564309 565769 567130 567216 568096 571741 572226 572542 572543 572583 572647 573248 574630 577074 577697 578295 579166 579776 580449 584200 584507 584853 585163 585240 585307 585936 587274 587278 587801 588097 588629 588760 589664 589680 589694 590604 590705 590919 591052 591278 591288 591313 591514 591823 591859 592453 592499 592588 593046 593421 593506 596557 599010 599734 600609 600624 600645 602997 603302 603781 604619 604844 605904 606092 607303 610025 610049 613941 616461 616474 618333 618469 619470 620345 622170 622360 622462 624845 625221 626866 626891 630566 631264 631604 632072 636409 641308 643851 651192 660943 676508 680838 683787 684029 687468 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (7.51%) |
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 676508 680838 683787 684029 651192 660943 687468 545507 546843 546857 546887 549253 549358 549787 550357 551949 552495 554124 554245 554466 555356 555942 558508 559586 559855 560149 560174 561913 562049 562955 562975 563170 564309 565769 567130 567216 568096 571741 572226 572542 572543 572583 572647 573248 574630 577074 577697 578295 579166 579776 580449 584200 584507 584853 587274 588097 588629 590705 592453 593046 593506 599734 600609 600645 602997 604619 610025 610049 613941 618469 622170 625221 626866 626891 630566 631264 632072 636409 585936 587801 588760 589680 590604 590919 591052 591278 591288 591514 591859 592588 593421 596557 599010 600624 603302 603781 604844 605904 606092 607303 616461 616474 618333 619470 620345 622360 622462 624845 631604 641308 643851 585163 585240 585307 587278 589664 589694 591313 591823 592499 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.57%) |
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 545507 546843 546857 546887 549253 549358 549787 550357 551949 552495 554124 554245 554466 555356 555942 558508 559586 559855 560149 560174 561913 562049 562955 562975 563170 564309 565769 567130 567216 568096 571741 572226 572542 572543 572583 572647 573248 574630 577074 577697 578295 579166 579776 580449 584200 584507 584853 585163 585240 585307 585936 587274 587278 587801 588097 588629 588760 589664 589680 589694 590604 590705 590919 591052 591278 591288 591313 591514 591823 591859 592453 592499 592588 593046 593421 593506 596557 599010 599734 600609 600624 600645 602997 603302 603781 604619 604844 605904 606092 607303 610025 610049 613941 616461 616474 618333 618469 619470 620345 622170 622360 622462 624845 625221 626866 626891 630566 631264 631604 632072 636409 641308 643851 651192 660943 676508 680838 683787 684029 687468 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"классическая"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"классическ"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.67%) |
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.