Query Metrics
7
Database Queries
7
Different statements
202.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.15 ms (87.59%) |
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 2571 6609 39719 58201 71071 73070 73990 80663 80900 92531 95557 102043 103649 148793 153472 157617 183022 185435 186793 190869 190929 191160 191470 237161 249597 270386 312466 327193 348275 361382 372443 375930 381874 381901 382181 382458 382472 382720 384025 384230 384543 384798 384900 384904 385841 385908 385953 386263 386477 386787 387072 387182 387353 388228 388532 388738 388774 389262 389355 390042 390071 390175 390362 390368 390693 391483 392331 392797 392805 392999 393087 393849 394785 395407 395502 396054 396222 396230 396353 396571 396988 397013 397071 397172 397222 397781 397872 397908 398039 398666 401509 403678 403754 407064 410075 417887 421491 424866 429193 429542 430742 430770 445576 464112 477124 523483 531275 536740 549309 549323 564922 566574 589263 630282 639261 667117 714761 761274 818191 818201 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (6.88%) |
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 382472 2571 388532 396230 445576 549309 549323 714761 639261 73070 375930 381874 464112 381901 237161 58201 391483 397872 387353 385908 384230 185435 191160 183022 372443 186793 390368 397222 421491 429542 523483 531275 564922 388738 389262 392331 393849 395502 388228 424866 430770 148793 395407 430742 327193 385841 386477 103649 361382 6609 390071 761274 384025 403678 102043 270386 71071 384543 386263 382720 80900 384904 249597 398666 392797 396222 390693 397781 396571 190929 390362 385953 390175 393087 392805 312466 382458 387182 429193 818201 477124 536740 566574 589263 390042 384900 386787 190869 394785 382181 95557 39719 388774 389355 397013 397172 818191 667117 630282 396988 397071 401509 384798 392999 348275 92531 387072 396054 396353 417887 407064 73990 80663 398039 403754 191470 397908 410075 153472 157617 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (1.81%) |
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 2571 6609 39719 58201 71071 73070 73990 80663 80900 92531 95557 102043 103649 148793 153472 157617 183022 185435 186793 190869 190929 191160 191470 237161 249597 270386 312466 327193 348275 361382 372443 375930 381874 381901 382181 382458 382472 382720 384025 384230 384543 384798 384900 384904 385841 385908 385953 386263 386477 386787 387072 387182 387353 388228 388532 388738 388774 389262 389355 390042 390071 390175 390362 390368 390693 391483 392331 392797 392805 392999 393087 393849 394785 395407 395502 396054 396222 396230 396353 396571 396988 397013 397071 397172 397222 397781 397872 397908 398039 398666 401509 403678 403754 407064 410075 417887 421491 424866 429193 429542 430742 430770 445576 464112 477124 523483 531275 536740 549309 549323 564922 566574 589263 630282 639261 667117 714761 761274 818191 818201 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мускулистые"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex muscle"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс мускулистые"
]
|
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.