Query Metrics
7
Database Queries
7
Different statements
395.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
369.63 ms (93.42%) |
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 75896 97290 382202 389208 399609 403592 409180 449021 502487 612053 712696 806220 815180 815191 815195 815229 815236 815238 815242 815254 815256 815288 815306 815311 815340 815343 815363 815365 815372 815389 815403 815409 815441 815452 815454 815459 815462 815469 815472 815481 815496 815502 815509 815518 815519 815523 815531 815539 815573 815579 815625 815629 815653 815671 815676 815677 815678 815683 815696 815715 815726 815729 815749 815771 815774 815777 815785 815787 815791 815797 815804 815814 815874 815890 815899 815905 815912 815913 815914 815941 815958 815962 815965 815973 815980 815993 815998 816030 816035 816066 816069 816074 816080 816083 816330 816367 816384 816405 816419 816508 816510 816538 816539 816542 816544 816554 816583 816586 816876 816886 816892 816893 816894 816916 816932 816934 816970 820120 820667 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (3.58%) |
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 815726 815993 816074 816367 815941 612053 449021 389208 502487 816384 815180 815340 815288 815678 815715 815913 816080 816542 816886 815469 815749 815771 816894 815256 815653 815890 820120 815523 816538 816934 815625 815791 815914 816330 815403 815579 815787 815874 816554 97290 815229 816586 712696 75896 816419 815236 815774 816030 816892 815238 815242 815496 815962 820667 815519 815777 815454 816405 815629 815696 815182 815254 815372 815452 815502 815539 815677 816066 816539 816583 816916 816932 815343 815804 815998 816510 815441 815306 815472 399609 815814 815531 815797 816876 816893 815389 815980 815365 382202 403592 409180 815311 815363 815409 815481 815683 815785 816069 815191 816035 816083 816970 816508 816544 815958 815965 806220 815462 815671 815459 815509 815518 815573 815676 815729 815899 815905 815912 815973 815195 ] |
||||||||||||||||||||||||||||||
|
3.81 ms (0.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 75896 97290 382202 389208 399609 403592 409180 449021 502487 612053 712696 806220 815180 815191 815195 815229 815236 815238 815242 815254 815256 815288 815306 815311 815340 815343 815363 815365 815372 815389 815403 815409 815441 815452 815454 815459 815462 815469 815472 815481 815496 815502 815509 815518 815519 815523 815531 815539 815573 815579 815625 815629 815653 815671 815676 815677 815678 815683 815696 815715 815726 815729 815749 815771 815774 815777 815785 815787 815791 815797 815804 815814 815874 815890 815899 815905 815912 815913 815914 815941 815958 815962 815965 815973 815980 815993 815998 816030 816035 816066 816069 816074 816080 816083 816330 816367 816384 816405 816419 816508 816510 816538 816539 816542 816544 816554 816583 816586 816876 816886 816892 816893 816894 816916 816932 816934 816970 820120 820667 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers big boobs"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers большие boobs"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers большие boobs"
]
|
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.