Query Metrics
7
Database Queries
7
Different statements
139.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.95 ms (82.65%) |
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 106347 190869 320078 342450 383290 385123 395741 396034 399613 399630 399633 399944 407376 409165 409330 426418 445939 446135 448114 460172 477210 535016 645320 645349 806220 815144 815150 815152 815207 815210 815263 815269 815283 815285 815316 815317 815325 815328 815333 815339 815349 815353 815369 815381 815388 815391 815392 815408 815418 815421 815433 815444 815446 815448 815456 815467 815470 815478 815489 815493 815511 815541 815581 815583 815606 815626 815639 815674 815688 815690 815710 815723 815725 815740 815742 815765 815769 815798 815805 815823 815835 815839 815840 815848 815849 815892 815904 815946 815948 815952 815958 815961 815965 815977 815978 815980 815995 816025 816040 816052 816061 816077 816209 816216 816233 816319 816326 816420 816455 816506 816513 816516 816524 816529 816543 816887 816952 816962 816990 822511 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (10.12%) |
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 815849 815958 815965 815978 815980 806220 477210 815723 816455 815283 815317 815391 815392 815446 815626 815639 816529 815349 815448 815583 815742 815805 815892 816025 816040 816052 816990 815408 815478 815606 815904 815952 815995 816524 816887 815339 815369 815418 815444 815710 815977 816319 816543 645349 399944 342450 396034 409165 815325 815328 815381 815421 815470 816513 816952 815144 815333 815433 815456 815581 815848 815946 815961 816216 816506 816962 815150 815152 815207 815353 815467 815493 815823 815840 816420 815511 815541 815690 815725 815765 815839 815948 816061 816209 816233 816516 445939 448114 645320 426418 383290 446135 460172 395741 535016 385123 106347 190869 320078 399613 399630 399633 407376 409330 815285 815316 815769 815798 815835 816077 822511 815388 815688 815210 815263 815269 815489 815674 815740 816326 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (2.16%) |
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 106347 190869 320078 342450 383290 385123 395741 396034 399613 399630 399633 399944 407376 409165 409330 426418 445939 446135 448114 460172 477210 535016 645320 645349 806220 815144 815150 815152 815207 815210 815263 815269 815283 815285 815316 815317 815325 815328 815333 815339 815349 815353 815369 815381 815388 815391 815392 815408 815418 815421 815433 815444 815446 815448 815456 815467 815470 815478 815489 815493 815511 815541 815581 815583 815606 815626 815639 815674 815688 815690 815710 815723 815725 815740 815742 815765 815769 815798 815805 815823 815835 815839 815840 815848 815849 815892 815904 815946 815948 815952 815958 815961 815965 815977 815978 815980 815995 816025 816040 816052 816061 816077 816209 816216 816233 816319 816326 816420 816455 816506 816513 816516 816524 816529 816543 816887 816952 816962 816990 822511 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers boobs"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers boobs"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.11%) |
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.