Query Metrics
7
Database Queries
7
Different statements
169.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.22 ms (85.67%) |
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 559753 560132 566911 575675 578926 584199 584741 585275 585569 585755 587711 587729 587943 588095 588557 588609 588767 588861 589203 590173 590206 590472 590492 590916 590917 591160 591189 591329 591539 591641 591907 592093 592591 592788 592793 592900 593068 593191 593793 593910 593977 594024 594030 594095 594166 595046 595634 595715 595883 596530 596945 596999 597031 597145 597581 597672 597713 597807 598230 598462 598914 598965 599783 600476 600487 600488 600737 600768 601067 601498 601543 602450 602509 602652 602701 603019 603181 603261 603363 603398 604434 604490 604720 604754 604802 605118 605619 605887 606008 607359 607830 609436 610074 611351 613810 615284 615488 615924 616012 616822 616824 617122 617441 619059 620531 622103 622317 623288 624768 625089 626287 626858 627706 629855 632734 634276 634468 635697 636819 644359 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (8.02%) |
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 559753 560132 566911 575675 578926 584199 584741 585275 585569 588095 591641 592591 595046 595634 597581 598965 600737 602652 605619 606008 607830 610074 615284 616822 617122 622103 624768 634468 636819 585755 587943 588767 588861 590472 590916 591189 591539 591907 592793 593068 593191 593977 597713 597807 598462 600768 601498 602450 602509 602701 604434 604490 604720 611351 615924 616012 619059 632734 634276 644359 589203 590173 590492 590917 591160 591329 593910 594030 594166 595715 597145 598230 598914 600476 600487 601067 603019 603261 603363 603398 604754 604802 605118 607359 616824 620531 623288 625089 626287 626858 627706 629855 635697 587711 587729 588557 588609 590206 592093 592788 592900 593793 594024 594095 595883 596530 596945 596999 597031 597672 599783 600488 601543 603181 605887 609436 613810 615488 617441 622317 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.55%) |
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 559753 560132 566911 575675 578926 584199 584741 585275 585569 585755 587711 587729 587943 588095 588557 588609 588767 588861 589203 590173 590206 590472 590492 590916 590917 591160 591189 591329 591539 591641 591907 592093 592591 592788 592793 592900 593068 593191 593793 593910 593977 594024 594030 594095 594166 595046 595634 595715 595883 596530 596945 596999 597031 597145 597581 597672 597713 597807 598230 598462 598914 598965 599783 600476 600487 600488 600737 600768 601067 601498 601543 602450 602509 602652 602701 603019 603181 603261 603363 603398 604434 604490 604720 604754 604802 605118 605619 605887 606008 607359 607830 609436 610074 611351 613810 615284 615488 615924 616012 616822 616824 617122 617441 619059 620531 622103 622317 623288 624768 625089 626287 626858 627706 629855 632734 634276 634468 635697 636819 644359 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосет и дрочит"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосет дрочк"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.