Query Metrics
7
Database Queries
7
Different statements
139.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.45 ms (85.47%) |
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 13527 15317 48366 70070 70186 70246 80370 91278 92167 135434 188600 207540 336884 336938 338316 338474 339415 377993 378109 378600 382041 382061 382422 382738 387931 389249 390974 393347 393697 393812 395246 396799 396916 398369 398679 401441 403999 407369 410328 412493 427751 458191 467578 475636 479731 483152 491270 491678 498551 509983 512975 521381 524218 532109 537574 538804 539171 542012 545012 545829 583087 598556 697560 707511 709366 710495 710901 717185 718356 719750 720153 725308 727397 739371 739618 739619 744011 744370 746623 746624 750902 752902 761416 763544 766919 768260 768349 772162 772868 775159 775162 775167 776770 777945 781774 785532 786456 791999 792251 792662 793758 803414 816680 816709 816811 817684 818576 818817 819829 819991 820728 823443 824852 825173 825223 825711 825837 827093 827330 828306 ] |
||||||||||||||||||||||||||||||
|
11.42 ms (8.17%) |
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 775167 803414 412493 135434 336884 339415 338474 407369 816811 823443 820728 583087 80370 70246 92167 475636 537574 532109 539171 479731 710495 752902 763544 746623 717185 792662 188600 48366 427751 709366 718356 720153 598556 775159 776770 777945 785532 792251 793758 761416 772162 744011 750902 739371 739618 739619 744370 727397 746624 766919 768349 772868 697560 710901 786456 791999 483152 512975 521381 542012 545829 458191 491678 509983 491270 389249 398679 401441 827330 816709 819829 825173 524218 403999 398369 393697 393812 13527 825837 818817 538804 545012 707511 725308 768260 378109 498551 336938 382041 378600 382422 70186 91278 15317 390974 396916 410328 816680 824852 827093 818576 819991 825223 467578 719750 775162 781774 395246 70070 382738 207540 393347 377993 382061 338316 387931 396799 817684 825711 828306 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.58%) |
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 13527 15317 48366 70070 70186 70246 80370 91278 92167 135434 188600 207540 336884 336938 338316 338474 339415 377993 378109 378600 382041 382061 382422 382738 387931 389249 390974 393347 393697 393812 395246 396799 396916 398369 398679 401441 403999 407369 410328 412493 427751 458191 467578 475636 479731 483152 491270 491678 498551 509983 512975 521381 524218 532109 537574 538804 539171 542012 545012 545829 583087 598556 697560 707511 709366 710495 710901 717185 718356 719750 720153 725308 727397 739371 739618 739619 744011 744370 746623 746624 750902 752902 761416 763544 766919 768260 768349 772162 772868 775159 775162 775167 776770 777945 781774 785532 786456 791999 792251 792662 793758 803414 816680 816709 816811 817684 818576 818817 819829 819991 820728 823443 824852 825173 825223 825711 825837 827093 827330 828306 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нарезку и подборку"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк подборк"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (1.00%) |
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.