Query Metrics
7
Database Queries
7
Different statements
216.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.77 ms (87.20%) |
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 3691 7390 24076 32761 135702 395788 396757 406521 419953 422064 423178 425408 426482 428089 437837 438655 442983 446139 446944 448403 449735 451556 453983 457267 457326 458431 459182 461821 469635 474053 474116 475603 475615 479381 480710 480836 485517 488816 490859 494238 494318 494680 496977 499270 503689 507208 508281 508597 510858 513013 513302 513377 514339 517028 518539 521745 525960 526129 528671 533594 539282 540139 541284 541795 542728 544857 546969 551167 551565 552341 552937 555220 555660 555991 556007 556683 557965 559024 560679 561428 563036 565414 566284 566576 576849 576942 578217 579856 581053 585284 588811 589335 590591 594980 595131 606123 613176 617543 643706 649356 651836 653287 662097 664450 670263 689804 707236 709660 732084 765918 766262 770039 778866 787916 798757 801814 801832 804422 811873 827602 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (7.43%) |
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 3691 765918 24076 496977 576849 552937 428089 664450 135702 508597 707236 525960 542728 560679 446944 480836 588811 395788 422064 494680 827602 649356 606123 643706 811873 510858 670263 651836 425408 804422 449735 494318 513377 457267 539282 517028 566284 565414 566576 766262 469635 461821 526129 540139 541795 662097 561428 442983 458431 533594 528671 474053 581053 555660 578217 590591 798757 419953 396757 475603 437837 485517 513302 494238 546969 557965 594980 787916 423178 556683 689804 479381 406521 555991 579856 457326 521745 507208 555220 7390 426482 448403 474116 446139 480710 518539 541284 552341 544857 551565 576942 556007 559024 617543 513013 488816 499270 595131 801814 770039 709660 613176 438655 459182 653287 563036 589335 778866 451556 475615 514339 32761 490859 503689 585284 801832 732084 453983 508281 551167 ] |
||||||||||||||||||||||||||||||
|
4.63 ms (2.14%) |
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 3691 7390 24076 32761 135702 395788 396757 406521 419953 422064 423178 425408 426482 428089 437837 438655 442983 446139 446944 448403 449735 451556 453983 457267 457326 458431 459182 461821 469635 474053 474116 475603 475615 479381 480710 480836 485517 488816 490859 494238 494318 494680 496977 499270 503689 507208 508281 508597 510858 513013 513302 513377 514339 517028 518539 521745 525960 526129 528671 533594 539282 540139 541284 541795 542728 544857 546969 551167 551565 552341 552937 555220 555660 555991 556007 556683 557965 559024 560679 561428 563036 565414 566284 566576 576849 576942 578217 579856 581053 585284 588811 589335 590591 594980 595131 606123 613176 617543 643706 649356 651836 653287 662097 664450 670263 689804 707236 709660 732084 765918 766262 770039 778866 787916 798757 801814 801832 804422 811873 827602 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пися туалет"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин туалет"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.70%) |
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.