Query Metrics
7
Database Queries
7
Different statements
202.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.27 ms (85.58%) |
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 419267 425474 432618 432690 432732 441269 442144 445061 448096 450215 451827 452153 455237 465302 466834 467093 467627 475993 486288 489005 491584 494221 495364 497653 501968 507083 508166 511552 514776 521490 523641 526457 529214 529526 529948 530574 530886 543970 554248 554387 554455 557071 559846 564924 565780 565784 565909 568114 572828 573222 574153 574418 578041 580053 580292 583096 583207 585989 587136 587338 587755 588516 589094 592197 595025 596363 607328 613778 615538 615548 617441 623841 626280 626432 627708 628289 629543 638917 644729 645317 650197 675633 677821 678188 682259 720042 738066 763046 764307 765736 766818 769797 770964 771891 773524 775405 776164 776614 776894 776988 779955 780430 780592 784742 787065 790862 791351 792569 796301 796938 797859 805175 805181 810890 810967 812827 812850 813142 813273 813282 ] |
||||||||||||||||||||||||||||||
|
18.74 ms (9.25%) |
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 455237 467093 489005 491584 511552 523641 529526 529948 507083 529214 494221 526457 530886 565784 580053 543970 554455 557071 564924 568114 573222 574418 580292 583096 677821 682259 720042 645317 650197 678188 554248 554387 559846 565780 583207 587136 589094 595025 607328 613778 615538 638917 587338 588516 615548 623841 644729 585989 596363 627708 776988 779955 780592 784742 810890 810967 776614 776894 790862 796301 812827 766818 773524 787065 791351 792569 805175 813273 769797 738066 763046 771891 764307 765736 770964 626280 626432 629543 775405 776164 780430 796938 797859 805181 812850 813142 813282 432618 442144 514776 486288 495364 508166 521490 450215 451827 475993 530574 578041 565909 675633 574153 587755 592197 617441 628289 497653 419267 432732 425474 441269 445061 432690 448096 452153 501968 465302 466834 467627 572828 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.34%) |
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 419267 425474 432618 432690 432732 441269 442144 445061 448096 450215 451827 452153 455237 465302 466834 467093 467627 475993 486288 489005 491584 494221 495364 497653 501968 507083 508166 511552 514776 521490 523641 526457 529214 529526 529948 530574 530886 543970 554248 554387 554455 557071 559846 564924 565780 565784 565909 568114 572828 573222 574153 574418 578041 580053 580292 583096 583207 585989 587136 587338 587755 588516 589094 592197 595025 596363 607328 613778 615538 615548 617441 623841 626280 626432 627708 628289 629543 638917 644729 645317 650197 675633 677821 678188 682259 720042 738066 763046 764307 765736 766818 769797 770964 771891 773524 775405 776164 776614 776894 776988 779955 780430 780592 784742 787065 790862 791351 792569 796301 796938 797859 805175 805181 810890 810967 812827 812850 813142 813273 813282 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская пов"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina pov"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
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.