Query Metrics
7
Database Queries
7
Different statements
127.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
109.47 ms (86.19%) |
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 75925 393724 398922 411039 453863 484956 487439 489499 509018 510436 512294 517367 518471 527506 530331 530354 538809 547218 547259 548196 548606 549757 549887 549892 549910 549920 550627 554709 565048 566789 572590 573076 574718 576346 583841 586833 589426 599935 599949 622014 622223 629489 648728 652900 652960 656072 656990 657038 657665 657715 657716 658046 658063 658568 658652 659526 659713 660882 660923 665607 666613 669413 674377 684348 700913 709810 740396 744580 754634 765961 778357 795108 797373 815292 815327 817144 817778 817894 818056 818231 819399 820915 821025 821584 821747 824071 824392 825094 825603 825929 825967 826300 826347 826352 826569 827324 828059 828132 828152 828161 828212 828275 828392 828504 828731 828732 828813 828843 ] |
||||||||||||||||||||||||||||||
|
8.94 ms (7.04%) |
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 509018 510436 512294 517367 484956 489499 518471 75925 411039 824071 825929 825967 819399 824569 824820 817144 825094 826352 828161 828152 828132 828212 549910 550627 657038 659713 684348 709810 652960 658568 665607 666613 547218 565048 599935 589426 599949 740396 744580 622014 815327 827324 815292 660882 554709 778357 795108 566789 548606 574718 576346 622223 393724 487439 817894 823213 825382 826300 818231 818056 821747 825603 821584 824392 824566 825960 826347 826569 828813 828392 828275 828504 828731 530331 530354 538809 549920 549887 547259 572590 652900 656072 657716 659526 660923 669413 657665 658046 658063 658652 674377 656990 657715 700913 548196 549892 583841 586833 629489 754634 765961 797373 820915 821025 453863 527506 573076 549757 648728 398922 824828 817778 823395 821981 823872 828204 828262 828059 828843 828732 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.66%) |
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 75925 393724 398922 411039 453863 484956 487439 489499 509018 510436 512294 517367 518471 527506 530331 530354 538809 547218 547259 548196 548606 549757 549887 549892 549910 549920 550627 554709 565048 566789 572590 573076 574718 576346 583841 586833 589426 599935 599949 622014 622223 629489 648728 652900 652960 656072 656990 657038 657665 657715 657716 658046 658063 658568 658652 659526 659713 660882 660923 665607 666613 669413 674377 684348 700913 709810 740396 744580 754634 765961 778357 795108 797373 815292 815327 817144 817778 817894 818056 818231 819399 820915 821025 821584 821747 824071 824392 825094 825603 825929 825967 826300 826347 826352 826569 827324 828059 828132 828152 828161 828212 828275 828392 828504 828731 828732 828813 828843 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens skinny"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens худые"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens худые"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.17%) |
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.