Query Metrics
7
Database Queries
7
Different statements
185.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.60 ms (87.21%) |
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 397224 399075 399874 400157 411739 411849 419073 443315 443417 443963 443982 446875 447416 456627 464282 465816 466930 467330 470742 473909 484092 484464 487902 488306 491646 494536 495317 502730 505288 507963 515110 515111 515170 515175 515183 519980 523265 527165 529152 530756 536217 537767 540181 543657 545517 545607 546695 548582 549971 550611 550621 551982 552159 554180 556408 556911 560111 562300 563618 563876 566513 566789 567020 567147 567153 567159 567863 568041 569668 569677 575176 579368 579922 584537 586665 596659 599295 618906 645014 647937 663492 663507 668176 680156 681843 716032 722875 757896 759639 814068 814167 814644 817367 817705 817861 818118 818905 819510 819616 819624 821041 821217 821433 821529 821550 821869 821873 822097 822106 822288 822353 822725 822905 823181 824146 824999 825502 826309 827117 827862 ] |
||||||||||||||||||||||||||||||
|
14.64 ms (7.90%) |
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 551982 579368 567147 567153 567159 567863 569677 663507 663492 668176 716032 545517 569668 596659 599295 618906 759639 467330 473909 399874 465816 443963 446875 456627 464282 470742 443982 515183 487902 491646 502730 515170 515175 523265 505288 419073 411849 466930 530756 519980 550611 560111 548582 556911 575176 545607 568041 584537 645014 647937 722875 680156 681843 586665 757896 443315 447416 494536 484092 495317 507963 566789 397224 400157 399075 411739 443417 814068 814644 822097 822106 822353 822725 825502 814167 817861 819616 827117 818118 819624 821041 821217 821433 822905 817367 817705 818905 819510 821529 821550 821869 821873 822288 823181 824146 826309 827862 824999 484464 515110 515111 529152 536217 537767 527165 540181 488306 543657 549971 550621 552159 554180 579922 556408 562300 563618 563876 566513 567020 546695 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.28%) |
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 397224 399075 399874 400157 411739 411849 419073 443315 443417 443963 443982 446875 447416 456627 464282 465816 466930 467330 470742 473909 484092 484464 487902 488306 491646 494536 495317 502730 505288 507963 515110 515111 515170 515175 515183 519980 523265 527165 529152 530756 536217 537767 540181 543657 545517 545607 546695 548582 549971 550611 550621 551982 552159 554180 556408 556911 560111 562300 563618 563876 566513 566789 567020 567147 567153 567159 567863 568041 569668 569677 575176 579368 579922 584537 586665 596659 599295 618906 645014 647937 663492 663507 668176 680156 681843 716032 722875 757896 759639 814068 814167 814644 817367 817705 817861 818118 818905 819510 819616 819624 821041 821217 821433 821529 821550 821869 821873 822097 822106 822288 822353 822725 822905 823181 824146 824999 825502 826309 827117 827862 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old and skinny"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old худые"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old худые"
]
|
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.