Query Metrics
7
Database Queries
7
Different statements
130.42 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.73 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.43 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"внутр"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.15 ms |
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 555797 573760 578552 578790 693954 555847 569110 616673 585454 605391 594560 615721 616396 606935 734437 766738 782385 797462 616094 632818 804619 470251 480987 484233 498483 522678 528751 456484 533390 536451 503097 526913 486162 553000 545849 552955 559779 580769 552659 552680 687094 697006 583148 588288 628727 626595 610958 474264 510371 513558 525786 527315 501259 514214 537250 485055 552664 720072 553096 555821 631468 591749 624041 791738 723994 422958 532739 521515 525626 555798 545851 575169 563026 598233 607027 627097 498722 527425 580714 547651 597919 540572 521002 527011 552623 607329 523253 ] |
||||||||||||||||||||||||||||||
| 4 | 3.20 ms |
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 422958 456484 470251 474264 480987 484233 485055 486162 498483 498722 501259 503097 510371 513558 514214 521002 521515 522678 523253 525626 525786 526913 527011 527315 527425 528751 532739 533390 536451 537250 540572 545849 545851 547651 552623 552659 552664 552680 552955 553000 553096 555797 555798 555821 555847 559779 563026 569110 573760 575169 578552 578790 580714 580769 583148 585454 588288 591749 594560 597919 598233 605391 606935 607027 607329 610958 615721 616094 616396 616673 624041 626595 627097 628727 631468 632818 687094 693954 697006 720072 723994 734437 766738 782385 791738 797462 804619 ] |
||||||||||||||||||||||||||||||
| 5 | 103.52 ms |
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 422958 456484 470251 474264 480987 484233 485055 486162 498483 498722 501259 503097 510371 513558 514214 521002 521515 522678 523253 525626 525786 526913 527011 527315 527425 528751 532739 533390 536451 537250 540572 545849 545851 547651 552623 552659 552664 552680 552955 553000 553096 555797 555798 555821 555847 559779 563026 569110 573760 575169 578552 578790 580714 580769 583148 585454 588288 591749 594560 597919 598233 605391 606935 607027 607329 610958 615721 616094 616396 616673 624041 626595 627097 628727 631468 632818 687094 693954 697006 720072 723994 734437 766738 782385 791738 797462 804619 ] |
||||||||||||||||||||||||||||||
| 6 | 1.71 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"внутр"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.69 ms |
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.