Query Metrics
7
Database Queries
7
Different statements
184.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.39 ms (88.15%) |
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 187990 382748 383780 386987 390738 395515 395518 395579 397210 397647 398555 399935 400739 404389 407602 407887 410844 411012 411833 411984 428053 431105 450104 450187 451495 453270 453272 454213 460672 462317 464293 465401 465542 466101 469365 469410 470610 470639 472638 474661 474685 474694 475837 476328 479127 480059 481282 482575 484557 484558 484750 485444 485948 490262 490523 490780 498730 499825 500458 500480 506047 509476 513118 515903 518545 520207 520743 529247 537845 537854 549240 555110 559065 563098 576594 581931 589629 614476 614519 614881 620240 652856 665254 665850 667319 667676 667886 669783 678775 680704 681312 705449 710250 712558 718570 720533 721377 721449 721463 722240 724052 726903 733315 736386 737372 740791 742729 744991 746460 761030 766647 815340 817886 818731 818973 820384 824023 824908 825274 826988 ] |
||||||||||||||||||||||||||||||
|
12.59 ms (6.83%) |
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 515903 520743 818973 400739 395515 395518 398555 410844 411012 815340 817886 465542 472638 490780 520207 614881 737372 740791 407887 397210 464293 529247 383780 460672 469365 669783 710250 705449 724052 761030 450104 382748 470610 563098 474661 474694 466101 474685 484557 490262 484558 826988 818731 824908 825274 576594 667886 746460 453270 453272 411984 509476 549240 390738 499825 665254 667319 559065 454213 428053 462317 498730 667676 589629 404389 479127 481282 537845 485948 742729 451495 386987 485444 506047 490523 513118 678775 726903 733315 397647 537854 581931 681312 652856 718570 720533 480059 484750 187990 399935 407602 475837 665850 712558 555110 620240 766647 465401 820384 824023 721377 721449 721463 680704 614476 614519 736386 744991 722240 395579 450187 476328 469410 470639 411833 431105 482575 500458 500480 518545 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.33%) |
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 187990 382748 383780 386987 390738 395515 395518 395579 397210 397647 398555 399935 400739 404389 407602 407887 410844 411012 411833 411984 428053 431105 450104 450187 451495 453270 453272 454213 460672 462317 464293 465401 465542 466101 469365 469410 470610 470639 472638 474661 474685 474694 475837 476328 479127 480059 481282 482575 484557 484558 484750 485444 485948 490262 490523 490780 498730 499825 500458 500480 506047 509476 513118 515903 518545 520207 520743 529247 537845 537854 549240 555110 559065 563098 576594 581931 589629 614476 614519 614881 620240 652856 665254 665850 667319 667676 667886 669783 678775 680704 681312 705449 710250 712558 718570 720533 721377 721449 721463 722240 724052 726903 733315 736386 737372 740791 742729 744991 746460 761030 766647 815340 817886 818731 818973 820384 824023 824908 825274 826988 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick mature"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член mature"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член mature"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.