Query Metrics
7
Database Queries
7
Different statements
157.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.70 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 14940 33260 61726 86472 98871 197358 301977 381862 383324 383441 384340 388193 392750 401406 404377 407064 415558 418897 418968 420348 426706 427014 429200 441593 443882 452287 453451 453602 453745 455111 455537 456472 457989 458045 459065 461831 469777 470062 475821 477255 481061 481852 483132 483258 485421 490969 494750 497861 498216 508101 508832 509892 512275 520094 522062 522570 522803 523527 527334 527837 539272 545674 546494 546929 548775 549531 549941 552233 557344 560474 560655 562240 562273 563180 569652 569881 569911 569954 569985 570040 570251 570280 570350 570352 570469 570492 570540 570552 571541 571591 571614 571649 571876 571924 572079 572152 572429 572814 573102 573865 573875 573876 573901 574528 578086 597114 598815 603179 705642 710872 722525 742755 745193 766306 796330 802820 802835 810521 810699 813473 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (9.33%) |
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 508832 522570 522803 527334 512275 520094 522062 485421 527837 383324 384340 383441 197358 392750 301977 381862 86472 33260 61726 14940 98871 388193 401406 404377 420348 429200 441593 407064 415558 418897 443882 418968 427014 456472 457989 483258 452287 458045 481061 481852 453451 455537 459065 469777 475821 477255 508101 539272 494750 497861 509892 498216 523527 461831 470062 483132 490969 549941 569652 570040 570350 570469 571591 571649 572079 572814 573875 578086 545674 546494 562273 569881 569954 570552 571541 571924 573102 573865 574528 546929 549531 560474 562240 569911 570280 570352 572152 573901 722525 710872 548775 552233 557344 560655 563180 569985 570251 570492 570540 571614 571876 572429 573876 598815 603179 597114 810521 810699 802820 742755 745193 802835 813473 766306 705642 796330 426706 453602 453745 455111 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.08%) |
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 14940 33260 61726 86472 98871 197358 301977 381862 383324 383441 384340 388193 392750 401406 404377 407064 415558 418897 418968 420348 426706 427014 429200 441593 443882 452287 453451 453602 453745 455111 455537 456472 457989 458045 459065 461831 469777 470062 475821 477255 481061 481852 483132 483258 485421 490969 494750 497861 498216 508101 508832 509892 512275 520094 522062 522570 522803 523527 527334 527837 539272 545674 546494 546929 548775 549531 549941 552233 557344 560474 560655 562240 562273 563180 569652 569881 569911 569954 569985 570040 570251 570280 570350 570352 570469 570492 570540 570552 571541 571591 571614 571649 571876 571924 572079 572152 572429 572814 573102 573865 573875 573876 573901 574528 578086 597114 598815 603179 705642 710872 722525 742755 745193 766306 796330 802820 802835 810521 810699 813473 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"гост"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"гост"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.