Query Metrics
7
Database Queries
7
Different statements
206.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.01 ms (82.47%) |
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 251476 384789 384856 386285 386653 388838 393737 393745 393750 393762 393770 393779 394233 394247 396564 396757 400418 400422 400435 400452 400903 402081 402093 402094 412957 413208 413228 430275 445040 453553 455180 461906 462961 463161 463166 464282 464315 466154 467296 470846 473913 473928 474060 475453 480420 488004 494369 515136 515195 520300 520727 522566 523265 525671 538868 545521 566144 566986 569672 569676 569678 569684 569687 569690 569784 570050 570062 570064 570069 570071 570076 570077 578477 580237 597574 605610 663955 663975 665287 676453 681187 693073 693075 693076 700660 701488 702852 708807 709639 722670 722706 735480 737673 740610 741650 743082 743139 744312 744314 744324 745818 747858 748145 759405 759581 759599 766578 767956 775383 777345 780713 788471 788647 789212 794702 807638 812127 812143 816232 826097 ] |
||||||||||||||||||||||||||||||
|
25.16 ms (12.20%) |
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 470846 453553 412957 473928 709639 475453 812127 566144 580237 676453 794702 759599 741650 788647 445040 748145 461906 693073 569687 466154 735480 780713 816232 826097 747858 743082 566986 807638 722706 570077 538868 777345 393745 665287 681187 745818 393750 394233 578477 570076 400452 605610 488004 569684 473913 455180 766578 400422 744312 515195 545521 386285 515136 570071 693075 788471 700660 569672 393779 413208 396564 494369 463161 759581 767956 569678 393762 569690 597574 812143 463166 522566 569676 570062 388838 413228 474060 393737 480420 462961 464315 570069 722670 708807 789212 402081 570050 520727 525671 393770 744324 251476 663955 663975 759405 775383 402094 743139 520300 701488 744314 570064 430275 400418 400903 402093 400435 384789 740610 737673 386653 396757 394247 702852 384856 464282 523265 693076 467296 569784 ] |
||||||||||||||||||||||||||||||
|
3.80 ms (1.84%) |
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 251476 384789 384856 386285 386653 388838 393737 393745 393750 393762 393770 393779 394233 394247 396564 396757 400418 400422 400435 400452 400903 402081 402093 402094 412957 413208 413228 430275 445040 453553 455180 461906 462961 463161 463166 464282 464315 466154 467296 470846 473913 473928 474060 475453 480420 488004 494369 515136 515195 520300 520727 522566 523265 525671 538868 545521 566144 566986 569672 569676 569678 569684 569687 569690 569784 570050 570062 570064 570069 570071 570076 570077 578477 580237 597574 605610 663955 663975 665287 676453 681187 693073 693075 693076 700660 701488 702852 708807 709639 722670 722706 735480 737673 740610 741650 743082 743139 744312 744314 744324 745818 747858 748145 759405 759581 759599 766578 767956 775383 777345 780713 788471 788647 789212 794702 807638 812127 812143 816232 826097 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob old man"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс old мужчин"
]
|
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.