Query Metrics
7
Database Queries
7
Different statements
187.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.89 ms (82.97%) |
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 172262 188338 232945 233224 233353 312831 358778 381785 383094 383377 383912 385039 385158 385469 388739 389044 389612 390293 391380 391614 391651 391652 391913 391964 393081 394206 394228 395601 395933 396014 396971 397004 397226 397911 398557 399613 400473 400519 400735 400888 401062 401190 402378 403588 404495 405114 405208 405504 405954 406593 406983 407365 407903 408969 409346 411397 411400 411408 411723 411756 411762 412273 412975 418957 421536 422199 424463 424483 428141 428830 428858 430393 434045 434066 443119 443165 443378 444113 451465 453269 454205 462706 464545 465649 466079 466155 474465 474843 475452 479025 481918 481926 482339 484582 484615 484618 485695 486535 490878 493198 511790 533609 542957 546932 546937 546951 549773 562976 563123 563207 563436 563439 567416 569967 571016 584799 586582 599353 614521 726515 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (7.68%) |
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 563207 397004 411397 444113 511790 388739 412273 428141 474465 542957 188338 385469 466155 233353 391652 466079 599353 614521 569967 391651 403588 390293 571016 411756 402378 428830 405114 475452 485695 546932 383094 385158 394228 358778 396014 400473 398557 400888 400735 406983 546937 563439 395933 397911 400519 404495 430393 443119 462706 389612 393081 409346 391964 395601 411723 424463 464545 232945 391913 394206 443378 454205 424483 481926 486535 490878 493198 383377 383912 389044 399613 401190 405954 407365 434066 453269 474843 549773 562976 584799 563123 586582 233224 428858 397226 401062 411400 312831 451465 479025 533609 172262 405208 412975 421536 434045 484582 563436 391380 391614 484615 422199 465649 484618 481918 567416 406593 408969 482339 546951 411408 407903 443165 385039 396971 405504 418957 726515 381785 411762 ] |
||||||||||||||||||||||||||||||
|
9.64 ms (5.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"старая баба"
]
|
||||||||||||||||||||||||||||||
|
2.87 ms (1.53%) |
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 172262 188338 232945 233224 233353 312831 358778 381785 383094 383377 383912 385039 385158 385469 388739 389044 389612 390293 391380 391614 391651 391652 391913 391964 393081 394206 394228 395601 395933 396014 396971 397004 397226 397911 398557 399613 400473 400519 400735 400888 401062 401190 402378 403588 404495 405114 405208 405504 405954 406593 406983 407365 407903 408969 409346 411397 411400 411408 411723 411756 411762 412273 412975 418957 421536 422199 424463 424483 428141 428830 428858 430393 434045 434066 443119 443165 443378 444113 451465 453269 454205 462706 464545 465649 466079 466155 474465 474843 475452 479025 481918 481926 482339 484582 484615 484618 485695 486535 490878 493198 511790 533609 542957 546932 546937 546951 549773 562976 563123 563207 563436 563439 567416 569967 571016 584799 586582 599353 614521 726515 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старая женщин женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"старая женщин женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.76%) |
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.