Query Metrics
7
Database Queries
7
Different statements
169.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.91 ms (83.30%) |
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 154512 375135 381966 382205 383500 386193 392839 398095 402278 403896 414094 416537 416631 416695 416707 421993 423784 427128 427457 432824 432944 432945 432974 441040 442337 443251 444896 445950 448880 449921 449970 454368 454793 466739 469792 471129 471168 471676 474596 476658 494529 500333 505093 511864 512072 516676 521139 523362 524675 526902 526905 530368 531578 531580 542163 545453 556514 567120 567122 568501 573257 574038 576848 586999 587291 589836 592650 595622 596989 600922 619322 634109 644386 648704 656856 658816 662026 662046 662049 668305 688181 689775 705119 705641 712268 717520 717542 721257 722381 739123 739795 745083 745092 745915 747325 752630 752675 752682 752686 752755 769148 770386 777052 782517 784701 787290 788027 791132 792370 792712 792726 794303 796949 806834 808742 809000 810761 813205 814140 814151 ] |
||||||||||||||||||||||||||||||
|
17.53 ms (10.36%) |
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 521139 524675 542163 662049 688181 717542 689775 705119 717520 722381 705641 567122 600922 644386 813205 782517 752675 752686 752755 769148 745083 381966 392839 375135 386193 656856 788027 810761 154512 494529 574038 712268 794303 402278 403896 416707 414094 427128 441040 432944 432945 443251 416695 427457 449970 471676 448880 454793 512072 511864 500333 531578 505093 516676 526905 474596 556514 662046 567120 576848 592650 587291 619322 589836 596989 808742 432824 432974 471129 423784 416631 421993 445950 721257 595622 792370 787290 796949 739123 739795 398095 416537 442337 814140 814151 471168 449921 476658 523362 526902 530368 531580 545453 573257 568501 648704 658816 662026 668305 586999 634109 809000 777052 745092 784701 792726 752682 745915 747325 752630 770386 791132 792712 806834 382205 383500 454368 469792 444896 466739 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (2.10%) |
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 154512 375135 381966 382205 383500 386193 392839 398095 402278 403896 414094 416537 416631 416695 416707 421993 423784 427128 427457 432824 432944 432945 432974 441040 442337 443251 444896 445950 448880 449921 449970 454368 454793 466739 469792 471129 471168 471676 474596 476658 494529 500333 505093 511864 512072 516676 521139 523362 524675 526902 526905 530368 531578 531580 542163 545453 556514 567120 567122 568501 573257 574038 576848 586999 587291 589836 592650 595622 596989 600922 619322 634109 644386 648704 656856 658816 662026 662046 662049 668305 688181 689775 705119 705641 712268 717520 717542 721257 722381 739123 739795 745083 745092 745915 747325 752630 752675 752682 752686 752755 769148 770386 777052 782517 784701 787290 788027 791132 792370 792712 792726 794303 796949 806834 808742 809000 810761 813205 814140 814151 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дылдо teens"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд teens"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд teens"
]
|
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.