Query Metrics
7
Database Queries
7
Different statements
167.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.30 ms (85.42%) |
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 57971 241269 258915 331382 479068 479744 481986 482947 485389 530453 535602 546367 571506 582729 587845 590652 591246 592240 601639 605978 606859 606999 608826 610862 627981 628678 629549 630696 637159 637986 638157 640166 647915 648411 650688 651768 670720 671239 676659 685394 685411 685415 686305 690027 692548 702351 703702 707542 708915 712142 712226 712673 714164 714947 714965 720811 724573 725538 726899 727724 732850 733097 734189 734358 734672 735980 738541 739604 745598 750169 750815 751247 757092 758090 759138 759552 760317 761944 762298 764245 766380 768101 768570 769559 772550 775543 776018 778083 778110 781363 782122 785125 790786 793814 794338 795249 795335 795719 796233 796837 797188 801783 801820 804297 804482 805788 806240 810891 812541 813836 816693 817342 817996 818926 820113 820159 823602 823757 823950 ] |
||||||||||||||||||||||||||||||
|
13.35 ms (7.96%) |
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 690027 671239 685394 685415 692548 651768 676659 685411 686305 712673 720811 546367 582729 592240 610862 637159 605978 627981 628678 637986 587845 590652 591246 601639 778083 785125 796233 796837 797188 801820 804482 775543 776018 790786 795249 806240 734672 750815 762298 768101 772550 781363 793814 795335 801783 812541 734358 751247 759138 726899 745598 750169 725538 735980 766380 768570 724573 738541 757092 759552 764245 608826 629549 638157 703702 708915 714164 714965 777182 778110 794338 804297 482947 820159 670720 647915 712142 650688 606999 630696 606859 640166 782122 805788 761944 758090 707542 530453 712226 727724 769559 57971 810891 734189 258915 535602 648411 714947 795719 732850 733097 739604 702351 479068 571506 760317 241269 331382 816693 817996 823757 823950 813836 817342 818926 823602 820113 479744 485389 481986 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.98%) |
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 57971 241269 258915 331382 479068 479744 481986 482947 485389 530453 535602 546367 571506 582729 587845 590652 591246 592240 601639 605978 606859 606999 608826 610862 627981 628678 629549 630696 637159 637986 638157 640166 647915 648411 650688 651768 670720 671239 676659 685394 685411 685415 686305 690027 692548 702351 703702 707542 708915 712142 712226 712673 714164 714947 714965 720811 724573 725538 726899 727724 732850 733097 734189 734358 734672 735980 738541 739604 745598 750169 750815 751247 757092 758090 759138 759552 760317 761944 762298 764245 766380 768101 768570 769559 772550 775543 776018 778083 778110 781363 782122 785125 790786 793814 794338 795249 795335 795719 796233 796837 797188 801783 801820 804297 804482 805788 806240 810891 812541 813836 816693 817342 817996 818926 820113 820159 823602 823757 823950 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен home"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife home"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен home"
]
|
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.