Query Metrics
7
Database Queries
7
Different statements
179.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.07 ms (85.31%) |
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 3335 221091 301977 386329 386408 391908 396903 405423 413643 426111 435645 458346 470593 470667 478541 479706 507809 508723 516083 528149 528583 530286 532715 533523 536544 537001 543360 543421 545077 545085 546675 547946 547983 552005 552008 554811 554816 557937 557945 561046 563407 566451 579077 581552 583446 587263 592373 593857 593885 603244 603544 605583 606471 608331 616688 622086 622110 624985 624998 628184 631329 632250 633179 634305 635787 635856 642524 649087 649208 649276 651317 651420 651886 653175 653593 653854 654276 671243 675936 675953 676283 677081 677584 692463 694027 694346 709411 710263 710407 711013 719808 725335 729266 731113 732690 738936 742691 745917 747159 750741 768227 771965 773528 773948 782468 784322 784850 786153 792480 793629 795151 799233 801533 802953 805819 813050 824498 826217 827104 827106 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (8.59%) |
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 676283 813050 827106 710263 545077 725335 729266 773528 710407 795151 631329 543360 552008 649087 771965 435645 557937 675936 587263 532715 583446 651886 386329 802953 675953 719808 603544 547946 545085 554816 552005 692463 3335 826217 563407 547983 530286 533523 528583 799233 824498 731113 386408 738936 742691 546675 750741 508723 677081 653854 793629 554811 561046 671243 651317 616688 624998 628184 624985 528149 557945 634305 413643 566451 593857 635856 732690 507809 581552 603244 470593 221091 654276 622086 632250 768227 711013 543421 405423 579077 784322 792480 827104 537001 649208 709411 608331 786153 773948 745917 470667 426111 478541 391908 479706 458346 396903 801533 805819 536544 651420 694027 694346 649276 653175 677584 653593 593885 633179 642524 605583 606471 635787 622110 592373 784850 747159 516083 301977 782468 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.51%) |
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 3335 221091 301977 386329 386408 391908 396903 405423 413643 426111 435645 458346 470593 470667 478541 479706 507809 508723 516083 528149 528583 530286 532715 533523 536544 537001 543360 543421 545077 545085 546675 547946 547983 552005 552008 554811 554816 557937 557945 561046 563407 566451 579077 581552 583446 587263 592373 593857 593885 603244 603544 605583 606471 608331 616688 622086 622110 624985 624998 628184 631329 632250 633179 634305 635787 635856 642524 649087 649208 649276 651317 651420 651886 653175 653593 653854 654276 671243 675936 675953 676283 677081 677584 692463 694027 694346 709411 710263 710407 711013 719808 725335 729266 731113 732690 738936 742691 745917 747159 750741 768227 771965 773528 773948 782468 784322 784850 786153 792480 793629 795151 799233 801533 802953 805819 813050 824498 826217 827104 827106 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome amateur"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро любительск"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
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.