Query Metrics
7
Database Queries
7
Different statements
149.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.61 ms (83.10%) |
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 88274 136157 187643 387696 401849 404438 404532 409694 413070 414061 417599 420432 422103 423983 424026 426293 428911 431439 435549 442060 444952 446745 446926 447019 447021 448593 448596 450047 450273 450450 454360 457639 458932 464019 464618 465603 465624 466308 466654 468208 469177 475761 476053 476711 477436 478029 478109 492218 492814 493732 500070 517795 519532 520524 522167 528883 529382 533193 534353 541500 541519 551554 561494 574949 581774 585306 587510 590474 593897 596732 604422 607200 610024 611030 620178 620188 628623 629825 631395 631649 640952 644222 661326 664592 666682 669914 679957 696148 696497 708637 711773 736347 738633 741170 751361 751532 753951 754447 754546 755502 759080 760176 762208 765865 768057 768460 768591 780820 781909 783309 790647 798335 798467 799892 800744 802551 803684 812526 824787 827668 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (9.81%) |
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 620178 790647 798335 799892 736347 741170 753951 755502 783309 803684 768460 754546 738633 751532 765865 768591 751361 762208 629825 781909 800744 802551 423983 424026 475761 88274 435549 466308 401849 466654 404532 468208 477436 519532 492218 493732 431439 478029 476053 420432 444952 450450 469177 522167 492814 517795 446745 136157 187643 387696 404438 417599 413070 414061 426293 442060 422103 409694 428911 824787 827668 447021 448596 450047 446926 450273 454360 457639 458932 465624 478109 447019 448593 464618 465603 520524 528883 500070 529382 533193 534353 464019 476711 574949 541500 541519 551554 696497 708637 711773 664592 679957 661326 666682 669914 696148 561494 581774 585306 590474 593897 610024 628623 631395 640952 604422 631649 587510 596732 607200 611030 620188 644222 780820 798467 812526 754447 759080 760176 768057 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (2.00%) |
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 88274 136157 187643 387696 401849 404438 404532 409694 413070 414061 417599 420432 422103 423983 424026 426293 428911 431439 435549 442060 444952 446745 446926 447019 447021 448593 448596 450047 450273 450450 454360 457639 458932 464019 464618 465603 465624 466308 466654 468208 469177 475761 476053 476711 477436 478029 478109 492218 492814 493732 500070 517795 519532 520524 522167 528883 529382 533193 534353 541500 541519 551554 561494 574949 581774 585306 587510 590474 593897 596732 604422 607200 610024 611030 620178 620188 628623 629825 631395 631649 640952 644222 661326 664592 666682 669914 679957 696148 696497 708637 711773 736347 738633 741170 751361 751532 753951 754447 754546 755502 759080 760176 762208 765865 768057 768460 768591 780820 781909 783309 790647 798335 798467 799892 800744 802551 803684 812526 824787 827668 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"голые соло"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые соло"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
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.