Query Metrics
7
Database Queries
7
Different statements
144.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.63 ms (82.32%) |
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 91146 96445 97231 117755 118258 130022 148176 161485 182504 214602 282542 348409 359067 382188 382720 382955 385113 385324 385436 386965 387207 387245 388053 388094 389611 390678 390956 390981 391978 392589 392874 393743 394598 394636 395491 395536 396073 396605 398166 400945 401854 404608 409105 415978 419931 421039 429820 457216 491368 501926 515559 531707 532741 534567 534664 539239 546803 556476 578233 584903 594415 597251 621389 628416 631202 633444 641761 665095 666539 666897 668537 669390 677724 677986 678066 678067 678144 693502 713027 725627 731200 738817 742727 757905 766703 771793 788093 788409 788567 790381 796817 803697 805281 805494 807305 809133 809225 809597 810623 811830 814258 814276 814284 816650 817300 817753 817756 817966 818707 820772 824915 826020 826692 827849 827928 827941 827946 827962 827980 ] |
||||||||||||||||||||||||||||||
|
16.08 ms (11.16%) |
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 814258 814276 817756 816650 817300 641761 282542 348409 457216 546803 556476 693502 668537 788567 738817 400945 396605 827961 827941 359067 584903 578233 396073 788409 803697 395536 631202 404608 826692 817966 809597 731200 788093 807305 725627 811830 391978 96445 415978 148176 669390 665095 429820 491368 621389 597251 809225 757905 393743 394598 118258 594415 419931 628416 394636 385436 534664 678067 97231 382720 91146 532741 633444 817753 814284 805281 742727 161485 214602 390956 515559 827946 539239 534567 666539 678144 677986 666897 678066 382955 130022 827849 117755 771793 827962 390678 790381 820772 385324 501926 398166 385113 401854 182504 392589 824915 826020 810623 805494 387245 409105 382188 387207 531707 713027 386965 388053 421039 388094 827928 827980 677724 809133 766703 796817 395491 818707 392874 390981 389611 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (2.06%) |
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 91146 96445 97231 117755 118258 130022 148176 161485 182504 214602 282542 348409 359067 382188 382720 382955 385113 385324 385436 386965 387207 387245 388053 388094 389611 390678 390956 390981 391978 392589 392874 393743 394598 394636 395491 395536 396073 396605 398166 400945 401854 404608 409105 415978 419931 421039 429820 457216 491368 501926 515559 531707 532741 534567 534664 539239 546803 556476 578233 584903 594415 597251 621389 628416 631202 633444 641761 665095 666539 666897 668537 669390 677724 677986 678066 678067 678144 693502 713027 725627 731200 738817 742727 757905 766703 771793 788093 788409 788567 790381 796817 803697 805281 805494 807305 809133 809225 809597 810623 811830 814258 814276 814284 816650 817300 817753 817756 817966 818707 820772 824915 826020 826692 827849 827928 827941 827946 827962 827980 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob extreme"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.