Query Metrics
7
Database Queries
7
Different statements
147.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.30 ms (82.08%) |
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 393145 413826 414771 443323 445737 448840 451264 465651 466690 468035 468733 469852 471691 473779 474643 483543 484692 488734 489243 495273 498623 507696 522138 523860 523924 525679 529129 530495 530501 530912 531105 532643 532680 532745 532829 532843 533837 533846 534372 534984 536582 537184 537236 537584 537648 537906 538255 541863 544163 544838 544840 544843 545444 546953 556045 556046 564554 582697 590809 599865 599867 599966 600708 604565 617427 632601 633123 633602 635215 639334 639716 639760 639796 639798 642032 642660 643103 645284 645861 648820 649953 650198 654097 662162 662389 666865 666895 672388 674966 677303 677397 678504 681295 690749 691381 692718 693860 696582 699397 699767 706311 714622 720582 720749 724170 728146 729691 730415 741518 745924 757099 757372 779560 783693 787519 800232 803455 805170 814503 819686 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (11.49%) |
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 730415 451264 582697 533846 541863 556045 465651 662162 692718 469852 523860 498623 529129 525679 393145 819686 546953 564554 654097 693860 699767 706311 633602 600708 779560 805170 787519 745924 714622 783693 468733 474643 531105 414771 443323 448840 534372 534984 537184 530912 530495 536582 537648 544840 545444 556046 648820 666895 645284 544843 599966 642032 639796 639798 639716 639760 632601 643103 803455 635215 413826 495273 522138 532680 532643 532745 649953 666865 645861 639334 642660 599865 617427 484692 537236 489243 532843 530501 533837 537584 471691 544838 677303 678504 696582 699397 650198 674966 599867 633123 468035 445737 483543 488734 814503 532829 677397 720582 672388 681295 720749 691381 800232 729691 757372 741518 724170 728146 757099 604565 523924 507696 537906 473779 590809 538255 544163 662389 466690 690749 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.97%) |
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 393145 413826 414771 443323 445737 448840 451264 465651 466690 468035 468733 469852 471691 473779 474643 483543 484692 488734 489243 495273 498623 507696 522138 523860 523924 525679 529129 530495 530501 530912 531105 532643 532680 532745 532829 532843 533837 533846 534372 534984 536582 537184 537236 537584 537648 537906 538255 541863 544163 544838 544840 544843 545444 546953 556045 556046 564554 582697 590809 599865 599867 599966 600708 604565 617427 632601 633123 633602 635215 639334 639716 639760 639796 639798 642032 642660 643103 645284 645861 648820 649953 650198 654097 662162 662389 666865 666895 672388 674966 677303 677397 678504 681295 690749 691381 692718 693860 696582 699397 699767 706311 714622 720582 720749 724170 728146 729691 730415 741518 745924 757099 757372 779560 783693 787519 800232 803455 805170 814503 819686 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal cock"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал cock"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд анал cock"
]
|
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.