Query Metrics
7
Database Queries
7
Different statements
134.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
112.49 ms (83.47%) |
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 126458 282465 397131 443417 463321 516702 526480 527506 533010 537568 537767 544457 545734 546740 549290 549991 562928 572946 574251 587975 594596 595599 602415 611309 613949 618782 623348 624539 628441 628767 628887 629398 637647 649267 652053 652554 653572 655101 655314 656046 656739 657034 657270 658292 658367 658413 658820 659608 660761 670175 676482 676503 676520 676996 677109 677213 677689 678011 678218 678802 685471 686040 696397 700660 700681 705352 710391 717848 720573 728431 729720 730575 730851 732442 734287 735773 735999 736947 737100 737245 737370 739381 739747 740059 740500 741377 741976 743265 743708 744037 744552 746279 747577 749534 758651 760356 761076 766314 767302 767309 771476 778519 779225 780444 780527 782133 784321 786069 793518 794865 794918 797408 797421 809730 809980 810838 811544 812010 827642 827660 ] |
||||||||||||||||||||||||||||||
|
11.67 ms (8.66%) |
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 549290 574251 544457 657270 676520 677213 720573 658367 676482 678011 696397 546740 549991 594596 623348 811544 778519 779225 794865 797421 739747 760356 812010 730851 741976 749534 758651 730575 734287 737245 735999 780444 780527 809730 397131 443417 827642 463321 537767 516702 677109 678802 685471 700681 710391 628441 637647 618782 810838 740059 740500 761076 728431 732442 602415 700660 717848 782133 126458 526480 533010 629398 282465 827660 537568 527506 562928 545734 572946 655314 676503 676996 649267 652053 657034 659608 677689 686040 652554 653572 655101 656046 656739 658292 658413 658820 660761 670175 678218 705352 595599 611309 613949 628887 628767 587975 784321 797408 786069 793518 809980 729720 737370 741377 746279 767302 794918 744552 767309 771476 735773 743265 737100 739381 743708 747577 736947 744037 766314 624539 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (2.00%) |
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 126458 282465 397131 443417 463321 516702 526480 527506 533010 537568 537767 544457 545734 546740 549290 549991 562928 572946 574251 587975 594596 595599 602415 611309 613949 618782 623348 624539 628441 628767 628887 629398 637647 649267 652053 652554 653572 655101 655314 656046 656739 657034 657270 658292 658367 658413 658820 659608 660761 670175 676482 676503 676520 676996 677109 677213 677689 678011 678218 678802 685471 686040 696397 700660 700681 705352 710391 717848 720573 728431 729720 730575 730851 732442 734287 735773 735999 736947 737100 737245 737370 739381 739747 740059 740500 741377 741976 743265 743708 744037 744552 746279 747577 749534 758651 760356 761076 766314 767302 767309 771476 778519 779225 780444 780527 782133 784321 786069 793518 794865 794918 797408 797421 809730 809980 810838 811544 812010 827642 827660 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"смотрет порно 18"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"смотрет порн 18"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"смотрет порн 18"
]
|
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.