Query Metrics
7
Database Queries
7
Different statements
200.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.22 ms (89.03%) |
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 538873 540076 541376 541586 541624 542493 542960 543725 543825 544571 546614 547431 548679 549296 549762 549778 550236 551020 556597 556794 556842 557322 558801 559012 559122 560083 560088 560381 560627 562844 563462 565446 566158 566244 566354 566475 566641 566649 566673 566675 566684 566886 567396 567398 567403 567407 567755 568266 568304 569480 569858 569915 570003 570021 570043 570332 570669 571650 572579 572582 572603 572766 573114 573908 574558 575424 576626 576655 576711 577346 577358 577381 581380 581401 583851 583872 583882 586813 587472 589204 589747 592395 592450 592451 592514 592515 592522 592526 595842 596336 598058 599011 603161 605325 605333 605342 606413 620141 621025 627061 629009 644330 649150 649153 651951 652187 652876 654089 669570 670103 672138 677705 685263 694160 694553 694554 706899 719137 736405 743063 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (6.30%) |
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 566158 566673 567755 541624 542493 566244 652876 654089 649150 651951 685263 694160 694553 719137 566649 567398 568266 571650 572582 576626 577346 606413 736405 743063 620141 546614 589747 538873 540076 541376 543725 543825 556597 556842 557322 558801 560381 567396 567403 570043 570332 572603 575424 577358 577381 583851 583882 541586 548679 559012 559122 565446 566684 566886 569858 572766 573114 547431 549296 549762 556794 566354 566475 567407 568304 570669 576655 581380 649153 652187 672138 677705 694554 669570 670103 551020 562844 563462 570003 570021 572579 573908 574558 583872 589204 592450 596336 598058 605325 605342 586813 592395 595842 599011 603161 587472 592451 592515 592522 592526 621025 605333 627061 629009 644330 706899 542960 576711 592514 581401 544571 549778 550236 560083 560088 560627 566641 566675 569480 569915 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.28%) |
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 538873 540076 541376 541586 541624 542493 542960 543725 543825 544571 546614 547431 548679 549296 549762 549778 550236 551020 556597 556794 556842 557322 558801 559012 559122 560083 560088 560381 560627 562844 563462 565446 566158 566244 566354 566475 566641 566649 566673 566675 566684 566886 567396 567398 567403 567407 567755 568266 568304 569480 569858 569915 570003 570021 570043 570332 570669 571650 572579 572582 572603 572766 573114 573908 574558 575424 576626 576655 576711 577346 577358 577381 581380 581401 583851 583872 583882 586813 587472 589204 589747 592395 592450 592451 592514 592515 592522 592526 595842 596336 598058 599011 603161 605325 605333 605342 606413 620141 621025 627061 629009 644330 649150 649153 651951 652187 652876 654089 669570 670103 672138 677705 685263 694160 694553 694554 706899 719137 736405 743063 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр худые"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro skinny"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр худые"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.73%) |
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.