Query Metrics
7
Database Queries
7
Different statements
161.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.46 ms (82.83%) |
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 30967 36844 46870 58313 58554 72305 79524 86926 114536 146341 147173 185873 197574 201885 234200 304761 308297 329296 381767 382439 382488 382854 383139 384541 386097 386449 386828 388144 389304 390163 390445 391216 392436 392584 396476 397416 398504 398771 398982 400955 401386 401641 401727 402045 404021 404072 405845 406986 410008 410079 412158 414711 417034 418497 421154 421408 422293 426234 427087 428623 432370 432425 432481 432871 432897 433480 433822 434899 441241 444057 445511 446352 446527 447461 452288 453706 455389 456978 457205 457671 459843 460487 460553 460971 461463 461916 462248 467659 468808 474164 475339 477793 478183 478984 481701 483669 483724 486582 486684 486848 490151 491213 505165 508131 509395 509772 510634 511395 538233 561304 570571 623727 652587 655725 712201 726539 781687 781758 791054 802155 ] |
||||||||||||||||||||||||||||||
|
15.61 ms (9.69%) |
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 538233 561304 509395 382488 453706 86926 58313 447461 201885 432871 623727 398504 412158 712201 781758 791054 392584 185873 455389 329296 483669 404072 405845 432425 456978 402045 655725 382439 391216 457671 432370 390163 432897 386828 382854 400955 414711 460971 781687 58554 401727 384541 406986 508131 486582 197574 460553 421408 510634 460487 72305 30967 46870 389304 390445 398982 418497 434899 457205 490151 478183 478984 459843 726539 401386 114536 467659 475339 477793 481701 652587 427087 410008 509772 392436 401641 444057 79524 426234 398771 441241 36844 505165 446527 511395 147173 308297 397416 404021 410079 432481 381767 422293 452288 802155 146341 234200 396476 421154 570571 433480 388144 417034 445511 486684 462248 474164 486848 483724 383139 433822 446352 468808 461463 461916 428623 491213 386097 386449 304761 ] |
||||||||||||||||||||||||||||||
|
5.19 ms (3.22%) |
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 30967 36844 46870 58313 58554 72305 79524 86926 114536 146341 147173 185873 197574 201885 234200 304761 308297 329296 381767 382439 382488 382854 383139 384541 386097 386449 386828 388144 389304 390163 390445 391216 392436 392584 396476 397416 398504 398771 398982 400955 401386 401641 401727 402045 404021 404072 405845 406986 410008 410079 412158 414711 417034 418497 421154 421408 422293 426234 427087 428623 432370 432425 432481 432871 432897 433480 433822 434899 441241 444057 445511 446352 446527 447461 452288 453706 455389 456978 457205 457671 459843 460487 460553 460971 461463 461916 462248 467659 468808 474164 475339 477793 478183 478984 481701 483669 483724 486582 486684 486848 490151 491213 505165 508131 509395 509772 510634 511395 538233 561304 570571 623727 652587 655725 712201 726539 781687 781758 791054 802155 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член парен мужскойрод"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"член ухажера"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.93%) |
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.