Query Metrics
7
Database Queries
7
Different statements
194.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.31 ms (87.88%) |
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 161358 311176 385039 389709 395584 397625 404354 425814 438312 441321 443676 450764 454822 461301 463295 466023 467909 477562 478454 478816 480111 480248 480496 483820 483978 485893 486256 491357 493023 493087 494722 496315 503495 505290 506019 506878 507152 508770 515259 517972 520257 523497 523670 524260 525149 527526 527548 528880 528995 534340 534467 534732 535317 539503 542342 542812 543116 543175 543219 543223 543801 544017 544953 545644 545738 548220 549816 550257 550574 550585 552821 554471 555404 556669 557103 557277 557606 557963 562850 563541 563925 565647 566258 566797 566987 568138 568260 569787 570813 571094 575002 575637 576654 577052 577118 582529 586438 588311 592128 597172 599487 601169 603048 604363 605115 605179 605272 611767 616984 618291 619402 620047 622929 635752 664470 668025 669912 673368 679618 685034 ] |
||||||||||||||||||||||||||||||
|
14.16 ms (7.26%) |
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 494722 508770 485893 385039 161358 397625 404354 441321 454822 480248 503495 506878 534340 525149 534732 477562 545738 562850 543801 582529 542812 575002 664470 679618 668025 669912 673368 550574 556669 557606 592128 616984 622929 586438 597172 599487 603048 620047 635752 619402 438312 461301 311176 425814 443676 466023 507152 483820 483978 517972 491357 480111 576654 601169 604363 605272 605179 611767 618291 605115 588311 395584 389709 478816 493023 467909 480496 450764 463295 478454 486256 506019 535317 539503 496315 505290 523670 524260 527548 528880 528995 520257 527526 515259 523497 534467 493087 543175 543219 548220 549816 550257 555404 557963 563925 565647 566258 566987 575637 577052 542342 543223 544017 544953 545644 550585 557103 566797 571094 543116 563541 568260 569787 570813 685034 552821 554471 557277 568138 577118 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.60%) |
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 161358 311176 385039 389709 395584 397625 404354 425814 438312 441321 443676 450764 454822 461301 463295 466023 467909 477562 478454 478816 480111 480248 480496 483820 483978 485893 486256 491357 493023 493087 494722 496315 503495 505290 506019 506878 507152 508770 515259 517972 520257 523497 523670 524260 525149 527526 527548 528880 528995 534340 534467 534732 535317 539503 542342 542812 543116 543175 543219 543223 543801 544017 544953 545644 545738 548220 549816 550257 550574 550585 552821 554471 555404 556669 557103 557277 557606 557963 562850 563541 563925 565647 566258 566797 566987 568138 568260 569787 570813 571094 575002 575637 576654 577052 577118 582529 586438 588311 592128 597172 599487 601169 603048 604363 605115 605179 605272 611767 616984 618291 619402 620047 622929 635752 664470 668025 669912 673368 679618 685034 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в плате"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в плат"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"в плат"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.73%) |
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.