Query Metrics
7
Database Queries
7
Different statements
155.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.10 ms (82.33%) |
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 358259 382163 382818 400493 407182 411927 421840 422259 422264 423484 424247 438692 439450 443903 446757 447992 453463 455626 456208 459421 460410 466164 466808 472703 477564 486610 488557 488745 492440 494177 497234 498089 505936 506792 509014 509651 510102 514088 519173 519422 519604 531268 531814 537260 543115 544509 567081 569213 582394 592955 608931 630775 633426 638164 655186 662894 666447 710400 714421 714868 718463 727857 731028 731429 734026 739178 739946 741832 742276 744370 748812 755464 761230 761889 764418 765580 778034 778634 779576 779904 785161 786466 791802 793770 793826 793951 795142 795461 796184 796203 796205 797392 797913 799056 799290 799962 800746 800934 801562 804552 807522 807846 808254 810044 813528 817018 818222 824939 824965 825066 825323 825391 825431 825764 826216 826928 827032 828219 828631 828806 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (10.22%) |
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 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 509014 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 447992 492440 459421 714868 779576 779904 796205 804552 731028 742276 761230 796203 382818 424247 494177 519604 497234 519422 411927 422259 825323 825391 826216 824939 826928 827032 817018 818222 825431 825764 828219 505936 531268 506792 569213 543115 633426 813528 800746 808254 734026 786466 797913 744370 764418 731429 755464 714421 718463 799056 810044 537260 655186 799290 801562 727857 795142 739946 748812 739178 797392 807846 453463 472703 807522 793770 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (2.28%) |
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 358259 382163 382818 400493 407182 411927 421840 422259 422264 423484 424247 438692 439450 443903 446757 447992 453463 455626 456208 459421 460410 466164 466808 472703 477564 486610 488557 488745 492440 494177 497234 498089 505936 506792 509014 509651 510102 514088 519173 519422 519604 531268 531814 537260 543115 544509 567081 569213 582394 592955 608931 630775 633426 638164 655186 662894 666447 710400 714421 714868 718463 727857 731028 731429 734026 739178 739946 741832 742276 744370 748812 755464 761230 761889 764418 765580 778034 778634 779576 779904 785161 786466 791802 793770 793826 793951 795142 795461 796184 796203 796205 797392 797913 799056 799290 799962 800746 800934 801562 804552 807522 807846 808254 810044 813528 817018 818222 824939 824965 825066 825323 825391 825431 825764 826216 826928 827032 828219 828631 828806 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother cum"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин cum"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
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.