Query Metrics
7
Database Queries
7
Different statements
178.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.92 ms (84.70%) |
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 388560 389551 400715 419013 422357 426689 432954 433984 438841 442564 446674 448503 453865 457506 459122 464779 466362 469836 470238 470616 470943 471189 473649 473675 484832 491084 492060 492061 503891 504206 510506 510636 510649 522682 523305 523938 524366 525908 526120 533585 534170 538143 538228 542551 546789 547686 547902 549865 552077 552079 552133 552163 552183 552410 552839 554052 557365 558831 559554 561312 562323 564139 564809 565900 569291 569301 570231 570325 570628 570970 571634 572523 573031 573037 573692 573697 578383 579991 584114 590406 598027 598715 599007 599560 601407 601870 602836 603876 607283 610543 610847 616000 617647 618774 621593 623055 628024 635667 651808 651812 652590 676455 682352 693292 694157 709816 714486 740254 748149 756804 763435 777914 779940 781676 781741 783231 784142 793593 793629 795151 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (9.28%) |
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 542551 564139 569291 552077 569301 598027 599560 607283 598715 388560 389551 438841 453865 469836 470616 422357 459122 470943 471189 448503 504206 510506 523305 503891 526120 492061 510636 523938 484832 538228 579991 534170 466362 491084 562323 558831 572523 552163 552183 552410 694157 571634 590406 603876 419013 470238 522682 510649 525908 457506 400715 473649 538143 524366 533585 492060 552133 552839 564809 570325 547902 559554 565900 573692 573697 578383 584114 549865 552079 570231 570628 570970 573031 651808 651812 652590 676455 682352 709816 693292 714486 546789 547686 554052 557365 561312 573037 601870 610543 610847 623055 601407 616000 599007 602836 617647 618774 628024 635667 777914 779940 763435 781741 784142 740254 748149 756804 621593 781676 783231 793593 793629 795151 432954 446674 464779 473675 426689 433984 442564 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.78%) |
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 388560 389551 400715 419013 422357 426689 432954 433984 438841 442564 446674 448503 453865 457506 459122 464779 466362 469836 470238 470616 470943 471189 473649 473675 484832 491084 492060 492061 503891 504206 510506 510636 510649 522682 523305 523938 524366 525908 526120 533585 534170 538143 538228 542551 546789 547686 547902 549865 552077 552079 552133 552163 552183 552410 552839 554052 557365 558831 559554 561312 562323 564139 564809 565900 569291 569301 570231 570325 570628 570970 571634 572523 573031 573037 573692 573697 578383 579991 584114 590406 598027 598715 599007 599560 601407 601870 602836 603876 607283 610543 610847 616000 617647 618774 621593 623055 628024 635667 651808 651812 652590 676455 682352 693292 694157 709816 714486 740254 748149 756804 763435 777914 779940 781676 781741 783231 784142 793593 793629 795151 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian natural"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 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.