Query Metrics
7
Database Queries
7
Different statements
202.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.09 ms (88.06%) |
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 186948 233187 266977 384128 386042 388722 389616 390542 390567 391025 391967 395878 395897 396344 398803 404503 405830 405859 406062 407783 407819 411690 411702 411704 411718 411722 413081 424429 432350 442634 443177 443408 443756 443761 447745 451491 454177 454247 454560 458000 458014 458929 460757 460923 462705 465347 465397 465399 466051 466350 468097 470289 470768 470977 470980 471710 474478 474479 474480 474490 474674 474680 476262 476284 477961 479053 479073 479078 479079 479106 479148 479765 484586 484625 484626 486341 486345 486542 488377 490013 505652 513201 523164 526733 526832 529338 539658 544478 555745 557932 563148 563779 589691 590303 591197 609071 612922 618513 624466 624791 640724 646807 697302 707441 719121 730361 738327 742574 744203 746095 746686 748254 759011 762186 780661 803510 808125 810056 823916 825243 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (7.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 759011 810056 738327 748254 730361 744203 746095 612922 640724 391967 462705 384128 233187 390542 390567 407783 442634 411690 411702 443177 458014 470980 458929 471710 488377 505652 490013 563148 557932 590303 609071 424429 443756 447745 396344 404503 443408 454560 465397 470289 479148 395878 432350 466350 470977 479106 411722 186948 391025 405859 406062 413081 407819 460923 474479 476262 479053 486542 523164 746686 465347 466051 470768 474490 454247 465399 474480 476284 479079 460757 477961 479078 388722 405830 411704 454177 458000 479073 443761 451491 468097 474478 474674 479765 484625 526832 484586 484626 486345 513201 386042 266977 539658 563779 624466 589691 624791 742574 808125 762186 719121 803510 823916 529338 526733 618513 780661 544478 591197 707441 411718 474680 486341 646807 697302 825243 555745 395897 389616 398803 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.07%) |
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 186948 233187 266977 384128 386042 388722 389616 390542 390567 391025 391967 395878 395897 396344 398803 404503 405830 405859 406062 407783 407819 411690 411702 411704 411718 411722 413081 424429 432350 442634 443177 443408 443756 443761 447745 451491 454177 454247 454560 458000 458014 458929 460757 460923 462705 465347 465397 465399 466051 466350 468097 470289 470768 470977 470980 471710 474478 474479 474480 474490 474674 474680 476262 476284 477961 479053 479073 479078 479079 479106 479148 479765 484586 484625 484626 486341 486345 486542 488377 490013 505652 513201 523164 526733 526832 529338 539658 544478 555745 557932 563148 563779 589691 590303 591197 609071 612922 618513 624466 624791 640724 646807 697302 707441 719121 730361 738327 742574 744203 746095 746686 748254 759011 762186 780661 803510 808125 810056 823916 825243 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature mature hairy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature mature волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature mature волосатая"
]
|
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.