Query Metrics
7
Database Queries
7
Different statements
174.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.67 ms (85.29%) |
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 35405 315244 386232 387026 391326 395879 396707 400483 400487 400506 400861 401101 404596 411408 411967 414067 414666 415256 421819 421829 421843 421844 421851 421862 421873 421917 421977 422182 422237 422561 422593 423495 424379 439187 440813 444531 444608 446095 448554 449120 452551 454548 455467 457468 459628 460323 463818 464125 465615 468095 469054 469577 470522 472198 472449 472691 474103 474579 478377 478491 480331 481484 482342 482345 483869 484638 494442 496143 497725 504935 511259 515779 517848 518936 521129 534077 534550 536624 547976 550411 565275 565949 566766 597268 607549 618514 623458 628116 646824 668975 669035 669408 678954 683955 686130 696154 712555 717906 719898 720111 722903 747451 751120 761163 761850 765628 792185 793901 796945 798529 799284 803621 805033 807435 809935 810061 812075 813276 814508 827830 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (8.94%) |
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 712555 720111 387026 386232 391326 400861 404596 422593 444608 411967 414067 424379 439187 814508 469054 482345 455467 459628 460323 472198 474103 474579 481484 446095 463818 465615 470522 472449 517848 511259 536624 497725 515779 464125 469577 547976 566766 550411 678954 686130 719898 669408 696154 646824 668975 669035 683955 722903 565275 565949 623458 597268 607549 618514 796945 803621 805033 807435 792185 793901 812075 813276 765628 798529 799284 747451 761850 751120 761163 717906 809935 810061 421829 421843 422237 452551 457468 472691 478491 400483 400487 401101 421844 421862 440813 482342 411408 415256 421819 421873 395879 421851 421917 422182 478377 480331 423495 448554 468095 484638 496143 521129 483869 494442 504935 534077 35405 827830 628116 315244 396707 400506 421977 422561 414666 444531 454548 449120 518936 534550 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.65%) |
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 35405 315244 386232 387026 391326 395879 396707 400483 400487 400506 400861 401101 404596 411408 411967 414067 414666 415256 421819 421829 421843 421844 421851 421862 421873 421917 421977 422182 422237 422561 422593 423495 424379 439187 440813 444531 444608 446095 448554 449120 452551 454548 455467 457468 459628 460323 463818 464125 465615 468095 469054 469577 470522 472198 472449 472691 474103 474579 478377 478491 480331 481484 482342 482345 483869 484638 494442 496143 497725 504935 511259 515779 517848 518936 521129 534077 534550 536624 547976 550411 565275 565949 566766 597268 607549 618514 623458 628116 646824 668975 669035 669408 678954 683955 686130 696154 712555 717906 719898 720111 722903 747451 751120 761163 761850 765628 792185 793901 796945 798529 799284 803621 805033 807435 809935 810061 812075 813276 814508 827830 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red anal"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red анал"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red анал"
]
|
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.