Query Metrics
7
Database Queries
7
Different statements
156.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.79 ms (80.32%) |
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 305328 382202 389208 399609 403592 409180 449021 502487 612053 712696 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 815554 815573 815579 815625 815629 815653 815671 815676 815677 815678 815683 815696 815715 815721 815726 815729 815749 815768 815771 815774 815777 815785 815787 815791 815797 815804 815814 815874 815890 815899 815905 815912 815913 815914 815962 815973 815993 815998 816030 816035 816055 816066 816069 816074 816080 816083 816330 816336 816367 816405 816419 816508 816510 816538 816539 816542 816544 816554 816583 816586 816876 816886 816892 816893 816894 816916 816932 816934 816970 820120 820667 ] |
||||||||||||||||||||||||||||||
|
21.83 ms (13.94%) |
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 815554 815726 815993 816074 816336 816367 449021 612053 389208 502487 815340 815256 97290 815180 815288 815653 815678 815715 815890 820120 815229 815523 815913 816538 816934 815625 815791 815914 816080 816330 816542 816586 816886 815403 815469 815579 815749 815771 815787 815874 816554 816894 712696 815454 816405 75896 815236 815441 815629 815696 815774 815306 816030 816892 815182 815238 815242 815254 815372 815452 815472 815496 815502 815539 815677 815962 816066 816419 816539 816583 816916 816932 820667 815343 815519 815777 815804 815998 816510 399609 815365 305328 382202 403592 409180 815311 815363 815409 815462 815481 815671 815683 815785 815814 816055 816069 815191 815459 815531 815768 815797 816035 816083 816970 815509 815518 815573 815676 815729 815899 815905 815912 815973 816508 816544 816876 816893 815195 815389 815721 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.71%) |
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 305328 382202 389208 399609 403592 409180 449021 502487 612053 712696 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 815554 815573 815579 815625 815629 815653 815671 815676 815677 815678 815683 815696 815715 815721 815726 815729 815749 815768 815771 815774 815777 815785 815787 815791 815797 815804 815814 815874 815890 815899 815905 815912 815913 815914 815962 815973 815993 815998 816030 816035 816055 816066 816069 816074 816080 816083 816330 816336 816367 816405 816419 816508 816510 816538 816539 816542 816544 816554 816583 816586 816876 816886 816892 816893 816894 816916 816932 816934 816970 820120 820667 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers boobs"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers boobs"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.94%) |
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.