Query Metrics
7
Database Queries
7
Different statements
200.72 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.73 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.21 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"селена"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.55 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 483392 502819 515126 476399 560486 655087 653463 582189 590427 445934 524992 517768 554519 573234 654617 657296 659842 637243 595498 474000 430697 520573 568610 652197 668033 569885 621515 594869 597124 618924 597013 603150 491776 544296 551012 559050 563007 580296 561137 577658 654399 663930 668140 574258 609845 611739 591674 604158 622932 597542 636869 598475 598604 608106 608926 617039 443320 517008 521989 494617 517651 514093 574527 543842 555870 577403 584704 614273 624215 596500 598806 623692 475891 481310 485204 486336 535016 507596 541871 674762 593372 643316 528075 ] |
||||||||||||||||||||||||||||||
| 4 | 2.52 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 430697 443320 445934 474000 475891 476399 481310 483392 485204 486336 491776 494617 502819 507596 514093 515126 517008 517651 517768 520573 521989 524992 528075 535016 541871 543842 544296 551012 554519 555870 559050 560486 561137 563007 568610 569885 573234 574258 574527 577403 577658 580296 582189 584704 590427 591674 593372 594869 595498 596500 597013 597124 597542 598475 598604 598806 603150 604158 608106 608926 609845 611739 614273 617039 618924 621515 622932 623692 624215 636869 637243 643316 652197 653463 654399 654617 655087 657296 659842 663930 668033 668140 674762 ] |
||||||||||||||||||||||||||||||
| 5 | 170.86 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 430697 443320 445934 474000 475891 476399 481310 483392 485204 486336 491776 494617 502819 507596 514093 515126 517008 517651 517768 520573 521989 524992 528075 535016 541871 543842 544296 551012 554519 555870 559050 560486 561137 563007 568610 569885 573234 574258 574527 577403 577658 580296 582189 584704 590427 591674 593372 594869 595498 596500 597013 597124 597542 598475 598604 598806 603150 604158 608106 608926 609845 611739 614273 617039 618924 621515 622932 623692 624215 636869 637243 643316 652197 653463 654399 654617 655087 657296 659842 663930 668033 668140 674762 ] |
||||||||||||||||||||||||||||||
| 6 | 2.09 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сел"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.77 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.