Query Metrics
7
Database Queries
7
Different statements
150.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.92 ms (80.31%) |
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 13913 130045 177261 385389 394773 401616 408138 419738 427946 428114 432704 432727 441789 443984 445644 448838 450455 451849 454535 454540 457480 458420 464202 466834 468369 469373 470411 474743 474756 474872 480283 481470 485125 488743 496802 503269 507041 512818 531929 533929 536640 540478 545166 550900 560949 567340 576590 585726 586917 593562 604306 630651 650179 660422 671389 680435 680756 703471 703481 709594 709723 724844 726839 727501 729115 732272 733548 735017 736741 740874 746486 758502 760249 761017 762813 764757 765355 766650 766888 767024 767159 767192 767269 776913 789953 794124 796140 796149 797728 801240 801318 801618 804803 805439 806201 809291 810278 810470 811014 811728 812988 814240 814249 814471 814582 814849 815912 816046 816887 817383 820052 820345 820550 820707 821377 822424 823466 824177 824227 824915 ] |
||||||||||||||||||||||||||||||
|
18.48 ms (12.27%) |
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 454535 458420 512818 445644 432704 488743 814849 451849 660422 709723 805439 804803 13913 822424 824177 536640 507041 468369 824227 823466 531929 630651 593562 811728 801618 746486 761017 485125 814249 821377 820052 703481 545166 811014 776913 801318 733548 724844 766888 767024 767192 810278 810470 427946 560949 760249 567340 550900 709594 796149 806201 727501 789953 796140 797728 740874 766650 765355 767159 767269 703471 177261 394773 469373 464202 586917 474743 474756 428114 432727 474872 470411 457480 466834 441789 503269 650179 480283 408138 585726 732272 736741 758502 735017 533929 401616 801240 726839 540478 496802 443984 448838 481470 450455 454540 809291 419738 385389 824915 816887 820345 820707 671389 680756 680435 576590 812988 794124 762813 729115 764757 604306 130045 814471 817383 814240 816046 820550 814582 815912 ] |
||||||||||||||||||||||||||||||
|
3.03 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 13913 130045 177261 385389 394773 401616 408138 419738 427946 428114 432704 432727 441789 443984 445644 448838 450455 451849 454535 454540 457480 458420 464202 466834 468369 469373 470411 474743 474756 474872 480283 481470 485125 488743 496802 503269 507041 512818 531929 533929 536640 540478 545166 550900 560949 567340 576590 585726 586917 593562 604306 630651 650179 660422 671389 680435 680756 703471 703481 709594 709723 724844 726839 727501 729115 732272 733548 735017 736741 740874 746486 758502 760249 761017 762813 764757 765355 766650 766888 767024 767159 767192 767269 776913 789953 794124 796140 796149 797728 801240 801318 801618 804803 805439 806201 809291 810278 810470 811014 811728 812988 814240 814249 814471 814582 814849 815912 816046 816887 817383 820052 820345 820550 820707 821377 822424 823466 824177 824227 824915 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature latina anal"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature латинская анал"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature латинская анал"
]
|
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.