Query Metrics
7
Database Queries
7
Different statements
141.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.46 ms (84.60%) |
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 73289 91248 351182 382249 384337 386531 387664 388685 391380 395236 395984 396101 397300 398270 401646 409942 419668 425022 429042 444158 457459 457472 459382 459866 460770 470118 471475 474579 484638 491286 493986 496818 500674 514386 547220 547417 566871 568929 578734 582514 585998 596198 598723 604309 605328 605886 620246 640537 643516 645912 649585 669298 671597 690346 690517 694324 695631 696522 698704 699400 701850 702633 706254 717066 718755 719002 719431 719898 720682 722609 725176 726923 727689 727798 728432 731595 732000 739934 742461 743378 747576 748973 752717 756106 756418 758991 758997 760192 760971 765441 766688 766812 769829 769892 778347 784277 789253 790203 790857 793677 797428 799815 799981 805996 811148 811946 812076 813377 813553 813947 818209 818531 818867 820899 820921 821197 821937 823136 827592 ] |
||||||||||||||||||||||||||||||
|
12.11 ms (8.58%) |
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 474579 769829 568929 598723 457459 457472 459382 514386 491286 813947 820921 821937 547417 695631 699400 702633 649585 696522 690517 719431 585998 643516 797428 731595 747576 765441 727798 748973 756418 758991 728432 769892 727689 732000 743378 766812 756106 760971 640537 718755 382249 395236 827592 818209 818531 566871 719002 722609 671597 694324 690346 547220 605886 596198 812076 760192 766688 811946 725176 770352 739934 758997 742461 701850 717066 778347 790203 790857 793677 799981 419668 789253 386531 91248 387664 429042 459866 493986 388685 397300 460770 578734 719898 726923 813377 391380 484638 500674 706254 669298 401646 384337 398270 720682 799815 811148 752717 470118 582514 605328 396101 620246 425022 821197 823136 698704 604309 784277 351182 444158 813553 805996 471475 395984 496818 73289 409942 818867 820899 645912 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (2.03%) |
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 73289 91248 351182 382249 384337 386531 387664 388685 391380 395236 395984 396101 397300 398270 401646 409942 419668 425022 429042 444158 457459 457472 459382 459866 460770 470118 471475 474579 484638 491286 493986 496818 500674 514386 547220 547417 566871 568929 578734 582514 585998 596198 598723 604309 605328 605886 620246 640537 643516 645912 649585 669298 671597 690346 690517 694324 695631 696522 698704 699400 701850 702633 706254 717066 718755 719002 719431 719898 720682 722609 725176 726923 727689 727798 728432 731595 732000 739934 742461 743378 747576 748973 752717 756106 756418 758991 758997 760192 760971 765441 766688 766812 769829 769892 778347 784277 789253 790203 790857 793677 797428 799815 799981 805996 811148 811946 812076 813377 813553 813947 818209 818531 818867 820899 820921 821197 821937 823136 827592 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебет типа в жопу"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.08%) |
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.