Query Metrics
7
Database Queries
7
Different statements
159.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.00 ms (82.23%) |
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 53992 145646 319463 383224 387215 389945 393572 396670 398769 400438 400854 401479 402009 403556 406071 408354 410150 411627 411727 411769 411946 413233 413268 417655 419836 421360 422503 422548 423023 423266 426406 427368 428113 431776 443513 443664 443673 443719 443953 443970 446886 447257 447837 449078 451725 452441 456400 462579 462709 463954 464097 464278 468927 472847 473073 474409 476237 477980 482247 482805 484447 484648 485691 486275 486314 487927 487931 490193 490881 503917 503924 505501 516076 523442 526027 545167 549245 551982 556490 560372 561731 566046 571210 581664 581688 581696 586628 586631 614519 663381 663391 663956 665288 665518 665835 667615 667859 668848 675537 679826 685004 695283 716487 718550 724762 726859 732203 739955 758429 776008 781659 794699 806311 807431 808167 815543 816541 820388 821365 824406 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (11.03%) |
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 776008 806311 808167 53992 319463 413268 443719 417655 477980 400438 419836 456400 462579 443673 503917 484447 505501 526027 452441 571210 581696 685004 468927 545167 726859 724762 739955 411769 516076 486314 551982 566046 462709 411946 485691 586628 145646 383224 387215 464278 490881 560372 408354 482247 716487 663391 668848 665835 667615 695283 614519 794699 807431 758429 732203 718550 781659 423023 426406 411627 464097 473073 581688 561731 581664 443953 396670 423266 486275 523442 389945 411727 503924 406071 490193 443513 487931 449078 476237 487927 447837 556490 665288 663381 667859 398769 484648 549245 663956 675537 679826 586631 665518 463954 393572 400854 402009 401479 403556 422548 410150 421360 431776 413233 428113 443664 422503 427368 443970 820388 824406 816541 815543 821365 482805 446886 447257 451725 472847 474409 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.95%) |
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 53992 145646 319463 383224 387215 389945 393572 396670 398769 400438 400854 401479 402009 403556 406071 408354 410150 411627 411727 411769 411946 413233 413268 417655 419836 421360 422503 422548 423023 423266 426406 427368 428113 431776 443513 443664 443673 443719 443953 443970 446886 447257 447837 449078 451725 452441 456400 462579 462709 463954 464097 464278 468927 472847 473073 474409 476237 477980 482247 482805 484447 484648 485691 486275 486314 487927 487931 490193 490881 503917 503924 505501 516076 523442 526027 545167 549245 551982 556490 560372 561731 566046 571210 581664 581688 581696 586628 586631 614519 663381 663391 663956 665288 665518 665835 667615 667859 668848 675537 679826 685004 695283 716487 718550 724762 726859 732203 739955 758429 776008 781659 794699 806311 807431 808167 815543 816541 820388 821365 824406 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young hairy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young волосатая"
]
|
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.