Query Metrics
7
Database Queries
7
Different statements
153.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.87 ms (82.42%) |
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 14700 80332 382681 389966 404731 405191 412984 415755 418886 429888 430792 439521 440863 441853 443095 453112 455088 455886 457003 466869 473750 476046 476900 478510 479821 480406 480470 485638 485646 488753 491914 494231 501258 503113 504450 506516 512781 514243 517633 519246 519299 522343 522795 527409 528293 528862 529609 529648 531262 531871 531882 533380 533460 536576 542203 544163 545294 547466 547478 548834 550680 550896 552664 555297 555394 555567 560211 564222 564551 573734 575300 589058 600017 601357 603772 604361 604418 620260 628518 639710 641126 671487 672383 673503 681746 688666 689001 695879 710814 711998 715894 725475 736674 741067 742636 750301 760313 761711 766588 770963 778882 786174 788173 789496 789950 790515 790926 791803 791812 792142 792541 794124 804528 804674 806180 812988 813581 815370 818456 825514 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (9.70%) |
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 531871 542203 671487 695879 812988 794124 710814 778882 725475 689001 476046 415755 519246 501258 786174 791812 760313 790515 715894 789496 736674 792541 560211 552664 441853 555567 439521 418886 429888 813581 825514 488753 529648 533460 517633 529609 531882 545294 550896 548834 564222 673503 681746 628518 603772 604418 620260 589058 790926 792142 741067 766588 789950 804528 770963 761711 804674 806180 641126 564551 750301 604361 550680 742636 528862 791803 405191 430792 485638 455088 480406 491914 503113 522795 527409 466869 80332 506516 531262 533380 555297 672383 688666 473750 514243 494231 440863 457003 815370 818456 480470 453112 478510 512781 536576 547466 547478 573734 555394 575300 711998 601357 600017 639710 519299 528293 788173 522343 504450 14700 455886 479821 485646 476900 382681 389966 404731 412984 443095 544163 ] |
||||||||||||||||||||||||||||||
|
4.36 ms (2.84%) |
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 14700 80332 382681 389966 404731 405191 412984 415755 418886 429888 430792 439521 440863 441853 443095 453112 455088 455886 457003 466869 473750 476046 476900 478510 479821 480406 480470 485638 485646 488753 491914 494231 501258 503113 504450 506516 512781 514243 517633 519246 519299 522343 522795 527409 528293 528862 529609 529648 531262 531871 531882 533380 533460 536576 542203 544163 545294 547466 547478 548834 550680 550896 552664 555297 555394 555567 560211 564222 564551 573734 575300 589058 600017 601357 603772 604361 604418 620260 628518 639710 641126 671487 672383 673503 681746 688666 689001 695879 710814 711998 715894 725475 736674 741067 742636 750301 760313 761711 766588 770963 778882 786174 788173 789496 789950 790515 790926 791803 791812 792142 792541 794124 804528 804674 806180 812988 813581 815370 818456 825514 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелую в анал с игрушками"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин анал игрушк"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"зрелая женщин анал игрушк"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.20%) |
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.