Query Metrics
7
Database Queries
7
Different statements
140.35 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.64 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers milf mom"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.58 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 480367 815353 815311 815371 815399 815409 815462 815481 815671 815683 816055 816069 816082 815191 815459 815531 815768 815797 816001 816035 816083 816497 816879 816970 815309 815397 815518 815676 815729 815905 815912 815973 815979 816508 816534 816544 816876 816893 815151 815168 815195 815721 815779 815793 815941 815958 815965 815978 815980 612053 502487 815283 815317 815391 815392 815446 815450 816241 816529 815256 815448 815583 815742 815805 815892 816025 816040 816451 816990 815408 815474 815478 815606 815876 815895 815904 815952 815995 816524 816887 815339 815418 815425 815540 816060 816319 816535 816543 645349 806174 399944 712696 815257 815328 815381 815454 815470 815862 816201 816513 816952 815433 815456 815581 815848 815946 816237 816405 816506 816962 815150 815207 815380 815493 815521 815823 815840 816295 816420 816484 ] |
||||||||||||||||||||||||||||||
| 4 | 2.72 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 399944 480367 502487 612053 645349 712696 806174 815150 815151 815168 815191 815195 815207 815256 815257 815283 815309 815311 815317 815328 815339 815353 815371 815380 815381 815391 815392 815397 815399 815408 815409 815418 815425 815433 815446 815448 815450 815454 815456 815459 815462 815470 815474 815478 815481 815493 815518 815521 815531 815540 815581 815583 815606 815671 815676 815683 815721 815729 815742 815768 815779 815793 815797 815805 815823 815840 815848 815862 815876 815892 815895 815904 815905 815912 815941 815946 815952 815958 815965 815973 815978 815979 815980 815995 816001 816025 816035 816040 816055 816060 816069 816082 816083 816201 816237 816241 816295 816319 816405 816420 816451 816484 816497 816506 816508 816513 816524 816529 816534 816535 816543 816544 816876 816879 816887 816893 816952 816962 816970 816990 ] |
||||||||||||||||||||||||||||||
| 5 | 117.49 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 399944 480367 502487 612053 645349 712696 806174 815150 815151 815168 815191 815195 815207 815256 815257 815283 815309 815311 815317 815328 815339 815353 815371 815380 815381 815391 815392 815397 815399 815408 815409 815418 815425 815433 815446 815448 815450 815454 815456 815459 815462 815470 815474 815478 815481 815493 815518 815521 815531 815540 815581 815583 815606 815671 815676 815683 815721 815729 815742 815768 815779 815793 815797 815805 815823 815840 815848 815862 815876 815892 815895 815904 815905 815912 815941 815946 815952 815958 815965 815973 815978 815979 815980 815995 816001 816025 816035 816040 816055 816060 816069 816082 816083 816201 816237 816241 816295 816319 816405 816420 816451 816484 816497 816506 816508 816513 816524 816529 816534 816535 816543 816544 816876 816879 816887 816893 816952 816962 816970 816990 ] |
||||||||||||||||||||||||||||||
| 6 | 1.67 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers milf mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.53 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers milf 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.