Query Metrics
7
Database Queries
7
Different statements
202.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.72 ms (88.72%) |
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 33443 88436 88591 109176 154972 352189 382298 383388 390157 390286 391992 392006 392427 397065 397794 398078 398198 398376 401861 402631 408824 412855 419461 423508 423784 424192 437717 438181 439151 441048 444064 452800 452824 455133 455887 473448 475504 475633 476158 477516 486465 494535 499917 500263 500843 502641 502797 509168 510138 510541 511858 513010 513968 514233 514316 521481 526061 530658 531347 536320 537822 544001 546972 554954 556139 556183 556425 561573 563310 564518 571091 573288 575844 576848 581306 582636 585680 585863 587208 587313 588514 594053 594143 597810 598882 602251 613559 619666 621496 623277 632920 636716 649914 663749 664091 670956 675344 678713 687305 697484 709150 710528 744024 744038 745292 759345 760548 760594 774881 778108 779866 780390 786655 791039 796694 796716 798706 804150 806451 808611 ] |
||||||||||||||||||||||||||||||
|
14.13 ms (6.98%) |
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 582636 623277 513010 536320 597810 444064 621496 423508 455133 452824 494535 513968 670956 588514 88436 437717 477516 397065 526061 438181 455887 473448 554954 575844 510138 581306 561573 475633 390157 390286 452800 514233 391992 382298 398198 500843 663749 602251 509168 398078 744038 109176 424192 563310 709150 613559 636716 786655 774881 697484 632920 675344 649914 33443 710528 687305 619666 760548 796716 760594 796694 804150 402631 475504 564518 585680 594143 352189 514316 571091 573288 808611 778108 791039 745292 744024 779866 780390 806451 476158 678713 154972 88591 576848 423784 499917 397794 798706 759345 392006 419461 441048 500263 546972 556183 544001 556425 587313 594053 587208 502641 556139 585863 401861 398376 502797 521481 412855 439151 537822 530658 511858 531347 598882 664091 408824 392427 486465 510541 383388 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.14%) |
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 33443 88436 88591 109176 154972 352189 382298 383388 390157 390286 391992 392006 392427 397065 397794 398078 398198 398376 401861 402631 408824 412855 419461 423508 423784 424192 437717 438181 439151 441048 444064 452800 452824 455133 455887 473448 475504 475633 476158 477516 486465 494535 499917 500263 500843 502641 502797 509168 510138 510541 511858 513010 513968 514233 514316 521481 526061 530658 531347 536320 537822 544001 546972 554954 556139 556183 556425 561573 563310 564518 571091 573288 575844 576848 581306 582636 585680 585863 587208 587313 588514 594053 594143 597810 598882 602251 613559 619666 621496 623277 632920 636716 649914 663749 664091 670956 675344 678713 687305 697484 709150 710528 744024 744038 745292 759345 760548 760594 774881 778108 779866 780390 786655 791039 796694 796716 798706 804150 806451 808611 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц мастурбац дилд"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public masturbation dildo"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц мастурбац дилд"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.71%) |
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.