Query Metrics
7
Database Queries
7
Different statements
247.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
219.23 ms (88.62%) |
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 382113 387857 395246 412525 415543 426796 427656 434076 434133 434135 435324 447138 457774 459474 459485 459515 463490 466909 472181 472583 473129 478949 495172 504553 505300 512392 512997 514250 514859 515665 517536 525198 530409 531873 532111 547962 553600 554110 554143 554711 555301 555597 556596 561213 562150 562542 563374 565137 565143 567222 568107 570892 571778 579487 579920 580136 583084 583796 584037 584315 585645 586411 592604 592850 597545 598000 598136 600668 601163 604634 609844 611854 613358 614578 615329 626037 626560 628747 628756 628854 635328 636172 641298 649447 650258 657791 660743 661023 664227 673935 674231 678966 708320 712234 715426 715621 727163 730528 740326 743996 744231 749025 750387 751380 753524 754504 754938 759123 759129 759222 764731 769434 772483 777292 778448 789021 804838 808540 810390 813139 ] |
||||||||||||||||||||||||||||||
|
18.07 ms (7.31%) |
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 712234 649447 673935 708320 715621 555301 579920 600668 641298 626560 636172 609844 614578 615329 740326 744231 759123 769434 804838 751380 753524 754938 730528 743996 754504 759222 727163 749025 764731 635328 715426 777292 789021 387857 395246 415543 427656 434076 466909 457774 463490 512997 514250 531873 515665 472583 568107 547962 554110 565143 579487 583084 584037 584315 678966 657791 554711 556596 571778 580136 597545 611854 613358 592850 604634 626037 592604 598000 598136 426796 478949 435324 447138 459474 434133 412525 473129 459485 514859 504553 495172 472181 382113 434135 459515 512392 517536 530409 525198 532111 505300 553600 583796 562542 570892 563374 565137 660743 664227 674231 650258 661023 554143 555597 561213 562150 567222 628747 585645 586411 601163 628756 628854 778448 808540 813139 810390 750387 759129 772483 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.02%) |
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 382113 387857 395246 412525 415543 426796 427656 434076 434133 434135 435324 447138 457774 459474 459485 459515 463490 466909 472181 472583 473129 478949 495172 504553 505300 512392 512997 514250 514859 515665 517536 525198 530409 531873 532111 547962 553600 554110 554143 554711 555301 555597 556596 561213 562150 562542 563374 565137 565143 567222 568107 570892 571778 579487 579920 580136 583084 583796 584037 584315 585645 586411 592604 592850 597545 598000 598136 600668 601163 604634 609844 611854 613358 614578 615329 626037 626560 628747 628756 628854 635328 636172 641298 649447 650258 657791 660743 661023 664227 673935 674231 678966 708320 712234 715426 715621 727163 730528 740326 743996 744231 749025 750387 751380 753524 754504 754938 759123 759129 759222 764731 769434 772483 777292 778448 789021 804838 808540 810390 813139 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван эротик"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван эротик"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom erotic"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.65%) |
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.