Query Metrics
7
Database Queries
7
Different statements
184.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.70 ms (86.55%) |
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 12090 13229 16744 24289 24724 29242 31134 32874 34645 37495 38637 56639 67112 96862 101841 111630 116603 122554 123554 129791 131975 145053 150507 154497 170942 185011 186988 187819 191336 191361 191509 191599 194903 200708 205205 207775 214139 214663 232973 233862 239542 266184 308331 318318 335196 382202 382213 382344 382362 382746 382943 383088 383592 384232 384520 384872 384888 385342 385605 385851 386092 386648 386778 386879 387723 387953 388121 388149 388519 388951 389385 389594 391221 392459 393469 393694 393701 394190 394282 395275 395428 395504 396242 396543 396697 396859 396954 397170 397255 397307 397808 397851 397927 398260 398674 399405 399757 401925 410056 417879 417884 419126 421259 425866 451497 540497 544342 549369 552049 560070 560090 587026 612062 619211 630861 634492 667160 688675 698526 809487 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (7.95%) |
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 382344 389385 233862 396242 111630 417884 401925 397307 417879 549369 612062 630861 194903 101841 397851 391221 397808 382943 145053 214139 32874 16744 388519 387723 540497 395504 384872 308331 382213 24724 131975 388149 419126 560090 552049 688675 187819 191361 451497 383088 383592 154497 191336 185011 395275 34645 31134 387953 398260 399757 619211 809487 38637 116603 200708 232973 388121 394190 37495 386778 382202 56639 667160 587026 122554 335196 191509 266184 205205 393694 396543 123554 129791 382362 386648 385851 67112 150507 186988 170942 29242 388951 389594 399405 425866 560070 397255 239542 393469 396859 13229 385605 394282 318318 12090 386879 634492 207775 421259 384520 385342 24289 396697 396954 397927 544342 698526 96862 384232 398674 397170 410056 386092 382746 384888 214663 191599 393701 392459 395428 ] |
||||||||||||||||||||||||||||||
|
3.42 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 12090 13229 16744 24289 24724 29242 31134 32874 34645 37495 38637 56639 67112 96862 101841 111630 116603 122554 123554 129791 131975 145053 150507 154497 170942 185011 186988 187819 191336 191361 191509 191599 194903 200708 205205 207775 214139 214663 232973 233862 239542 266184 308331 318318 335196 382202 382213 382344 382362 382746 382943 383088 383592 384232 384520 384872 384888 385342 385605 385851 386092 386648 386778 386879 387723 387953 388121 388149 388519 388951 389385 389594 391221 392459 393469 393694 393701 394190 394282 395275 395428 395504 396242 396543 396697 396859 396954 397170 397255 397307 397808 397851 397927 398260 398674 399405 399757 401925 410056 417879 417884 419126 421259 425866 451497 540497 544342 549369 552049 560070 560090 587026 612062 619211 630861 634492 667160 688675 698526 809487 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex muscle"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мускулистые"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.79%) |
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.