Query Metrics
7
Database Queries
7
Different statements
154.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.84 ms (82.93%) |
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 384478 385222 387364 404095 411435 411559 412311 412717 413439 416924 425562 433448 437260 437323 437342 442422 442423 442442 442447 442952 444428 449153 449164 453191 453998 454476 460423 463047 468909 470119 476405 483967 485891 492268 500019 502211 511369 523496 524266 528765 532006 543457 547557 548599 548871 550976 554253 554963 557574 558187 559949 560879 563873 564801 565093 566811 574184 575272 579793 581909 583426 587533 589337 594152 595967 597177 599615 599733 605366 612426 612489 614088 615634 621431 650076 650101 650197 680585 696556 706498 709511 710185 710800 719693 720175 720868 724464 729165 731064 740694 742608 743877 744251 744516 746555 747735 750069 754156 756601 759107 763640 763678 763841 765243 766500 767448 770813 771811 778021 784029 785956 787780 790208 791821 792601 794445 798983 806131 807681 817326 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (10.82%) |
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 523496 565093 442423 706498 710185 759107 559949 453191 543457 806131 744516 766500 767448 742608 770813 412717 444428 384478 411559 416924 817326 500019 558187 599615 605366 807681 747735 763640 743877 746555 794445 404095 387364 413439 524266 554253 575272 560879 385222 411435 528765 563873 710800 720868 650101 557574 615634 621431 791821 790208 798983 784029 792601 724464 729165 763678 763841 771811 709511 476405 485891 650076 564801 595967 778021 744251 754156 437260 492268 547557 574184 511369 719693 589337 594152 449153 453998 502211 468909 612426 612489 587533 599733 765243 787780 442442 442952 483967 412311 550976 437323 437342 442422 442447 454476 470119 460423 566811 548599 548871 583426 696556 650197 554963 581909 614088 597177 740694 731064 750069 756601 785956 449164 425562 433448 532006 463047 579793 680585 720175 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.70%) |
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 384478 385222 387364 404095 411435 411559 412311 412717 413439 416924 425562 433448 437260 437323 437342 442422 442423 442442 442447 442952 444428 449153 449164 453191 453998 454476 460423 463047 468909 470119 476405 483967 485891 492268 500019 502211 511369 523496 524266 528765 532006 543457 547557 548599 548871 550976 554253 554963 557574 558187 559949 560879 563873 564801 565093 566811 574184 575272 579793 581909 583426 587533 589337 594152 595967 597177 599615 599733 605366 612426 612489 614088 615634 621431 650076 650101 650197 680585 696556 706498 709511 710185 710800 719693 720175 720868 724464 729165 731064 740694 742608 743877 744251 744516 746555 747735 750069 754156 756601 759107 763640 763678 763841 765243 766500 767448 770813 771811 778021 784029 785956 787780 790208 791821 792601 794445 798983 806131 807681 817326 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister tits"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister сиськ"
]
|
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.