Query Metrics
7
Database Queries
7
Different statements
197.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.68 ms (85.40%) |
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 6669 23687 33711 97288 198127 262418 270386 288045 329500 356378 382089 382200 382311 382609 383733 384585 384750 384889 386442 393505 395263 398646 400014 400341 401587 401894 402032 404208 404359 413956 415254 418389 422816 423983 426234 428286 428877 429117 429220 429321 432384 435888 444250 445216 445855 447753 449258 451698 452600 453895 454786 454789 455361 457017 457090 457400 458750 460664 462794 464073 469099 473095 486726 490479 490580 492838 495864 499918 500738 501020 509390 512302 519758 523365 524519 528449 528575 528672 528926 530642 532151 532344 533530 536009 537790 538782 544448 545046 548025 550499 551405 556298 560145 566885 570461 570478 571894 579364 581936 583562 591222 600454 601513 602345 615048 618458 635192 650094 655083 656372 670405 674369 687506 690480 697570 757487 765346 811615 812616 824864 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (8.11%) |
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 544448 697570 670405 655083 635192 811615 812616 765346 382311 386442 401587 418389 458750 500738 528575 383733 288045 382609 382200 6669 400341 401894 444250 429220 447753 490580 492838 453895 454786 454789 499918 519758 533530 530642 509390 536009 495864 486726 570461 656372 650094 674369 618458 600454 402032 404208 423983 384750 413956 445216 457017 404359 455361 398646 473095 426234 537790 528449 490479 512302 524519 384585 384889 395263 393505 382089 356378 97288 33711 23687 429117 432384 435888 428286 428877 429321 824864 445855 462794 449258 457090 457400 464073 451698 460664 528672 532344 501020 538782 532151 523365 528926 556298 571894 550499 581936 560145 579364 583562 690480 687506 545046 548025 551405 566885 570478 601513 591222 757487 602345 615048 198127 415254 452600 270386 400014 422816 469099 262418 329500 ] |
||||||||||||||||||||||||||||||
|
4.24 ms (2.15%) |
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 6669 23687 33711 97288 198127 262418 270386 288045 329500 356378 382089 382200 382311 382609 383733 384585 384750 384889 386442 393505 395263 398646 400014 400341 401587 401894 402032 404208 404359 413956 415254 418389 422816 423983 426234 428286 428877 429117 429220 429321 432384 435888 444250 445216 445855 447753 449258 451698 452600 453895 454786 454789 455361 457017 457090 457400 458750 460664 462794 464073 469099 473095 486726 490479 490580 492838 495864 499918 500738 501020 509390 512302 519758 523365 524519 528449 528575 528672 528926 530642 532151 532344 533530 536009 537790 538782 544448 545046 548025 550499 551405 556298 560145 566885 570461 570478 571894 579364 581936 583562 591222 600454 601513 602345 615048 618458 635192 650094 655083 656372 670405 674369 687506 690480 697570 757487 765346 811615 812616 824864 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"шортах"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шорт"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.77%) |
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.