Query Metrics
7
Database Queries
7
Different statements
150.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.33 ms (80.89%) |
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 198179 394548 411471 413464 417126 419147 426862 427355 434889 434908 435477 437443 437450 437790 438060 444080 447140 450567 451144 452463 452756 453058 453061 456797 456940 458427 458526 459002 459346 459381 463562 471326 471772 472843 473393 474910 479874 480806 481670 482850 486742 487552 488297 489259 489260 495444 495965 498076 498435 499341 500692 504423 505320 505550 508521 509288 509293 510478 510704 510834 511235 511356 514966 516666 517169 517384 517998 518093 518317 518802 519120 519124 524344 526882 527978 528814 533030 548643 552333 553101 561657 565393 571322 577632 579631 581988 587995 590200 590286 594525 595794 598020 600320 600558 605396 612581 614073 616376 624787 625582 628823 633689 636434 639051 650177 652945 660606 677064 687190 716072 717173 717606 721728 724209 724636 725458 774563 776731 795216 821036 ] |
||||||||||||||||||||||||||||||
|
19.52 ms (13.01%) |
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 628823 590286 795216 774563 724636 725458 716072 413464 434908 438060 473393 426862 518317 533030 434889 821036 452756 456797 458526 479874 450567 518802 499341 511356 500692 472843 489259 489260 581988 463562 474910 437450 453058 471326 411471 427355 453061 417126 471772 528814 488297 495965 717173 508521 419147 487552 548643 456940 509293 498435 435477 721728 614073 624787 594525 517998 518093 437790 495444 577632 579631 561657 677064 660606 571322 587995 595794 600320 639051 598020 600558 590200 636434 776731 633689 198179 447140 687190 605396 437443 486742 527978 459346 505550 517169 505320 510478 510834 552333 565393 444080 480806 509288 482850 510704 511235 514966 519120 526882 498076 519124 481670 394548 458427 459381 452463 524344 724209 717606 517384 504423 459002 516666 553101 650177 652945 616376 625582 612581 451144 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.50%) |
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 198179 394548 411471 413464 417126 419147 426862 427355 434889 434908 435477 437443 437450 437790 438060 444080 447140 450567 451144 452463 452756 453058 453061 456797 456940 458427 458526 459002 459346 459381 463562 471326 471772 472843 473393 474910 479874 480806 481670 482850 486742 487552 488297 489259 489260 495444 495965 498076 498435 499341 500692 504423 505320 505550 508521 509288 509293 510478 510704 510834 511235 511356 514966 516666 517169 517384 517998 518093 518317 518802 519120 519124 524344 526882 527978 528814 533030 548643 552333 553101 561657 565393 571322 577632 579631 581988 587995 590200 590286 594525 595794 598020 600320 600558 605396 612581 614073 616376 624787 625582 628823 633689 636434 639051 650177 652945 660606 677064 687190 716072 717173 717606 721728 724209 724636 725458 774563 776731 795216 821036 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big load"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие load"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие load"
]
|
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.