Query Metrics
7
Database Queries
7
Different statements
185.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.74 ms (86.52%) |
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 232995 365945 390931 391928 392604 400994 424195 426096 429872 435064 439738 445818 452181 455594 455738 456499 459476 469797 470498 472574 473269 473761 473977 478400 478753 478902 479091 479272 479452 482856 482917 482933 483601 485429 485966 486334 487547 488144 489073 489331 491144 495228 495328 496357 499021 501747 501801 501912 501996 502388 502944 505372 510007 511055 512061 513516 515841 516778 518901 520395 521959 522249 522481 522792 523731 523959 524424 525984 526326 527625 527794 528215 542742 543678 544955 546775 551278 551888 552324 555963 555994 560554 561563 569593 571971 587918 599549 599617 600438 601358 602841 605296 636643 656019 658052 658266 658487 658624 675464 692944 693264 704595 707507 715422 736058 744912 766783 799915 803232 803233 810708 816120 817437 817835 817880 818038 819930 819940 819991 825698 ] |
||||||||||||||||||||||||||||||
|
16.37 ms (8.81%) |
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 569593 542742 561563 571971 555963 560554 600438 601358 587918 599617 744912 636643 426096 435064 400994 470498 459476 513516 522792 495228 482856 482917 487547 522249 523731 524424 527625 488144 489073 489331 501996 502388 515841 518901 520395 523959 526326 527794 528215 803232 803233 473977 232995 816120 817437 478902 544955 543678 656019 799915 766783 810708 391928 483601 486334 472574 485966 546775 555994 552324 551278 599549 605296 390931 424195 469797 473761 392604 455594 455738 429872 456499 445818 452181 473269 478400 478753 479091 479272 479452 501801 512061 516778 521959 501912 502944 511055 510007 522481 482933 485429 491144 495328 496357 499021 501747 505372 525984 602841 551888 736058 365945 439738 817835 825698 819930 819940 817880 818038 819991 658052 658624 693264 707507 715422 658266 704595 658487 675464 692944 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.32%) |
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 232995 365945 390931 391928 392604 400994 424195 426096 429872 435064 439738 445818 452181 455594 455738 456499 459476 469797 470498 472574 473269 473761 473977 478400 478753 478902 479091 479272 479452 482856 482917 482933 483601 485429 485966 486334 487547 488144 489073 489331 491144 495228 495328 496357 499021 501747 501801 501912 501996 502388 502944 505372 510007 511055 512061 513516 515841 516778 518901 520395 521959 522249 522481 522792 523731 523959 524424 525984 526326 527625 527794 528215 542742 543678 544955 546775 551278 551888 552324 555963 555994 560554 561563 569593 571971 587918 599549 599617 600438 601358 602841 605296 636643 656019 658052 658266 658487 658624 675464 692944 693264 704595 707507 715422 736058 744912 766783 799915 803232 803233 810708 816120 817437 817835 817880 818038 819930 819940 819991 825698 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"душ русское"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван русск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.72%) |
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.