Query Metrics
7
Database Queries
7
Different statements
207.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.54 ms (86.22%) |
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 66611 322037 328446 381795 382045 382289 384977 385398 386122 390888 391967 392807 394338 394804 395508 395511 395905 395910 401978 403393 406176 407685 409585 411243 415835 417015 417848 418900 420245 420374 421871 429565 430748 437918 439524 443182 443538 443671 445039 446088 451554 453270 453553 460747 463707 463873 464450 466160 466599 468911 470716 470939 472179 473169 475843 476272 476360 477985 481320 482563 484463 484954 485286 486314 493094 493184 511790 511871 512249 512549 512643 513326 518013 518280 518566 520004 520826 521995 522057 522847 524566 525457 528459 543790 543795 549833 551540 555903 557998 559059 559470 560452 561013 561089 561453 564213 567153 567407 567423 568283 568429 569523 574818 577138 580321 585140 586617 586761 591056 597227 601956 623967 629762 642672 649081 684462 685425 724176 731788 810765 ] |
||||||||||||||||||||||||||||||
|
19.33 ms (9.33%) |
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 468911 420374 476272 524566 443538 520826 512549 567153 395905 384977 381795 395910 429565 453553 543795 564213 569523 560452 649081 629762 586761 623967 481320 430748 445039 470716 513326 512249 520004 437918 525457 391967 418900 395511 731788 477985 392807 407685 511790 512643 386122 409585 585140 464450 451554 522847 543790 580321 555903 561089 642672 810765 724176 390888 460747 439524 521995 522057 511871 518280 421871 470939 484463 394338 322037 382045 417015 411243 493094 559470 561013 685425 577138 66611 403393 415835 443671 475843 591056 601956 484954 472179 473169 518013 486314 568283 597227 463873 476360 466599 466160 518566 528459 493184 385398 394804 395508 328446 401978 406176 417848 420245 443182 482563 463707 453270 446088 485286 551540 559059 549833 557998 567407 568429 574818 684462 561453 567423 586617 382289 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.17%) |
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 66611 322037 328446 381795 382045 382289 384977 385398 386122 390888 391967 392807 394338 394804 395508 395511 395905 395910 401978 403393 406176 407685 409585 411243 415835 417015 417848 418900 420245 420374 421871 429565 430748 437918 439524 443182 443538 443671 445039 446088 451554 453270 453553 460747 463707 463873 464450 466160 466599 468911 470716 470939 472179 473169 475843 476272 476360 477985 481320 482563 484463 484954 485286 486314 493094 493184 511790 511871 512249 512549 512643 513326 518013 518280 518566 520004 520826 521995 522057 522847 524566 525457 528459 543790 543795 549833 551540 555903 557998 559059 559470 560452 561013 561089 561453 564213 567153 567407 567423 568283 568429 569523 574818 577138 580321 585140 586617 586761 591056 597227 601956 623967 629762 642672 649081 684462 685425 724176 731788 810765 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн young"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen young"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн young"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.