Query Metrics
7
Database Queries
7
Different statements
139.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.24 ms (83.94%) |
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 6741 239112 382549 395706 396554 399874 401343 402607 402680 407617 416172 418369 426159 443963 473782 473909 475021 476808 480420 489430 492392 492649 501461 503468 515202 515226 515231 518547 519725 520714 520727 521588 523806 528344 533010 536252 536720 539157 543013 545357 550602 552599 563961 565286 568575 579368 580237 590328 594213 595458 596991 597585 597997 598444 598471 598675 620300 620399 623200 624238 624464 624854 630490 633474 636405 637139 655062 657434 663492 665108 665116 666968 671656 675514 675742 678763 683536 683774 683880 684187 684211 685001 685617 687187 687461 693528 699009 702087 702439 706321 706343 709623 709703 715326 716027 716468 719129 720505 722684 737395 737417 739934 746445 746478 748389 759660 771203 779014 803294 805650 807537 812922 813659 815621 817630 817688 819605 820086 821628 822172 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (9.64%) |
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 395706 402680 401343 503468 519725 624854 748389 443963 492392 623200 813659 426159 473782 685001 666968 594213 521588 407617 821628 822172 817688 702439 683880 693528 597585 803294 771203 805650 396554 239112 382549 6741 520714 665116 665108 475021 528344 815621 746478 819605 817630 820086 552599 563961 545357 655062 657434 675514 683536 683774 699009 715326 716468 720505 675742 678763 684187 706321 687187 702087 709703 719129 590328 624238 636405 779014 737417 739934 759660 706343 807537 536252 533010 518547 543013 812922 476808 418369 402607 536720 539157 709623 722684 565286 624464 746445 492649 550602 580237 684211 687461 597997 480420 568575 501461 489430 520727 515231 579368 663492 473909 399874 515202 515226 523806 620399 737395 416172 685617 671656 716027 598675 630490 633474 595458 598444 637139 596991 598471 620300 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.82%) |
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 6741 239112 382549 395706 396554 399874 401343 402607 402680 407617 416172 418369 426159 443963 473782 473909 475021 476808 480420 489430 492392 492649 501461 503468 515202 515226 515231 518547 519725 520714 520727 521588 523806 528344 533010 536252 536720 539157 543013 545357 550602 552599 563961 565286 568575 579368 580237 590328 594213 595458 596991 597585 597997 598444 598471 598675 620300 620399 623200 624238 624464 624854 630490 633474 636405 637139 655062 657434 663492 665108 665116 666968 671656 675514 675742 678763 683536 683774 683880 684187 684211 685001 685617 687187 687461 693528 699009 702087 702439 706321 706343 709623 709703 715326 716027 716468 719129 720505 722684 737395 737417 739934 746445 746478 748389 759660 771203 779014 803294 805650 807537 812922 813659 815621 817630 817688 819605 820086 821628 822172 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old большие"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen old big"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old большие"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.07%) |
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.