Query Metrics
7
Database Queries
7
Different statements
181.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.90 ms (87.35%) |
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 177739 386227 387046 392279 397533 397613 401250 401386 417255 419253 427771 428904 436838 438053 441336 455261 464870 469492 476698 500095 510223 514444 515615 517254 517256 522190 522422 533479 539353 541021 542122 542700 544591 547884 548395 550787 554314 559654 561123 568728 574573 576800 577287 578787 582678 582852 582941 584944 585319 587983 588325 588433 592073 592083 592123 592133 592134 592142 592145 592147 592323 595117 598913 600865 600876 601376 603005 607010 612035 612233 620547 622886 626843 628824 629443 630704 633253 633824 634895 635057 635355 638117 638859 645736 648424 666669 667469 678217 684898 697390 704425 709952 712484 717848 722694 728360 729576 732543 732783 733516 739963 742618 748707 755550 759913 767693 768197 769846 771514 772157 774007 783722 787317 787830 787881 789597 791625 804326 808453 819449 ] |
||||||||||||||||||||||||||||||
|
13.34 ms (7.33%) |
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 712484 722694 585319 592134 598913 635355 592142 601376 630704 629443 787881 769846 772157 728360 742618 729576 759913 767693 771514 633824 635057 789597 397613 401386 438053 517256 397533 427771 819449 455261 469492 522422 517254 541021 577287 582941 542122 582852 645736 678217 684898 697390 704425 709952 547884 578787 584944 588325 600876 634895 603005 612035 587983 592123 607010 612233 787830 755550 791625 732783 739963 748707 774007 732543 768197 633253 638859 717848 428904 476698 386227 401250 515615 177739 417255 441336 464870 522190 510223 533479 539353 514444 542700 550787 554314 568728 574573 582678 544591 548395 561123 576800 648424 666669 667469 559654 592083 592145 592147 620547 622886 595117 600865 628824 588433 592073 592133 592323 626843 783722 804326 808453 787317 733516 638117 392279 436838 419253 500095 387046 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.48%) |
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 177739 386227 387046 392279 397533 397613 401250 401386 417255 419253 427771 428904 436838 438053 441336 455261 464870 469492 476698 500095 510223 514444 515615 517254 517256 522190 522422 533479 539353 541021 542122 542700 544591 547884 548395 550787 554314 559654 561123 568728 574573 576800 577287 578787 582678 582852 582941 584944 585319 587983 588325 588433 592073 592083 592123 592133 592134 592142 592145 592147 592323 595117 598913 600865 600876 601376 603005 607010 612035 612233 620547 622886 626843 628824 629443 630704 633253 633824 634895 635057 635355 638117 638859 645736 648424 666669 667469 678217 684898 697390 704425 709952 712484 717848 722694 728360 729576 732543 732783 733516 739963 742618 748707 755550 759913 767693 768197 769846 771514 772157 774007 783722 787317 787830 787881 789597 791625 804326 808453 819449 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"quickie"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"quickie"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"quickie"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
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.