Query Metrics
7
Database Queries
7
Different statements
155.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.52 ms (84.51%) |
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 34369 145503 193462 229207 393435 395439 401802 408358 409374 413184 420262 422320 425586 431262 442318 443190 445427 450777 451324 455788 466733 469317 477067 485887 487930 494735 500432 519931 533193 540363 555268 555283 563157 567042 568411 569415 569720 579410 580381 582396 583795 585044 589746 592297 607149 628055 630903 635446 642764 645254 666160 675282 709594 716915 717299 718775 721084 721233 723642 724204 724699 731618 731620 732989 736379 736522 738327 742321 744540 744980 745765 751482 751767 752963 754946 755322 756254 757363 762192 762819 769886 769888 771000 776554 776824 777721 779336 779613 780282 781310 782675 783322 785746 785873 786094 786197 788957 797754 797846 797867 799168 799738 801855 802111 804095 804158 805544 805551 806098 806621 806774 806986 807217 811474 811989 813770 815808 815989 818445 819253 ] |
||||||||||||||||||||||||||||||
|
14.23 ms (9.14%) |
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 752963 781310 788957 797867 799168 799738 801855 804095 807217 811989 724699 732989 769886 744980 754946 755322 736522 762819 724204 751482 771000 642764 718775 721084 779336 779613 783322 786094 797754 802111 804158 805551 806098 806774 811474 401802 145503 393435 408358 431262 666160 455788 469317 579410 568411 645254 563157 425586 451324 500432 494735 628055 744540 717299 582396 555268 555283 420262 466733 569415 442318 519931 409374 445427 450777 540363 533193 485887 583795 567042 569720 580381 709594 716915 675282 721233 592297 589746 630903 776554 782675 785873 786197 806986 776824 777721 785746 797846 745765 757363 769888 805544 731618 738327 756254 742321 762192 736379 751767 731620 607149 635446 780282 806621 422320 477067 413184 487930 229207 193462 395439 34369 443190 813770 815808 815989 818445 819253 585044 723642 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.84%) |
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 34369 145503 193462 229207 393435 395439 401802 408358 409374 413184 420262 422320 425586 431262 442318 443190 445427 450777 451324 455788 466733 469317 477067 485887 487930 494735 500432 519931 533193 540363 555268 555283 563157 567042 568411 569415 569720 579410 580381 582396 583795 585044 589746 592297 607149 628055 630903 635446 642764 645254 666160 675282 709594 716915 717299 718775 721084 721233 723642 724204 724699 731618 731620 732989 736379 736522 738327 742321 744540 744980 745765 751482 751767 752963 754946 755322 756254 757363 762192 762819 769886 769888 771000 776554 776824 777721 779336 779613 780282 781310 782675 783322 785746 785873 786094 786197 788957 797754 797846 797867 799168 799738 801855 802111 804095 804158 805544 805551 806098 806621 806774 806986 807217 811474 811989 813770 815808 815989 818445 819253 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom vagina"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom вагин"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom вагин"
]
|
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.