Query Metrics
7
Database Queries
7
Different statements
160.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.59 ms (81.77%) |
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 13249 17037 397436 401594 409820 419029 420730 423873 429927 429960 441541 443884 446117 446162 447422 447512 454136 455745 458456 461423 463328 463903 465773 465915 468089 468093 478732 478895 496049 496585 496738 497647 501755 503292 505905 507685 513307 515848 519498 533782 537959 537974 571415 574780 575082 576119 589749 590413 590989 592425 595401 595873 598056 598612 598685 609883 619042 626880 652927 655919 656291 671197 675762 675798 679171 680391 683242 683303 685409 685423 685480 685534 685810 686581 696228 698226 705106 707164 715020 715657 718672 719347 720952 731096 734330 735330 742458 747407 747409 747709 754207 754584 761768 762277 765066 766785 773644 777021 777207 777582 779665 779730 781101 781412 782674 786372 786752 788351 790531 792953 794932 800003 819255 821116 823740 826674 827221 827429 ] |
||||||||||||||||||||||||||||||
|
19.42 ms (12.07%) |
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 762277 747407 397436 409820 465915 478895 443884 533782 800003 446117 468089 455745 17037 423873 458456 503292 447422 675762 781101 478732 497647 496049 537974 683303 735330 747409 718672 13249 429960 463328 821116 574780 575082 696228 576119 609883 598612 590413 598056 589749 590989 446162 465773 419029 461423 463903 505905 513307 519498 496738 507685 496585 501755 515848 719347 777207 761768 731096 765066 447512 420730 454136 468093 595401 595873 429927 734330 819255 826674 827221 823740 827429 683242 685810 652927 656291 715020 592425 794932 790531 742458 744999 747709 754584 766785 721975 777021 779665 401594 675798 598685 441541 537959 671197 680391 685409 685480 686581 715657 720952 655919 679171 685423 685534 705106 698226 707164 571415 619042 626880 777582 779730 788351 782674 754207 773644 781412 786372 786752 792953 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.82%) |
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 13249 17037 397436 401594 409820 419029 420730 423873 429927 429960 441541 443884 446117 446162 447422 447512 454136 455745 458456 461423 463328 463903 465773 465915 468089 468093 478732 478895 496049 496585 496738 497647 501755 503292 505905 507685 513307 515848 519498 533782 537959 537974 571415 574780 575082 576119 589749 590413 590989 592425 595401 595873 598056 598612 598685 609883 619042 626880 652927 655919 656291 671197 675762 675798 679171 680391 683242 683303 685409 685423 685480 685534 685810 686581 696228 698226 705106 707164 715020 715657 718672 719347 720952 731096 734330 735330 742458 747407 747409 747709 754207 754584 761768 762277 765066 766785 773644 777021 777207 777582 779665 779730 781101 781412 782674 786372 786752 788351 790531 792953 794932 800003 819255 821116 823740 826674 827221 827429 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus anal teen"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск анал teen"
]
|
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.