Query Metrics
7
Database Queries
7
Different statements
202.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.94 ms (86.94%) |
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 340567 352187 393067 396701 402630 410346 411025 416515 416751 420120 424088 428570 429609 429703 430478 432288 440094 441952 445533 446274 447987 451775 452325 453400 455574 465565 468377 471674 475319 475947 487779 493618 493757 499617 509085 517690 520400 521435 524849 532882 536624 541322 543941 544108 544707 546222 547920 551123 554350 554864 555198 555271 555379 558001 568254 568261 571137 579128 588077 594340 599358 602863 605725 609246 620545 625744 626027 628019 640785 646044 649296 653031 657505 665450 679583 691821 700996 704178 708923 710053 710293 713141 715107 719392 720094 720264 720737 723667 728292 728376 737197 738390 744618 747298 752592 758226 759040 782112 787564 788651 791783 793925 794305 796333 800334 801287 802582 810821 811643 814114 815930 816094 817194 819228 819924 823860 823974 824523 826988 827142 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (7.65%) |
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 424088 396701 646044 451775 517690 640785 811643 429703 554864 541322 657505 708923 704178 594340 796333 453400 428570 817194 826988 819924 554350 555271 788651 728292 794305 720264 599358 800334 744618 720737 710053 782112 759040 402630 801287 555379 571137 827142 555198 420120 441952 429609 446274 493618 445533 493757 471674 544108 475947 475319 440094 499617 487779 520400 465565 524849 787564 393067 411025 521435 455574 468377 579128 815930 665450 558001 700996 547920 551123 758226 410346 452325 728376 568261 791783 532882 752592 816094 536624 737197 430478 509085 340567 544707 416515 723667 720094 602863 747298 416751 605725 432288 447987 588077 352187 814114 819228 824523 823860 823974 543941 568254 649296 653031 691821 715107 719392 679583 710293 713141 546222 620545 626027 628019 609246 625744 810821 793925 802582 738390 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.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 340567 352187 393067 396701 402630 410346 411025 416515 416751 420120 424088 428570 429609 429703 430478 432288 440094 441952 445533 446274 447987 451775 452325 453400 455574 465565 468377 471674 475319 475947 487779 493618 493757 499617 509085 517690 520400 521435 524849 532882 536624 541322 543941 544108 544707 546222 547920 551123 554350 554864 555198 555271 555379 558001 568254 568261 571137 579128 588077 594340 599358 602863 605725 609246 620545 625744 626027 628019 640785 646044 649296 653031 657505 665450 679583 691821 700996 704178 708923 710053 710293 713141 715107 719392 720094 720264 720737 723667 728292 728376 737197 738390 744618 747298 752592 758226 759040 782112 787564 788651 791783 793925 794305 796333 800334 801287 802582 810821 811643 814114 815930 816094 817194 819228 819924 823860 823974 824523 826988 827142 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape fuck"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк секс"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
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.