Query Metrics
7
Database Queries
7
Different statements
209.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.26 ms (87.21%) |
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 91344 102086 117844 121555 160126 182285 233353 288045 382278 382821 386023 387281 388150 391493 392906 394598 395472 397529 398074 398384 400672 404470 405143 406881 409310 409680 411025 413391 415561 421093 422335 428223 428231 428956 441834 451337 455004 467601 469080 476142 480470 484457 491368 493715 498449 504144 505094 508292 510024 513846 514854 523201 529621 529626 531336 531787 532741 532826 532847 533544 534560 534567 538879 539023 539239 545428 545457 547058 547499 550917 564387 568264 576439 630798 633744 636958 639731 641562 651132 656826 662026 669386 672913 699397 722378 722380 734417 751437 752612 753614 755925 765260 766591 783425 787514 788107 788567 789529 789964 794977 799697 801975 809165 816167 816650 817011 817157 817300 817754 819545 819606 822969 824148 824247 827827 827828 827837 827851 827875 827949 ] |
||||||||||||||||||||||||||||||
|
16.60 ms (7.94%) |
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 734417 182285 391493 469080 387281 395472 398074 816167 508292 531787 547499 550917 630798 400672 827828 827851 493715 498449 576439 722378 656826 672913 751437 766591 809165 636958 523201 824247 827949 405143 819545 421093 160126 765260 441834 476142 455004 233353 564387 669386 722380 102086 788567 411025 532741 639731 752612 817157 819606 827827 817011 510024 533544 755925 406881 788107 539239 534567 545428 121555 633744 409310 491368 394598 415561 816650 817300 817754 641562 794977 799697 398384 404470 484457 532847 382278 789529 386023 428223 480470 532826 568264 513846 545457 91344 413391 824148 827875 539023 529621 783425 699397 382821 428231 451337 422335 467601 514854 534560 538879 662026 753614 547058 505094 801975 117844 288045 428956 409680 531336 787514 789964 504144 392906 388150 397529 822969 827837 529626 651132 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.27%) |
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 91344 102086 117844 121555 160126 182285 233353 288045 382278 382821 386023 387281 388150 391493 392906 394598 395472 397529 398074 398384 400672 404470 405143 406881 409310 409680 411025 413391 415561 421093 422335 428223 428231 428956 441834 451337 455004 467601 469080 476142 480470 484457 491368 493715 498449 504144 505094 508292 510024 513846 514854 523201 529621 529626 531336 531787 532741 532826 532847 533544 534560 534567 538879 539023 539239 545428 545457 547058 547499 550917 564387 568264 576439 630798 633744 636958 639731 641562 651132 656826 662026 669386 672913 699397 722378 722380 734417 751437 752612 753614 755925 765260 766591 783425 787514 788107 788567 789529 789964 794977 799697 801975 809165 816167 816650 817011 817157 817300 817754 819545 819606 822969 824148 824247 827827 827828 827837 827851 827875 827949 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme ass sex"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.