Query Metrics
7
Database Queries
7
Different statements
149.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.91 ms (80.80%) |
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 23524 49426 60096 82217 117513 118098 130482 153364 163429 163536 185334 188655 219765 285321 317820 338587 382745 385509 385913 387374 387720 389346 391002 397131 398043 398105 401871 404608 406330 406501 406578 406907 409941 415623 418332 419126 420207 420613 422513 422709 422711 422901 422949 422958 422960 422993 423006 423021 423022 423023 423171 423205 423280 423418 424946 425424 425759 429544 433610 435645 435646 443582 446266 448734 456627 456633 457749 458098 468616 469366 469576 472949 472962 477406 477408 477747 492410 496106 500077 505296 510622 512195 530930 537566 550639 551951 551978 552014 552032 552884 554307 556408 559868 559895 559968 566001 579632 586623 618528 621025 622625 623503 632682 634755 650951 652252 702087 717892 724460 729065 730556 730579 736172 737107 744704 747956 748667 755696 784514 797490 ] |
||||||||||||||||||||||||||||||
|
17.23 ms (11.51%) |
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 420207 435646 554307 219765 492410 737107 406907 49426 389346 784514 736172 730556 387374 82217 398105 477747 559895 477406 618528 422709 422901 420613 446266 456633 422949 456627 469576 418332 423021 60096 398043 496106 530930 552014 650951 652252 702087 730579 724460 385509 130482 285321 401871 409941 425424 457749 163536 118098 469366 415623 425759 23524 586623 153364 163429 391002 429544 551951 552884 566001 422958 422513 404608 717892 387720 385913 537566 423205 422993 423006 423023 424946 510622 744704 423022 433610 423280 422711 423418 500077 579632 623503 797490 338587 185334 317820 423171 443582 477408 468616 512195 550639 551978 552032 632682 621025 622625 458098 472949 505296 382745 472962 188655 397131 406330 406501 419126 448734 556408 559968 729065 747956 755696 748667 634755 117513 559868 422960 435645 406578 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (2.51%) |
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 23524 49426 60096 82217 117513 118098 130482 153364 163429 163536 185334 188655 219765 285321 317820 338587 382745 385509 385913 387374 387720 389346 391002 397131 398043 398105 401871 404608 406330 406501 406578 406907 409941 415623 418332 419126 420207 420613 422513 422709 422711 422901 422949 422958 422960 422993 423006 423021 423022 423023 423171 423205 423280 423418 424946 425424 425759 429544 433610 435645 435646 443582 446266 448734 456627 456633 457749 458098 468616 469366 469576 472949 472962 477406 477408 477747 492410 496106 500077 505296 510622 512195 530930 537566 550639 551951 551978 552014 552032 552884 554307 556408 559868 559895 559968 566001 579632 586623 618528 621025 622625 623503 632682 634755 650951 652252 702087 717892 724460 729065 730556 730579 736172 737107 744704 747956 748667 755696 784514 797490 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian-man"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
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.