Query Metrics
7
Database Queries
7
Different statements
203.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.73 ms (85.06%) |
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 20322 49426 185352 291689 381949 382491 385370 389346 390185 397045 397129 397516 401859 403589 413745 414509 420231 422589 422658 422710 422753 423026 423703 429276 430977 431664 435759 443301 444938 445233 445766 447324 448734 448931 456637 459234 459263 459265 459819 460953 462253 465194 471355 473751 473757 500708 512216 516811 522193 532591 533117 539028 539950 545473 549087 550644 551951 551972 551979 552019 552040 552886 552917 552930 556366 556389 556408 557681 561372 565992 566845 568613 572738 574467 575276 576991 583677 585825 591278 600537 603458 605069 610365 610669 613040 619432 622591 637757 643379 658187 674216 680749 680753 688319 703229 708301 718994 735602 740928 742486 744871 748667 749812 750448 753962 755696 755824 758860 762136 772011 784514 791307 800268 805057 807970 811267 816839 825406 828059 828206 ] |
||||||||||||||||||||||||||||||
|
20.12 ms (9.91%) |
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 385370 422753 444938 429276 435759 459265 465194 445766 456637 462253 460953 551972 575276 565992 574467 572738 591278 431664 459263 445233 471355 420231 459819 512216 397129 552917 516811 473751 500708 556408 561372 566845 568613 708301 557681 585825 610365 600537 605069 811267 750448 744871 755696 748667 825406 583677 533117 816839 382491 443301 422658 423026 459234 556389 610669 414509 430977 397045 422710 828059 828206 413745 550644 552886 551951 556366 551979 552040 622591 643379 753962 576991 397516 422589 545473 680753 674216 680749 619432 740928 735602 423703 447324 185352 20322 49426 389346 390185 448931 522193 552019 552930 688319 658187 718994 603458 613040 637757 791307 800268 784514 805057 758860 755824 762136 742486 749812 772011 703229 807970 381949 403589 291689 401859 448734 473757 539950 532591 539028 549087 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.57%) |
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 20322 49426 185352 291689 381949 382491 385370 389346 390185 397045 397129 397516 401859 403589 413745 414509 420231 422589 422658 422710 422753 423026 423703 429276 430977 431664 435759 443301 444938 445233 445766 447324 448734 448931 456637 459234 459263 459265 459819 460953 462253 465194 471355 473751 473757 500708 512216 516811 522193 532591 533117 539028 539950 545473 549087 550644 551951 551972 551979 552019 552040 552886 552917 552930 556366 556389 556408 557681 561372 565992 566845 568613 572738 574467 575276 576991 583677 585825 591278 600537 603458 605069 610365 610669 613040 619432 622591 637757 643379 658187 674216 680749 680753 688319 703229 708301 718994 735602 740928 742486 744871 748667 749812 750448 753962 755696 755824 758860 762136 772011 784514 791307 800268 805057 807970 811267 816839 825406 828059 828206 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian girl xxx"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк девушк xxx"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк девушк xxx"
]
|
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.