Query Metrics
7
Database Queries
7
Different statements
145.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.66 ms (80.16%) |
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 66799 72607 123340 383902 384808 390831 396600 400946 401640 403641 405712 406290 408458 409061 414339 420410 426576 428723 429799 429943 434045 443066 443734 446165 451552 461271 462362 465224 466118 467035 474874 478445 486782 489598 490831 491771 493190 494289 501237 501239 506783 507696 514711 516684 524193 526042 527884 529187 529542 530019 530482 530483 530493 530623 530633 530643 531173 531260 531261 532726 532737 532741 532779 533556 534150 535591 535644 536259 536262 536344 536542 536562 536579 536580 536588 536608 536618 537896 537915 537922 540573 540944 544439 544838 546083 546959 549261 552595 554889 558991 589127 589152 591143 595200 599885 599894 605569 612431 629411 632269 634207 634811 637049 639735 641958 644962 645952 647320 675019 678125 679003 679818 682562 700291 704236 708443 723620 775802 798443 814948 ] |
||||||||||||||||||||||||||||||
|
18.15 ms (12.47%) |
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 536262 536588 384808 478445 554889 443734 443066 462362 486782 535591 529542 506783 66799 489598 434045 465224 527884 540573 632269 558991 637049 530482 544838 595200 682562 461271 383902 123340 544439 605569 775802 428723 501239 529187 72607 426576 408458 409061 536542 537915 546959 552595 679003 549261 589152 493190 526042 494289 420410 403641 490831 536580 591143 491771 466118 516684 814948 537922 599894 798443 406290 390831 400946 446165 530483 534150 536259 530019 530623 530643 540944 679818 700291 599885 704236 451552 524193 531260 467035 647320 645952 612431 708443 474874 501237 536562 537896 675019 634207 530493 589127 514711 532726 536344 507696 678125 546083 639735 641958 629411 634811 401640 396600 405712 414339 429799 429943 723620 644962 532779 536608 536618 530633 532737 532741 533556 536579 531173 531261 535644 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.08%) |
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 66799 72607 123340 383902 384808 390831 396600 400946 401640 403641 405712 406290 408458 409061 414339 420410 426576 428723 429799 429943 434045 443066 443734 446165 451552 461271 462362 465224 466118 467035 474874 478445 486782 489598 490831 491771 493190 494289 501237 501239 506783 507696 514711 516684 524193 526042 527884 529187 529542 530019 530482 530483 530493 530623 530633 530643 531173 531260 531261 532726 532737 532741 532779 533556 534150 535591 535644 536259 536262 536344 536542 536562 536579 536580 536588 536608 536618 537896 537915 537922 540573 540944 544439 544838 546083 546959 549261 552595 554889 558991 589127 589152 591143 595200 599885 599894 605569 612431 629411 632269 634207 634811 637049 639735 641958 644962 645952 647320 675019 678125 679003 679818 682562 700291 704236 708443 723620 775802 798443 814948 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge tits group"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные сиськ group"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные сиськ group"
]
|
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.