Query Metrics
7
Database Queries
7
Different statements
139.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.05 ms (83.39%) |
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 444209 477565 530666 542295 542310 542316 542322 542348 542356 543165 543178 543288 543289 543291 543293 543508 545030 547225 549146 550303 550309 557203 559358 567595 574960 574977 574998 575026 575590 576925 578726 580577 585459 588387 591571 591865 595241 599521 602852 606917 610076 610711 615020 618760 620047 621887 622916 623994 626366 628449 628519 628548 628631 632549 632959 635361 636477 640180 640964 645183 649059 650642 655939 656544 656873 658136 660035 660770 660817 660845 661581 666026 687564 688950 702056 706381 707516 710026 711660 712629 713058 714048 714424 726130 727545 727571 730062 731298 731361 733136 741152 745925 746756 747879 749515 749608 750237 750247 750250 750278 757046 762777 769775 769906 778694 782334 785317 785615 789507 792961 796041 796049 796067 797135 800084 804420 810027 811549 813743 826480 ] |
||||||||||||||||||||||||||||||
|
12.35 ms (8.88%) |
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 785317 785615 796041 796067 749515 746756 726130 741152 750278 707516 712629 713058 782334 792961 543178 622916 714424 731361 714048 610711 636477 610076 542310 543291 731298 804420 813743 530666 542348 574960 542322 542356 550309 656544 660035 661581 655939 710026 547225 640180 591865 606917 796049 778694 811549 730062 797135 745925 750250 750237 628449 769775 567595 543165 687564 733136 826480 549146 557203 574998 575590 542316 543293 660770 660817 666026 711660 649059 656873 702056 706381 645183 650642 621887 599521 628631 635361 595241 602852 800084 789507 727571 810027 747879 769906 762777 749608 757046 618760 632959 640964 444209 477565 620047 660845 542295 543288 545030 550303 559358 580577 543289 574977 575026 576925 578726 658136 688950 623994 628519 588387 628548 585459 591571 750247 727545 615020 632549 543508 626366 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.91%) |
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 444209 477565 530666 542295 542310 542316 542322 542348 542356 543165 543178 543288 543289 543291 543293 543508 545030 547225 549146 550303 550309 557203 559358 567595 574960 574977 574998 575026 575590 576925 578726 580577 585459 588387 591571 591865 595241 599521 602852 606917 610076 610711 615020 618760 620047 621887 622916 623994 626366 628449 628519 628548 628631 632549 632959 635361 636477 640180 640964 645183 649059 650642 655939 656544 656873 658136 660035 660770 660817 660845 661581 666026 687564 688950 702056 706381 707516 710026 711660 712629 713058 714048 714424 726130 727545 727571 730062 731298 731361 733136 741152 745925 746756 747879 749515 749608 750237 750247 750250 750278 757046 762777 769775 769906 778694 782334 785317 785615 789507 792961 796041 796049 796067 797135 800084 804420 810027 811549 813743 826480 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"arab wife"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"араб жен"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.