Query Metrics
7
Database Queries
7
Different statements
146.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.26 ms (82.98%) |
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 6804 393253 395688 396249 397366 397683 400624 400994 401922 402046 403258 404600 412957 413484 421175 424720 427494 429160 429272 432707 434378 451728 457949 464280 466339 466966 479053 484984 489083 489474 489490 491220 501139 506659 511081 511871 512217 517144 519227 519395 519986 523811 525109 526420 534221 534776 535318 537636 540199 550443 552186 559053 562069 562362 564184 567162 567521 568574 574186 575736 576008 577356 585711 591111 600660 604048 606539 615812 618672 623279 624281 627692 631246 646858 649081 649588 651190 651977 652934 665139 666416 670955 686710 692859 704010 704561 709544 712820 712824 713520 714840 717860 721551 722055 722918 723437 731821 734630 744640 747461 757201 763522 772694 776708 794992 795606 799591 804043 804902 807688 807806 807927 810544 810665 813902 817497 817727 819444 820280 820482 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (9.75%) |
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 519986 484984 491220 550443 512217 817497 537636 562069 666416 772694 403258 400624 412957 413484 429272 427494 501139 568574 692859 712824 714840 651190 618672 810665 799591 763522 722918 404600 466966 819444 540199 600660 606539 713520 649081 712820 704010 395688 402046 604048 649588 804902 721551 517144 631246 429160 489083 534776 575736 670955 624281 466339 511871 489474 489490 519227 397683 820280 651977 646858 591111 810544 731821 804043 623279 813902 519395 627692 794992 744640 747461 722055 723437 807806 393253 535318 451728 526420 562362 665139 686710 432707 434378 396249 464280 506659 511081 564184 552186 652934 401922 820482 576008 717860 567521 585711 807927 421175 525109 424720 523811 704561 567162 615812 807688 397366 577356 479053 400994 457949 574186 776708 757201 6804 817727 534221 559053 709544 795606 734630 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.94%) |
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 6804 393253 395688 396249 397366 397683 400624 400994 401922 402046 403258 404600 412957 413484 421175 424720 427494 429160 429272 432707 434378 451728 457949 464280 466339 466966 479053 484984 489083 489474 489490 491220 501139 506659 511081 511871 512217 517144 519227 519395 519986 523811 525109 526420 534221 534776 535318 537636 540199 550443 552186 559053 562069 562362 564184 567162 567521 568574 574186 575736 576008 577356 585711 591111 600660 604048 606539 615812 618672 623279 624281 627692 631246 646858 649081 649588 651190 651977 652934 665139 666416 670955 686710 692859 704010 704561 709544 712820 712824 713520 714840 717860 721551 722055 722918 723437 731821 734630 744640 747461 757201 763522 772694 776708 794992 795606 799591 804043 804902 807688 807806 807927 810544 810665 813902 817497 817727 819444 820280 820482 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl hot"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк hot"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк hot"
]
|
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.