Query Metrics
7
Database Queries
7
Different statements
154.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.44 ms (84.58%) |
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 6699 191748 390041 390255 391868 397406 398368 413112 420384 429519 434609 443056 443602 444195 447788 448794 450179 450473 450639 451742 452226 453036 453142 456743 458287 458401 460324 463026 463758 463770 464418 470128 472677 475930 479314 481319 484468 486201 487842 488771 489446 491472 494703 494997 497386 497974 499368 502907 509862 511019 512860 514662 516144 516452 519110 520735 521765 522152 522366 522412 522675 524618 525192 525576 525703 525778 525810 525811 527607 529708 531412 533983 535297 536690 537192 540089 540115 540274 541530 551457 554782 559150 561312 561698 579531 593168 597169 601866 604596 611336 618842 619169 626735 643653 650018 650206 662009 670114 675795 680172 709288 710316 711275 720739 737720 741889 744845 759482 766469 771805 775926 793114 797884 799549 804502 806674 813453 821838 826859 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (9.59%) |
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 390041 420384 429519 443602 413112 448794 451742 452226 458287 512860 522675 499368 520735 521765 525810 529708 511019 554782 675795 680172 662009 720739 561312 561698 579531 597169 643653 626735 434609 191748 509862 491472 522412 525703 453036 525576 516452 618842 741889 799549 464418 535297 479314 759482 804502 494703 524618 502907 444195 443056 821838 447788 484468 470128 489446 533983 536690 494997 537192 540115 531412 519110 527607 463770 559150 541530 650018 650206 551457 619169 601866 611336 793114 766469 604596 391868 398368 450473 463758 525811 497386 453142 488771 390255 475930 397406 481319 525192 711275 775926 593168 463026 522152 670114 6699 540089 450179 487842 826859 486201 458401 472677 525778 516144 522366 540274 514662 710316 709288 797884 813453 737720 806674 744845 771805 774965 450639 456743 460324 497974 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.51%) |
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 6699 191748 390041 390255 391868 397406 398368 413112 420384 429519 434609 443056 443602 444195 447788 448794 450179 450473 450639 451742 452226 453036 453142 456743 458287 458401 460324 463026 463758 463770 464418 470128 472677 475930 479314 481319 484468 486201 487842 488771 489446 491472 494703 494997 497386 497974 499368 502907 509862 511019 512860 514662 516144 516452 519110 520735 521765 522152 522366 522412 522675 524618 525192 525576 525703 525778 525810 525811 527607 529708 531412 533983 535297 536690 537192 540089 540115 540274 541530 551457 554782 559150 561312 561698 579531 593168 597169 601866 604596 611336 618842 619169 626735 643653 650018 650206 662009 670114 675795 680172 709288 710316 711275 720739 737720 741889 744845 759482 766469 771805 775926 793114 797884 799549 804502 806674 813453 821838 826859 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"humiliation blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.91%) |
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.