Query Metrics
7
Database Queries
7
Different statements
192.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.90 ms (86.35%) |
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 37730 76649 117479 381735 383791 390032 391493 393127 396033 396636 396836 398009 398874 398907 399223 412729 417154 417395 418658 419030 419099 419277 424539 434008 436539 447180 447733 449108 449499 449544 449800 450955 451795 455518 456946 458347 460611 461325 463398 466471 471623 478715 478740 480009 484458 487862 488282 509163 513885 517344 519427 524390 528122 528471 533332 533345 533383 533387 536861 539241 542972 544255 546893 550342 550345 558203 560696 568926 569220 590787 591819 593396 596629 604466 609866 625800 631168 654337 654353 654398 677919 690618 691180 698207 698468 713051 725167 740743 750769 751173 755765 772150 778954 779845 781359 781416 782130 785280 785448 787156 788163 788701 788730 790618 791218 791530 792002 795343 797032 797565 799648 800681 806263 810203 812149 817734 818039 818092 823447 827984 ] |
||||||||||||||||||||||||||||||
|
14.99 ms (7.80%) |
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 817734 818092 827984 447733 449108 449800 539241 533383 533345 544255 550345 560696 654353 698207 698468 654337 654398 677919 785280 788730 790618 791530 797565 778954 779845 781359 785448 797032 725167 740743 751173 755765 782130 788163 799648 806263 810203 772150 750769 609866 625800 781416 787156 788701 795343 812149 37730 117479 398874 391493 398009 436539 390032 396033 396636 399223 418658 455518 450955 456946 542972 550342 568926 604466 593396 596629 590787 591819 631168 792002 791218 800681 449544 434008 458347 471623 417395 419030 424539 466471 393127 419277 447180 461325 478740 528471 484458 524390 528122 517344 487862 451795 419099 449499 396836 480009 478715 536861 513885 488282 519427 383791 381735 76649 398907 412729 417154 823447 818039 463398 460611 509163 533387 533332 546893 558203 569220 690618 691180 713051 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.80%) |
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 37730 76649 117479 381735 383791 390032 391493 393127 396033 396636 396836 398009 398874 398907 399223 412729 417154 417395 418658 419030 419099 419277 424539 434008 436539 447180 447733 449108 449499 449544 449800 450955 451795 455518 456946 458347 460611 461325 463398 466471 471623 478715 478740 480009 484458 487862 488282 509163 513885 517344 519427 524390 528122 528471 533332 533345 533383 533387 536861 539241 542972 544255 546893 550342 550345 558203 560696 568926 569220 590787 591819 593396 596629 604466 609866 625800 631168 654337 654353 654398 677919 690618 691180 698207 698468 713051 725167 740743 750769 751173 755765 772150 778954 779845 781359 781416 782130 785280 785448 787156 788163 788701 788730 790618 791218 791530 792002 795343 797032 797565 799648 800681 806263 810203 812149 817734 818039 818092 823447 827984 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая creampie"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful creampie"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая creampie"
]
|
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.