Query Metrics
7
Database Queries
7
Different statements
150.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.70 ms (82.31%) |
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 414114 415921 416824 418122 420031 424693 427339 441027 444645 447575 450707 452881 454800 465334 468797 471088 473066 480019 502269 503310 507696 521256 521716 522264 524964 530026 530480 530623 530763 531183 531206 531351 532726 532748 532943 533051 533376 535005 536259 536281 537371 537901 537906 538484 546083 546202 550536 559359 562052 569613 580193 581136 582580 589181 590169 591427 595646 595894 597107 598406 601366 601460 601651 601862 603407 605874 607298 607631 613180 617429 617604 622720 623154 629411 631358 632687 639735 640133 640331 641958 642065 648832 649912 650322 650333 657244 664431 667276 676111 678125 704236 713027 723461 732131 739827 759793 761572 764426 766433 770383 777039 781786 782274 785841 785967 785982 787525 793683 804306 805151 805543 806577 807050 807219 807597 810455 811343 811727 812431 812497 ] |
||||||||||||||||||||||||||||||
|
16.46 ms (10.95%) |
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 607298 590169 601460 589181 782274 785967 785982 806577 812497 793683 807050 811343 732131 739827 764426 622720 640133 785841 537371 597107 601366 787525 537906 468797 538484 595646 601862 595894 642065 629411 530026 521716 640331 617604 766433 781786 759793 444645 418122 531351 530480 447575 532943 521256 581136 805151 807219 465334 441027 533376 598406 503310 471088 812431 777039 480019 580193 723461 607631 631358 811727 770383 810455 530763 569613 532748 649912 704236 416824 427339 450707 582580 562052 550536 591427 424693 454800 524964 473066 536281 537901 650333 664431 601651 657244 807597 533051 535005 507696 678125 632687 805543 546083 420031 452881 531206 532726 536259 531183 530623 648832 676111 650322 617429 639735 641958 613180 603407 414114 522264 415921 502269 559359 713027 546202 605874 623154 761572 804306 667276 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.83%) |
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 414114 415921 416824 418122 420031 424693 427339 441027 444645 447575 450707 452881 454800 465334 468797 471088 473066 480019 502269 503310 507696 521256 521716 522264 524964 530026 530480 530623 530763 531183 531206 531351 532726 532748 532943 533051 533376 535005 536259 536281 537371 537901 537906 538484 546083 546202 550536 559359 562052 569613 580193 581136 582580 589181 590169 591427 595646 595894 597107 598406 601366 601460 601651 601862 603407 605874 607298 607631 613180 617429 617604 622720 623154 629411 631358 632687 639735 640133 640331 641958 642065 648832 649912 650322 650333 657244 664431 667276 676111 678125 704236 713027 723461 732131 739827 759793 761572 764426 766433 770383 777039 781786 782274 785841 785967 785982 787525 793683 804306 805151 805543 806577 807050 807219 807597 810455 811343 811727 812431 812497 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob long dildo"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс длинные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс длинные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.