Query Metrics
7
Database Queries
7
Different statements
394.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.63 ms (57.70%) |
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 478091 522703 531909 712956 660454 589979 630455 809634 799466 761601 737186 761740 610923 704429 384350 402979 396864 436900 403400 447224 463709 413235 480243 517998 491294 514383 666321 738645 766131 66046 228398 401364 395675 191069 513773 498285 567368 592363 788132 420305 463909 487823 534011 520301 11175 732808 432189 433996 814105 487737 471912 670748 648758 677028 556933 626852 810048 806881 748997 756671 757667 771384 783154 428794 466661 402601 418337 519937 522127 508262 515662 582708 400311 416901 419846 677726 559625 634806 733450 782543 744717 632108 419062 487621 470511 584021 443516 451795 464659 497247 679653 690479 591073 447515 282006 427794 445947 449499 417898 425330 478074 423520 458937 473258 506287 507903 515611 518334 524916 483620 515052 523087 523155 491026 665615 676793 605039 758276 742651 613987 ] |
||||||||||||||||||||||||||||||
|
157.58 ms (39.94%) |
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 11175 66046 191069 228398 282006 384350 395675 396864 400311 401364 402601 402979 403400 413235 416901 417898 418337 419062 419846 420305 423520 425330 427794 428794 432189 433996 436900 443516 445947 447224 447515 449499 451795 458937 463709 463909 464659 466661 470511 471912 473258 478074 478091 480243 483620 487621 487737 487823 491026 491294 497247 498285 506287 507903 508262 513773 514383 515052 515611 515662 517998 518334 519937 520301 522127 522703 523087 523155 524916 531909 534011 556933 559625 567368 582708 584021 589979 591073 592363 605039 610923 613987 626852 632108 634806 648758 660454 665615 666321 670748 676793 677028 677726 679653 690479 704429 712956 732808 733450 737186 738645 742651 744717 748997 756671 757667 758276 761601 761740 766131 771384 782543 783154 788132 799466 806881 809634 810048 814105 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.63%) |
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 11175 66046 191069 228398 282006 384350 395675 396864 400311 401364 402601 402979 403400 413235 416901 417898 418337 419062 419846 420305 423520 425330 427794 428794 432189 433996 436900 443516 445947 447224 447515 449499 451795 458937 463709 463909 464659 466661 470511 471912 473258 478074 478091 480243 483620 487621 487737 487823 491026 491294 497247 498285 506287 507903 508262 513773 514383 515052 515611 515662 517998 518334 519937 520301 522127 522703 523087 523155 524916 531909 534011 556933 559625 567368 582708 584021 589979 591073 592363 605039 610923 613987 626852 632108 634806 648758 660454 665615 666321 670748 676793 677028 677726 679653 690479 704429 712956 732808 733450 737186 738645 742651 744717 748997 756671 757667 758276 761601 761740 766131 771384 782543 783154 788132 799466 806881 809634 810048 814105 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful ass"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая жоп"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.