Query Metrics
7
Database Queries
7
Different statements
161.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.88 ms (82.04%) |
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 318700 359067 366354 396349 396526 396564 400753 402876 404217 404320 405061 405070 406629 409119 411477 411638 411747 417053 417056 419483 419621 419738 427241 428125 430534 433047 440687 443573 443991 446754 447691 448542 452189 453235 453531 453737 454801 458001 460079 460099 461032 461036 463825 464336 464350 464359 465698 466493 466552 471890 473467 473891 474619 476340 476564 485266 485733 485996 487588 488894 493200 496551 499332 499333 499336 500931 501233 504121 512527 512528 516661 521509 527762 528363 528913 529166 530110 531540 532341 532629 532888 536438 536569 539786 540346 544834 545819 548264 553296 554444 554445 567143 569793 570174 576616 578406 582050 582935 598622 602617 603298 605499 605557 606769 610290 614715 630870 637145 645293 646938 653972 668528 675515 693383 759472 788252 808077 808757 809272 815789 ] |
||||||||||||||||||||||||||||||
|
18.44 ms (11.39%) |
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 493200 512527 359067 366354 396349 402876 404217 406629 440687 411477 815789 453235 464350 485266 453737 454801 476340 452189 453531 461032 461036 473891 476564 488894 532888 499333 532341 536438 536569 528913 529166 567143 569793 582050 548264 570174 645293 653972 693383 630870 602617 603298 614715 788252 404320 419621 430534 419738 405070 446754 521509 501233 318700 400753 409119 411638 411747 443573 427241 458001 464336 466493 471890 447691 463825 465698 448542 460079 473467 485733 487588 499336 504121 528363 530110 527762 532629 539786 540346 474619 485996 553296 582935 554444 646938 544834 576616 610290 605557 808757 759472 808077 396526 428125 466552 419483 405061 417056 396564 417053 443991 460099 496551 499332 500931 512528 516661 531540 464359 554445 545819 578406 675515 668528 598622 605499 637145 809272 606769 433047 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.79%) |
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 318700 359067 366354 396349 396526 396564 400753 402876 404217 404320 405061 405070 406629 409119 411477 411638 411747 417053 417056 419483 419621 419738 427241 428125 430534 433047 440687 443573 443991 446754 447691 448542 452189 453235 453531 453737 454801 458001 460079 460099 461032 461036 463825 464336 464350 464359 465698 466493 466552 471890 473467 473891 474619 476340 476564 485266 485733 485996 487588 488894 493200 496551 499332 499333 499336 500931 501233 504121 512527 512528 516661 521509 527762 528363 528913 529166 530110 531540 532341 532629 532888 536438 536569 539786 540346 544834 545819 548264 553296 554444 554445 567143 569793 570174 576616 578406 582050 582935 598622 602617 603298 605499 605557 606769 610290 614715 630870 637145 645293 646938 653972 668528 675515 693383 759472 788252 808077 808757 809272 815789 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc chubby"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc chubby"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc chubby"
]
|
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.