Query Metrics
7
Database Queries
7
Different statements
502.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
263.76 ms (52.48%) |
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 56464 72431 187847 188610 358438 358481 383235 385486 387043 388364 391054 391326 394059 396881 400487 400923 401804 402973 403000 404522 405222 406298 407878 411208 411389 411408 421843 421883 421894 421913 422182 428421 429409 430630 432235 439710 440813 440938 442198 443769 447474 448800 451505 454989 460638 465394 466733 468537 468900 470109 470290 471195 475724 480270 482345 484402 484692 485697 491230 492320 507015 517711 518750 519588 520672 523767 526556 529362 538834 556524 556654 557118 562885 578509 601956 601975 607537 620158 636283 642853 665789 706030 710460 719873 721646 726794 730444 759451 765134 765726 766442 767175 768328 768420 772585 772612 778143 782628 789225 792533 792564 793886 793997 797780 797844 799093 800171 800344 802998 803062 803621 805768 808452 808870 810402 810477 811174 812356 813944 814571 ] |
||||||||||||||||||||||||||||||
|
215.62 ms (42.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
14.73 ms (2.93%) |
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 557118 466733 480270 485697 406298 538834 429409 484402 607537 519588 562885 430630 636283 484692 601956 465394 726794 470290 520672 492320 523767 556524 443769 468537 793886 451505 442198 793997 518750 721646 391054 812356 768328 803062 387043 440938 411408 358438 802998 421894 439710 782628 470109 400487 358481 421913 529362 383235 400923 800344 188610 710460 765726 402973 768420 810477 767175 187847 507015 394059 401804 471195 620158 642853 797844 792564 396881 813944 491230 526556 719873 706030 810402 730444 789225 411389 811174 454989 778143 447474 56464 765134 808452 428421 482345 799093 422182 405222 665789 766442 404522 421883 432235 411208 460638 792533 468900 517711 72431 475724 403000 388364 800171 759451 772585 797780 805768 808870 814571 601975 391326 407878 448800 556654 578509 803621 772612 421843 385486 440813 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.61%) |
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 56464 72431 187847 188610 358438 358481 383235 385486 387043 388364 391054 391326 394059 396881 400487 400923 401804 402973 403000 404522 405222 406298 407878 411208 411389 411408 421843 421883 421894 421913 422182 428421 429409 430630 432235 439710 440813 440938 442198 443769 447474 448800 451505 454989 460638 465394 466733 468537 468900 470109 470290 471195 475724 480270 482345 484402 484692 485697 491230 492320 507015 517711 518750 519588 520672 523767 526556 529362 538834 556524 556654 557118 562885 578509 601956 601975 607537 620158 636283 642853 665789 706030 710460 719873 721646 726794 730444 759451 765134 765726 766442 767175 768328 768420 772585 772612 778143 782628 789225 792533 792564 793886 793997 797780 797844 799093 800171 800344 802998 803062 803621 805768 808452 808870 810402 810477 811174 812356 813944 814571 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"рыжие мамы"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.