Query Metrics
7
Database Queries
7
Different statements
210.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.92 ms (86.10%) |
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 381742 382437 383209 385882 390303 398531 409881 410958 411330 411350 411392 411398 453250 453448 453700 454187 454561 459131 460704 462099 462110 464547 466872 474122 474413 476334 476679 477719 477958 479049 483054 484447 484612 485286 486535 490189 491960 513834 514903 515815 516479 517069 518571 523835 524476 524779 526456 527075 528274 530143 531033 532471 533898 537263 539546 545694 549231 552285 555110 556519 557514 559059 561531 564818 565661 567407 567412 569976 570885 591048 602947 611520 614518 622794 663772 663898 665357 666093 666741 668529 696985 714911 725198 726491 726691 727022 733375 736099 743829 746685 748504 750773 758122 758509 759849 761027 766582 770129 772114 777420 781689 781901 781925 782194 782235 782259 788275 788959 789693 796957 803091 806311 807384 813085 819044 819754 820156 823705 824311 826197 ] |
||||||||||||||||||||||||||||||
|
18.31 ms (8.71%) |
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 474122 476679 483054 485286 530143 532471 513834 539546 514903 518571 462110 545694 549231 552285 556519 559059 557514 564818 567407 663898 666741 663772 665357 666093 714911 668529 696985 555110 567412 569976 611520 591048 622794 602947 614518 781689 782235 788275 807384 813085 777420 782194 788959 789693 796957 803091 725198 758509 772114 746685 748504 759849 766582 743829 726691 750773 770129 726491 727022 733375 736099 758122 761027 781901 781925 782259 806311 410958 453448 460704 477958 382437 383209 411330 454187 459131 464547 385882 390303 398531 409881 411398 453700 454561 462099 476334 477719 411392 453250 484612 491960 517069 537263 484447 486535 490189 515815 526456 528274 523835 524779 479049 466872 411350 381742 819754 824311 819044 826197 820156 823705 474413 524476 531033 533898 516479 527075 561531 565661 570885 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.60%) |
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 381742 382437 383209 385882 390303 398531 409881 410958 411330 411350 411392 411398 453250 453448 453700 454187 454561 459131 460704 462099 462110 464547 466872 474122 474413 476334 476679 477719 477958 479049 483054 484447 484612 485286 486535 490189 491960 513834 514903 515815 516479 517069 518571 523835 524476 524779 526456 527075 528274 530143 531033 532471 533898 537263 539546 545694 549231 552285 555110 556519 557514 559059 561531 564818 565661 567407 567412 569976 570885 591048 602947 611520 614518 622794 663772 663898 665357 666093 666741 668529 696985 714911 725198 726491 726691 727022 733375 736099 743829 746685 748504 750773 758122 758509 759849 761027 766582 770129 772114 777420 781689 781901 781925 782194 782235 782259 788275 788959 789693 796957 803091 806311 807384 813085 819044 819754 820156 823705 824311 826197 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature maid"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature горничн"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature горничн"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.79%) |
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.