Query Metrics
7
Database Queries
7
Different statements
232.81 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.06 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.95 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx brazzers mom"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.81 ms |
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 815539 815962 816066 816419 816539 816583 816916 820667 815343 815777 815804 815858 815998 816206 815311 815371 815399 815409 815462 815481 815671 815683 815785 816055 816069 816082 815191 815459 815531 815768 815797 816001 816035 816083 816497 816879 816970 815309 815397 815509 815518 815676 815729 815905 815912 815973 815979 816508 816534 816544 816876 816893 815151 815168 815195 815721 815779 815793 815941 815958 815965 815978 815980 398178 712696 815283 815317 815340 815391 815392 815446 815450 816241 816529 815256 815448 815583 815742 815805 815892 816025 816040 816052 816451 816990 815408 815474 815478 815606 815876 815895 815904 815952 815995 816524 816887 815339 815418 815425 815540 816060 816319 816535 816543 645349 806174 399944 815257 815328 815381 815454 815470 815862 816201 816513 816952 815433 815456 815581 815848 ] |
||||||||||||||||||||||||||||||
| 4 | 3.07 ms |
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 398178 399944 645349 712696 806174 815151 815168 815191 815195 815256 815257 815283 815309 815311 815317 815328 815339 815340 815343 815371 815381 815391 815392 815397 815399 815408 815409 815418 815425 815433 815446 815448 815450 815454 815456 815459 815462 815470 815474 815478 815481 815509 815518 815531 815539 815540 815581 815583 815606 815671 815676 815683 815721 815729 815742 815768 815777 815779 815785 815793 815797 815804 815805 815848 815858 815862 815876 815892 815895 815904 815905 815912 815941 815952 815958 815962 815965 815973 815978 815979 815980 815995 815998 816001 816025 816035 816040 816052 816055 816060 816066 816069 816082 816083 816201 816206 816241 816319 816419 816451 816497 816508 816513 816524 816529 816534 816535 816539 816543 816544 816583 816876 816879 816887 816893 816916 816952 816970 816990 820667 ] |
||||||||||||||||||||||||||||||
| 5 | 208.61 ms |
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 398178 399944 645349 712696 806174 815151 815168 815191 815195 815256 815257 815283 815309 815311 815317 815328 815339 815340 815343 815371 815381 815391 815392 815397 815399 815408 815409 815418 815425 815433 815446 815448 815450 815454 815456 815459 815462 815470 815474 815478 815481 815509 815518 815531 815539 815540 815581 815583 815606 815671 815676 815683 815721 815729 815742 815768 815777 815779 815785 815793 815797 815804 815805 815848 815858 815862 815876 815892 815895 815904 815905 815912 815941 815952 815958 815962 815965 815973 815978 815979 815980 815995 815998 816001 816025 816035 816040 816052 816055 816060 816066 816069 816082 816083 816201 816206 816241 816319 816419 816451 816497 816508 816513 816524 816529 816534 816535 816539 816543 816544 816583 816876 816879 816887 816893 816916 816952 816970 816990 820667 ] |
||||||||||||||||||||||||||||||
| 6 | 1.79 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx brazzers mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.52 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx brazzers mom"
]
|
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.