Query Metrics
7
Database Queries
7
Different statements
155.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.77 ms (89.11%) |
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 7015 187974 382864 383273 387149 404296 415559 443674 462080 481906 482364 490814 512964 526892 537105 538863 538935 544335 544479 550330 551508 563124 572561 595842 663963 672105 683284 690827 690865 691509 691518 691523 692265 692317 692331 692813 693028 693860 694023 694072 694091 694181 694222 694441 694559 695188 695196 695213 695219 695233 695241 695242 695247 695283 695614 695620 695621 695919 696350 697278 697790 697801 697808 698516 698517 698528 698554 698579 699385 699390 699689 699695 699707 699735 699743 699745 699757 699765 700275 703437 717072 725566 728380 747312 747500 756426 780541 781019 782657 799567 801883 808226 811489 814758 815238 815340 815365 815511 815530 815542 815573 815629 815722 815774 815804 815860 815890 815931 815965 816082 816319 816405 816529 816544 816886 816932 817396 819767 820707 826784 ] |
||||||||||||||||||||||||||||||
|
8.38 ms (5.38%) |
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 387149 544335 512964 826784 692813 815860 815629 697801 551508 695196 692317 663963 781019 700275 694559 187974 697808 692265 698554 695233 815340 815722 694072 747500 699385 538863 544479 695614 695219 698516 383273 815365 808226 815890 816886 695242 691509 692331 782657 572561 7015 816932 695213 694091 698579 443674 815804 683284 698528 693028 695283 814758 550330 815530 725566 815774 815238 695919 699689 698517 816082 482364 595842 815573 747312 703437 816544 815965 538935 691523 693860 695621 697790 780541 694023 699743 672105 811489 699707 699757 694222 695188 695620 816529 695247 690865 694441 717072 699390 699695 699735 382864 817396 691518 728380 801883 415559 694181 815931 815542 820707 816319 563124 696350 695241 490814 404296 462080 526892 537105 799567 756426 699765 481906 690827 697278 819767 699745 816405 815511 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.45%) |
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 7015 187974 382864 383273 387149 404296 415559 443674 462080 481906 482364 490814 512964 526892 537105 538863 538935 544335 544479 550330 551508 563124 572561 595842 663963 672105 683284 690827 690865 691509 691518 691523 692265 692317 692331 692813 693028 693860 694023 694072 694091 694181 694222 694441 694559 695188 695196 695213 695219 695233 695241 695242 695247 695283 695614 695620 695621 695919 696350 697278 697790 697801 697808 698516 698517 698528 698554 698579 699385 699390 699689 699695 699707 699735 699743 699745 699757 699765 700275 703437 717072 725566 728380 747312 747500 756426 780541 781019 782657 799567 801883 808226 811489 814758 815238 815340 815365 815511 815530 815542 815573 815629 815722 815774 815804 815860 815890 815931 815965 816082 816319 816405 816529 816544 816886 816932 817396 819767 820707 826784 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sex scene"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature секс scene"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature секс scene"
]
|
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.