Query Metrics
7
Database Queries
7
Different statements
145.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.29 ms (82.53%) |
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 395741 399613 399628 399632 401617 402375 409165 409180 411190 426418 480383 480389 480395 535016 591087 612053 626892 712696 815144 815179 815191 815201 815210 815227 815229 815242 815254 815270 815279 815286 815287 815298 815343 815371 815388 815389 815392 815396 815399 815403 815441 815446 815452 815462 815466 815467 815481 815485 815496 815509 815523 815525 815539 815554 815579 815619 815625 815671 815674 815683 815688 815696 815722 815727 815749 815771 815787 815798 815801 815805 815806 815835 815844 815866 815874 815891 815892 815913 815914 815927 815933 815948 815962 815998 816023 816030 816050 816052 816055 816066 816069 816080 816206 816211 816297 816340 816345 816363 816388 816403 816415 816419 816423 816520 816527 816539 816540 816543 816583 816586 816894 816916 816927 816934 816967 816979 820120 820667 822511 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (10.33%) |
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 820120 815229 815523 815913 816934 815625 815914 816080 816586 815403 815579 815749 815771 815787 815874 815933 816023 816527 816894 535016 612053 815144 815279 815467 815948 815798 815835 822511 815388 815674 816979 815286 815485 815727 815866 816050 816345 815722 816340 401617 815462 816069 815509 815389 815891 816297 816927 816967 815554 815441 815696 815844 816030 815182 815242 815254 815452 815496 815539 815962 816066 816419 816539 816583 816916 820667 815343 815998 816206 480389 480383 399613 815287 815688 815179 815210 815927 816540 591087 816052 399628 399632 411190 815201 815298 815525 815619 816423 815466 815806 816520 815227 815270 815801 816388 816403 816415 815396 816211 816363 402375 426418 712696 395741 480395 626892 409165 815392 815446 815805 815892 816543 409180 815371 815399 815481 815671 815683 816055 815191 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.22%) |
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 395741 399613 399628 399632 401617 402375 409165 409180 411190 426418 480383 480389 480395 535016 591087 612053 626892 712696 815144 815179 815191 815201 815210 815227 815229 815242 815254 815270 815279 815286 815287 815298 815343 815371 815388 815389 815392 815396 815399 815403 815441 815446 815452 815462 815466 815467 815481 815485 815496 815509 815523 815525 815539 815554 815579 815619 815625 815671 815674 815683 815688 815696 815722 815727 815749 815771 815787 815798 815801 815805 815806 815835 815844 815866 815874 815891 815892 815913 815914 815927 815933 815948 815962 815998 816023 816030 816050 816052 816055 816066 816069 816080 816206 816211 816297 816340 816345 816363 816388 816403 816415 816419 816423 816520 816527 816539 816540 816543 816583 816586 816894 816916 816927 816934 816967 816979 820120 820667 822511 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers mother"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.08%) |
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.