Query Metrics
7
Database Queries
7
Different statements
157.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.84 ms (82.84%) |
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 7157 33714 190869 190925 191057 318132 382726 392760 395741 397526 398178 399627 399628 399631 399659 399662 399691 400093 402375 409103 417629 421007 426418 427561 429368 445939 445940 448962 450184 454577 454679 460172 462425 468545 468938 473533 474141 474819 479802 480383 480792 484205 499856 521546 570978 593436 815152 815159 815184 815188 815210 815212 815214 815227 815263 815269 815286 815305 815316 815328 815357 815365 815367 815381 815386 815388 815421 815431 815433 815454 815456 815467 815470 815485 815489 815493 815505 815522 815529 815541 815589 815645 815658 815674 815688 815690 815692 815722 815725 815727 815737 815740 815759 815765 815769 815798 815839 815841 815848 815865 815866 815880 815926 815946 815948 815961 815969 816010 816050 816067 816077 816242 816326 816345 816405 816420 816465 816513 816540 816979 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (11.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 815431 815658 318132 815286 445940 499856 399659 399662 392760 33714 7157 399631 399628 815880 474819 479802 190925 815328 815381 815421 815454 815470 816513 815433 815456 815529 815848 815946 815961 816405 815152 815467 815493 816420 815541 815690 815725 815765 815839 815948 426418 421007 815367 815722 382726 815305 815357 815737 815645 815212 815759 815865 445939 815388 816326 815727 816050 816540 593436 468938 474141 460172 480792 815505 815589 402375 190869 815769 815798 816077 815269 815674 815692 816242 816345 191057 815214 468545 473533 815316 815688 815210 815365 815489 815522 815740 816979 815386 815485 815841 815866 399627 815969 816067 815159 815184 815926 521546 570978 454577 484205 815227 429368 427561 399691 816010 816465 448962 815263 815188 417629 397526 409103 450184 480383 462425 395741 400093 454679 398178 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.48%) |
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 7157 33714 190869 190925 191057 318132 382726 392760 395741 397526 398178 399627 399628 399631 399659 399662 399691 400093 402375 409103 417629 421007 426418 427561 429368 445939 445940 448962 450184 454577 454679 460172 462425 468545 468938 473533 474141 474819 479802 480383 480792 484205 499856 521546 570978 593436 815152 815159 815184 815188 815210 815212 815214 815227 815263 815269 815286 815305 815316 815328 815357 815365 815367 815381 815386 815388 815421 815431 815433 815454 815456 815467 815470 815485 815489 815493 815505 815522 815529 815541 815589 815645 815658 815674 815688 815690 815692 815722 815725 815727 815737 815740 815759 815765 815769 815798 815839 815841 815848 815865 815866 815880 815926 815946 815948 815961 815969 816010 816050 816067 816077 816242 816326 816345 816405 816420 816465 816513 816540 816979 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits brazzers"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ brazzers"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ brazzers"
]
|
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.