Query Metrics
7
Database Queries
7
Different statements
205.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.28 ms (84.83%) |
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 401904 410807 412875 414292 417934 419063 420418 428487 435515 435958 437789 438987 443269 446611 446678 448744 452477 453614 453669 454396 457308 458285 458427 462724 469648 473939 476478 476553 485229 485996 486802 486892 489594 496013 496910 504488 504837 507017 508519 513198 513351 513384 513757 514005 516060 519505 519701 520035 522453 522521 523977 524509 526274 526280 533138 536889 538022 542526 544102 551564 558418 561067 562147 565251 565283 567041 567358 574162 575178 578512 578812 582243 582270 584748 587292 588281 589202 589407 592854 596643 598201 600978 601887 605989 606225 611559 613558 619286 619535 620818 621729 623334 623930 624802 626388 627419 643660 650955 666816 676808 697006 705160 720047 721895 744844 747649 760169 761602 766625 771845 788252 788566 788886 789583 790019 792018 794214 805439 806247 813346 ] |
||||||||||||||||||||||||||||||
|
20.90 ms (10.17%) |
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 705160 666816 676808 720047 721895 567041 578512 582243 582270 589407 592854 598201 619286 606225 624802 589202 613558 587292 627419 643660 792018 805439 788252 788566 806247 813346 760169 789583 744844 747649 761602 771845 620818 410807 443269 448744 453614 457308 469648 417934 420418 446678 473939 401904 412875 419063 437789 446611 458285 476478 476553 435958 438987 454396 462724 513198 522453 533138 538022 513351 489594 496013 514005 519505 520035 522521 486892 496910 504837 513384 524509 428487 414292 435515 458427 486802 507017 526274 513757 508519 516060 504488 519701 523977 526280 536889 485229 485996 542526 544102 565283 551564 558418 567358 574162 562147 575178 584748 650955 697006 561067 565251 578812 588281 600978 626388 623930 596643 605989 601887 619535 788886 790019 794214 766625 611559 621729 623334 452477 453669 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.56%) |
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 401904 410807 412875 414292 417934 419063 420418 428487 435515 435958 437789 438987 443269 446611 446678 448744 452477 453614 453669 454396 457308 458285 458427 462724 469648 473939 476478 476553 485229 485996 486802 486892 489594 496013 496910 504488 504837 507017 508519 513198 513351 513384 513757 514005 516060 519505 519701 520035 522453 522521 523977 524509 526274 526280 533138 536889 538022 542526 544102 551564 558418 561067 562147 565251 565283 567041 567358 574162 575178 578512 578812 582243 582270 584748 587292 588281 589202 589407 592854 596643 598201 600978 601887 605989 606225 611559 613558 619286 619535 620818 621729 623334 623930 624802 626388 627419 643660 650955 666816 676808 697006 705160 720047 721895 744844 747649 760169 761602 766625 771845 788252 788566 788886 789583 790019 792018 794214 805439 806247 813346 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сам"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"саме"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.71%) |
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.