Query Metrics
7
Database Queries
7
Different statements
125.81 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.72 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"розовое платье"
]
|
||||||||||||||||||||||||||||||
| 3 | 10.91 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 525541 528596 496821 498643 505939 527160 685469 408659 474720 480375 527226 536625 519503 583397 576658 581063 583581 672418 675897 669218 675723 546878 559687 584656 592004 586940 622983 395276 516246 513846 504365 515276 491220 501866 602658 401321 442026 482775 540346 517391 488817 550742 583681 686710 582218 591668 597083 624000 611916 400958 453501 494710 469288 526148 484410 557128 570743 574492 550300 578774 607325 462307 511178 518827 568053 561241 599979 588473 618931 621352 461503 484880 603776 597042 466088 513761 546125 563158 611369 488811 671403 606948 604375 602734 532028 533348 624270 613204 496564 ] |
||||||||||||||||||||||||||||||
| 4 | 2.63 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 395276 400958 401321 408659 442026 453501 461503 462307 466088 469288 474720 480375 482775 484410 484880 488811 488817 491220 494710 496564 496821 498643 501866 504365 505939 511178 513761 513846 515276 516246 517391 518827 519503 525541 526148 527160 527226 528596 532028 533348 536625 540346 546125 546878 550300 550742 557128 559687 561241 563158 568053 570743 574492 576658 578774 581063 582218 583397 583581 583681 584656 586940 588473 591668 592004 597042 597083 599979 602658 602734 603776 604375 606948 607325 611369 611916 613204 618931 621352 622983 624000 624270 669218 671403 672418 675723 675897 685469 686710 ] |
||||||||||||||||||||||||||||||
| 5 | 105.28 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 395276 400958 401321 408659 442026 453501 461503 462307 466088 469288 474720 480375 482775 484410 484880 488811 488817 491220 494710 496564 496821 498643 501866 504365 505939 511178 513761 513846 515276 516246 517391 518827 519503 525541 526148 527160 527226 528596 532028 533348 536625 540346 546125 546878 550300 550742 557128 559687 561241 563158 568053 570743 574492 576658 578774 581063 582218 583397 583581 583681 584656 586940 588473 591668 592004 597042 597083 599979 602658 602734 603776 604375 606948 607325 611369 611916 613204 618931 621352 622983 624000 624270 669218 671403 672418 675723 675897 685469 686710 ] |
||||||||||||||||||||||||||||||
| 6 | 1.88 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"розов плат"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.52 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.