Query Metrics
7
Database Queries
7
Different statements
192.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.00 ms (86.92%) |
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 16897 29367 89199 91458 285923 345851 382460 382955 389431 393531 396110 396408 397353 400035 401142 401306 401858 402659 403151 404216 404734 406404 407282 413112 413183 415191 417395 418058 418193 418690 419030 428586 429353 429384 431629 432304 437189 439169 443877 444841 451605 453081 459070 459484 461480 466690 468089 478464 478482 478740 479496 490076 492176 493223 494386 505324 510132 511357 512911 515441 520400 523645 531913 539126 556855 560630 561703 565164 570576 573651 574848 586546 590273 590334 594162 596350 600064 601524 604259 605791 610689 611857 630289 641946 644326 652910 653215 653229 653488 653505 653555 659408 682936 691567 697311 706331 712713 712718 721329 721428 722585 722890 738199 742197 744630 744942 751571 753841 754200 756081 760915 761482 777054 787448 797504 802539 810402 812343 821288 826180 ] |
||||||||||||||||||||||||||||||
|
16.32 ms (8.50%) |
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 644326 590334 630289 761482 760915 742197 744630 744942 756081 812343 397353 415191 432304 429353 403151 16897 29367 505324 418058 396110 413112 600064 605791 601524 466690 439169 417395 400035 490076 389431 826180 721329 653229 653488 691567 697311 653505 682936 712718 610689 590273 594162 604259 777054 753841 754200 751571 641946 401858 396408 407282 459070 556855 91458 401306 402659 429384 573651 596350 797504 810402 345851 382955 404734 413183 437189 419030 478740 461480 478482 510132 520400 523645 652910 787448 738199 802539 393531 285923 406404 611857 418690 428586 492176 561703 468089 404216 511357 512911 382460 401142 531913 570576 560630 586546 444841 453081 478464 479496 459484 494386 539126 451605 89199 418193 431629 443877 821288 493223 515441 565164 574848 706331 721428 722585 722890 659408 712713 653215 653555 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.31%) |
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 16897 29367 89199 91458 285923 345851 382460 382955 389431 393531 396110 396408 397353 400035 401142 401306 401858 402659 403151 404216 404734 406404 407282 413112 413183 415191 417395 418058 418193 418690 419030 428586 429353 429384 431629 432304 437189 439169 443877 444841 451605 453081 459070 459484 461480 466690 468089 478464 478482 478740 479496 490076 492176 493223 494386 505324 510132 511357 512911 515441 520400 523645 531913 539126 556855 560630 561703 565164 570576 573651 574848 586546 590273 590334 594162 596350 600064 601524 604259 605791 610689 611857 630289 641946 644326 652910 653215 653229 653488 653505 653555 659408 682936 691567 697311 706331 712713 712718 721329 721428 722585 722890 738199 742197 744630 744942 751571 753841 754200 756081 760915 761482 777054 787448 797504 802539 810402 812343 821288 826180 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал красивая"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.