Query Metrics
7
Database Queries
7
Different statements
155.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.48 ms (83.68%) |
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 88410 336987 337263 386613 392440 392544 392552 392655 393323 394597 396778 397807 398044 398464 398516 398689 399053 402409 408178 408219 411134 412537 416083 417502 417998 418395 419308 419826 420622 421417 422305 422734 423628 423630 423708 424697 425394 432317 433996 434401 437854 438878 440676 442100 444968 447049 450389 451277 453870 453882 455823 459277 465639 465685 467109 468128 469181 469266 469270 472393 472395 472396 482735 495125 507559 510584 523397 528307 529945 529952 530115 532531 532572 537487 540217 542026 542578 545773 545791 545801 545802 545803 545822 545829 545839 546442 550277 550315 550563 550677 552623 566908 574467 579386 583068 583960 596147 596556 598139 600186 603258 604517 604528 605521 605612 616336 631981 632269 632595 632680 632694 632701 636559 644718 656175 656209 656307 688369 768349 823777 ] |
||||||||||||||||||||||||||||||
|
14.99 ms (9.61%) |
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 546442 631981 636559 596556 596147 632694 644718 542026 545839 545829 537487 545801 550277 616336 468128 532531 583960 545803 545822 545791 604528 688369 605612 532572 540217 632680 393323 545802 550315 603258 604517 566908 412537 768349 632269 392655 552623 545773 632595 408178 823777 632701 392552 605521 656209 392544 421417 398516 420622 411134 656307 495125 386613 398044 419826 399053 550677 465685 523397 550563 397807 433996 417998 482735 88410 337263 469266 579386 440676 510584 442100 459277 398689 447049 450389 453870 453882 465639 469270 469181 472393 336987 437854 434401 451277 598139 408219 423630 419308 467109 656175 444968 423628 528307 472395 392440 396778 402409 416083 418395 438878 472396 583068 574467 425394 455823 424697 394597 432317 422305 398464 417502 507559 530115 529945 542578 422734 529952 423708 600186 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.60%) |
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 88410 336987 337263 386613 392440 392544 392552 392655 393323 394597 396778 397807 398044 398464 398516 398689 399053 402409 408178 408219 411134 412537 416083 417502 417998 418395 419308 419826 420622 421417 422305 422734 423628 423630 423708 424697 425394 432317 433996 434401 437854 438878 440676 442100 444968 447049 450389 451277 453870 453882 455823 459277 465639 465685 467109 468128 469181 469266 469270 472393 472395 472396 482735 495125 507559 510584 523397 528307 529945 529952 530115 532531 532572 537487 540217 542026 542578 545773 545791 545801 545802 545803 545822 545829 545839 546442 550277 550315 550563 550677 552623 566908 574467 579386 583068 583960 596147 596556 598139 600186 603258 604517 604528 605521 605612 616336 631981 632269 632595 632680 632694 632701 636559 644718 656175 656209 656307 688369 768349 823777 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pmv big"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pmv большие"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pmv большие"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.