Query Metrics
7
Database Queries
7
Different statements
185.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.74 ms (84.09%) |
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 187954 310671 365924 379600 382748 388322 388722 390045 390252 392213 392750 398209 398954 403324 403924 406899 407819 408318 409934 411345 411352 411397 411720 411745 414601 422298 439752 440312 441124 444113 444145 450143 450286 451937 452234 452940 453313 454247 457515 458000 460175 460746 460757 460906 464138 465592 465834 466206 466318 466801 467050 467279 467469 467484 469106 469355 469372 469575 470158 470610 471078 471417 471975 474080 474113 475842 476224 476279 476284 477070 477961 478378 479073 479100 479102 479103 479145 480851 481881 482525 483655 484160 484413 484564 484686 485971 487338 488959 490197 491989 495881 502929 505089 508451 514445 515841 515910 516227 516470 516483 516562 525489 525695 526745 526832 533607 546715 555274 563066 563173 569943 580340 590347 591977 620098 665446 726522 751627 815095 827098 ] |
||||||||||||||||||||||||||||||
|
18.19 ms (9.82%) |
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 477070 485971 525489 476279 555274 390252 392213 411720 480851 467050 471975 411397 471078 310671 382748 388322 440312 444113 466318 470610 525695 484413 505089 827098 726522 187954 390045 398209 403924 406899 411745 407819 409934 451937 452234 467484 476224 464138 471417 465592 466801 475842 533607 460175 469575 474080 563066 563173 569943 546715 591977 411352 457515 479102 411345 439752 452940 454247 460906 467279 476284 403324 460757 467469 469372 474113 477961 479145 379600 388722 444145 458000 465834 466206 479073 479100 479103 450286 470158 478378 516470 516562 483655 526745 526832 484564 487338 488959 490197 491989 502929 516483 484686 514445 515841 515910 392750 441124 422298 815095 450143 495881 484160 665446 590347 751627 469106 398954 365924 408318 414601 460746 482525 580340 620098 453313 469355 481881 508451 516227 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.75%) |
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 187954 310671 365924 379600 382748 388322 388722 390045 390252 392213 392750 398209 398954 403324 403924 406899 407819 408318 409934 411345 411352 411397 411720 411745 414601 422298 439752 440312 441124 444113 444145 450143 450286 451937 452234 452940 453313 454247 457515 458000 460175 460746 460757 460906 464138 465592 465834 466206 466318 466801 467050 467279 467469 467484 469106 469355 469372 469575 470158 470610 471078 471417 471975 474080 474113 475842 476224 476279 476284 477070 477961 478378 479073 479100 479102 479103 479145 480851 481881 482525 483655 484160 484413 484564 484686 485971 487338 488959 490197 491989 495881 502929 505089 508451 514445 515841 515910 516227 516470 516483 516562 525489 525695 526745 526832 533607 546715 555274 563066 563173 569943 580340 590347 591977 620098 665446 726522 751627 815095 827098 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature женскийрод"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature bitch"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.95%) |
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.