Query Metrics
7
Database Queries
7
Different statements
170.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.26 ms (83.83%) |
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 187186 385158 389861 390041 391186 394446 395924 395926 397903 400487 400888 400990 400999 405417 407803 411165 411508 411682 411902 413303 439721 444145 450368 459949 460757 462082 462104 462110 463707 465387 466109 470017 471449 473229 474113 474480 474794 477961 479073 479078 479079 479098 479112 479115 482322 484452 484594 484598 484625 484626 484686 491114 491153 492062 513499 518868 559059 561453 565672 565731 574462 614832 619521 619536 619987 621196 621339 629847 667314 667560 668901 676432 680794 696312 709545 726468 726480 726484 726491 726503 726518 726520 726523 726527 726530 726531 726542 726552 726558 726561 726691 726702 726815 726873 726876 727022 731194 733251 740826 742811 742860 742873 748130 748337 750773 750782 763471 766582 766618 772318 781651 781727 794974 796115 796124 807332 807334 807337 807338 808690 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (9.26%) |
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 439721 466109 474480 479079 479098 460757 471449 474113 477961 479078 479115 444145 470017 479073 479112 482322 450368 484594 484625 492062 484598 484626 484686 491114 491153 513499 394446 405417 668901 667314 667560 400487 473229 413303 696312 748130 629847 385158 187186 395924 395926 389861 390041 391186 400888 407803 411508 411682 411902 459949 462082 463707 474794 465387 484452 518868 462104 462110 565672 559059 565731 574462 680794 676432 561453 619987 621339 619521 619536 621196 781651 781727 794974 796124 796115 807332 807334 807337 726503 726520 726523 726873 742873 763471 772318 726815 748337 750782 766582 766618 726468 726484 726527 726530 726531 726542 726552 726558 726561 726702 726876 726518 726691 733251 740826 742860 750773 726480 726491 727022 731194 742811 614832 709545 807338 808690 397903 400990 400999 411165 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.05%) |
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 187186 385158 389861 390041 391186 394446 395924 395926 397903 400487 400888 400990 400999 405417 407803 411165 411508 411682 411902 413303 439721 444145 450368 459949 460757 462082 462104 462110 463707 465387 466109 470017 471449 473229 474113 474480 474794 477961 479073 479078 479079 479098 479112 479115 482322 484452 484594 484598 484625 484626 484686 491114 491153 492062 513499 518868 559059 561453 565672 565731 574462 614832 619521 619536 619987 621196 621339 629847 667314 667560 668901 676432 680794 696312 709545 726468 726480 726484 726491 726503 726518 726520 726523 726527 726530 726531 726542 726552 726558 726561 726691 726702 726815 726873 726876 727022 731194 733251 740826 742811 742860 742873 748130 748337 750773 750782 763471 766582 766618 772318 781651 781727 794974 796115 796124 807332 807334 807337 807338 808690 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old mature жен"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old mature жен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mature wife"
]
|
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.