Query Metrics
7
Database Queries
7
Different statements
148.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.73 ms (82.91%) |
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 350951 366017 424102 432379 432395 432413 432526 432533 432571 433218 433415 433552 433775 434220 434412 436149 438062 438514 438604 440741 444780 453618 456144 456463 456716 458809 459742 460288 461670 462041 465020 466342 470571 470706 470708 472106 472609 473328 473905 477067 477630 477949 478350 483855 488040 497857 498116 499418 505705 506649 508300 512757 513579 514018 514066 514313 517960 518797 523414 533710 534122 535604 535605 536155 553258 561838 561917 568730 569986 578348 596176 609765 612602 638174 658431 658464 660910 692650 696199 703702 707744 715068 715071 716135 716182 716232 719977 730311 731122 732875 736010 736847 738421 741768 744101 744431 744738 747010 753734 759997 761399 763463 764711 767615 781344 785049 787990 789160 790186 790189 791139 800741 801432 803165 804904 811330 814685 828431 828548 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (10.30%) |
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 553258 432413 434220 456144 433775 456716 438062 456463 473905 523414 781344 801432 561838 438604 459742 466342 514313 477067 483855 512757 350951 477949 440741 508300 753734 787990 828652 715071 800741 803165 767615 811330 736010 741768 731122 761399 703702 472609 444780 473328 461670 462041 460288 568730 561917 432395 424102 497857 533710 534122 535605 535604 478350 715068 470706 432379 696199 791139 747010 804904 814685 638174 764711 744101 470571 514018 472106 433552 596176 434412 505705 514066 498116 518797 707744 716182 719977 658464 612602 744431 738421 759997 438514 433415 513579 785049 790189 732875 763463 730311 744738 432526 433218 436149 465020 477630 453618 458809 470708 488040 499418 517960 506649 578348 736847 789160 790186 432533 432571 536155 366017 828431 828548 569986 692650 658431 716135 660910 716232 609765 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.94%) |
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 350951 366017 424102 432379 432395 432413 432526 432533 432571 433218 433415 433552 433775 434220 434412 436149 438062 438514 438604 440741 444780 453618 456144 456463 456716 458809 459742 460288 461670 462041 465020 466342 470571 470706 470708 472106 472609 473328 473905 477067 477630 477949 478350 483855 488040 497857 498116 499418 505705 506649 508300 512757 513579 514018 514066 514313 517960 518797 523414 533710 534122 535604 535605 536155 553258 561838 561917 568730 569986 578348 596176 609765 612602 638174 658431 658464 660910 692650 696199 703702 707744 715068 715071 716135 716182 716232 719977 730311 731122 732875 736010 736847 738421 741768 744101 744431 744738 747010 753734 759997 761399 763463 764711 767615 781344 785049 787990 789160 790186 790189 791139 800741 801432 803165 804904 811330 814685 828431 828548 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член русск"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob russian"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.