Query Metrics
7
Database Queries
7
Different statements
195.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.60 ms (86.73%) |
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 108925 326134 360015 383118 384332 391537 396395 399058 402626 412814 413235 415303 415961 416501 416561 416611 416624 416631 416666 416725 420356 421072 423434 427970 428241 439230 443418 446353 448199 455353 455914 457974 457975 458675 458922 463262 465006 465516 465548 465604 468665 482814 482825 485161 492482 497776 500940 501440 508910 511488 511864 514233 516685 517861 518935 519209 523398 524863 524870 533002 536576 536847 537922 538309 541135 547523 549506 566784 575850 575852 579648 579651 580166 580183 580691 592409 597190 597234 597267 597472 598675 600118 622392 623973 633439 633442 633512 633801 634327 637087 640741 640785 644271 647349 649569 650845 664633 671674 671677 675897 680198 680816 685718 733838 733843 733883 752973 755079 756406 756775 759845 760267 761275 780530 785421 786461 805707 806084 811643 814948 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (8.19%) |
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 465516 538309 580166 541135 566784 600118 759845 439230 756775 455353 633439 412814 416611 423434 455914 511864 524870 680816 597190 597267 416631 518935 671677 637087 391537 326134 537922 650845 671674 685718 399058 814948 465604 649569 633512 640785 780530 733883 733838 733843 811643 516685 448199 482814 465006 517861 523398 536576 575850 580183 644271 756406 760267 786461 383118 396395 402626 416624 420356 428241 536847 511488 549506 580691 680198 597234 592409 633801 634327 633442 640741 806084 752973 785421 761275 458922 421072 524863 533002 465548 675897 598675 623973 755079 463262 413235 458675 108925 415961 501440 508910 492482 416561 416666 416725 446353 485161 519209 482825 579648 579651 547523 575852 664633 647349 597472 622392 360015 457974 416501 384332 415303 443418 468665 457975 500940 514233 805707 427970 497776 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.29%) |
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 108925 326134 360015 383118 384332 391537 396395 399058 402626 412814 413235 415303 415961 416501 416561 416611 416624 416631 416666 416725 420356 421072 423434 427970 428241 439230 443418 446353 448199 455353 455914 457974 457975 458675 458922 463262 465006 465516 465548 465604 468665 482814 482825 485161 492482 497776 500940 501440 508910 511488 511864 514233 516685 517861 518935 519209 523398 524863 524870 533002 536576 536847 537922 538309 541135 547523 549506 566784 575850 575852 579648 579651 580166 580183 580691 592409 597190 597234 597267 597472 598675 600118 622392 623973 633439 633442 633512 633801 634327 637087 640741 640785 644271 647349 649569 650845 664633 671674 671677 675897 680198 680816 685718 733838 733843 733883 752973 755079 756406 756775 759845 760267 761275 780530 785421 786461 805707 806084 811643 814948 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex monster"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс monster"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс monster"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.