Query Metrics
7
Database Queries
7
Different statements
149.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.57 ms (82.02%) |
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 188338 197678 197736 358566 382058 387856 388769 389273 389713 391163 391380 391703 391704 391928 400819 409935 411398 411406 418126 420849 421826 421870 421900 421918 422141 423940 426712 427091 429736 433291 434313 434358 434371 434384 435530 439078 439546 439555 439610 439737 440964 443696 443702 445103 451507 452960 455130 456333 460760 460873 462019 463792 465528 465812 466180 466190 466195 466196 466256 473252 475185 476675 476936 478377 478462 478740 479369 482342 483787 484649 486578 490406 491444 491943 493258 494798 495811 499391 500806 502712 506031 508684 513379 513676 516299 519540 520309 520904 528143 536433 540743 543694 546955 546958 549822 549825 549843 552855 555093 556519 583085 668529 683284 709528 714911 719929 725570 728687 733371 740826 758509 777727 796252 797358 802151 807352 807353 816609 824066 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (10.89%) |
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 411398 427091 476675 388769 391163 411406 452960 460873 473252 462019 540743 491444 494798 495811 520309 389273 358566 391380 391703 466190 797358 391928 460760 389713 482342 478377 490406 486578 420849 556519 714911 668529 555093 802151 807352 807353 777727 733371 758509 740826 725570 719929 188338 479369 391704 400819 409935 478740 434358 466196 500806 536433 508684 506031 520904 824066 728687 484649 816609 827870 683284 709528 796252 197736 543694 387856 382058 435530 439078 455130 546955 552855 426712 475185 478462 197678 429736 434313 434384 439546 463792 421918 422141 476936 418126 434371 443696 443702 456333 465528 421826 421870 445103 451507 528143 493258 499391 513379 513676 516299 519540 483787 491943 423940 439610 440964 421900 502712 583085 549825 549843 546958 549822 433291 466180 466256 439555 439737 465812 466195 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.91%) |
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 188338 197678 197736 358566 382058 387856 388769 389273 389713 391163 391380 391703 391704 391928 400819 409935 411398 411406 418126 420849 421826 421870 421900 421918 422141 423940 426712 427091 429736 433291 434313 434358 434371 434384 435530 439078 439546 439555 439610 439737 440964 443696 443702 445103 451507 452960 455130 456333 460760 460873 462019 463792 465528 465812 466180 466190 466195 466196 466256 473252 475185 476675 476936 478377 478462 478740 479369 482342 483787 484649 486578 490406 491444 491943 493258 494798 495811 499391 500806 502712 506031 508684 513379 513676 516299 519540 520309 520904 528143 536433 540743 543694 546955 546958 549822 549825 549843 552855 555093 556519 583085 668529 683284 709528 714911 719929 725570 728687 733371 740826 758509 777727 796252 797358 802151 807352 807353 816609 824066 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с мамой русские"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин русск"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.16%) |
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.