Query Metrics
7
Database Queries
7
Different statements
151.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.98 ms (79.78%) |
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 61707 153376 275727 324568 383477 384098 385596 386759 387831 387886 388069 389819 390467 396379 398567 401678 406045 410993 453316 454390 455065 465653 476290 496315 496720 512541 517605 519626 526204 526214 526264 527420 527919 529740 536309 537842 540086 543714 546471 560123 564281 583352 588939 589592 603407 618674 620330 644905 660061 663445 663871 664810 665038 665260 665833 666152 666778 667279 667541 667640 667682 667752 667754 667974 668895 669457 705788 719915 732986 733038 736097 742618 752065 752495 757547 771480 774410 775436 776402 781803 781805 781809 781811 781818 781833 781837 781863 781897 781906 781911 781967 781977 782015 794828 794863 795101 797335 797341 804951 805868 808071 811991 813805 813812 815369 817870 819331 819354 819635 821761 824356 824441 824688 825161 825384 825405 827197 827506 827627 ] |
||||||||||||||||||||||||||||||
|
19.83 ms (13.08%) |
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 705788 752495 275727 618674 476290 666778 797341 527919 383477 819354 825384 819331 543714 526204 526264 512541 526214 589592 385596 388069 387831 813805 588939 752065 410993 819635 774410 827197 827627 824356 517605 564281 660061 667269 667754 719915 667640 667974 665260 667682 781803 781805 808071 781977 804951 781897 733038 757547 771480 781906 781967 794863 603407 324568 384098 813812 825161 496720 663445 781809 620330 454390 386759 61707 401678 667752 666152 781818 776402 527420 153376 387886 817870 644905 827506 825405 519626 537842 546471 583352 665038 663871 665833 667279 668895 667541 669457 781863 781911 781837 736097 781811 781833 732986 742618 797335 805868 811991 390467 406045 529740 536309 794828 795101 775436 560123 389819 465653 496315 782015 396379 453316 398567 824688 821761 824441 815369 455065 540086 664810 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.96%) |
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 61707 153376 275727 324568 383477 384098 385596 386759 387831 387886 388069 389819 390467 396379 398567 401678 406045 410993 453316 454390 455065 465653 476290 496315 496720 512541 517605 519626 526204 526214 526264 527420 527919 529740 536309 537842 540086 543714 546471 560123 564281 583352 588939 589592 603407 618674 620330 644905 660061 663445 663871 664810 665038 665260 665833 666152 666778 667279 667541 667640 667682 667752 667754 667974 668895 669457 705788 719915 732986 733038 736097 742618 752065 752495 757547 771480 774410 775436 776402 781803 781805 781809 781811 781818 781833 781837 781863 781897 781906 781911 781967 781977 782015 794828 794863 795101 797335 797341 804951 805868 808071 811991 813805 813812 815369 817870 819331 819354 819635 821761 824356 824441 824688 825161 825384 825405 827197 827506 827627 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass chubby bbw"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп chubby bbw"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп chubby bbw"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
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.