Query Metrics
7
Database Queries
7
Different statements
164.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.63 ms (76.25%) |
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 96023 196316 382190 391184 396614 406064 406390 419631 425694 428391 428420 430400 430429 432751 445955 446752 451570 451582 455805 455984 457332 460806 466635 466960 468705 470848 470858 471154 472341 475514 482179 490843 490868 491378 491387 492330 492839 495608 497570 502315 512823 512830 514733 520409 521051 521943 523948 523951 526185 528825 529670 530850 533320 533327 533340 533352 533791 536613 536863 536869 537969 538583 538653 539061 539105 539116 541225 543260 543393 547919 548577 549992 552954 564078 565355 565359 565363 565364 565402 565405 565416 565450 565487 572397 573230 579138 580767 580941 588285 591329 592385 596084 601536 604506 605288 606812 607185 621651 621962 623973 632668 634468 640686 647052 649136 649935 656495 662562 674702 678481 708810 709198 720394 726675 759472 762664 766546 811826 815608 817928 ] |
||||||||||||||||||||||||||||||
|
28.42 ms (17.25%) |
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 521943 432751 96023 455805 520409 539105 533352 539061 428391 451570 471154 445955 497570 468705 466960 565355 565359 514733 196316 391184 533791 539116 533340 565487 552954 565450 572397 579138 573230 607185 634468 604506 592385 708810 425694 536869 523951 490843 580941 502315 565364 547919 457332 565363 548577 564078 759472 472341 523948 446752 526185 541225 623973 490868 512823 512830 811826 396614 406064 406390 430429 419631 430400 815608 817928 470858 492330 521051 538583 537969 529670 530850 533320 536613 543260 543393 565416 649136 649935 656495 647052 662562 720394 565402 580767 621651 640686 596084 591329 766546 726675 762664 601536 632668 709198 466635 460806 428420 451582 491387 536863 565405 678481 549992 495608 470848 528825 533327 674702 606812 605288 475514 491378 588285 621962 382190 455984 492839 538653 482179 ] |
||||||||||||||||||||||||||||||
|
3.43 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 96023 196316 382190 391184 396614 406064 406390 419631 425694 428391 428420 430400 430429 432751 445955 446752 451570 451582 455805 455984 457332 460806 466635 466960 468705 470848 470858 471154 472341 475514 482179 490843 490868 491378 491387 492330 492839 495608 497570 502315 512823 512830 514733 520409 521051 521943 523948 523951 526185 528825 529670 530850 533320 533327 533340 533352 533791 536613 536863 536869 537969 538583 538653 539061 539105 539116 541225 543260 543393 547919 548577 549992 552954 564078 565355 565359 565363 565364 565402 565405 565416 565450 565487 572397 573230 579138 580767 580941 588285 591329 592385 596084 601536 604506 605288 606812 607185 621651 621962 623973 632668 634468 640686 647052 649136 649935 656495 662562 674702 678481 708810 709198 720394 726675 759472 762664 766546 811826 815608 817928 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc public"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc на улиц"
]
|
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.