Query Metrics
7
Database Queries
7
Different statements
192.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.80 ms (84.73%) |
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 398970 403770 407532 408313 411846 414200 415787 416675 416850 418861 418910 420219 427536 429782 432673 435941 439810 442407 444919 445350 448145 449099 451849 452091 452333 452496 453554 453584 453734 454186 456017 458730 459420 460517 464246 464478 465209 467010 467072 468370 469262 470158 470523 471424 472673 474312 474490 476229 476318 478628 478847 481548 481942 482121 482219 482239 482358 482479 483478 483867 484139 484582 484652 484686 484942 484951 484957 486431 487191 488401 488432 492161 494568 495876 496539 498434 499548 499661 502775 503580 503972 506345 506436 507519 507537 508167 508393 508654 508816 509309 509590 512181 514262 515281 515709 515876 517040 518201 518362 520631 521727 522517 523029 527497 528474 533636 540968 543133 544976 547777 553084 554383 555990 556529 557511 561714 573395 582447 584486 595877 ] |
||||||||||||||||||||||||||||||
|
19.28 ms (10.03%) |
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 518362 483478 507519 507537 508654 520631 527497 484957 495876 496539 499661 522517 435941 494568 453554 474490 411846 427536 476318 518201 533636 492161 503972 484139 484582 486431 467010 439810 408313 429782 442407 453584 454186 451849 484942 458730 460517 482219 488401 499548 503580 464246 555990 554383 561714 582447 418861 444919 464478 472673 476229 398970 416675 452496 467072 481942 470523 415787 453734 470158 506345 517040 508393 487191 502775 508816 509309 515876 483867 484686 488432 514262 523029 528474 414200 459420 482358 512181 543133 595877 478847 540968 506436 484652 509590 515281 515709 556529 403770 407532 420219 416850 418910 432673 445350 465209 471424 474312 482479 452333 478628 482121 448145 449099 452091 456017 481548 482239 508167 498434 521727 468370 469262 484951 547777 584486 544976 557511 573395 553084 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.60%) |
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 398970 403770 407532 408313 411846 414200 415787 416675 416850 418861 418910 420219 427536 429782 432673 435941 439810 442407 444919 445350 448145 449099 451849 452091 452333 452496 453554 453584 453734 454186 456017 458730 459420 460517 464246 464478 465209 467010 467072 468370 469262 470158 470523 471424 472673 474312 474490 476229 476318 478628 478847 481548 481942 482121 482219 482239 482358 482479 483478 483867 484139 484582 484652 484686 484942 484951 484957 486431 487191 488401 488432 492161 494568 495876 496539 498434 499548 499661 502775 503580 503972 506345 506436 507519 507537 508167 508393 508654 508816 509309 509590 512181 514262 515281 515709 515876 517040 518201 518362 520631 521727 522517 523029 527497 528474 533636 540968 543133 544976 547777 553084 554383 555990 556529 557511 561714 573395 582447 584486 595877 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в форм"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в форм"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
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.