Query Metrics
7
Database Queries
7
Different statements
183.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.05 ms (85.05%) |
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 384803 386997 405612 413458 414785 423431 425572 428572 434717 436642 444900 450014 450292 455090 455879 457169 458443 462057 475106 475109 477813 482041 482052 490361 491106 500297 501597 504103 505336 507674 508237 508799 508884 510779 511046 519421 519705 525858 526385 527395 531910 536049 542505 547735 550444 554187 558415 559465 561070 563082 563100 564510 566254 567091 571722 571741 580288 584721 588564 590146 599130 600667 611890 615065 617615 620419 628455 629681 630081 631083 631263 632567 632818 633983 643652 650290 650511 658860 661964 662104 664166 680771 687917 710913 711934 720132 724437 724769 729090 730509 730947 732130 741780 747248 749063 756551 757649 761190 765349 767268 768797 769344 771333 773977 781980 784771 788251 793013 794320 795383 797119 797330 799722 801316 809845 810303 811740 814401 823518 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (9.27%) |
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 811740 724769 436642 823518 450014 482052 462057 554187 584721 650290 658860 710913 563100 643652 628455 631263 769344 732130 724437 765349 757649 761190 767268 801316 475106 501597 809845 423431 508237 680771 661964 588564 599130 611890 633983 793013 799722 747248 794320 771333 729090 756551 730509 797330 475109 491106 508799 386997 814401 455090 505336 508884 536049 559465 547735 564510 711934 650511 664166 615065 617615 590146 629681 741780 749063 768797 730947 720132 781980 784771 788251 795383 384803 458443 414785 531910 490361 500297 507674 571722 413458 455879 504103 511046 510779 525858 563082 567091 542505 550444 687917 571741 580288 600667 797119 810303 773977 444900 482041 450292 405612 519421 566254 632567 428572 434717 527395 526385 558415 561070 572897 662104 631083 630081 632818 457169 477813 519705 620419 425572 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.44%) |
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 384803 386997 405612 413458 414785 423431 425572 428572 434717 436642 444900 450014 450292 455090 455879 457169 458443 462057 475106 475109 477813 482041 482052 490361 491106 500297 501597 504103 505336 507674 508237 508799 508884 510779 511046 519421 519705 525858 526385 527395 531910 536049 542505 547735 550444 554187 558415 559465 561070 563082 563100 564510 566254 567091 571722 571741 580288 584721 588564 590146 599130 600667 611890 615065 617615 620419 628455 629681 630081 631083 631263 632567 632818 633983 643652 650290 650511 658860 661964 662104 664166 680771 687917 710913 711934 720132 724437 724769 729090 730509 730947 732130 741780 747248 749063 756551 757649 761190 765349 767268 768797 769344 771333 773977 781980 784771 788251 793013 794320 795383 797119 797330 799722 801316 809845 810303 811740 814401 823518 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"so much"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"so much"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"so much"
]
|
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.