Query Metrics
7
Database Queries
7
Different statements
182.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.99 ms (87.18%) |
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 6858 181184 233443 365992 382132 386662 389116 390805 393550 396127 396159 396211 397856 401594 401975 402222 429946 447101 453901 457406 461424 476742 481298 531285 533779 536236 595423 595440 597560 598013 598474 598695 605730 624161 626880 652927 653533 654409 655069 657291 675041 680391 683242 695093 696297 705106 707164 713300 715020 716992 720641 721322 724240 725167 725948 730623 739913 740085 742846 743025 743051 746067 747164 747435 747709 753472 754207 754228 754584 754630 755677 755739 760935 766173 766479 766505 766712 766785 766796 766802 766806 766839 768867 769052 769833 770319 770435 771889 773599 773644 777021 777041 777551 778900 779741 780061 781358 781412 782674 783618 786372 786765 787484 788198 788351 789308 790531 792953 799998 801285 804320 805722 806332 813093 820385 821116 823740 826674 827429 828626 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (7.37%) |
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 771889 389116 597560 396211 598695 476742 453901 787484 396127 654409 605730 789308 801285 755739 755677 766173 766796 747164 753472 770319 766479 769052 768867 779741 806332 813093 386662 531285 695093 720641 397856 457406 598013 826674 823740 827429 683242 652927 715020 790531 747709 754584 766785 777021 401594 396159 365992 233443 429946 481298 181184 536236 653533 657291 675041 696297 655069 624161 780061 804320 754630 781358 766505 766806 770435 754228 725948 401975 743051 743025 828626 821116 680391 705106 707164 626880 788351 782674 754207 773644 781412 786372 792953 742846 766712 739913 724240 773599 716992 783618 6858 533779 713300 598474 595440 595423 725167 740085 461424 820385 721322 777041 730623 746067 786765 805722 747435 760935 766802 766839 769833 777551 778900 788198 799998 382132 390805 447101 393550 402222 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.61%) |
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 6858 181184 233443 365992 382132 386662 389116 390805 393550 396127 396159 396211 397856 401594 401975 402222 429946 447101 453901 457406 461424 476742 481298 531285 533779 536236 595423 595440 597560 598013 598474 598695 605730 624161 626880 652927 653533 654409 655069 657291 675041 680391 683242 695093 696297 705106 707164 713300 715020 716992 720641 721322 724240 725167 725948 730623 739913 740085 742846 743025 743051 746067 747164 747435 747709 753472 754207 754228 754584 754630 755677 755739 760935 766173 766479 766505 766712 766785 766796 766802 766806 766839 768867 769052 769833 770319 770435 771889 773599 773644 777021 777041 777551 778900 779741 780061 781358 781412 782674 783618 786372 786765 787484 788198 788351 789308 790531 792953 799998 801285 804320 805722 806332 813093 820385 821116 823740 826674 827429 828626 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русский анальный секс…"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.78%) |
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.