Query Metrics
7
Database Queries
7
Different statements
192.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.72 ms (87.13%) |
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 398178 399944 502487 645349 712696 806174 815151 815168 815191 815195 815207 815256 815283 815306 815309 815311 815317 815328 815339 815340 815343 815353 815371 815381 815391 815392 815397 815399 815408 815409 815418 815433 815441 815446 815448 815454 815456 815459 815462 815470 815472 815474 815478 815481 815509 815511 815518 815531 815581 815583 815606 815671 815676 815683 815721 815729 815742 815768 815779 815785 815793 815797 815804 815805 815823 815840 815844 815848 815858 815892 815895 815904 815905 815911 815912 815941 815952 815958 815965 815973 815978 815979 815980 815995 815998 816001 816025 816035 816040 816052 816055 816061 816069 816082 816083 816206 816209 816319 816451 816497 816506 816508 816513 816516 816524 816529 816534 816535 816543 816544 816583 816876 816879 816887 816893 816916 816952 816962 816970 816990 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (7.71%) |
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 816583 816916 815343 815804 815998 502487 815441 815844 815306 815911 815472 815858 815531 815797 816876 816893 815980 815311 815399 815409 815481 815683 815785 816069 815191 816035 816083 816970 815309 816508 816544 815958 815965 398178 816206 815462 815671 815459 816497 816879 815509 815518 815676 815729 815905 815912 815973 815979 815195 815721 815941 815978 712696 815371 816055 815768 816534 815168 815793 815391 399944 815317 815340 816529 815448 815583 815742 815805 816040 815606 815995 815339 816319 816543 645349 816082 816001 815397 815151 815779 815283 815392 815446 815256 815892 816025 816052 816451 816990 815408 815478 815904 816524 816887 815418 816535 815474 815895 815952 806174 816209 816952 816962 815581 816506 815207 815353 815823 815840 815511 816061 816516 815328 815381 815454 815470 816513 815433 815456 815848 ] |
||||||||||||||||||||||||||||||
|
2.85 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 398178 399944 502487 645349 712696 806174 815151 815168 815191 815195 815207 815256 815283 815306 815309 815311 815317 815328 815339 815340 815343 815353 815371 815381 815391 815392 815397 815399 815408 815409 815418 815433 815441 815446 815448 815454 815456 815459 815462 815470 815472 815474 815478 815481 815509 815511 815518 815531 815581 815583 815606 815671 815676 815683 815721 815729 815742 815768 815779 815785 815793 815797 815804 815805 815823 815840 815844 815848 815858 815892 815895 815904 815905 815911 815912 815941 815952 815958 815965 815973 815978 815979 815980 815995 815998 816001 816025 816035 816040 816052 816055 816061 816069 816082 816083 816206 816209 816319 816451 816497 816506 816508 816513 816516 816524 816529 816534 816535 816543 816544 816583 816876 816879 816887 816893 816916 816952 816962 816970 816990 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers mom big"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers mom большие"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"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.