Query Metrics
7
Database Queries
7
Different statements
203.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.32 ms (90.49%) |
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 12710 251476 382347 382450 383130 384285 384880 386024 386207 386470 386524 387627 392716 394238 394247 400421 400425 402036 402081 402085 402252 403042 418449 453668 453712 464277 464317 470711 470844 470855 478879 484126 491490 495030 515252 517048 525671 528340 550447 562105 566547 567160 569676 578470 580466 584674 588625 599148 612106 614094 614849 618893 630834 644194 644660 663910 668646 676536 682510 682523 682538 684574 693074 694537 701300 703100 708519 708803 708807 710970 712810 712832 714452 716076 720480 722660 722670 722686 722706 722913 727680 734613 735800 740331 741467 741652 743021 743103 743127 743135 743142 744310 745012 745033 748139 748142 759581 759587 759650 759670 765996 766015 766025 775383 775811 778616 788582 789212 789283 804530 804746 804753 807967 810286 812115 812127 812143 812153 824090 827523 ] |
||||||||||||||||||||||||||||||
|
11.08 ms (5.44%) |
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 694537 682510 682538 708807 722670 588625 644660 812115 804753 740331 743135 804530 766015 745012 745033 612106 567160 400421 810286 812153 386470 708519 569676 827523 470855 722913 748139 759650 517048 550447 515252 251476 562105 584674 578470 580466 663910 712810 630834 599148 614849 807967 765996 741652 744310 775383 453712 693074 788582 470711 384285 525671 384880 400425 491490 714452 618893 402085 470844 392716 382347 464277 464317 676536 722706 382450 386024 775811 386524 394238 743142 748142 759581 812127 386207 418449 495030 12710 403042 708803 701300 614094 743127 766025 759670 394247 402036 824090 684574 710970 644194 789283 387627 402252 528340 716076 722660 722686 712832 682523 727680 812143 453668 566547 703100 668646 778616 804746 743021 743103 789212 734613 741467 759587 735800 402081 478879 383130 484126 720480 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.06%) |
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 12710 251476 382347 382450 383130 384285 384880 386024 386207 386470 386524 387627 392716 394238 394247 400421 400425 402036 402081 402085 402252 403042 418449 453668 453712 464277 464317 470711 470844 470855 478879 484126 491490 495030 515252 517048 525671 528340 550447 562105 566547 567160 569676 578470 580466 584674 588625 599148 612106 614094 614849 618893 630834 644194 644660 663910 668646 676536 682510 682523 682538 684574 693074 694537 701300 703100 708519 708803 708807 710970 712810 712832 714452 716076 720480 722660 722670 722686 722706 722913 727680 734613 735800 740331 741467 741652 743021 743103 743127 743135 743142 744310 745012 745033 748139 748142 759581 759587 759650 759670 765996 766015 766025 775383 775811 778616 788582 789212 789283 804530 804746 804753 807967 810286 812115 812127 812143 812153 824090 827523 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"grandpa секс young"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"grandpa fuck young"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"grandpa секс young"
]
|
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.