Query Metrics
7
Database Queries
7
Different statements
188.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.04 ms (85.76%) |
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 90485 382404 383744 383773 384348 385421 391603 397279 397514 398236 398244 398261 403315 404346 406217 413117 414329 417878 418577 420490 421366 427089 429065 434455 434803 438054 444378 445776 446310 453078 454387 457873 461487 466969 467131 467955 468031 470689 471153 472811 480300 481965 484058 485208 486748 486751 486753 501466 507591 509476 510948 511262 511269 511403 515058 517882 520292 521171 521226 521953 526046 528097 529101 530942 532300 533897 534279 535703 542507 543596 545328 546082 552800 552967 554506 554527 554657 556912 556920 557378 560392 560447 560898 562006 562714 564655 567136 571841 579807 580144 584049 622778 624131 644813 659013 670662 700975 708232 710357 723075 732423 737168 738480 741427 744088 748552 749735 750896 752876 770954 773922 776493 777823 784557 785024 785293 814209 815354 815592 816601 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (9.47%) |
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 738480 750896 770954 732423 744088 752876 773922 737168 741427 748552 749735 710357 776493 777823 784557 785024 785293 403315 406217 427089 446310 384348 397514 398236 417878 467131 472811 397279 445776 453078 90485 414329 421366 444378 470689 511262 511403 526046 517882 521171 484058 486751 521953 571841 507591 543596 556912 584049 622778 624131 385421 383744 383773 391603 382404 398261 398244 404346 420490 429065 434803 438054 413117 418577 434455 815354 644813 814209 815592 816601 485208 468031 480300 486753 454387 457873 466969 467955 481965 501466 510948 521226 529101 533897 532300 534279 515058 520292 530942 535703 509476 511269 528097 461487 471153 486748 552967 554506 560898 562714 567136 579807 580144 542507 545328 560447 562006 564655 546082 554527 560392 659013 670662 700975 708232 723075 552800 554657 556920 557378 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.23%) |
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 90485 382404 383744 383773 384348 385421 391603 397279 397514 398236 398244 398261 403315 404346 406217 413117 414329 417878 418577 420490 421366 427089 429065 434455 434803 438054 444378 445776 446310 453078 454387 457873 461487 466969 467131 467955 468031 470689 471153 472811 480300 481965 484058 485208 486748 486751 486753 501466 507591 509476 510948 511262 511269 511403 515058 517882 520292 521171 521226 521953 526046 528097 529101 530942 532300 533897 534279 535703 542507 543596 545328 546082 552800 552967 554506 554527 554657 556912 556920 557378 560392 560447 560898 562006 562714 564655 567136 571841 579807 580144 584049 622778 624131 644813 659013 670662 700975 708232 710357 723075 732423 737168 738480 741427 744088 748552 749735 750896 752876 770954 773922 776493 777823 784557 785024 785293 814209 815354 815592 816601 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая очкастые"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"брюнетка очки"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 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.