Query Metrics
7
Database Queries
7
Different statements
165.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.23 ms (84.16%) |
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 398676 402085 402093 402312 402335 408994 411289 417943 418159 418454 418479 418627 422231 423260 425679 427249 429367 433879 435958 438987 444546 447142 455145 455558 458436 459498 461459 461973 462591 466594 468627 470194 470510 471372 473047 473751 474060 474376 474719 475606 477393 478864 479482 485994 487251 487313 491739 492708 493349 493460 495449 496013 496047 500043 512373 512647 517311 521332 521876 522083 522682 526027 526968 536809 538427 548764 551624 552784 554164 554722 557433 558511 558855 559759 560846 564076 567674 569846 570460 571381 571848 573780 573857 575114 577959 578342 580295 590081 594095 594868 595819 598145 603166 603428 603913 608441 615651 626618 628063 628420 636522 642679 668613 671083 676517 709661 737110 739780 743355 747952 754205 758893 765448 785274 789876 795120 806031 806877 806892 810119 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (10.34%) |
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 754205 418454 461973 474060 474719 526027 626618 491739 423260 789876 475606 425679 548764 462591 459498 485994 558855 470510 411289 810119 417943 538427 470194 402085 474376 590081 594095 737110 806877 628420 512647 473047 564076 567674 398676 557433 575114 595819 552784 422231 473751 598145 739780 603428 433879 461459 521876 455145 571848 487251 455558 468627 558511 559759 577959 594868 458436 427249 435958 438987 466594 492708 493349 496047 495449 496013 487313 493460 522083 402093 478864 608441 536809 668613 636522 642679 806892 743355 758893 747952 603913 615651 709661 785274 408994 676517 418159 603166 447142 418479 795120 418627 429367 500043 560846 551624 569846 570460 571381 573780 573857 580295 402312 479482 477393 402335 444546 522682 512373 517311 521332 526968 471372 806031 765448 554164 578342 671083 554722 628063 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.52%) |
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 398676 402085 402093 402312 402335 408994 411289 417943 418159 418454 418479 418627 422231 423260 425679 427249 429367 433879 435958 438987 444546 447142 455145 455558 458436 459498 461459 461973 462591 466594 468627 470194 470510 471372 473047 473751 474060 474376 474719 475606 477393 478864 479482 485994 487251 487313 491739 492708 493349 493460 495449 496013 496047 500043 512373 512647 517311 521332 521876 522083 522682 526027 526968 536809 538427 548764 551624 552784 554164 554722 557433 558511 558855 559759 560846 564076 567674 569846 570460 571381 571848 573780 573857 575114 577959 578342 580295 590081 594095 594868 595819 598145 603166 603428 603913 608441 615651 626618 628063 628420 636522 642679 668613 671083 676517 709661 737110 739780 743355 747952 754205 758893 765448 785274 789876 795120 806031 806877 806892 810119 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"19 летние отсос"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 19 лет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 19 лет минет оральн секс"
]
|
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.