Query Metrics
7
Database Queries
7
Different statements
163.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.14 ms (85.75%) |
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 88591 391371 391915 391917 408928 410962 414292 414306 414374 415878 416032 419613 439393 441160 443317 446949 449406 452274 452876 460196 464815 467903 467952 468238 470191 470198 477021 479095 482190 483732 483762 486810 490731 491103 493825 496337 497692 498228 502024 502885 508891 512933 513220 513977 514886 517810 519350 519358 521716 521831 522174 528608 530480 530503 531839 537861 546129 547468 547470 547475 547481 547482 547492 547854 555752 566777 569258 569749 583713 593495 594340 599906 602283 604781 613780 629602 632107 638477 642029 658819 660364 660369 660380 665958 669038 670356 670360 671008 672944 674087 680252 681295 713635 715475 720074 720140 742364 744795 749067 749271 752617 758790 760319 765721 776829 782148 784775 787512 788113 788360 788521 794371 796319 797326 803543 806822 807415 816382 825432 827396 ] |
||||||||||||||||||||||||||||||
|
14.20 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 665958 680252 776829 784775 797326 803543 749067 742364 744795 749271 752617 788521 806822 547475 660380 672944 660369 670356 670360 671008 502885 521831 681295 713635 467952 493825 464815 613780 88591 443317 531839 530503 414292 477021 513977 410962 569258 816382 566777 391917 414306 486810 502024 498228 468238 547492 555752 593495 519350 508891 530480 547481 604781 449406 482190 496337 513220 547482 547468 669038 760319 408928 416032 497692 483732 439393 460196 537861 583713 660364 720074 594340 642029 794371 765721 758790 391371 441160 827396 825432 569749 787512 807415 715475 782148 470198 796319 391915 483762 528608 632107 467903 479095 470191 519358 490731 517810 414374 415878 419613 452274 512933 514886 522174 547470 599906 446949 452876 491103 521716 547854 674087 658819 720140 546129 602283 629602 638477 788113 788360 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.45%) |
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 88591 391371 391915 391917 408928 410962 414292 414306 414374 415878 416032 419613 439393 441160 443317 446949 449406 452274 452876 460196 464815 467903 467952 468238 470191 470198 477021 479095 482190 483732 483762 486810 490731 491103 493825 496337 497692 498228 502024 502885 508891 512933 513220 513977 514886 517810 519350 519358 521716 521831 522174 528608 530480 530503 531839 537861 546129 547468 547470 547475 547481 547482 547492 547854 555752 566777 569258 569749 583713 593495 594340 599906 602283 604781 613780 629602 632107 638477 642029 658819 660364 660369 660380 665958 669038 670356 670360 671008 672944 674087 680252 681295 713635 715475 720074 720140 742364 744795 749067 749271 752617 758790 760319 765721 776829 782148 784775 787512 788113 788360 788521 794371 796319 797326 803543 806822 807415 816382 825432 827396 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo mature ass"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.91%) |
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.