Query Metrics
7
Database Queries
7
Different statements
161.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.34 ms (84.29%) |
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 4282 391644 396384 397299 397958 398025 401037 404212 413474 430161 432690 432776 434874 456664 465267 469236 471532 490952 504072 505531 516637 525027 525855 527223 536408 540656 547530 556336 565288 570260 574712 579842 581462 584025 592301 592955 597005 599092 600204 600796 604669 612060 618782 624551 643993 669276 676680 677338 681256 700930 701682 703619 707497 707933 708551 712541 712777 714608 715041 720136 723926 726966 726984 734589 739178 743586 747756 751189 756653 757522 757932 758203 759902 759910 759961 761012 761093 761187 761754 762934 765220 765514 766698 767213 769064 769472 770279 770500 771172 771333 771579 777533 778494 780745 781056 784206 785770 786115 787942 788928 790084 791802 794037 794494 795555 795567 795746 798013 798914 806574 808978 809762 811923 812348 812983 814263 817268 826286 827318 828861 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (8.63%) |
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 618782 795555 798914 778494 787942 794494 795567 808978 751189 759910 761754 788928 790084 809762 812348 757522 757932 761093 765220 766698 769064 769472 726966 734589 756653 770500 771579 758203 761187 762934 771172 770279 707497 785770 791802 806574 811923 812983 397958 396384 398025 413474 814263 827318 471532 570260 677338 703619 681256 712777 700930 707933 714608 715041 600204 612060 643993 780745 781056 798013 795746 723926 767213 784206 794037 747756 759902 726984 765514 771333 739178 743586 759961 761012 720136 777533 401037 404212 490952 4282 826286 828861 504072 391644 397299 432776 434874 430161 432690 817268 469236 456664 465267 536408 540656 516637 505531 525027 525855 527223 547530 565288 556336 581462 584025 676680 701682 669276 712541 708551 574712 579842 592955 600796 597005 604669 624551 592301 599092 786115 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.18%) |
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 4282 391644 396384 397299 397958 398025 401037 404212 413474 430161 432690 432776 434874 456664 465267 469236 471532 490952 504072 505531 516637 525027 525855 527223 536408 540656 547530 556336 565288 570260 574712 579842 581462 584025 592301 592955 597005 599092 600204 600796 604669 612060 618782 624551 643993 669276 676680 677338 681256 700930 701682 703619 707497 707933 708551 712541 712777 714608 715041 720136 723926 726966 726984 734589 739178 743586 747756 751189 756653 757522 757932 758203 759902 759910 759961 761012 761093 761187 761754 762934 765220 765514 766698 767213 769064 769472 770279 770500 771172 771333 771579 777533 778494 780745 781056 784206 785770 786115 787942 788928 790084 791802 794037 794494 795555 795567 795746 798013 798914 806574 808978 809762 811923 812348 812983 814263 817268 826286 827318 828861 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum and anal"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum анал"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum анал"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.15%) |
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.