Query Metrics
7
Database Queries
7
Different statements
242.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.64 ms (89.05%) |
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 449562 482101 482240 488132 493391 494717 497404 502273 506052 508593 509296 511295 511568 513090 514647 516034 517368 518940 519962 520020 520418 520695 523412 526545 527065 527850 531073 531076 531468 531500 531996 532066 540562 550064 550355 550976 551909 552321 554911 557124 558807 558904 561095 561103 561107 561375 562895 564112 565038 565150 572839 573361 573467 574298 576262 576616 578184 578416 581596 581620 581698 581734 582392 584711 586454 586457 586480 586485 586555 586806 590194 590861 591304 592417 594768 597874 598652 600763 600864 601707 603431 605238 605617 607195 607713 615729 617116 620206 622714 626147 630592 634203 637540 647687 649175 669215 671351 673577 673965 673988 674780 676162 681137 681455 681857 684910 685682 685791 686095 687924 688042 688055 688099 688548 688575 688656 688664 689379 690124 691196 ] |
||||||||||||||||||||||||||||||
|
16.55 ms (6.84%) |
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 493391 523412 527850 531996 494717 511295 517368 513090 516034 520020 520418 520695 508593 532066 554911 572839 573467 581734 550064 550355 558807 581698 584711 551909 576262 581596 673577 669215 681137 688042 552321 561103 564112 573361 574298 576616 582392 586485 586806 592417 594768 620206 586454 605238 630592 637540 586480 591304 600864 607713 626147 590194 600763 603431 497404 449562 531073 531076 511568 531500 502273 519962 482101 565038 581620 557124 565150 578184 578416 674780 681455 685682 647687 649175 676162 681857 684910 686095 688055 688548 688575 689379 561107 607195 634203 586555 598652 617116 586457 590861 615729 597874 605617 601707 622714 482240 540562 506052 531468 509296 518940 526545 514647 527065 488132 550976 558904 561095 561375 562895 688099 688664 690124 671351 673965 685791 688656 691196 673988 687924 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.11%) |
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 449562 482101 482240 488132 493391 494717 497404 502273 506052 508593 509296 511295 511568 513090 514647 516034 517368 518940 519962 520020 520418 520695 523412 526545 527065 527850 531073 531076 531468 531500 531996 532066 540562 550064 550355 550976 551909 552321 554911 557124 558807 558904 561095 561103 561107 561375 562895 564112 565038 565150 572839 573361 573467 574298 576262 576616 578184 578416 581596 581620 581698 581734 582392 584711 586454 586457 586480 586485 586555 586806 590194 590861 591304 592417 594768 597874 598652 600763 600864 601707 603431 605238 605617 607195 607713 615729 617116 620206 622714 626147 630592 634203 637540 647687 649175 669215 671351 673577 673965 673988 674780 676162 681137 681455 681857 684910 685682 685791 686095 687924 688042 688055 688099 688548 688575 688656 688664 689379 690124 691196 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom сюжет"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom сюжет"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom сюжет"
]
|
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.