Query Metrics
7
Database Queries
7
Different statements
181.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.02 ms (87.29%) |
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 385224 392579 398032 398408 404121 411501 413389 422149 425733 433959 434252 437986 438654 438657 446678 452715 459721 462571 465869 469218 490269 491576 494616 498954 501473 505551 567073 585914 591236 594608 610708 613301 618246 620973 623392 625157 631316 634692 642237 642249 696924 721970 723589 724678 726352 726913 727519 731005 731156 736395 736548 736570 740009 740096 740986 741772 741781 742769 742927 743633 743905 745461 757434 757863 759666 759739 759747 762223 765130 767354 772383 773728 773789 776963 778117 779485 779689 779732 779757 779941 780221 780328 781403 782697 782855 783070 784033 785065 786217 786823 787442 790464 790592 790610 790828 791279 792415 793252 793360 793446 793586 793972 794930 794958 794983 797964 798165 799419 800258 800579 802756 808260 810405 811138 811796 814002 814140 817293 818908 827590 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (7.95%) |
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 594608 642237 591236 618246 620973 610708 613301 631316 585914 623392 780328 782855 790592 790610 790828 793972 794983 797964 811138 776963 778117 779689 779732 779941 780221 781403 782697 783070 786823 791279 792415 793252 793360 793446 799419 800258 800579 808260 726913 736570 740009 740986 741772 743905 757434 762223 767354 773728 785065 786217 790464 793586 794958 798165 811796 727519 736395 736548 740096 759666 759739 724678 726352 731005 745461 759747 765130 772383 773789 741781 742769 742927 743633 757863 731156 625157 634692 642249 696924 721970 779485 779757 784033 787442 794930 802756 810405 398032 398408 404121 438654 385224 411501 469218 392579 438657 422149 494616 505551 498954 490269 413389 567073 446678 434252 425733 437986 433959 723589 814140 817293 818908 827590 814002 452715 462571 459721 465869 491576 501473 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.40%) |
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 385224 392579 398032 398408 404121 411501 413389 422149 425733 433959 434252 437986 438654 438657 446678 452715 459721 462571 465869 469218 490269 491576 494616 498954 501473 505551 567073 585914 591236 594608 610708 613301 618246 620973 623392 625157 631316 634692 642237 642249 696924 721970 723589 724678 726352 726913 727519 731005 731156 736395 736548 736570 740009 740096 740986 741772 741781 742769 742927 743633 743905 745461 757434 757863 759666 759739 759747 762223 765130 767354 772383 773728 773789 776963 778117 779485 779689 779732 779757 779941 780221 780328 781403 782697 782855 783070 784033 785065 786217 786823 787442 790464 790592 790610 790828 791279 792415 793252 793360 793446 793586 793972 794930 794958 794983 797964 798165 799419 800258 800579 802756 808260 810405 811138 811796 814002 814140 817293 818908 827590 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam mouth"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер mouth"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер mouth"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.75%) |
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.