Query Metrics
7
Database Queries
7
Different statements
177.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.87 ms (84.93%) |
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 7295 66768 74434 183634 187786 188129 188437 232945 232973 233135 233321 233556 233570 233608 233617 233683 311235 361315 365880 365908 386973 388261 388313 388322 388329 388766 389623 391237 391520 391659 391668 391967 392028 392031 392037 392054 392597 392599 392675 392679 394200 394211 395914 397850 397861 397885 397886 397902 397905 397911 398933 398935 398951 398958 398959 400832 400858 401000 403314 411345 411365 411372 411397 411408 411415 411419 411897 422288 428886 428904 443953 444124 451483 452187 454544 463156 466175 466768 468839 469587 478793 479051 479061 479105 480929 484634 490380 490883 490892 490902 490934 490936 491899 493106 511518 518846 520920 523830 526726 543535 546917 547605 555096 555137 561354 563191 563201 563207 567751 588693 721471 741724 770585 781689 782158 782235 785932 795990 803091 824909 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (9.85%) |
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 388766 233608 388329 188129 392031 311235 392679 183634 394200 188437 397885 398959 365880 397886 365908 463156 66768 397911 397861 232945 479105 411365 389623 785932 361315 392054 232973 398935 403314 392597 511518 391520 74434 391237 490883 411415 233617 563207 400858 233321 391967 490934 491899 392675 411372 411397 490936 411897 233683 391659 392028 395914 401000 484634 443953 588693 386973 411419 392599 388313 233556 782158 411408 567751 397850 452187 398951 428904 795990 518846 543535 398933 454544 394211 721471 493106 400832 741724 428886 824909 547605 187786 392037 398958 397902 444124 555096 782235 803091 490902 388261 490892 391668 411345 479061 469587 526726 466175 388322 233570 233135 7295 781689 770585 561354 563191 468839 451483 478793 422288 546917 563201 520920 555137 480929 523830 466768 479051 397905 490380 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.53%) |
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 7295 66768 74434 183634 187786 188129 188437 232945 232973 233135 233321 233556 233570 233608 233617 233683 311235 361315 365880 365908 386973 388261 388313 388322 388329 388766 389623 391237 391520 391659 391668 391967 392028 392031 392037 392054 392597 392599 392675 392679 394200 394211 395914 397850 397861 397885 397886 397902 397905 397911 398933 398935 398951 398958 398959 400832 400858 401000 403314 411345 411365 411372 411397 411408 411415 411419 411897 422288 428886 428904 443953 444124 451483 452187 454544 463156 466175 466768 468839 469587 478793 479051 479061 479105 480929 484634 490380 490883 490892 490902 490934 490936 491899 493106 511518 518846 520920 523830 526726 543535 546917 547605 555096 555137 561354 563191 563201 563207 567751 588693 721471 741724 770585 781689 782158 782235 785932 795990 803091 824909 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian stockings mature"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск чулк нижн бел mature"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск чулк нижн бел mature"
]
|
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.