Query Metrics
7
Database Queries
7
Different statements
184.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.46 ms (87.87%) |
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 5537 50436 387315 411768 464192 468622 514316 516470 528279 531025 532822 534526 537542 537568 537728 539175 547325 549929 549940 552760 563348 565811 570787 572899 574210 581330 584883 591525 600277 603322 605021 605035 611905 613832 613990 626627 628030 644338 652248 652262 654712 654818 656022 657972 658092 658415 658562 658736 659666 659721 659814 661906 664137 667100 667681 669578 670777 672743 686491 693043 693934 698477 701050 706864 708662 712214 712806 713060 715095 720540 721892 723100 731754 732845 735340 736772 741914 743141 743164 743251 744350 744805 745296 745559 749025 750338 752908 753371 753630 753848 754482 756108 757060 757791 768529 770040 775230 776466 776944 784895 785888 789327 804574 808483 809528 814450 823137 823399 823810 823924 824359 824529 826247 827453 827458 827504 828283 ] |
||||||||||||||||||||||||||||||
|
12.08 ms (6.54%) |
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 669578 776466 745559 611905 387315 828283 659666 743251 468622 565811 605035 784895 613832 823137 658736 667100 658562 659814 644338 757060 753371 741914 743141 814450 823924 537728 661906 537542 732845 824359 532822 547325 581330 664137 693043 693934 600277 628030 808483 752908 563348 753630 701050 411768 516470 698477 591525 776019 50436 823399 534526 539175 514316 552760 584883 654712 656022 658415 672743 686491 654818 657972 658092 659721 670777 708662 574210 613990 775230 744805 757791 745296 749025 756108 712214 712806 786797 823810 824529 827504 531025 549929 667681 715095 652248 652262 720540 605021 626627 603322 785888 754482 770040 744350 768529 736772 750338 735340 706864 809528 5537 827453 827458 826247 828081 570787 713060 804574 776944 753848 731754 721892 723100 789327 572899 528279 537568 549940 743164 464192 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (1.87%) |
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 5537 50436 387315 411768 464192 468622 514316 516470 528279 531025 532822 534526 537542 537568 537728 539175 547325 549929 549940 552760 563348 565811 570787 572899 574210 581330 584883 591525 600277 603322 605021 605035 611905 613832 613990 626627 628030 644338 652248 652262 654712 654818 656022 657972 658092 658415 658562 658736 659666 659721 659814 661906 664137 667100 667681 669578 670777 672743 686491 693043 693934 698477 701050 706864 708662 712214 712806 713060 715095 720540 721892 723100 731754 732845 735340 736772 741914 743141 743164 743251 744350 744805 745296 745559 749025 750338 752908 753371 753630 753848 754482 756108 757060 757791 768529 770040 775230 776466 776944 784895 785888 789327 804574 808483 809528 814450 823137 823399 823810 823924 824359 824529 826247 827453 827458 827504 828283 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short hair girl"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short hair девушк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short hair девушк"
]
|
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.