Query Metrics
7
Database Queries
7
Different statements
175.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.58 ms (84.64%) |
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 383324 384900 387160 388886 390875 392760 395269 395410 396368 399628 402030 403966 409084 409403 418954 420383 425034 425594 443793 444223 444778 450825 453338 453670 457331 459161 462365 462541 470945 471371 474030 474551 475907 476714 477393 479750 482136 482782 486699 486805 487005 489447 489991 492641 501250 506764 507901 509847 517794 518740 519270 521904 521976 533628 533772 534080 540896 543851 549859 551044 552694 562369 578370 580824 595729 603110 603211 603248 606570 621323 622199 622245 630861 634477 643725 644264 645948 650114 653756 668527 669391 675236 676342 676895 679444 681087 694485 703538 708823 710216 710396 712649 720939 725612 731682 739208 743817 746079 746852 756092 756104 756398 756766 776020 776339 780701 784908 789981 790029 798948 802791 803344 804468 804478 808229 817446 818470 821316 822642 822696 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (8.69%) |
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 645948 694485 720939 622245 606570 630861 789981 804478 756104 739208 725612 756766 731682 743817 790029 387160 603110 409084 622199 808229 462365 392760 388886 399628 420383 817446 822696 821316 818470 822642 479750 518740 474551 669391 679444 676342 675236 676895 681087 703538 708823 710216 644264 634477 643725 746079 756092 621323 396368 477393 425594 487005 552694 476714 453338 489991 474030 486805 459161 519270 533628 506764 482136 549859 551044 650114 562369 580824 595729 776339 784908 798948 802791 803344 804468 710396 475907 418954 450825 509847 521904 492641 501250 383324 384900 402030 409403 444778 482782 533772 534080 471371 489447 543851 603211 403966 462541 521976 578370 776020 712649 780701 390875 540896 486699 668527 395269 395410 425034 517794 507901 756398 443793 470945 457331 603248 746852 653756 444223 453670 ] |
||||||||||||||||||||||||||||||
|
4.39 ms (2.50%) |
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 383324 384900 387160 388886 390875 392760 395269 395410 396368 399628 402030 403966 409084 409403 418954 420383 425034 425594 443793 444223 444778 450825 453338 453670 457331 459161 462365 462541 470945 471371 474030 474551 475907 476714 477393 479750 482136 482782 486699 486805 487005 489447 489991 492641 501250 506764 507901 509847 517794 518740 519270 521904 521976 533628 533772 534080 540896 543851 549859 551044 552694 562369 578370 580824 595729 603110 603211 603248 606570 621323 622199 622245 630861 634477 643725 644264 645948 650114 653756 668527 669391 675236 676342 676895 679444 681087 694485 703538 708823 710216 710396 712649 720939 725612 731682 739208 743817 746079 746852 756092 756104 756398 756766 776020 776339 780701 784908 789981 790029 798948 802791 803344 804468 804478 808229 817446 818470 821316 822642 822696 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ group"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ group"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits group"
]
|
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.