Query Metrics
7
Database Queries
7
Different statements
163.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.95 ms (84.77%) |
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 4252 13954 24855 69063 157194 157617 172291 172752 185401 187928 193837 233369 233710 285923 287436 330715 351216 382613 383224 383377 383912 384488 386787 387296 389440 390929 391077 391483 391590 391910 392076 392600 392750 393441 395643 395901 395934 395988 396424 396907 397222 397619 397874 400151 400820 404598 405114 408218 409774 411397 411752 411762 411790 411854 413650 418957 419846 426389 428512 428522 432338 442997 443806 446249 446291 446384 453633 454178 455448 457218 460736 460744 461504 462466 464391 464561 466026 469402 469486 470029 470917 471402 473954 474398 475080 477985 484640 484643 489457 489958 514757 518928 519153 526749 535722 542781 550434 563207 564542 598988 601904 629837 654777 663987 665508 697704 721498 723112 725401 728451 746890 760851 768079 780560 788571 788872 789532 792215 806959 818660 ] |
||||||||||||||||||||||||||||||
|
14.91 ms (9.10%) |
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 396907 400151 405114 408218 413650 428512 475080 519153 157194 389440 442997 443806 446291 462466 470029 471402 390929 400820 454178 514757 526749 484640 550434 535722 654777 768079 601904 489958 383224 193837 185401 172752 393441 391590 392076 395901 395934 285923 330715 69063 4252 13954 387296 396424 397222 418957 426389 419846 411752 818660 446249 469486 457218 453633 469402 474398 542781 721498 665508 697704 663987 723112 563207 598988 629837 788571 792215 780560 788872 789532 746890 725401 728451 806959 233710 411762 473954 477985 24855 233369 397874 432338 455448 351216 391483 392600 397619 411397 461504 172291 187928 382613 518928 404598 409774 411790 464561 464391 489457 564542 391077 411854 428522 446384 460744 466026 460736 470917 484643 760851 383377 384488 383912 386787 157617 391910 392750 395643 395988 287436 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.53%) |
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 4252 13954 24855 69063 157194 157617 172291 172752 185401 187928 193837 233369 233710 285923 287436 330715 351216 382613 383224 383377 383912 384488 386787 387296 389440 390929 391077 391483 391590 391910 392076 392600 392750 393441 395643 395901 395934 395988 396424 396907 397222 397619 397874 400151 400820 404598 405114 408218 409774 411397 411752 411762 411790 411854 413650 418957 419846 426389 428512 428522 432338 442997 443806 446249 446291 446384 453633 454178 455448 457218 460736 460744 461504 462466 464391 464561 466026 469402 469486 470029 470917 471402 473954 474398 475080 477985 484640 484643 489457 489958 514757 518928 519153 526749 535722 542781 550434 563207 564542 598988 601904 629837 654777 663987 665508 697704 721498 723112 725401 728451 746890 760851 768079 780560 788571 788872 789532 792215 806959 818660 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен парен"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy boy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 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.