Query Metrics
7
Database Queries
7
Different statements
165.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.21 ms (86.18%) |
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 393462 483669 531273 543538 544158 544321 544534 547862 549252 553702 555332 555342 555464 555649 555781 559260 560122 576579 583643 589633 589644 604303 624419 628658 629612 630212 646664 672824 680619 682612 709368 709945 712665 713181 714330 719916 725431 727259 727565 728261 729917 730084 734380 734965 735944 738602 740289 741514 742565 742797 747104 756070 758304 758701 759299 759933 760921 761038 761072 762774 764180 765376 765686 766220 766601 766635 767095 769838 769935 772997 773912 774511 775701 783369 788603 789400 789595 792539 794351 794359 794363 794710 794765 794855 794873 794908 795706 795927 795947 795964 796001 796050 796285 797057 797073 797097 797208 797521 798730 798814 799701 800388 800612 800636 800800 801294 801306 801436 803709 804705 805214 805651 808175 811555 811948 812905 825688 ] |
||||||||||||||||||||||||||||||
|
11.10 ms (6.72%) |
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 646664 709945 713181 547862 560122 604303 630212 624419 788603 796050 798730 799701 800636 800800 801294 774511 775701 794873 795706 795947 796285 797521 801306 804705 811948 729917 730084 734380 735944 743671 762774 789595 792539 794363 794765 794855 795927 795964 800612 812905 766220 766601 766635 769935 727259 728261 734965 740289 758701 741514 742797 758304 759933 760921 765376 765549 767095 773912 727565 738602 747104 759299 761038 761072 764180 765686 769838 719916 783369 794351 794359 794908 797097 798814 800388 805651 811555 393462 483669 531273 725431 825688 544158 549252 555342 555464 544321 555332 555649 559260 543538 544534 553702 576579 672824 712665 680619 682612 709368 714330 555781 583643 583788 589633 629612 628658 589644 797057 797073 803709 805214 789400 801436 742565 756070 794710 796001 797208 808175 772997 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.68%) |
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 393462 483669 531273 543538 544158 544321 544534 547862 549252 553702 555332 555342 555464 555649 555781 559260 560122 576579 583643 589633 589644 604303 624419 628658 629612 630212 646664 672824 680619 682612 709368 709945 712665 713181 714330 719916 725431 727259 727565 728261 729917 730084 734380 734965 735944 738602 740289 741514 742565 742797 747104 756070 758304 758701 759299 759933 760921 761038 761072 762774 764180 765376 765686 766220 766601 766635 767095 769838 769935 772997 773912 774511 775701 783369 788603 789400 789595 792539 794351 794359 794363 794710 794765 794855 794873 794908 795706 795927 795947 795964 796001 796050 796285 797057 797073 797097 797208 797521 798730 798814 799701 800388 800612 800636 800800 801294 801306 801436 803709 804705 805214 805651 808175 811555 811948 812905 825688 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"как женщина кончает"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин сперм"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.86%) |
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.