Query Metrics
7
Database Queries
7
Different statements
181.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.37 ms (84.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 187349 384898 401228 412180 414184 416002 416025 418719 418720 418877 419765 420593 424608 426519 427898 428356 428603 429149 434808 435745 437592 438333 439439 445356 446586 447231 449231 450250 455974 456007 456726 457194 459151 459397 459749 462886 464659 467703 470071 473302 474596 475488 477688 478995 481367 484972 490328 493311 494298 497038 498357 502549 509833 510522 511153 511856 511951 512477 512937 513007 513588 514097 514935 516024 517422 520234 520405 520618 520972 522206 523309 523796 523903 526073 526789 528186 529548 537889 537901 546725 546824 551886 555899 557209 562856 563444 565768 569082 569784 575451 575708 579379 587919 588016 588052 589145 589758 589795 590602 591214 602957 605015 605529 606759 619753 629212 630900 630915 631466 633216 637540 648880 657136 663294 674474 712684 721551 788573 799421 808060 ] |
||||||||||||||||||||||||||||||
|
17.76 ms (9.81%) |
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 590602 439439 512937 474596 674474 629212 633216 446586 419765 555899 605529 631466 475488 418877 523309 416002 457194 513007 481367 648880 588016 384898 435745 449231 450250 490328 522206 528186 513588 575451 575708 579379 546824 565768 619753 602957 462886 459749 473302 497038 447231 523796 494298 526789 569784 562856 712684 569082 187349 456007 502549 514935 520618 520234 657136 788573 428356 424608 516024 418719 426519 437592 484972 512477 605015 589758 589145 799421 428603 418720 427898 438333 511153 520972 663294 537889 537901 589795 546725 414184 467703 498357 514097 529548 563444 606759 630915 429149 520405 412180 464659 511856 588052 511951 526073 401228 637540 587919 420593 455974 459397 523903 510522 478995 808060 445356 470071 434808 456726 416025 459151 517422 493311 557209 551886 721551 591214 630900 477688 509833 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.56%) |
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 187349 384898 401228 412180 414184 416002 416025 418719 418720 418877 419765 420593 424608 426519 427898 428356 428603 429149 434808 435745 437592 438333 439439 445356 446586 447231 449231 450250 455974 456007 456726 457194 459151 459397 459749 462886 464659 467703 470071 473302 474596 475488 477688 478995 481367 484972 490328 493311 494298 497038 498357 502549 509833 510522 511153 511856 511951 512477 512937 513007 513588 514097 514935 516024 517422 520234 520405 520618 520972 522206 523309 523796 523903 526073 526789 528186 529548 537889 537901 546725 546824 551886 555899 557209 562856 563444 565768 569082 569784 575451 575708 579379 587919 588016 588052 589145 589758 589795 590602 591214 602957 605015 605529 606759 619753 629212 630900 630915 631466 633216 637540 648880 657136 663294 674474 712684 721551 788573 799421 808060 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"watch sex"
]
|
||||||||||||||||||||||||||||||
|
2.33 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watch секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"watch секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
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.