Query Metrics
7
Database Queries
7
Different statements
188.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.76 ms (87.04%) |
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 476476 516221 538824 538837 538856 538913 539619 539627 541293 541337 541419 541599 541622 541626 541636 541693 541873 541875 542198 542471 543497 544254 544277 544278 544295 544308 544310 544313 544317 544864 547859 547869 548289 549300 549302 549780 556786 556988 560080 560091 560950 561026 562830 562834 562846 562857 563534 563540 566246 566686 566691 566692 566699 572545 573905 573911 574281 576632 576641 576669 576687 577353 577375 581260 581350 581389 583887 587763 587807 598427 601068 603212 618862 620120 620172 622316 628324 644315 644381 648963 649105 650570 650833 670090 670106 670114 671760 671761 672099 672112 672118 681085 681159 687130 690860 692103 692209 694485 699594 703037 703046 703097 703512 703514 703521 705521 705915 715676 716323 719059 719107 722197 730301 740097 744276 744287 750064 800625 813115 823358 ] |
||||||||||||||||||||||||||||||
|
13.66 ms (7.26%) |
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 715676 541419 581350 750064 476476 538856 539627 544308 572545 581389 549302 549780 692103 719059 719107 672118 648963 670090 672099 681159 694485 547869 562857 603212 622316 587807 730301 740097 722197 542198 541636 541693 628324 823358 538824 544864 560091 574281 544310 547859 576641 649105 690860 692209 705915 670106 670114 699594 703097 703512 671760 672112 681085 687130 705521 556988 618862 644315 598427 644381 620172 800625 813115 744276 744287 703037 703046 703514 703521 541626 539619 516221 538837 538913 541599 543497 544277 544313 544317 548289 562830 576687 577353 581260 583887 541293 541622 541873 544254 560080 562846 563540 566686 566692 573905 573911 577375 541337 541875 542471 544278 544295 549300 562834 563534 566246 566699 576632 576669 650570 671761 716323 650833 556786 560950 561026 566691 587763 601068 620120 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.43%) |
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 476476 516221 538824 538837 538856 538913 539619 539627 541293 541337 541419 541599 541622 541626 541636 541693 541873 541875 542198 542471 543497 544254 544277 544278 544295 544308 544310 544313 544317 544864 547859 547869 548289 549300 549302 549780 556786 556988 560080 560091 560950 561026 562830 562834 562846 562857 563534 563540 566246 566686 566691 566692 566699 572545 573905 573911 574281 576632 576641 576669 576687 577353 577375 581260 581350 581389 583887 587763 587807 598427 601068 603212 618862 620120 620172 622316 628324 644315 644381 648963 649105 650570 650833 670090 670106 670114 671760 671761 672099 672112 672118 681085 681159 687130 690860 692103 692209 694485 699594 703037 703046 703097 703512 703514 703521 705521 705915 715676 716323 719059 719107 722197 730301 740097 744276 744287 750064 800625 813115 823358 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage films"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage фильм"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage фильм"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.