Query Metrics
7
Database Queries
7
Different statements
204.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.15 ms (87.94%) |
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 12102 16663 81521 81526 107311 108054 136203 301259 339374 339467 345303 382130 382877 384302 385655 386238 388802 389236 389258 390625 391347 404181 404382 408371 430416 430460 462925 465458 471145 473372 489015 498919 508519 508539 509728 510622 511631 516167 516669 521103 521152 527236 531040 532176 536120 537380 542425 543327 547681 551668 552807 552846 555726 556470 558837 559647 561181 562474 563270 563379 566232 569265 569526 572195 572211 572290 572874 573411 575382 575871 581107 581139 581549 583263 584387 584529 585227 589331 591385 591796 592619 594846 596641 602697 603517 604856 607277 610147 610712 619455 621957 624383 624805 627925 628571 631072 631382 635001 639009 640356 643641 655456 655462 667257 667912 682668 710817 739587 751915 778136 778855 778985 783060 787202 793276 793456 793756 799908 802608 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (7.45%) |
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 572211 563379 575871 566232 655456 655462 552846 557804 572195 573411 607277 639009 592619 604856 610147 640356 594846 619455 81521 384302 339374 532176 547681 584387 552807 581549 627925 628571 787202 799908 107311 388802 389236 385655 108054 390625 404181 531040 581107 563270 596641 621957 793756 778985 793456 739587 631072 778855 339467 408371 345303 404382 430416 510622 521103 516669 508519 508539 509728 498919 511631 521152 473372 489015 542425 556470 569526 572290 591385 624805 610712 602697 471145 386238 382877 136203 301259 382130 16663 12102 81526 389258 391347 430460 462925 516167 527236 536120 537380 465458 543327 561181 572874 551668 559647 583263 555726 558837 562474 575382 710817 667257 682668 667912 569265 581139 584529 635001 589331 591796 603517 624383 643641 585227 631382 778136 783060 802608 793276 751915 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.56%) |
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 12102 16663 81521 81526 107311 108054 136203 301259 339374 339467 345303 382130 382877 384302 385655 386238 388802 389236 389258 390625 391347 404181 404382 408371 430416 430460 462925 465458 471145 473372 489015 498919 508519 508539 509728 510622 511631 516167 516669 521103 521152 527236 531040 532176 536120 537380 542425 543327 547681 551668 552807 552846 555726 556470 558837 559647 561181 562474 563270 563379 566232 569265 569526 572195 572211 572290 572874 573411 575382 575871 581107 581139 581549 583263 584387 584529 585227 589331 591385 591796 592619 594846 596641 602697 603517 604856 607277 610147 610712 619455 621957 624383 624805 627925 628571 631072 631382 635001 639009 640356 643641 655456 655462 667257 667912 682668 710817 739587 751915 778136 778855 778985 783060 787202 793276 793456 793756 799908 802608 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с лицом"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиц"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиц"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.