Query Metrics
7
Database Queries
7
Different statements
174.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.93 ms (81.82%) |
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 7446 382071 385296 391655 401500 402332 402698 402723 404766 405287 406381 408609 415950 417464 418848 420587 421363 421604 421878 421907 427974 431498 432754 433212 433238 435664 439565 443513 447426 449097 451951 453918 457419 458391 461375 461576 463936 467867 474095 474836 478401 478458 489866 491110 491250 493059 493163 494525 500430 502283 509920 513604 515633 516093 521131 521425 522095 523354 524528 526267 531654 532644 536648 541808 543496 547764 549255 550436 550604 551913 551919 552331 553190 554370 557249 559121 561853 561998 565501 569159 574464 576653 580773 583678 586564 587833 591135 593425 594370 597975 598142 598263 598574 604205 605416 608416 609897 610606 612434 613014 613179 613253 615938 617420 617423 620044 620124 620215 620236 620290 623678 623716 624030 625870 651244 652893 653459 654322 685469 740681 ] |
||||||||||||||||||||||||||||||
|
21.51 ms (12.31%) |
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 421878 478401 491110 494525 433212 433238 7446 443513 418848 598574 435664 574464 547764 391655 417464 478458 509920 740681 385296 453918 489866 526267 550604 402723 457419 431498 474095 521425 421604 500430 651244 493059 516093 569159 623716 421363 522095 515633 559121 401500 427974 458391 594370 463936 415950 654322 620044 461375 523354 439565 624030 451951 536648 580773 652893 402698 561853 620290 620124 406381 551919 531654 604205 461576 382071 447426 587833 421907 449097 561998 653459 605416 613253 404766 583678 549255 685469 625870 467867 521131 553190 557249 491250 474836 402332 565501 613014 623678 586564 597975 608416 513604 420587 550436 598263 609897 612434 408609 532644 432754 551913 552331 576653 598142 620236 593425 502283 524528 541808 543496 620215 615938 610606 591135 493163 554370 617423 405287 617420 613179 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.78%) |
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 7446 382071 385296 391655 401500 402332 402698 402723 404766 405287 406381 408609 415950 417464 418848 420587 421363 421604 421878 421907 427974 431498 432754 433212 433238 435664 439565 443513 447426 449097 451951 453918 457419 458391 461375 461576 463936 467867 474095 474836 478401 478458 489866 491110 491250 493059 493163 494525 500430 502283 509920 513604 515633 516093 521131 521425 522095 523354 524528 526267 531654 532644 536648 541808 543496 547764 549255 550436 550604 551913 551919 552331 553190 554370 557249 559121 561853 561998 565501 569159 574464 576653 580773 583678 586564 587833 591135 593425 594370 597975 598142 598263 598574 604205 605416 608416 609897 610606 612434 613014 613179 613253 615938 617420 617423 620044 620124 620215 620236 620290 623678 623716 624030 625870 651244 652893 653459 654322 685469 740681 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"язык в жопу"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"язык анал"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.82%) |
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.