Query Metrics
7
Database Queries
7
Different statements
148.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.33 ms (81.82%) |
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 35344 188169 206202 383436 391559 392466 395706 396168 396691 396877 398595 401134 402592 405315 407810 409100 411175 411682 412227 414021 416044 425304 430313 431776 432157 437346 439564 439582 439620 439656 439664 439726 444834 445200 447258 447560 456193 456697 457140 459527 465805 468608 472551 474631 482211 482824 487729 492256 494567 495148 507785 508438 509025 512549 520445 520986 521059 523579 525011 543863 549569 551913 552083 561304 564407 571999 581668 582236 585023 586463 594916 600623 603627 619189 620025 621467 621767 623143 624835 632028 647937 649154 683889 683945 684017 688604 692382 703955 706909 716834 718798 722653 722823 724186 727526 734146 737719 749338 753260 755406 758615 764582 771180 793762 804180 806308 806420 807551 807772 810689 811133 815592 816584 818644 819611 820158 821026 821745 825812 826764 ] |
||||||||||||||||||||||||||||||
|
17.12 ms (11.55%) |
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 392466 647937 621467 718798 457140 764582 551913 468608 396168 430313 487729 825812 621767 407810 456697 439620 432157 508438 512549 383436 561304 445200 444834 439582 465805 439656 552083 734146 806308 447560 482211 520445 396877 472551 683889 456193 582236 395706 603627 811133 474631 411682 439564 431776 459527 793762 683945 688604 411175 416044 507785 188169 716834 819611 684017 753260 543863 724186 758615 409100 439726 520986 437346 525011 447258 439664 816584 818644 405315 820158 623143 594916 722823 564407 521059 549569 585023 821026 581668 624835 737719 749338 771180 755406 807551 396691 414021 509025 391559 495148 492256 494567 35344 810689 206202 706909 412227 815592 826764 821745 692382 722653 600623 620025 586463 619189 806420 804180 807772 727526 703955 402592 398595 632028 401134 523579 571999 649154 425304 482824 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.85%) |
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 35344 188169 206202 383436 391559 392466 395706 396168 396691 396877 398595 401134 402592 405315 407810 409100 411175 411682 412227 414021 416044 425304 430313 431776 432157 437346 439564 439582 439620 439656 439664 439726 444834 445200 447258 447560 456193 456697 457140 459527 465805 468608 472551 474631 482211 482824 487729 492256 494567 495148 507785 508438 509025 512549 520445 520986 521059 523579 525011 543863 549569 551913 552083 561304 564407 571999 581668 582236 585023 586463 594916 600623 603627 619189 620025 621467 621767 623143 624835 632028 647937 649154 683889 683945 684017 688604 692382 703955 706909 716834 718798 722653 722823 724186 727526 734146 737719 749338 753260 755406 758615 764582 771180 793762 804180 806308 806420 807551 807772 810689 811133 815592 816584 818644 819611 820158 821026 821745 825812 826764 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade young deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск young глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск young глубокийминет минет оральн секс"
]
|
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.