Query Metrics
7
Database Queries
7
Different statements
220.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.90 ms (90.24%) |
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 188064 383377 387326 388639 391704 395699 396320 397923 402980 413653 416407 419940 425554 425560 427491 428466 428475 428603 432695 433699 434193 440372 440817 440902 443159 443728 445596 450765 450824 452271 467682 474465 484363 486257 488073 508730 513135 519735 522509 522510 523113 524251 532087 532130 532832 537729 539628 540609 543811 546947 549310 563912 563923 564682 573742 582222 583718 586831 586921 592441 603455 621700 682353 683978 696314 696321 696578 696990 699638 705358 708044 709346 710555 712041 712619 712625 712650 712685 712689 714339 714523 716288 728164 730627 730982 731187 744165 744386 744540 756426 761121 764621 777734 777755 780409 788277 788883 794766 795661 796212 799979 801013 801261 801450 802698 803339 805101 805704 806357 807352 807425 807738 809787 818148 819054 820140 824376 824915 825176 825303 ] |
||||||||||||||||||||||||||||||
|
11.85 ms (5.37%) |
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 730982 799979 807738 730627 764621 731187 709346 714523 777755 696321 603455 586831 744540 427491 563923 573742 402980 383377 450765 467682 488073 712041 419940 540609 543811 428475 440902 443159 582222 794766 425560 683978 712625 716288 621700 801013 744165 805704 806357 486257 433699 824915 807425 801261 744386 756426 801450 440372 484363 388639 825176 537729 696314 563912 761121 188064 440817 474465 807352 777734 788277 391704 522510 546947 396320 428603 416407 445596 519735 523113 387326 539628 425554 450824 508730 524251 532087 705358 592441 583718 564682 682353 696578 710555 712619 712685 712689 708044 714339 795661 805101 696990 712650 780409 788883 796212 803339 809787 513135 397923 428466 820140 818148 586921 728164 395699 443728 819054 825303 824376 532832 522509 549310 802698 699638 413653 432695 434193 452271 532130 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.24%) |
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 188064 383377 387326 388639 391704 395699 396320 397923 402980 413653 416407 419940 425554 425560 427491 428466 428475 428603 432695 433699 434193 440372 440817 440902 443159 443728 445596 450765 450824 452271 467682 474465 484363 486257 488073 508730 513135 519735 522509 522510 523113 524251 532087 532130 532832 537729 539628 540609 543811 546947 549310 563912 563923 564682 573742 582222 583718 586831 586921 592441 603455 621700 682353 683978 696314 696321 696578 696990 699638 705358 708044 709346 710555 712041 712619 712625 712650 712685 712689 714339 714523 716288 728164 730627 730982 731187 744165 744386 744540 756426 761121 764621 777734 777755 780409 788277 788883 794766 795661 796212 799979 801013 801261 801450 802698 803339 805101 805704 806357 807352 807425 807738 809787 818148 819054 820140 824376 824915 825176 825303 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother sleep"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин спящ"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.70%) |
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.