Query Metrics
7
Database Queries
7
Different statements
275.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
253.38 ms (92.09%) |
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 407159 464166 488469 491621 544722 545101 552985 556119 556719 556720 557805 565830 584964 592867 593881 604664 606815 613840 628615 629659 629930 632077 635357 640320 645021 653042 660114 664446 669244 674258 681773 682820 689462 692704 692734 693003 697733 698739 701773 706063 706554 706659 707056 707626 707741 707878 708070 710237 710947 711586 713945 714739 718460 719069 719087 719793 720006 722168 722180 723476 724130 724461 725020 725240 728116 728464 728634 728810 728870 728921 730309 734448 736671 736720 744362 744923 746132 747061 747680 748038 751266 752511 755106 757712 757930 758808 758874 760768 761339 761378 762873 763191 763843 764850 766162 767294 767629 767734 768542 772354 775527 778719 781562 782674 786670 788228 789508 791678 794546 794565 796755 808783 811650 824079 824081 824093 824799 825433 828765 ] |
||||||||||||||||||||||||||||||
|
11.99 ms (4.36%) |
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 584964 653042 664446 674258 682820 693003 701773 706554 707056 707741 711586 660114 681773 689462 692704 698739 707626 645021 669244 692734 707878 708070 710237 710947 714739 719793 720006 722180 544722 556720 592867 593881 628615 640320 604664 613840 629930 606815 763191 736720 744923 767294 728810 763843 632077 697733 706063 706659 789508 824093 464166 488469 545101 565830 629659 791678 728464 768542 719087 788228 505794 407159 824079 825433 824081 824799 828765 491621 556119 556719 557805 552985 722168 723476 713945 718460 719069 635357 778719 794546 775527 782674 794565 796755 728634 734448 736671 752511 755106 758808 758874 760768 761339 761378 764850 767629 772354 781562 786670 808783 811650 725020 725240 728921 730309 744362 747680 748038 751266 762873 767734 724461 746132 747061 757712 757930 766162 724130 728116 728870 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.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 407159 464166 488469 491621 544722 545101 552985 556119 556719 556720 557805 565830 584964 592867 593881 604664 606815 613840 628615 629659 629930 632077 635357 640320 645021 653042 660114 664446 669244 674258 681773 682820 689462 692704 692734 693003 697733 698739 701773 706063 706554 706659 707056 707626 707741 707878 708070 710237 710947 711586 713945 714739 718460 719069 719087 719793 720006 722168 722180 723476 724130 724461 725020 725240 728116 728464 728634 728810 728870 728921 730309 734448 736671 736720 744362 744923 746132 747061 747680 748038 751266 752511 755106 757712 757930 758808 758874 760768 761339 761378 762873 763191 763843 764850 766162 767294 767629 767734 768542 772354 775527 778719 781562 782674 786670 788228 789508 791678 794546 794565 796755 808783 811650 824079 824081 824093 824799 825433 828765 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot amateur"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot любительск"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot любительск"
]
|
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.