Query Metrics
7
Database Queries
7
Different statements
216.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.02 ms (89.01%) |
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 389630 415029 441683 443884 456526 459922 460118 460581 466365 466683 466723 474199 477692 481023 483258 484012 485494 486326 486327 507432 508223 516603 520652 527837 528103 531380 541779 549661 555184 555725 556493 556716 558484 562868 563299 563682 564844 570081 571277 588403 588916 591446 592856 596818 600850 602525 602662 602798 608633 615138 617245 624078 632124 632304 635367 637521 638566 639449 647122 651314 659345 664732 673874 675336 675583 685441 686610 696567 698354 699181 700592 700735 711354 716921 716935 723189 726390 731396 732154 733742 740646 759243 761677 761777 766082 769550 770626 772444 775271 775274 777456 778523 783922 785185 785548 786562 786596 788032 788071 788172 788359 788365 788915 788945 789496 790926 791572 792878 794807 797651 798763 800888 802766 802910 804537 809974 809992 821771 821899 822264 ] |
||||||||||||||||||||||||||||||
|
13.90 ms (6.41%) |
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 541779 570081 558484 563682 647122 651314 673874 686610 699181 723189 685441 711354 659345 698354 555184 556716 592856 602525 596818 788032 788071 788172 789496 797651 798763 809974 761677 785185 786596 794807 732154 770626 637521 639449 700592 778523 786562 788359 800888 474199 456526 486327 675336 617245 733742 632304 821899 822264 821771 486326 477692 459922 460581 555725 564844 556493 563299 664732 675583 716921 716935 602662 624078 638566 600850 635367 788945 791572 804537 775271 790926 731396 740646 761777 802910 809992 759243 766082 726390 769550 772444 602798 775274 783922 785548 389630 460118 508223 484012 485494 507432 527837 777456 415029 516603 571277 443884 441683 466365 481023 483258 466683 466723 520652 531380 528103 549661 562868 696567 700735 615138 588403 608633 632124 588916 591446 788915 792878 802766 788365 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.51%) |
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 389630 415029 441683 443884 456526 459922 460118 460581 466365 466683 466723 474199 477692 481023 483258 484012 485494 486326 486327 507432 508223 516603 520652 527837 528103 531380 541779 549661 555184 555725 556493 556716 558484 562868 563299 563682 564844 570081 571277 588403 588916 591446 592856 596818 600850 602525 602662 602798 608633 615138 617245 624078 632124 632304 635367 637521 638566 639449 647122 651314 659345 664732 673874 675336 675583 685441 686610 696567 698354 699181 700592 700735 711354 716921 716935 723189 726390 731396 732154 733742 740646 759243 761677 761777 766082 769550 770626 772444 775271 775274 777456 778523 783922 785185 785548 786562 786596 788032 788071 788172 788359 788365 788915 788945 789496 790926 791572 792878 794807 797651 798763 800888 802766 802910 804537 809974 809992 821771 821899 822264 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home пов"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home pov"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home пов"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.69%) |
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.