Query Metrics
7
Database Queries
7
Different statements
198.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.38 ms (85.74%) |
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 282649 395101 408470 416832 423178 426803 428388 429460 433067 434801 438710 443489 445977 447867 455594 457326 458856 459389 461472 462168 468959 470731 472323 474999 475376 475615 479401 485483 493248 494991 495324 499441 509077 517027 517028 517167 521425 523242 523965 524624 525360 526129 527250 527341 529217 533705 547884 548732 551164 551167 551565 551575 552546 553677 558363 558736 559006 561201 564082 565368 568113 569121 574442 576505 576849 578840 582036 585537 589331 590689 592125 594820 594979 595567 598784 610748 617486 617543 622077 629594 638187 646676 649356 649860 649885 650928 658881 661654 662097 664450 670263 683914 686133 695667 701520 709660 716121 716600 721875 727367 732084 735429 749432 758674 761228 764879 770578 772483 786467 787916 789799 792790 792832 793443 795504 802243 807301 813139 814258 818937 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (8.87%) |
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 818937 638187 646676 649356 786467 792790 552546 553677 662097 622077 629594 727367 795504 434801 523242 569121 564082 590689 594979 658881 664450 585537 592125 792832 521425 764879 457326 670263 433067 661654 561201 495324 576849 595567 429460 428388 468959 526129 525360 551565 617543 789799 455594 479401 610748 787916 582036 578840 695667 716600 749432 735429 686133 527250 443489 617486 472323 509077 558363 565368 548732 438710 568113 807301 551575 802243 709660 282649 716121 721875 458856 485483 533705 576505 408470 732084 683914 589331 793443 761228 770578 529217 474999 423178 459389 523965 517027 517028 517167 524624 649860 445977 594820 494991 558736 701520 547884 574442 598784 493248 527341 447867 758674 475376 426803 475615 650928 649885 813139 772483 461472 462168 551167 470731 499441 416832 551164 559006 395101 814258 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.68%) |
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 282649 395101 408470 416832 423178 426803 428388 429460 433067 434801 438710 443489 445977 447867 455594 457326 458856 459389 461472 462168 468959 470731 472323 474999 475376 475615 479401 485483 493248 494991 495324 499441 509077 517027 517028 517167 521425 523242 523965 524624 525360 526129 527250 527341 529217 533705 547884 548732 551164 551167 551565 551575 552546 553677 558363 558736 559006 561201 564082 565368 568113 569121 574442 576505 576849 578840 582036 585537 589331 590689 592125 594820 594979 595567 598784 610748 617486 617543 622077 629594 638187 646676 649356 649860 649885 650928 658881 661654 662097 664450 670263 683914 686133 695667 701520 709660 716121 716600 721875 727367 732084 735429 749432 758674 761228 764879 770578 772483 786467 787916 789799 792790 792832 793443 795504 802243 807301 813139 814258 818937 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в туалете молоденькая…"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.75%) |
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.