Query Metrics
7
Database Queries
7
Different statements
167.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.42 ms (82.68%) |
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 38452 95742 191093 387536 390111 390938 395592 395861 396057 396656 397675 399295 399689 400453 405438 407657 410251 410353 411033 411199 411451 412208 413234 413434 413703 416441 416647 416707 419410 420116 423513 424160 425117 425306 425519 428685 429263 429286 429483 431176 431302 431636 431647 435799 437434 438323 438335 445551 446618 447690 451712 454088 454674 458539 458840 460036 462193 462681 463443 467336 468475 468587 470345 470509 471580 474101 474292 474447 477410 481187 484837 489584 489909 490815 490824 496537 504995 506359 509079 513340 518048 519717 521451 521942 526941 527167 534724 542207 562298 567081 568356 571898 572152 580688 580864 581048 588846 589112 607165 618401 668607 668869 670102 675281 697150 702635 713014 714448 716274 721744 730751 741531 759609 766121 770105 775774 787530 791218 809328 816116 ] |
||||||||||||||||||||||||||||||
|
18.74 ms (11.19%) |
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 490824 581048 668869 809328 766121 730751 759609 412208 816116 425306 713014 399295 38452 467336 468475 431647 454088 387536 460036 446618 521942 474101 429286 411451 419410 431302 489909 775774 791218 399689 395861 410251 518048 471580 697150 716274 395592 451712 424160 519717 470345 787530 668607 562298 490815 481187 458840 437434 405438 496537 191093 410353 429483 413434 423513 580864 542207 670102 607165 618401 770105 702635 397675 411033 411199 504995 513340 572152 589112 534724 462193 477410 438335 400453 506359 431636 445551 428685 435799 454674 416441 489584 95742 396656 416707 413703 470509 468587 458539 567081 675281 568356 741531 714448 447690 425117 463443 474447 396057 509079 527167 474292 580688 571898 588846 425519 407657 416647 438323 521451 526941 484837 413234 431176 462681 721744 420116 390111 390938 429263 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.60%) |
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 38452 95742 191093 387536 390111 390938 395592 395861 396057 396656 397675 399295 399689 400453 405438 407657 410251 410353 411033 411199 411451 412208 413234 413434 413703 416441 416647 416707 419410 420116 423513 424160 425117 425306 425519 428685 429263 429286 429483 431176 431302 431636 431647 435799 437434 438323 438335 445551 446618 447690 451712 454088 454674 458539 458840 460036 462193 462681 463443 467336 468475 468587 470345 470509 471580 474101 474292 474447 477410 481187 484837 489584 489909 490815 490824 496537 504995 506359 509079 513340 518048 519717 521451 521942 526941 527167 534724 542207 562298 567081 568356 571898 572152 580688 580864 581048 588846 589112 607165 618401 668607 668869 670102 675281 697150 702635 713014 714448 716274 721744 730751 741531 759609 766121 770105 775774 787530 791218 809328 816116 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красивая блондинка с …"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.