Query Metrics
7
Database Queries
7
Different statements
174.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.01 ms (84.21%) |
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 385830 395720 404201 418354 419564 425296 437509 437618 441191 444346 450529 450847 453489 453600 453899 457014 457101 462904 467565 474253 475618 475693 476663 484133 491610 497334 497463 499189 501421 504688 505916 506754 507156 512476 513126 513215 513357 519122 519599 520117 521251 524174 525343 526608 528519 528800 535703 539006 542536 544037 547519 547989 556992 557015 560045 560325 564867 569193 570973 571075 572291 578327 578584 578655 579631 579825 580672 583344 583511 583688 587136 588146 588781 590352 592591 593855 604527 605584 615322 618834 619509 620300 620302 625689 625807 640105 641547 645852 652689 653349 680705 692421 700882 700949 703560 708232 718455 720253 727004 727132 737228 738073 760683 760767 766117 766884 773846 776259 782610 791855 792912 798075 799175 801742 802762 803316 813552 817445 817917 ] |
||||||||||||||||||||||||||||||
|
16.03 ms (9.18%) |
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 692421 703560 587136 641547 618834 625689 640105 588781 604527 760767 798075 801742 803316 727004 737228 760683 773846 738073 766117 615322 700882 792912 802762 419564 437618 453489 467565 457101 501421 506754 520117 524174 817445 560325 580672 569193 588146 590352 799175 499189 528519 395720 513357 700949 462904 593855 385830 418354 453600 475693 535703 542536 560045 571075 579631 547989 572291 578327 605584 620302 782610 727132 791855 475618 425296 450529 504688 528800 437509 453899 457014 476663 497463 519599 547519 570973 583511 578655 544037 579825 708232 680705 645852 556992 592591 619509 625807 766884 776259 474253 404201 512476 521251 484133 519122 450847 526608 564867 441191 513126 444346 620300 513215 813552 817917 539006 540618 525343 507156 497334 505916 491610 557015 583344 583688 578584 652689 718455 720253 653349 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.12%) |
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 385830 395720 404201 418354 419564 425296 437509 437618 441191 444346 450529 450847 453489 453600 453899 457014 457101 462904 467565 474253 475618 475693 476663 484133 491610 497334 497463 499189 501421 504688 505916 506754 507156 512476 513126 513215 513357 519122 519599 520117 521251 524174 525343 526608 528519 528800 535703 539006 542536 544037 547519 547989 556992 557015 560045 560325 564867 569193 570973 571075 572291 578327 578584 578655 579631 579825 580672 583344 583511 583688 587136 588146 588781 590352 592591 593855 604527 605584 615322 618834 619509 620300 620302 625689 625807 640105 641547 645852 652689 653349 680705 692421 700882 700949 703560 708232 718455 720253 727004 727132 737228 738073 760683 760767 766117 766884 773846 776259 782610 791855 792912 798075 799175 801742 802762 803316 813552 817445 817917 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"my girl friend"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"my девушк friend"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"my девушк friend"
]
|
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.