Query Metrics
7
Database Queries
7
Different statements
193.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.43 ms (85.91%) |
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 387334 390139 391289 396439 396941 397483 398543 398558 399422 400587 400598 400996 404684 407407 407462 411074 411904 413700 413737 414173 414225 415802 418425 418739 421524 423584 440563 441770 441957 442623 442915 443135 445288 451213 452175 452240 454460 456067 457546 466881 473383 475097 481101 481927 482735 483723 485383 488393 489033 489266 491214 493119 495520 529419 531817 539440 554451 563768 565302 569762 577420 584020 589120 601098 612229 612243 617536 643443 648503 651102 660400 661536 663405 663443 663459 663873 663913 663973 664274 664792 664848 665124 665230 665351 665471 665840 665854 665876 666763 667263 667523 667526 667597 667672 667675 668869 668880 669652 669742 669766 681216 700849 774609 776415 781764 781772 781778 781782 781854 781855 781869 790963 794872 797175 810715 813793 813802 813807 813818 814723 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (7.50%) |
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 387334 390139 391289 396439 396941 397483 400587 398558 399422 400598 398543 400996 404684 407462 413700 413737 441770 442623 411904 423584 440563 441957 443135 407407 411074 418425 418739 421524 414173 414225 415802 442915 445288 813807 813793 813802 813818 814723 451213 452240 457546 493119 452175 466881 475097 483723 488393 489033 454460 456067 481927 482735 485383 489266 491214 529419 539440 531817 495520 473383 481101 563768 554451 577420 648503 663405 663459 663973 664848 665351 665840 665854 665876 666763 667597 669652 669766 681216 651102 660400 661536 663913 664792 667263 667523 668869 700849 663443 663873 664274 665124 665230 665471 667526 667672 667675 668880 669742 565302 569762 584020 589120 601098 612229 612243 617536 643443 774609 776415 781764 781772 781782 781854 781855 781869 790963 794872 797175 781778 810715 ] |
||||||||||||||||||||||||||||||
|
4.91 ms (2.53%) |
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 387334 390139 391289 396439 396941 397483 398543 398558 399422 400587 400598 400996 404684 407407 407462 411074 411904 413700 413737 414173 414225 415802 418425 418739 421524 423584 440563 441770 441957 442623 442915 443135 445288 451213 452175 452240 454460 456067 457546 466881 473383 475097 481101 481927 482735 483723 485383 488393 489033 489266 491214 493119 495520 529419 531817 539440 554451 563768 565302 569762 577420 584020 589120 601098 612229 612243 617536 643443 648503 651102 660400 661536 663405 663443 663459 663873 663913 663973 664274 664792 664848 665124 665230 665351 665471 665840 665854 665876 666763 667263 667523 667526 667597 667672 667675 668869 668880 669652 669742 669766 681216 700849 774609 776415 781764 781772 781778 781782 781854 781855 781869 790963 794872 797175 810715 813793 813802 813807 813818 814723 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстушке"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.78%) |
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.