Query Metrics
7
Database Queries
7
Different statements
182.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.26 ms (83.99%) |
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 145660 396181 416032 418669 422967 424197 425113 434676 439236 441042 441442 448176 451304 454481 455131 456224 457336 457703 457970 458474 462087 464660 468245 469630 470058 476013 479728 480430 481188 482900 483786 483882 485441 486626 488556 489179 489265 492168 492300 496666 498037 498215 498255 498967 499987 501131 501522 501785 502867 502998 504685 504731 505846 506239 507266 508288 508690 510334 511341 511636 512850 513614 513615 514022 514489 516522 518041 518165 518548 519351 519496 519515 519953 520942 520970 521315 521335 522000 522564 522957 523327 523658 523798 524428 524445 525233 525395 525598 526580 527258 528380 528660 531550 534186 541816 542072 546978 548757 548852 549874 550347 555100 555116 555563 560041 560050 562193 563173 564121 565585 567181 568317 571252 571987 574721 578481 580659 586605 618066 755481 ] |
||||||||||||||||||||||||||||||
|
19.85 ms (10.88%) |
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 439236 481188 508288 510334 514489 520970 527258 485441 492300 498215 498967 501131 507266 511636 513614 521335 524428 483786 489265 498037 504685 504731 506239 513615 520942 522564 522957 525598 528660 531550 489179 502867 505846 519351 523327 525233 541816 441442 448176 454481 469630 456224 457703 470058 479728 511341 549874 560041 563173 565585 571252 571987 546978 555100 555116 560050 564121 567181 542072 562193 568317 578481 548757 548852 550347 555563 574721 580659 586605 618066 755481 396181 462087 418669 422967 425113 441042 458474 464660 145660 424197 434676 451304 455131 457336 457970 480430 416032 468245 476013 501522 501785 502998 518165 518548 522000 526580 483882 488556 496666 498255 518041 519496 519515 519953 524445 525395 534186 482900 486626 512850 514022 516522 521315 523658 523798 528380 492168 499987 508690 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.43%) |
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 145660 396181 416032 418669 422967 424197 425113 434676 439236 441042 441442 448176 451304 454481 455131 456224 457336 457703 457970 458474 462087 464660 468245 469630 470058 476013 479728 480430 481188 482900 483786 483882 485441 486626 488556 489179 489265 492168 492300 496666 498037 498215 498255 498967 499987 501131 501522 501785 502867 502998 504685 504731 505846 506239 507266 508288 508690 510334 511341 511636 512850 513614 513615 514022 514489 516522 518041 518165 518548 519351 519496 519515 519953 520942 520970 521315 521335 522000 522564 522957 523327 523658 523798 524428 524445 525233 525395 525598 526580 527258 528380 528660 531550 534186 541816 542072 546978 548757 548852 549874 550347 555100 555116 555563 560041 560050 562193 563173 564121 565585 567181 568317 571252 571987 574721 578481 580659 586605 618066 755481 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стороны"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сторон"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.80%) |
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.