Query Metrics
7
Database Queries
7
Different statements
177.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.17 ms (87.31%) |
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 13035 13373 31758 54201 116623 145280 149158 151455 172514 184943 247240 275727 352187 373277 377287 381844 382572 382671 382750 382926 382947 384430 384905 385148 385728 386414 387284 387520 391017 391696 391956 392971 393185 394064 397216 397838 397948 398542 398924 398976 400855 402119 402605 405808 405922 407411 412582 413453 414349 415742 415757 420557 421570 422718 428064 428107 434664 442009 451868 466902 526211 534624 541505 548515 557095 564254 579711 580773 584939 585486 588940 589671 595232 595964 607954 615335 624165 626186 631020 634616 641884 642563 645481 649784 658433 663357 665307 666951 672699 697197 697744 707111 715444 726646 730186 731140 735987 738396 742494 746808 754278 757861 759727 763807 767686 776269 778399 791920 795348 795566 796503 797342 802574 803875 806944 807500 807793 811708 812555 ] |
||||||||||||||||||||||||||||||
|
13.66 ms (7.69%) |
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 763807 631020 697744 774503 795348 807793 412582 414349 149158 382947 564254 580773 658433 421570 526211 386414 384430 247240 116623 151455 184943 393185 392971 391956 275727 352187 31758 387284 391017 397216 420557 422718 428064 415742 451868 466902 534624 579711 557095 541505 548515 665307 645481 649784 663357 666951 672699 697197 707111 715444 584939 615335 588940 607954 626186 595232 642563 585486 595964 634616 641884 796503 797342 807500 811708 791920 730186 767686 803875 806944 812555 757861 726646 731140 754278 738396 746808 759727 735987 742494 776269 778399 795566 802574 145280 382671 382926 398924 377287 589671 624165 385728 382750 384905 385148 172514 394064 391696 373277 381844 382572 54201 13373 13035 387520 397948 397838 398542 398976 400855 402119 402605 405808 405922 407411 428107 442009 413453 434664 415757 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.42%) |
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 13035 13373 31758 54201 116623 145280 149158 151455 172514 184943 247240 275727 352187 373277 377287 381844 382572 382671 382750 382926 382947 384430 384905 385148 385728 386414 387284 387520 391017 391696 391956 392971 393185 394064 397216 397838 397948 398542 398924 398976 400855 402119 402605 405808 405922 407411 412582 413453 414349 415742 415757 420557 421570 422718 428064 428107 434664 442009 451868 466902 526211 534624 541505 548515 557095 564254 579711 580773 584939 585486 588940 589671 595232 595964 607954 615335 624165 626186 631020 634616 641884 642563 645481 649784 658433 663357 665307 666951 672699 697197 697744 707111 715444 726646 730186 731140 735987 738396 742494 746808 754278 757861 759727 763807 767686 776269 778399 791920 795348 795566 796503 797342 802574 803875 806944 807500 807793 811708 812555 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстух"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"толстая"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 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.