Query Metrics
7
Database Queries
7
Different statements
148.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.64 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.95 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx hot"
]
|
||||||||||||||||||||||||||||||
| 3 | 8.60 ms |
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 650676 651799 652524 653790 658483 664795 668403 668584 669252 675783 677030 689342 692973 701414 705414 707879 712182 713513 719379 544905 549913 569795 572112 576609 583120 589508 602114 616206 628298 630425 631134 642456 596853 604482 620440 622570 622984 633174 601832 615227 625562 630721 634337 587979 601564 605352 615586 631297 777244 778016 778761 779807 780120 780365 780472 780550 782741 783802 783809 786818 787470 787788 792047 793224 794485 795570 797605 798777 800941 807466 810742 777483 777620 779509 780588 783696 787414 787573 788415 788492 790538 791347 791640 793808 793894 794732 796419 797283 800780 803983 804015 804414 808422 810519 810626 810686 811094 725216 728649 730743 731860 733443 734190 736372 737259 737288 739747 741472 742240 743565 744063 745991 746321 749487 753182 755500 757122 760582 765042 767331 ] |
||||||||||||||||||||||||||||||
| 4 | 2.29 ms |
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 544905 549913 569795 572112 576609 583120 587979 589508 596853 601564 601832 602114 604482 605352 615227 615586 616206 620440 622570 622984 625562 628298 630425 630721 631134 631297 633174 634337 642456 650676 651799 652524 653790 658483 664795 668403 668584 669252 675783 677030 689342 692973 701414 705414 707879 712182 713513 719379 725216 728649 730743 731860 733443 734190 736372 737259 737288 739747 741472 742240 743565 744063 745991 746321 749487 753182 755500 757122 760582 765042 767331 777244 777483 777620 778016 778761 779509 779807 780120 780365 780472 780550 780588 782741 783696 783802 783809 786818 787414 787470 787573 787788 788415 788492 790538 791347 791640 792047 793224 793808 793894 794485 794732 795570 796419 797283 797605 798777 800780 800941 803983 804015 804414 807466 808422 810519 810626 810686 810742 811094 ] |
||||||||||||||||||||||||||||||
| 5 | 130.65 ms |
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 544905 549913 569795 572112 576609 583120 587979 589508 596853 601564 601832 602114 604482 605352 615227 615586 616206 620440 622570 622984 625562 628298 630425 630721 631134 631297 633174 634337 642456 650676 651799 652524 653790 658483 664795 668403 668584 669252 675783 677030 689342 692973 701414 705414 707879 712182 713513 719379 725216 728649 730743 731860 733443 734190 736372 737259 737288 739747 741472 742240 743565 744063 745991 746321 749487 753182 755500 757122 760582 765042 767331 777244 777483 777620 778016 778761 779509 779807 780120 780365 780472 780550 780588 782741 783696 783802 783809 786818 787414 787470 787573 787788 788415 788492 790538 791347 791640 792047 793224 793808 793894 794485 794732 795570 796419 797283 797605 798777 800780 800941 803983 804015 804414 807466 808422 810519 810626 810686 810742 811094 ] |
||||||||||||||||||||||||||||||
| 6 | 1.97 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx hot"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.16 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx hot"
]
|
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.