Query Metrics
7
Database Queries
7
Different statements
425.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
401.09 ms (94.25%) |
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 79942 212914 213153 233333 365962 383090 384095 385008 397664 397843 398837 404000 406330 416163 417304 419548 419616 421484 421802 423019 423907 426771 429386 429654 432505 433594 447335 448051 451487 453526 465835 465903 466055 466067 469455 477793 481283 481750 486257 498126 500149 500654 508696 520739 524089 525930 526880 527893 533750 535962 546952 551812 555429 560265 563135 571082 612586 617044 621580 621592 625646 626177 627212 627758 657831 660076 663193 664276 677349 677860 682951 687852 695705 695734 695760 695766 695805 695812 709013 710173 721736 721738 721819 722141 723668 728173 728247 728253 730741 730760 730769 731907 732414 732442 732806 733085 735863 741899 744321 746089 746579 755146 755147 755164 757238 761217 767638 767669 767697 776818 782969 790760 791758 797509 801667 803159 812446 812464 812728 814363 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (3.38%) |
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 677349 626177 627758 728173 520739 571082 406330 710173 791758 741899 757238 767638 732414 79942 383090 213153 398837 469455 677860 682951 695705 695760 722141 625646 612586 621580 776818 812446 801667 723668 746579 761217 728253 730760 728247 746089 767697 421484 477793 451487 486257 527893 709013 687852 695766 621592 812728 755146 744321 812464 384095 524089 212914 721736 782969 730769 733085 767669 466055 429654 417304 721738 735863 555429 429386 397664 533750 508696 731907 732806 721819 419548 423019 419616 466067 526880 525930 416163 465835 397843 481750 500149 385008 814363 453526 535962 546952 695734 695812 660076 663193 695805 730741 732442 423907 421802 481283 233333 404000 426771 500654 448051 560265 551812 664276 657831 617044 627212 755164 790760 797509 803159 755147 433594 447335 432505 365962 498126 465903 563135 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (0.57%) |
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 79942 212914 213153 233333 365962 383090 384095 385008 397664 397843 398837 404000 406330 416163 417304 419548 419616 421484 421802 423019 423907 426771 429386 429654 432505 433594 447335 448051 451487 453526 465835 465903 466055 466067 469455 477793 481283 481750 486257 498126 500149 500654 508696 520739 524089 525930 526880 527893 533750 535962 546952 551812 555429 560265 563135 571082 612586 617044 621580 621592 625646 626177 627212 627758 657831 660076 663193 664276 677349 677860 682951 687852 695705 695734 695760 695766 695805 695812 709013 710173 721736 721738 721819 722141 723668 728173 728247 728253 730741 730760 730769 731907 732414 732442 732806 733085 735863 741899 744321 746089 746579 755146 755147 755164 757238 761217 767638 767669 767697 776818 782969 790760 791758 797509 801667 803159 812446 812464 812728 814363 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"колготк секс"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tights fuck"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.39%) |
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.