Query Metrics
7
Database Queries
7
Different statements
201.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.25 ms (81.70%) |
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 29677 384368 397203 400958 401326 407783 411702 411924 413460 413534 420306 422360 428174 430134 432348 443105 443177 450786 452620 453992 454179 454223 454567 459255 460732 463177 464326 468232 471178 478075 482303 485720 485745 486613 487758 488377 488991 489102 489299 491765 496550 496553 502033 517527 518842 518856 525468 526963 536637 537521 537826 546471 549247 552061 554106 559279 561082 561293 565931 569315 570942 574398 578198 578783 580944 583352 583417 585319 587301 591265 591572 592901 592999 594561 609057 613977 614717 617380 617563 618494 638398 644030 667294 667522 697688 699753 714510 718809 719917 725239 725439 725487 731050 746329 753039 759755 768881 769506 770022 775164 782022 782481 785136 795221 795939 796811 798759 803404 807884 808016 809545 809745 810130 824530 824733 824967 825405 826499 826789 827185 ] |
||||||||||||||||||||||||||||||
|
24.90 ms (12.39%) |
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 422360 443105 525468 413460 428174 491765 468232 496550 526963 496553 536637 613977 460732 400958 454567 454179 463177 454223 518842 489299 487758 488991 552061 464326 29677 824967 826499 826789 827185 824530 824733 825405 489102 478075 471178 537521 537826 517527 580944 546471 554106 561293 570942 578783 583352 667294 697688 719917 667522 699753 718809 583417 585319 587301 591265 592901 592999 617563 591572 594561 617380 618494 809545 810130 775164 782022 798759 803404 809745 725439 731050 753039 770022 782481 795221 795939 796811 725239 725487 746329 759755 768881 769506 638398 644030 714510 785136 807884 808016 411924 397203 401326 413534 450786 502033 574398 549247 578198 565931 569315 609057 561082 614717 559279 384368 407783 420306 432348 430134 411702 443177 482303 485720 452620 453992 485745 486613 459255 488377 518856 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (1.97%) |
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 29677 384368 397203 400958 401326 407783 411702 411924 413460 413534 420306 422360 428174 430134 432348 443105 443177 450786 452620 453992 454179 454223 454567 459255 460732 463177 464326 468232 471178 478075 482303 485720 485745 486613 487758 488377 488991 489102 489299 491765 496550 496553 502033 517527 518842 518856 525468 526963 536637 537521 537826 546471 549247 552061 554106 559279 561082 561293 565931 569315 570942 574398 578198 578783 580944 583352 583417 585319 587301 591265 591572 592901 592999 594561 609057 613977 614717 617380 617563 618494 638398 644030 667294 667522 697688 699753 714510 718809 719917 725239 725439 725487 731050 746329 753039 759755 768881 769506 770022 775164 782022 782481 785136 795221 795939 796811 798759 803404 807884 808016 809545 809745 810130 824530 824733 824967 825405 826499 826789 827185 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая полная"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая полная"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"волосатая толстушка с…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.