Query Metrics
7
Database Queries
7
Different statements
163.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.60 ms (85.00%) |
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 415869 423707 486146 535207 544029 551594 554659 575025 576578 578301 584830 589652 594306 599427 614385 616846 628048 636440 638697 649799 667363 688173 693082 693083 696143 698436 698479 703235 708709 710802 713086 722237 722433 725269 726736 727486 737062 738179 739788 740580 743094 745484 746197 746711 748773 749535 750376 751339 753700 756770 764782 766297 768236 773177 776092 777738 777835 777854 780668 782898 783375 783899 783960 784418 784886 784945 785138 785650 785652 785653 785694 785866 786394 786433 787172 788210 788378 790711 791165 791223 792973 796367 796385 796791 797032 797089 798727 800096 801820 802231 803986 806813 807212 810324 810398 810904 810927 812663 813356 813366 816668 817565 817566 817675 819406 820688 823654 824230 824301 824850 824853 824855 825855 826253 826773 827093 827543 827544 828026 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (8.58%) |
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 756770 766297 698479 792973 578301 828026 575025 584830 710802 797032 810324 750376 698436 696143 748773 810904 667363 688173 589652 784886 785653 801820 786394 749535 786433 827543 824230 824853 826253 544029 551594 576578 693082 713086 649799 693083 554659 636440 638697 594306 776092 777835 785652 788378 796791 790711 791165 796367 737062 743094 745484 746711 773177 782898 784418 803986 725269 727486 740580 751339 628048 722433 777854 780668 783899 783960 784945 785138 785694 785866 797089 806813 722237 616846 800096 783375 746197 753700 764782 807212 599427 614385 802231 785650 796385 787172 817565 817675 820688 823734 819406 826773 827093 827544 817566 768236 798727 738179 739788 726736 791223 810927 788210 415869 535207 708709 777738 812663 813356 813366 703235 810398 423707 823654 824855 825855 816668 824301 824850 486146 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.01%) |
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 415869 423707 486146 535207 544029 551594 554659 575025 576578 578301 584830 589652 594306 599427 614385 616846 628048 636440 638697 649799 667363 688173 693082 693083 696143 698436 698479 703235 708709 710802 713086 722237 722433 725269 726736 727486 737062 738179 739788 740580 743094 745484 746197 746711 748773 749535 750376 751339 753700 756770 764782 766297 768236 773177 776092 777738 777835 777854 780668 782898 783375 783899 783960 784418 784886 784945 785138 785650 785652 785653 785694 785866 786394 786433 787172 788210 788378 790711 791165 791223 792973 796367 796385 796791 797032 797089 798727 800096 801820 802231 803986 806813 807212 810324 810398 810904 810927 812663 813356 813366 816668 817565 817566 817675 819406 820688 823654 824230 824301 824850 824853 824855 825855 826253 826773 827093 827543 827544 828026 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbation orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк мастурбац orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк мастурбац orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
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.