Query Metrics
7
Database Queries
7
Different statements
219.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.80 ms (85.66%) |
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 106196 233193 233292 233512 233996 311237 338249 343227 365910 365962 368335 391492 398769 404251 426683 428814 439525 439599 443423 443691 443811 454264 454558 456341 460732 460747 462085 470272 471073 474493 475919 491950 501866 503928 504669 506051 508841 514789 520748 521995 541928 545999 546002 546951 548571 552672 553608 560594 563214 567170 567391 569983 570291 570638 573550 574815 574838 574839 575728 576020 576027 576038 576071 577117 580678 586449 594223 594918 595511 596161 597074 597223 597494 597960 598014 598069 598462 598470 598731 600157 601877 604147 605841 610595 654846 660300 664433 665830 678954 679378 695316 701508 714463 714490 716543 716577 722645 723933 744753 753260 775797 784569 785337 791362 800535 800563 805243 805504 809909 810032 811340 812364 814562 820924 821717 821839 821846 821854 821856 821867 ] |
||||||||||||||||||||||||||||||
|
19.48 ms (8.88%) |
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 501866 503928 508841 520748 821717 665830 610595 775797 460732 428814 454264 462085 470272 471073 439525 439599 474493 404251 426683 454558 460747 443811 506051 521995 233512 443423 106196 233193 343227 365910 368335 233292 233996 311237 338249 365962 391492 443691 491950 398769 475919 821839 814562 820924 821856 821846 821854 821867 456341 504669 514789 546951 552672 569983 573550 574838 574839 576020 576027 576038 576071 577117 541928 548571 560594 570291 570638 574815 575728 654846 664433 678954 701508 714490 716543 660300 716577 679378 695316 714463 722645 545999 546002 553608 563214 567170 567391 580678 597223 597960 598014 598069 598470 598462 604147 605841 586449 596161 597074 598731 600157 601877 594223 594918 595511 597494 805243 811340 812364 800535 800563 723933 744753 753260 784569 785337 791362 805504 809909 810032 ] |
||||||||||||||||||||||||||||||
|
3.90 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 106196 233193 233292 233512 233996 311237 338249 343227 365910 365962 368335 391492 398769 404251 426683 428814 439525 439599 443423 443691 443811 454264 454558 456341 460732 460747 462085 470272 471073 474493 475919 491950 501866 503928 504669 506051 508841 514789 520748 521995 541928 545999 546002 546951 548571 552672 553608 560594 563214 567170 567391 569983 570291 570638 573550 574815 574838 574839 575728 576020 576027 576038 576071 577117 580678 586449 594223 594918 595511 596161 597074 597223 597494 597960 598014 598069 598462 598470 598731 600157 601877 604147 605841 610595 654846 660300 664433 665830 678954 679378 695316 701508 714463 714490 716543 716577 722645 723933 744753 753260 775797 784569 785337 791362 800535 800563 805243 805504 809909 810032 811340 812364 814562 820924 821717 821839 821846 821854 821856 821867 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian old young"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск old young"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск old young"
]
|
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.