Query Metrics
7
Database Queries
7
Different statements
159.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.74 ms (82.99%) |
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 396388 511321 534192 562392 563838 617104 618797 626440 639919 672693 675447 686091 691763 700076 701215 702358 704165 709412 712486 712576 713410 716645 717982 718609 725545 730033 731407 733736 734732 734753 735812 736167 736288 736497 736755 738875 739785 747813 748058 748983 749536 749887 750671 752816 753179 756366 757902 757923 758914 766187 767243 767411 767929 768789 769046 770075 770616 773170 773316 777483 777630 777636 777690 777962 778162 778708 778871 778948 779407 779582 779944 781538 782164 787045 789116 789135 790057 790321 791254 791767 792114 792449 792496 793576 794865 794932 796791 798921 799251 799541 799552 800279 800280 802010 803567 803986 804834 806858 812456 813323 813965 813981 813983 816636 816770 817839 817988 818192 821003 824249 824284 824714 825297 825369 825423 826335 826647 827649 ] |
||||||||||||||||||||||||||||||
|
16.57 ms (10.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 777690 778948 792496 803567 736167 748058 750671 770616 773537 791767 768789 769046 734753 735812 767243 787045 793576 826335 824714 511321 562392 712576 713410 672693 702358 617104 778162 800280 777483 794865 725545 753179 770075 749536 733736 736755 739785 752816 757902 756366 626440 700076 778708 792449 825423 826647 816636 821003 825369 816770 824249 825928 813965 813983 817988 824284 827649 534192 563838 675447 701215 718609 691763 704165 779407 790321 796791 789116 790057 791254 794932 799251 800279 804834 812456 813323 758914 767411 767929 773170 781538 782164 789135 803986 806858 736288 757923 734732 736497 738875 747813 766187 748983 749887 773316 777636 777962 779944 798921 799541 799552 802010 618797 396388 818192 716645 792114 731407 813981 825297 817839 717982 712486 686091 709412 639919 778871 779582 777630 730033 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.05%) |
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 396388 511321 534192 562392 563838 617104 618797 626440 639919 672693 675447 686091 691763 700076 701215 702358 704165 709412 712486 712576 713410 716645 717982 718609 725545 730033 731407 733736 734732 734753 735812 736167 736288 736497 736755 738875 739785 747813 748058 748983 749536 749887 750671 752816 753179 756366 757902 757923 758914 766187 767243 767411 767929 768789 769046 770075 770616 773170 773316 777483 777630 777636 777690 777962 778162 778708 778871 778948 779407 779582 779944 781538 782164 787045 789116 789135 790057 790321 791254 791767 792114 792449 792496 793576 794865 794932 796791 798921 799251 799541 799552 800279 800280 802010 803567 803986 804834 806858 812456 813323 813965 813981 813983 816636 816770 817839 817988 818192 821003 824249 824284 824714 825297 825369 825423 826335 826647 827649 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex with stepsister"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс stepsister"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс stepsister"
]
|
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.