Query Metrics
7
Database Queries
7
Different statements
160.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.25 ms (80.98%) |
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 305931 358259 382163 385059 400493 407182 421840 422264 423484 438692 439450 439710 443903 446757 455626 456208 456995 460410 466041 466164 466808 477564 486610 488557 488745 492440 498089 509651 510102 514088 516211 519173 530462 531814 544509 547743 555992 567081 577107 582394 589314 592955 608931 610911 628709 630775 632111 638164 644447 655132 662894 666447 698250 707497 710400 714707 714868 715163 715896 717949 726138 730085 730407 731028 735834 735868 735875 735914 735932 735959 741832 742544 742560 747129 759018 760532 761012 761152 761162 761302 761754 761889 762994 765220 765580 765791 766680 769443 778034 778298 778634 779576 779904 785161 788928 791802 793826 793951 794900 795315 795461 796184 796205 796212 797020 797023 797289 798914 799046 799962 800934 804552 805813 819334 819988 820188 824965 825066 828631 828806 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (10.10%) |
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 698250 715163 796212 797020 797023 385059 761012 555992 439710 819988 799046 805813 797289 730085 735932 726138 742544 644447 305931 819334 820188 466041 456995 530462 516211 547743 577107 715896 655132 714707 717949 589314 632111 610911 628709 798914 778298 795315 735959 761754 762994 769443 788928 794900 735875 747129 765220 766680 730407 742560 759018 761302 735834 760532 761152 761162 765791 735868 735914 707497 710400 778034 791802 795461 800934 477564 358259 509651 488557 824965 825066 828806 828631 531814 466808 498089 544509 592955 793951 796184 765580 799962 400493 422264 423484 510102 486610 514088 488745 421840 456208 446757 455626 582394 567081 785161 778634 460410 519173 443903 662894 666447 608931 638164 793826 761889 741832 630775 466164 382163 407182 439450 438692 492440 714868 779576 779904 796205 804552 731028 ] |
||||||||||||||||||||||||||||||
|
4.85 ms (3.02%) |
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 305931 358259 382163 385059 400493 407182 421840 422264 423484 438692 439450 439710 443903 446757 455626 456208 456995 460410 466041 466164 466808 477564 486610 488557 488745 492440 498089 509651 510102 514088 516211 519173 530462 531814 544509 547743 555992 567081 577107 582394 589314 592955 608931 610911 628709 630775 632111 638164 644447 655132 662894 666447 698250 707497 710400 714707 714868 715163 715896 717949 726138 730085 730407 731028 735834 735868 735875 735914 735932 735959 741832 742544 742560 747129 759018 760532 761012 761152 761162 761302 761754 761889 762994 765220 765580 765791 766680 769443 778034 778298 778634 779576 779904 785161 788928 791802 793826 793951 794900 795315 795461 796184 796205 796212 797020 797023 797289 798914 799046 799962 800934 804552 805813 819334 819988 820188 824965 825066 828631 828806 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (2.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in mother"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum мам женщин"
]
|
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.