Query Metrics
7
Database Queries
7
Different statements
153.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.75 ms (78.67%) |
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 117687 325984 382467 385713 398097 400614 414067 414259 414268 414318 416580 416581 416681 416694 416712 419081 423434 425134 427950 428595 432576 432944 433343 436132 442039 446479 447998 456190 456232 461735 462384 464188 465468 466732 467577 468949 471330 473127 473145 482283 483737 484816 485918 493677 496149 500100 500960 503167 505093 513313 513495 513578 515419 541275 543256 544025 544538 545453 545697 548642 548902 550079 551421 552591 554700 554858 555804 556406 557109 558126 558359 559675 559868 560599 560940 560945 560953 565174 565935 566297 566570 574223 578114 580772 581565 584137 587260 587993 590444 595490 604105 613572 631716 638198 668370 670453 670826 678817 709705 717690 725379 732301 735126 735450 743227 758986 759050 760019 776909 787259 787813 788213 788331 794334 800235 803135 804386 805776 805841 813712 ] |
||||||||||||||||||||||||||||||
|
23.02 ms (15.00%) |
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 668370 732301 117687 432576 473145 503167 670826 513495 758986 544025 414318 559675 574223 584137 678817 631716 735450 787259 725379 794334 800235 473127 467577 557109 560599 496149 580772 813712 670453 613572 805841 804386 743227 416712 416681 483737 565174 513578 427950 485918 595490 548642 638198 382467 505093 515419 555804 587260 493677 461735 776909 760019 513313 442039 447998 709705 325984 788213 805776 560940 558126 425134 541275 428595 500100 545697 545453 419081 552591 446479 554858 565935 466732 559868 414067 432944 465468 456190 484816 544538 554700 548902 566570 578114 787813 788331 735126 759050 416580 468949 414259 416581 556406 416694 456232 560945 436132 482283 464188 385713 581565 587993 433343 500960 717690 566297 423434 550079 558359 398097 400614 560953 803135 604105 590444 543256 551421 414268 471330 462384 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.79%) |
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 117687 325984 382467 385713 398097 400614 414067 414259 414268 414318 416580 416581 416681 416694 416712 419081 423434 425134 427950 428595 432576 432944 433343 436132 442039 446479 447998 456190 456232 461735 462384 464188 465468 466732 467577 468949 471330 473127 473145 482283 483737 484816 485918 493677 496149 500100 500960 503167 505093 513313 513495 513578 515419 541275 543256 544025 544538 545453 545697 548642 548902 550079 551421 552591 554700 554858 555804 556406 557109 558126 558359 559675 559868 560599 560940 560945 560953 565174 565935 566297 566570 574223 578114 580772 581565 584137 587260 587993 590444 595490 604105 613572 631716 638198 668370 670453 670826 678817 709705 717690 725379 732301 735126 735450 743227 758986 759050 760019 776909 787259 787813 788213 788331 794334 800235 803135 804386 805776 805841 813712 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодежь в три дырки"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые молодая девушк молодой в дырк"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.02%) |
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.