Query Metrics
7
Database Queries
7
Different statements
218.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.62 ms (88.62%) |
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 8619 14232 14700 24931 97763 176979 187611 188403 191246 310672 320078 360439 370794 384133 384340 388097 388232 388569 388770 388774 388856 390218 391251 392787 393391 395592 397906 400428 400865 401130 401480 407618 409324 409331 411213 411401 413645 414871 415503 415734 420178 421094 421215 422185 424394 424414 425810 426515 428124 428624 433259 434193 439674 440781 445459 446757 447722 447981 448374 448727 448944 450288 451040 452157 453087 455496 458924 459932 460207 462325 464236 466150 466229 467933 467935 468181 468865 469574 470683 470931 474673 475917 476250 476691 477007 477691 478186 478546 479253 480392 481659 483149 485511 489357 490098 493270 497708 504482 520681 521166 526008 526074 526792 534670 560396 582222 610225 682176 684067 686637 726282 726398 732744 748231 759756 779534 797186 797872 802610 807866 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (6.42%) |
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 14232 97763 401480 407618 425810 428624 434193 448944 467933 469574 684067 732744 467935 188403 477007 8619 370794 388232 310672 414871 475917 526792 428124 447722 474673 439674 422185 424394 478186 393391 400865 534670 384340 176979 320078 388774 460207 470683 448374 582222 802610 759756 726282 779534 481659 395592 409324 411213 415503 447981 392787 610225 807866 726398 14700 400428 440781 388569 424414 480392 478546 391251 448727 797186 483149 520681 187611 748231 409331 191246 682176 24931 426515 390218 388770 477691 479253 420178 455496 446757 468181 485511 489357 504482 466229 686637 797872 384133 401130 452157 490098 453087 458924 476250 411401 470931 493270 526008 526074 388097 397906 421094 413645 451040 360439 445459 497708 560396 521166 415734 421215 433259 450288 468865 459932 466150 476691 464236 388856 462325 ] |
||||||||||||||||||||||||||||||
|
3.23 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 8619 14232 14700 24931 97763 176979 187611 188403 191246 310672 320078 360439 370794 384133 384340 388097 388232 388569 388770 388774 388856 390218 391251 392787 393391 395592 397906 400428 400865 401130 401480 407618 409324 409331 411213 411401 413645 414871 415503 415734 420178 421094 421215 422185 424394 424414 425810 426515 428124 428624 433259 434193 439674 440781 445459 446757 447722 447981 448374 448727 448944 450288 451040 452157 453087 455496 458924 459932 460207 462325 464236 466150 466229 467933 467935 468181 468865 469574 470683 470931 474673 475917 476250 476691 477007 477691 478186 478546 479253 480392 481659 483149 485511 489357 490098 493270 497708 504482 520681 521166 526008 526074 526792 534670 560396 582222 610225 682176 684067 686637 726282 726398 732744 748231 759756 779534 797186 797872 802610 807866 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big mother"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.77%) |
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.