Query Metrics
7
Database Queries
7
Different statements
407.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
274.86 ms (67.49%) |
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 470007 470311 506861 437980 406853 416152 444841 411183 440710 452827 434964 460525 466645 422241 430396 449280 484764 453506 472379 498933 446745 123994 419427 434081 441664 431727 435658 426042 418032 482579 466708 477636 445632 455023 469349 463590 481550 420507 458269 456307 425594 466486 461581 522409 501232 403283 447217 411425 454954 434854 435165 444523 420217 423642 456807 468738 463420 444672 389281 436578 467646 463445 480895 469299 527205 508316 508374 432656 423513 458318 452405 495221 441925 429107 419567 404346 439195 445825 454743 457208 428253 435795 449586 464836 431209 441756 452269 462402 454600 462696 460359 454869 454111 385830 420219 428354 428595 448512 461655 474809 472399 418005 425682 459040 463271 462996 427843 429929 457881 441288 405683 430832 432270 435512 441654 410891 448196 478791 478285 452410 ] |
||||||||||||||||||||||||||||||
|
123.18 ms (30.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 123994 385830 389281 403283 404346 405683 406853 410891 411183 411425 416152 418005 418032 419427 419567 420217 420219 420507 422241 423513 423642 425594 425682 426042 427843 428253 428354 428595 429107 429929 430396 430832 431209 431727 432270 432656 434081 434854 434964 435165 435512 435658 435795 436578 437980 439195 440710 441288 441654 441664 441756 441925 444523 444672 444841 445632 445825 446745 447217 448196 448512 449280 449586 452269 452405 452410 452827 453506 454111 454600 454743 454869 454954 455023 456307 456807 457208 457881 458269 458318 459040 460359 460525 461581 461655 462402 462696 462996 463271 463420 463445 463590 464836 466486 466645 466708 467646 468738 469299 469349 470007 470311 472379 472399 474809 477636 478285 478791 480895 481550 482579 484764 495221 498933 501232 506861 508316 508374 522409 527205 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.67%) |
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 123994 385830 389281 403283 404346 405683 406853 410891 411183 411425 416152 418005 418032 419427 419567 420217 420219 420507 422241 423513 423642 425594 425682 426042 427843 428253 428354 428595 429107 429929 430396 430832 431209 431727 432270 432656 434081 434854 434964 435165 435512 435658 435795 436578 437980 439195 440710 441288 441654 441664 441756 441925 444523 444672 444841 445632 445825 446745 447217 448196 448512 449280 449586 452269 452405 452410 452827 453506 454111 454600 454743 454869 454954 455023 456307 456807 457208 457881 458269 458318 459040 460359 460525 461581 461655 462402 462696 462996 463271 463420 463445 463590 464836 466486 466645 466708 467646 468738 469299 469349 470007 470311 472379 472399 474809 477636 478285 478791 480895 481550 482579 484764 495221 498933 501232 506861 508316 508374 522409 527205 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стройные голые девушк…"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"стройные голые девушк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.36%) |
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.