Query Metrics
7
Database Queries
7
Different statements
205.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.01 ms (87.71%) |
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 462182 494626 511117 530396 533713 536323 540453 545004 564281 577667 617017 629751 629754 657755 660251 687403 695406 708195 714561 715073 722129 725154 725241 725434 725444 725479 725494 725502 725509 727029 727036 731022 731042 731085 731137 731154 731189 731225 731262 731440 735830 735847 735864 735870 735886 735901 735927 735943 736004 739898 739927 740144 741761 741789 742585 742750 742784 743774 743778 743801 744221 744230 744413 744417 744423 744424 744432 744739 744772 745711 746104 746127 746139 746163 746680 746984 751474 754737 754934 755256 757547 757634 758166 758288 758317 758445 759709 759734 763429 763475 769463 788432 788753 789192 790949 794875 794885 794886 795032 795924 795931 795960 795972 797348 797355 800689 800738 800740 800745 800751 800904 801120 803406 803427 803436 803563 803862 804490 811179 827655 ] |
||||||||||||||||||||||||||||||
|
14.90 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 827655 462182 494626 533713 536323 511117 540453 530396 564281 545004 657755 660251 695406 708195 715073 687403 577667 629751 629754 617017 789192 790949 794875 794886 795972 800689 803406 804490 788753 794885 797348 800738 800740 800745 803563 811179 725154 725241 725434 725479 725494 725502 731137 731262 731440 736004 740144 741789 743778 744221 744772 746127 746163 758288 758445 795924 795931 795960 800904 801120 803436 803862 725444 731022 731042 735830 735943 741761 742784 743801 744230 744413 744417 744424 744739 746680 754934 759709 759734 763475 727036 731085 731225 735847 735864 739927 742585 743774 744423 745711 746139 763429 769463 725509 731189 735870 735886 735901 735927 744432 746984 754737 757547 757634 727029 731154 739898 742750 746104 751474 755256 758166 758317 714561 722129 788432 795032 797355 800751 803427 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.65%) |
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 462182 494626 511117 530396 533713 536323 540453 545004 564281 577667 617017 629751 629754 657755 660251 687403 695406 708195 714561 715073 722129 725154 725241 725434 725444 725479 725494 725502 725509 727029 727036 731022 731042 731085 731137 731154 731189 731225 731262 731440 735830 735847 735864 735870 735886 735901 735927 735943 736004 739898 739927 740144 741761 741789 742585 742750 742784 743774 743778 743801 744221 744230 744413 744417 744423 744424 744432 744739 744772 745711 746104 746127 746139 746163 746680 746984 751474 754737 754934 755256 757547 757634 758166 758288 758317 758445 759709 759734 763429 763475 769463 788432 788753 789192 790949 794875 794885 794886 795032 795924 795931 795960 795972 797348 797355 800689 800738 800740 800745 800751 800904 801120 803406 803427 803436 803563 803862 804490 811179 827655 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby wife russian"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby жен русск"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby жен русск"
]
|
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.