Query Metrics
7
Database Queries
7
Different statements
163.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.91 ms (83.05%) |
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 34462 81641 154707 155198 282038 382014 393314 402630 410310 415028 423307 428267 445083 447853 451694 486643 488933 490692 492440 494540 506310 517693 518601 525822 532399 533648 537857 537872 541468 542880 547028 554325 556813 563902 565111 567083 574318 576637 577408 592930 595189 597177 598338 599064 601194 603557 607676 607685 609696 613152 613608 614793 615935 615964 622733 625435 625467 626257 626263 631740 634849 644876 649644 668292 668620 668809 684731 689660 707483 715138 716181 732293 732428 736836 739912 743834 745422 745473 745968 747325 749909 750078 750483 752094 752656 752876 755165 758170 758248 758330 758715 760596 761027 770178 771213 773524 775529 775774 780653 785387 788113 788839 792265 792938 797308 799542 801341 804210 804445 804504 807387 807402 807894 808068 808650 809281 811477 813388 814151 827290 ] |
||||||||||||||||||||||||||||||
|
17.72 ms (10.83%) |
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 801341 758170 771213 743834 750078 732293 736836 752876 745473 749909 755165 761027 603557 615964 622733 626257 715138 34462 423307 486643 402630 609696 614793 739912 758715 760596 745968 792938 81641 155198 814151 533648 649644 599064 595189 775529 788113 788839 792265 804445 807894 758248 758330 747325 752094 752656 716181 807402 154707 393314 282038 382014 410310 428267 445083 415028 644876 827290 492440 451694 447853 490692 494540 506310 517693 537857 537872 518601 525822 532399 488933 542880 547028 567083 541468 556813 565111 576637 554325 574318 689660 707483 668292 668809 684731 668620 563902 577408 592930 607676 613152 625435 631740 634849 607685 613608 615935 626263 597177 598338 601194 625467 780653 799542 804210 804504 807387 808650 775774 785387 797308 813388 745422 750483 773524 808068 809281 811477 732428 770178 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.59%) |
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 34462 81641 154707 155198 282038 382014 393314 402630 410310 415028 423307 428267 445083 447853 451694 486643 488933 490692 492440 494540 506310 517693 518601 525822 532399 533648 537857 537872 541468 542880 547028 554325 556813 563902 565111 567083 574318 576637 577408 592930 595189 597177 598338 599064 601194 603557 607676 607685 609696 613152 613608 614793 615935 615964 622733 625435 625467 626257 626263 631740 634849 644876 649644 668292 668620 668809 684731 689660 707483 715138 716181 732293 732428 736836 739912 743834 745422 745473 745968 747325 749909 750078 750483 752094 752656 752876 755165 758170 758248 758330 758715 760596 761027 770178 771213 773524 775529 775774 780653 785387 788113 788839 792265 792938 797308 799542 801341 804210 804445 804504 807387 807402 807894 808068 808650 809281 811477 813388 814151 827290 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.90%) |
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.