Query Metrics
7
Database Queries
7
Different statements
173.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.36 ms (85.73%) |
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 396609 400946 402078 412687 415961 416614 416626 418145 418661 422464 427292 427457 428723 429844 430366 432927 434293 442990 443242 446165 446600 447098 447392 447534 448570 448759 448854 450323 451552 457751 460804 461673 465128 466807 467872 467882 467893 481602 486510 486776 489676 491171 492168 494339 494617 497695 498483 500339 501237 503105 504781 505547 513655 517572 524062 524193 529034 530623 531078 536105 536292 536580 536641 536889 540944 542912 551440 551886 552699 555124 556882 557038 557243 559951 561015 561034 566736 567127 567775 568655 569457 571968 571999 577316 579539 579624 579935 579958 582802 587442 591143 592500 597997 599885 599956 600985 609890 622391 648859 651136 656913 664794 669030 669035 669038 669056 669075 671018 671045 671052 672939 672950 686106 686130 695868 695870 700291 700294 801906 827078 ] |
||||||||||||||||||||||||||||||
|
14.57 ms (8.42%) |
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 415961 447098 460804 498483 517572 529034 486510 489676 492168 427457 827078 448759 536105 466807 561034 669030 672939 686130 695868 669056 669075 669035 671018 671045 672950 686106 592500 599956 587442 412687 447392 428723 447534 402078 491171 500339 542912 559951 429844 443242 465128 457751 536580 536889 571968 579624 664794 579935 591143 801906 434293 467872 467882 467893 427292 450323 422464 557243 600985 446600 501237 396609 400946 416626 432927 418661 442990 555124 448854 446165 461673 486776 497695 503105 504781 524062 530623 536292 540944 567127 571999 577316 551440 551886 552699 568655 651136 648859 656913 700291 567775 569457 599885 609890 597997 622391 700294 481602 430366 416614 448570 418145 451552 494339 505547 513655 524193 531078 494617 566736 536641 582802 556882 669038 671052 695870 557038 561015 579539 579958 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.85%) |
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 396609 400946 402078 412687 415961 416614 416626 418145 418661 422464 427292 427457 428723 429844 430366 432927 434293 442990 443242 446165 446600 447098 447392 447534 448570 448759 448854 450323 451552 457751 460804 461673 465128 466807 467872 467882 467893 481602 486510 486776 489676 491171 492168 494339 494617 497695 498483 500339 501237 503105 504781 505547 513655 517572 524062 524193 529034 530623 531078 536105 536292 536580 536641 536889 540944 542912 551440 551886 552699 555124 556882 557038 557243 559951 561015 561034 566736 567127 567775 568655 569457 571968 571999 577316 579539 579624 579935 579958 582802 587442 591143 592500 597997 599885 599956 600985 609890 622391 648859 651136 656913 664794 669030 669035 669038 669056 669075 671018 671045 671052 672939 672950 686106 686130 695868 695870 700291 700294 801906 827078 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge tits skinny"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные сиськ худые"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные сиськ худые"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.78%) |
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.