Query Metrics
7
Database Queries
7
Different statements
154.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.04 ms (78.46%) |
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 14602 106162 109043 212183 271756 274678 326305 381828 382437 385228 385476 391871 392760 393700 393737 396226 396757 396894 397329 399515 399689 399828 400418 400434 400458 400714 400715 401714 401976 411218 412713 413288 413468 414361 414498 417362 418485 421519 422711 425223 427449 427523 428364 428543 429249 430713 432887 435498 437448 437939 443370 446480 447661 448927 449109 450779 452413 453530 454195 458855 459811 462356 462961 463114 464925 465639 465652 467169 469079 469415 469594 469844 471448 474060 474385 475020 475869 476310 477553 477699 485600 487481 489245 489796 495159 497524 504829 508109 509075 515106 522079 522699 549296 549387 551137 555112 556425 556844 557983 559707 560188 560202 562361 565617 567380 567605 575778 581700 589148 593440 594807 597561 603954 605515 609196 609278 612751 613836 620882 624430 ] |
||||||||||||||||||||||||||||||
|
21.57 ms (13.99%) |
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 557983 399828 422711 504829 551137 560188 613836 589148 609196 609278 603954 567380 562361 620882 624430 385476 385228 392760 271756 381828 14602 396226 400714 400418 400458 400715 401976 411218 413468 421519 430713 437939 412713 417362 418485 427449 428543 435498 443370 427523 446480 453530 462356 463114 489245 489796 448927 459811 477553 447661 454195 462961 469415 508109 495159 465639 469079 469594 475869 476310 549387 549296 559707 555112 556425 556844 581700 593440 594807 597561 605515 109043 326305 391871 393700 414498 425223 428364 429249 458855 467169 474060 477699 106162 382437 396894 400434 413288 465652 212183 274678 397329 399689 437448 471448 474385 393737 396757 399515 401714 432887 449109 452413 464925 469844 475020 414361 450779 485600 509075 487481 522699 497524 515106 522079 565617 575778 560202 567605 612751 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.96%) |
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 14602 106162 109043 212183 271756 274678 326305 381828 382437 385228 385476 391871 392760 393700 393737 396226 396757 396894 397329 399515 399689 399828 400418 400434 400458 400714 400715 401714 401976 411218 412713 413288 413468 414361 414498 417362 418485 421519 422711 425223 427449 427523 428364 428543 429249 430713 432887 435498 437448 437939 443370 446480 447661 448927 449109 450779 452413 453530 454195 458855 459811 462356 462961 463114 464925 465639 465652 467169 469079 469415 469594 469844 471448 474060 474385 475020 475869 476310 477553 477699 485600 487481 489245 489796 495159 497524 504829 508109 509075 515106 522079 522699 549296 549387 551137 555112 556425 556844 557983 559707 560188 560202 562361 565617 567380 567605 575778 581700 589148 593440 594807 597561 603954 605515 609196 609278 612751 613836 620882 624430 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ÐâðÂð©ð║ Ðü ð╝ÐâðÂð©ð║ð¥ð╝ ð© ð▒ð░ð▒ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин мужчин женскийрод"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 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.