Query Metrics
7
Database Queries
7
Different statements
226.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.34 ms (86.72%) |
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 4311 54161 186823 269287 280580 382207 387477 391150 391217 392004 392019 393832 396362 397509 398077 405683 415753 416593 416599 417030 419832 424294 430369 435512 435539 435590 438579 440639 443106 444426 448000 452764 456245 464031 465144 465727 466405 467051 467577 467616 468256 468269 468329 469092 469250 470453 470473 471108 471155 475457 476049 479549 479931 480428 480450 480498 482751 483523 484241 485281 487414 493022 496081 499914 500333 502776 508552 509298 513744 517272 518185 518885 526645 528142 530199 531794 531806 537379 539317 544098 545223 554949 555002 555046 556340 570936 583355 583734 615157 623278 623300 628205 629205 643698 661034 675654 716360 717443 722952 742636 747356 750593 751339 752609 755287 756921 757473 761039 768915 782080 784128 791823 799942 804205 807121 809068 821602 826209 826322 827389 ] |
||||||||||||||||||||||||||||||
|
19.18 ms (8.47%) |
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 750593 751339 755287 756921 757473 768915 615157 623278 629205 643698 716360 717443 722952 782080 784128 791823 799942 804205 807121 4311 269287 742636 761039 393832 392019 382207 391150 405683 416593 438579 443106 430369 435539 435512 415753 424294 440639 444426 583734 482751 465727 467577 468269 469092 479931 487414 448000 467616 468329 469250 500333 544098 555046 556340 545223 555002 583355 675654 554949 570936 623300 752609 397509 416599 452764 464031 480428 417030 465144 471108 479549 392004 466405 471155 480450 419832 467051 470453 470473 468256 476049 518185 528142 484241 526645 485281 493022 502776 508552 517272 483523 499914 518885 456245 661034 628205 809068 747356 480498 435590 513744 186823 280580 54161 387477 391217 396362 398077 821602 826209 826322 827389 475457 496081 530199 537379 539317 509298 531794 531806 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.48%) |
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 4311 54161 186823 269287 280580 382207 387477 391150 391217 392004 392019 393832 396362 397509 398077 405683 415753 416593 416599 417030 419832 424294 430369 435512 435539 435590 438579 440639 443106 444426 448000 452764 456245 464031 465144 465727 466405 467051 467577 467616 468256 468269 468329 469092 469250 470453 470473 471108 471155 475457 476049 479549 479931 480428 480450 480498 482751 483523 484241 485281 487414 493022 496081 499914 500333 502776 508552 509298 513744 517272 518185 518885 526645 528142 530199 531794 531806 537379 539317 544098 545223 554949 555002 555046 556340 570936 583355 583734 615157 623278 623300 628205 629205 643698 661034 675654 716360 717443 722952 742636 747356 750593 751339 752609 755287 756921 757473 761039 768915 782080 784128 791823 799942 804205 807121 809068 821602 826209 826322 827389 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo doggy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло рак"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.76%) |
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.