Query Metrics
7
Database Queries
7
Different statements
152.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.38 ms (84.70%) |
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 10934 117610 117905 117941 118226 154157 219172 249009 383217 385109 385234 386336 391563 391983 397390 397619 399146 400730 401404 401508 401769 402596 403808 413431 457478 462580 474879 484054 485061 487270 487286 493808 494531 496393 508171 516428 517675 534537 550950 552575 555975 556887 568259 575560 593701 617583 618271 618479 619847 627163 634026 636252 639960 644369 650498 651987 656895 656933 662899 663216 664531 666962 668705 694600 705571 707571 710709 710934 713137 722428 735128 735130 735260 735974 740357 740523 741582 741625 742353 747291 752709 758163 760596 761155 761646 763560 766703 766941 770219 776064 782108 782791 784066 784236 784310 788555 789881 790719 792582 792706 792736 793466 794228 796270 796648 796706 796817 796872 797279 800131 801626 801814 808994 811785 812560 812561 813487 814317 827875 827915 ] |
||||||||||||||||||||||||||||||
|
13.28 ms (8.70%) |
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 788555 776064 784236 784310 789881 800131 801626 813487 740357 740523 761646 782108 796706 801814 808994 811785 812561 735128 735130 741625 758163 761155 766703 766941 742353 747291 752709 760596 770219 735260 735974 705571 782791 784066 792582 792706 794228 796270 796648 796817 796872 797279 413431 397390 474879 391563 391983 249009 508171 462580 552575 741582 763560 790719 10934 397619 219172 487270 664531 636252 694600 386336 383217 385109 385234 117610 117941 154157 117905 400730 402596 401404 814317 494531 812560 399146 487286 118226 656895 550950 792736 793466 457478 593701 485061 619847 827915 827875 484054 496393 516428 517675 556887 651987 656933 662899 666962 713137 618479 617583 639960 627163 644369 618271 710934 401508 401769 403808 493808 534537 555975 575560 668705 663216 722428 650498 707571 710709 568259 634026 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.01%) |
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 10934 117610 117905 117941 118226 154157 219172 249009 383217 385109 385234 386336 391563 391983 397390 397619 399146 400730 401404 401508 401769 402596 403808 413431 457478 462580 474879 484054 485061 487270 487286 493808 494531 496393 508171 516428 517675 534537 550950 552575 555975 556887 568259 575560 593701 617583 618271 618479 619847 627163 634026 636252 639960 644369 650498 651987 656895 656933 662899 663216 664531 666962 668705 694600 705571 707571 710709 710934 713137 722428 735128 735130 735260 735974 740357 740523 741582 741625 742353 747291 752709 758163 760596 761155 761646 763560 766703 766941 770219 776064 782108 782791 784066 784236 784310 788555 789881 790719 792582 792706 792736 793466 794228 796270 796648 796706 796817 796872 797279 800131 801626 801814 808994 811785 812560 812561 813487 814317 827875 827915 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.00%) |
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.