Query Metrics
7
Database Queries
7
Different statements
142.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.48 ms (85.21%) |
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 154497 228737 271001 383517 385319 386017 418182 418718 437121 445088 448925 450671 471610 503020 507261 513809 519158 524258 535775 538772 548425 549065 557206 557870 564243 565991 572219 588105 599515 599843 600811 605587 609423 610313 610993 617143 621073 622412 622427 625793 627838 630920 634730 643791 647147 648885 652711 654602 658769 661577 663883 667156 667490 676713 678823 679084 683303 687324 691514 697666 698583 699678 700296 712071 712252 714419 715608 717614 718305 720090 720215 720595 726173 736514 738868 739822 741301 747082 748281 762059 762449 764027 765645 765676 765898 767707 767991 768871 768881 769275 773313 782054 782298 784288 788376 796730 798221 798953 798960 799574 802068 803471 803770 805283 805544 807012 808016 808154 808343 809917 810838 811232 812007 813489 814090 816710 818010 818559 819808 827628 ] |
||||||||||||||||||||||||||||||
|
12.52 ms (8.78%) |
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 767707 769275 726173 739822 765676 768881 622427 630920 643791 715608 803770 808016 809917 386017 383517 154497 271001 418182 445088 814090 818010 818559 816710 819808 827628 471610 503020 513809 519158 535775 538772 524258 507261 565991 572219 548425 549065 654602 663883 667490 697666 699678 712071 647147 667156 676713 678823 683303 687324 712252 717614 720090 720595 648885 652711 658769 661577 679084 691514 718305 557206 557870 564243 605587 617143 622412 625793 609423 610313 588105 599843 610993 621073 627838 599515 600811 782298 788376 798953 799574 805283 807012 808343 810838 812007 782054 798960 803471 736514 784288 796730 802068 805544 808154 811232 813489 741301 762449 762059 764027 773313 765645 765898 738868 747082 748281 767991 768871 634730 698583 700296 714419 720215 798221 448925 385319 228737 418718 437121 450671 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.97%) |
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 154497 228737 271001 383517 385319 386017 418182 418718 437121 445088 448925 450671 471610 503020 507261 513809 519158 524258 535775 538772 548425 549065 557206 557870 564243 565991 572219 588105 599515 599843 600811 605587 609423 610313 610993 617143 621073 622412 622427 625793 627838 630920 634730 643791 647147 648885 652711 654602 658769 661577 663883 667156 667490 676713 678823 679084 683303 687324 691514 697666 698583 699678 700296 712071 712252 714419 715608 717614 718305 720090 720215 720595 726173 736514 738868 739822 741301 747082 748281 762059 762449 764027 765645 765676 765898 767707 767991 768871 768881 769275 773313 782054 782298 784288 788376 796730 798221 798953 798960 799574 802068 803471 803770 805283 805544 807012 808016 808154 808343 809917 810838 811232 812007 813489 814090 816710 818010 818559 819808 827628 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watch"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"and watch"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"watch"
]
|
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.