Query Metrics
7
Database Queries
7
Different statements
167.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.01 ms (81.44%) |
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 4245 384232 388858 391349 396265 397242 412119 420136 420423 422231 427021 427195 431681 441166 450180 451711 453852 454348 455232 456142 463988 468640 469371 471776 480819 481029 482173 484350 487010 490859 496693 517463 519259 542797 543239 545529 546843 556521 560238 563886 573659 583927 584743 604500 610283 616615 620650 620907 621086 626004 626605 633154 637111 647357 650375 653516 667921 675784 676850 682466 683955 684281 690117 695547 699762 702938 704220 707738 714848 717246 720738 723300 725753 727780 731933 734933 748108 754012 757423 757643 758116 759610 760036 761626 762041 762163 762485 763152 764396 766121 767308 767510 774022 775383 778096 778514 784464 785288 788710 789838 789839 797224 800463 800575 801036 803038 804186 807440 807982 811735 816921 821067 821461 821895 822110 822289 822360 822948 823141 827858 ] |
||||||||||||||||||||||||||||||
|
21.52 ms (12.89%) |
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 811735 762041 621086 456142 821895 823141 816921 822110 542797 714848 616615 788710 725753 761626 760036 427195 748108 422231 759610 807440 767510 774022 784464 4245 731933 391349 583927 637111 468640 563886 420423 471776 778096 734933 695547 723300 717246 827858 573659 650375 633154 801036 490859 684281 797224 620907 450180 496693 560238 800463 803038 764396 620650 699762 396265 420136 821067 675784 702938 704220 707738 720738 653516 690117 800575 789839 727780 757643 384232 821461 822289 822948 454348 543239 556521 682466 626605 610283 766121 767308 789838 807982 626004 754012 453852 412119 676850 778514 785288 762163 775383 388858 484350 455232 647357 427021 482173 584743 545529 480819 431681 463988 469371 481029 822360 517463 604500 451711 441166 546843 487010 683955 763152 757423 519259 667921 762485 758116 804186 397242 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.60%) |
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 4245 384232 388858 391349 396265 397242 412119 420136 420423 422231 427021 427195 431681 441166 450180 451711 453852 454348 455232 456142 463988 468640 469371 471776 480819 481029 482173 484350 487010 490859 496693 517463 519259 542797 543239 545529 546843 556521 560238 563886 573659 583927 584743 604500 610283 616615 620650 620907 621086 626004 626605 633154 637111 647357 650375 653516 667921 675784 676850 682466 683955 684281 690117 695547 699762 702938 704220 707738 714848 717246 720738 723300 725753 727780 731933 734933 748108 754012 757423 757643 758116 759610 760036 761626 762041 762163 762485 763152 764396 766121 767308 767510 774022 775383 778096 778514 784464 785288 788710 789838 789839 797224 800463 800575 801036 803038 804186 807440 807982 811735 816921 821067 821461 821895 822110 822289 822360 822948 823141 827858 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex small"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.94%) |
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.