Query Metrics
7
Database Queries
7
Different statements
151.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.90 ms (82.49%) |
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 27777 28397 44177 50537 73289 76649 91541 113322 280771 323352 327085 334474 359442 382361 382463 382520 383598 383923 384552 385247 386532 387854 387886 389209 390809 390955 391528 392318 393135 394589 395450 395451 396486 397097 397513 398907 399426 399969 400341 400346 401491 401886 401949 403426 403862 408887 412000 413259 413293 413560 417559 417808 418903 420298 421617 423471 426212 427448 429501 429786 431568 434087 434899 435596 435603 435662 437835 438051 438057 440681 440918 441744 441785 444057 444250 444499 446037 446893 448535 451282 451406 451631 453406 453654 454021 455715 456186 456363 456851 457548 457725 461632 463398 465456 465494 467670 468936 469062 470384 472108 472677 474607 475765 477624 478984 483990 484234 484749 486729 492542 492949 493827 495996 500747 506338 512142 523234 540860 671863 814967 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (10.20%) |
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 523234 483990 484749 486729 500747 512142 671863 506338 386532 383598 383923 384552 385247 113322 394589 393135 392318 391528 395450 395451 280771 323352 327085 334474 382463 382361 382520 359442 73289 76649 28397 44177 50537 27777 91541 389209 387854 387886 390809 390955 396486 397097 397513 400346 398907 399426 399969 400341 401886 401949 401491 403426 403862 408887 413293 420298 431568 434899 438051 441785 444250 421617 429786 438057 440681 444057 413259 417808 418903 426212 427448 429501 435603 441744 412000 417559 434087 435596 437835 440918 413560 423471 435662 444499 540860 814967 446037 446893 451631 457548 457725 465456 475765 492542 448535 451282 451406 454021 456186 456363 456851 463398 465494 468936 470384 472108 474607 478984 484234 492949 453406 453654 455715 461632 467670 469062 472677 477624 493827 495996 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.31%) |
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 27777 28397 44177 50537 73289 76649 91541 113322 280771 323352 327085 334474 359442 382361 382463 382520 383598 383923 384552 385247 386532 387854 387886 389209 390809 390955 391528 392318 393135 394589 395450 395451 396486 397097 397513 398907 399426 399969 400341 400346 401491 401886 401949 403426 403862 408887 412000 413259 413293 413560 417559 417808 418903 420298 421617 423471 426212 427448 429501 429786 431568 434087 434899 435596 435603 435662 437835 438051 438057 440681 440918 441744 441785 444057 444250 444499 446037 446893 448535 451282 451406 451631 453406 453654 454021 455715 456186 456363 456851 457548 457725 461632 463398 465456 465494 467670 468936 469062 470384 472108 472677 474607 475765 477624 478984 483990 484234 484749 486729 492542 492949 493827 495996 500747 506338 512142 523234 540860 671863 814967 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"как снимаит"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"снима"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.10%) |
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.