Query Metrics
7
Database Queries
7
Different statements
193.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.31 ms (84.79%) |
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 11385 95943 341596 384524 388449 394754 395919 395970 398347 400126 400857 402378 404273 405000 405940 406646 406913 407650 409682 409886 411237 411547 411948 419524 419529 421070 421494 422504 423375 424411 424428 425048 425582 425799 426653 430072 430095 430839 431242 432869 435496 436933 443741 443773 443799 444141 446112 446629 447163 449886 451250 451826 454709 459141 462515 463773 464129 466262 466369 466915 467004 467025 469071 471406 471522 471628 472142 472235 474147 474661 477580 478546 479149 483141 483440 484559 484739 485037 488301 491790 496832 504386 504456 505691 514841 523335 531531 551579 552281 554513 563844 563865 569682 574235 589752 611616 621965 623476 633528 650793 665317 665448 665875 667196 667532 667859 667878 674378 682129 684265 688055 688575 694181 698284 752563 789690 789968 791361 815745 820529 ] |
||||||||||||||||||||||||||||||
|
18.03 ms (9.31%) |
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 400126 422504 815745 531531 665317 665448 667878 667196 667859 682129 665875 667532 674378 589752 623476 394754 491790 504386 563865 474147 423375 488301 504456 395919 11385 684265 694181 650793 633528 791361 395970 611616 471628 523335 384524 466915 462515 569682 405000 405940 409886 411948 436933 563844 446112 483440 496832 472235 752563 398347 406646 425799 407650 430072 451250 459141 789690 478546 479149 621965 471522 454709 820529 552281 789968 406913 411547 425048 421070 469071 477580 484739 505691 574235 443773 400857 432869 95943 471406 466262 467004 484559 411237 447163 451826 463773 449886 464129 467025 551579 688055 698284 404273 419524 419529 424428 425582 443741 466369 472142 421494 431242 443799 402378 435496 446629 688575 554513 409682 444141 430095 430839 474661 424411 426653 485037 483141 341596 388449 514841 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (1.79%) |
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 11385 95943 341596 384524 388449 394754 395919 395970 398347 400126 400857 402378 404273 405000 405940 406646 406913 407650 409682 409886 411237 411547 411948 419524 419529 421070 421494 422504 423375 424411 424428 425048 425582 425799 426653 430072 430095 430839 431242 432869 435496 436933 443741 443773 443799 444141 446112 446629 447163 449886 451250 451826 454709 459141 462515 463773 464129 466262 466369 466915 467004 467025 469071 471406 471522 471628 472142 472235 474147 474661 477580 478546 479149 483141 483440 484559 484739 485037 488301 491790 496832 504386 504456 505691 514841 523335 531531 551579 552281 554513 563844 563865 569682 574235 589752 611616 621965 623476 633528 650793 665317 665448 665875 667196 667532 667859 667878 674378 682129 684265 688055 688575 694181 698284 752563 789690 789968 791361 815745 820529 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young boy threesome"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young парен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young парен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.92%) |
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.