Query Metrics
7
Database Queries
7
Different statements
243.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
219.46 ms (90.28%) |
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 393274 400428 403833 405698 410080 411055 413938 417192 423849 434602 437226 438552 440250 448625 458830 462939 466670 466675 467999 469172 472305 475516 475867 476039 476513 477783 478086 478554 479894 480600 483969 487047 487680 494023 499045 502045 504853 506550 509151 510015 510412 512878 518590 521447 523050 523275 523299 524618 525422 525810 526404 527293 527535 527575 528667 529886 533867 536320 543069 544299 550024 551567 551940 554214 555203 560162 561629 561734 566920 567133 571221 575673 576304 577545 577643 578221 580383 582514 583100 583515 586188 586314 586939 592719 595765 604789 605405 606595 617647 622038 630879 636065 639157 649888 678704 681507 714047 719528 723982 726894 735852 736414 737995 743811 745078 747070 756898 771508 777565 777676 779344 779494 787458 789067 793217 795139 798720 805221 814729 821688 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (5.64%) |
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 747070 777565 793217 787458 756898 533867 478086 529886 476513 789067 467999 475516 476039 512878 576304 583515 578221 719528 678704 681507 617647 779344 723982 795139 737995 438552 410080 487680 437226 469172 499045 502045 525810 526404 527575 494023 543069 551940 560162 566920 575673 604789 606595 798720 771508 743811 745078 779494 405698 413938 417192 814729 487047 458830 518590 527293 523275 527535 528667 475867 477783 580383 583100 577643 561734 586188 636065 595765 639157 622038 805221 440250 462939 478554 523050 411055 403833 434602 510412 550024 714047 586314 777676 726894 466675 423849 483969 509151 523299 510015 821688 544299 605405 735852 393274 630879 400428 479894 448625 554214 555203 586939 480600 466670 582514 536320 736414 525422 506550 567133 571221 504853 524618 521447 551567 577545 561629 592719 649888 472305 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.22%) |
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 393274 400428 403833 405698 410080 411055 413938 417192 423849 434602 437226 438552 440250 448625 458830 462939 466670 466675 467999 469172 472305 475516 475867 476039 476513 477783 478086 478554 479894 480600 483969 487047 487680 494023 499045 502045 504853 506550 509151 510015 510412 512878 518590 521447 523050 523275 523299 524618 525422 525810 526404 527293 527535 527575 528667 529886 533867 536320 543069 544299 550024 551567 551940 554214 555203 560162 561629 561734 566920 567133 571221 575673 576304 577545 577643 578221 580383 582514 583100 583515 586188 586314 586939 592719 595765 604789 605405 606595 617647 622038 630879 636065 639157 649888 678704 681507 714047 719528 723982 726894 735852 736414 737995 743811 745078 747070 756898 771508 777565 777676 779344 779494 787458 789067 793217 795139 798720 805221 814729 821688 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс улице"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс улиц"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.