Query Metrics
7
Database Queries
7
Different statements
169.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.00 ms (87.68%) |
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 79601 398274 510348 526595 526853 530216 537403 543188 549518 552545 553679 554700 555067 565636 566240 571107 577691 588472 591865 616783 620750 627617 632886 634615 636171 639116 649771 650622 652671 658863 663767 666661 667979 676695 678608 678722 692679 695780 713652 715746 717757 721650 726722 731112 744417 746708 758409 761458 762090 763649 763701 764078 764615 764707 764960 764961 765007 765029 765389 767393 771359 774013 774058 775731 777518 777521 777539 777693 777905 777990 778054 778554 778743 779165 779188 779797 779846 780905 781013 781441 781533 781571 782895 783515 784515 785025 785815 786829 788066 788326 790848 791699 792304 793026 793762 794608 794758 796010 796013 797938 799863 802944 803417 804273 804510 804884 804926 809233 810065 810565 811244 814276 817547 820075 825518 826911 ] |
||||||||||||||||||||||||||||||
|
9.91 ms (5.83%) |
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 781571 790848 793762 794758 796010 796013 799863 804510 744417 762090 746708 764537 762511 774013 761458 763649 763701 764615 771359 620715 777518 777521 777539 777990 778554 779165 779797 785815 793026 802944 510348 398274 530216 526595 634615 780905 554700 721650 649771 526853 79601 814276 826911 817547 820075 826133 825518 537403 553679 555067 577691 543188 549518 566240 652671 658863 666661 692679 695780 717757 650622 663767 676695 667979 678608 678722 715746 552545 565636 571107 636171 588472 639116 591865 616783 632886 627617 777693 777905 778054 778743 779846 783515 788066 791699 792304 794608 803417 804273 804884 779188 784515 786829 788326 797938 810565 764078 764961 765007 781441 781533 782895 804926 809233 810065 811244 731112 726722 758409 764960 765029 765389 767393 764707 774058 620750 713652 775731 781013 785025 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.65%) |
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 79601 398274 510348 526595 526853 530216 537403 543188 549518 552545 553679 554700 555067 565636 566240 571107 577691 588472 591865 616783 620750 627617 632886 634615 636171 639116 649771 650622 652671 658863 663767 666661 667979 676695 678608 678722 692679 695780 713652 715746 717757 721650 726722 731112 744417 746708 758409 761458 762090 763649 763701 764078 764615 764707 764960 764961 765007 765029 765389 767393 771359 774013 774058 775731 777518 777521 777539 777693 777905 777990 778054 778554 778743 779165 779188 779797 779846 780905 781013 781441 781533 781571 782895 783515 784515 785025 785815 786829 788066 788326 790848 791699 792304 793026 793762 794608 794758 796010 796013 797938 799863 802944 803417 804273 804510 804884 804926 809233 810065 810565 811244 814276 817547 820075 825518 826911 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mouth pov"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mouth пов"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mouth пов"
]
|
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.