Query Metrics
7
Database Queries
7
Different statements
141.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.27 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 554273 554748 563792 583109 584226 585380 585627 588102 591426 591454 595182 599198 600442 602695 603106 605261 606013 613805 616466 616542 616995 619996 620467 620585 622272 623790 624035 625206 626401 627709 627721 628480 634221 636485 637306 653073 653795 654919 666383 668275 671470 692995 694894 697159 701522 701613 707400 707650 707676 708153 708295 709760 710805 711542 711552 711555 716689 716954 717136 717493 723955 724045 727891 729421 741185 743076 750585 754124 758904 761789 765325 772385 772446 772908 773936 774716 774994 775083 775173 775231 776080 776548 777779 777914 778811 780030 780610 780932 781001 781234 782557 782633 782978 784238 784552 784731 785148 785399 785947 786410 787130 787214 788158 788668 790636 790844 791093 797873 798307 798469 799430 799523 799812 799933 801026 803594 807360 812289 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (9.72%) |
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 697159 701522 701613 707400 708295 709760 711542 711555 716936 717493 654919 692995 707650 716689 717136 653073 653795 659047 666383 668275 671470 694894 707676 708153 710805 711552 716954 554273 554748 563792 583109 584226 585380 623790 624035 626401 637306 600442 605261 613805 616466 616542 616995 619996 622272 625206 591426 595182 603106 620467 627709 627721 628480 634221 636485 585627 588102 591454 599198 602695 606013 620585 774716 775083 776548 777914 780610 781001 781234 782633 784238 784552 785148 785399 785947 790636 790844 797873 798307 807360 774994 775173 775231 776080 777779 778811 780030 780932 782978 787214 788158 798469 799430 799523 799812 799933 801026 803594 812289 723955 724045 727891 729421 741185 743076 750585 754124 758904 761789 765325 772385 772446 772908 773936 782557 784731 786410 787130 788668 791093 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (2.39%) |
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 554273 554748 563792 583109 584226 585380 585627 588102 591426 591454 595182 599198 600442 602695 603106 605261 606013 613805 616466 616542 616995 619996 620467 620585 622272 623790 624035 625206 626401 627709 627721 628480 634221 636485 637306 653073 653795 654919 666383 668275 671470 692995 694894 697159 701522 701613 707400 707650 707676 708153 708295 709760 710805 711542 711552 711555 716689 716954 717136 717493 723955 724045 727891 729421 741185 743076 750585 754124 758904 761789 765325 772385 772446 772908 773936 774716 774994 775083 775173 775231 776080 776548 777779 777914 778811 780030 780610 780932 781001 781234 782557 782633 782978 784238 784552 784731 785148 785399 785947 786410 787130 787214 788158 788668 790636 790844 791093 797873 798307 798469 799430 799523 799812 799933 801026 803594 807360 812289 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans cum"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет cum"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет cum"
]
|
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.