Query Metrics
7
Database Queries
7
Different statements
157.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.87 ms (79.92%) |
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 249637 384306 388789 398140 400850 402247 404289 409106 416385 421823 428643 434241 435064 435436 437876 451587 452112 452277 453615 453781 456423 460176 462935 463151 466134 466921 468827 469914 470262 471593 473729 476916 478332 478548 481727 483035 483174 483991 484718 485524 486390 487228 487469 487547 490018 491040 491839 492261 493460 496228 497085 498827 499695 499951 502106 504333 505202 506141 507010 507349 511039 511076 513123 516674 516848 516969 518189 518334 518499 519047 520686 521315 521993 522767 524147 525841 526010 526888 527792 529204 529483 542094 543756 544396 546853 553247 553678 556990 557951 559238 560466 560766 565905 569583 569886 573145 573538 574534 574819 597674 598658 603067 604545 605589 608751 616613 620038 634213 654562 672713 688991 705739 714776 726432 733138 751643 766849 776864 807323 807907 ] |
||||||||||||||||||||||||||||||
|
19.72 ms (12.52%) |
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 513123 518189 518499 502106 516674 516969 526010 511039 460176 463151 487469 543756 544396 546853 553678 556990 573145 542094 553247 557951 560466 569886 574819 569583 574534 672713 688991 705739 714776 654562 559238 560766 565905 573538 603067 608751 620038 597674 616613 598658 634213 776864 807323 807907 751643 766849 733138 726432 604545 605589 398140 400850 402247 409106 416385 421823 434241 452112 453781 466921 468827 473729 384306 404289 428643 437876 452277 466134 478332 249637 435064 451587 456423 470262 471593 481727 388789 462935 469914 476916 478548 435436 453615 499951 504333 505202 522767 491040 492261 516848 518334 519047 520686 524147 526888 527792 529483 483035 483991 485524 486390 487228 487547 490018 491839 497085 498827 499695 506141 507010 507349 521315 521993 525841 529204 483174 484718 493460 496228 511076 ] |
||||||||||||||||||||||||||||||
|
4.51 ms (2.86%) |
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 249637 384306 388789 398140 400850 402247 404289 409106 416385 421823 428643 434241 435064 435436 437876 451587 452112 452277 453615 453781 456423 460176 462935 463151 466134 466921 468827 469914 470262 471593 473729 476916 478332 478548 481727 483035 483174 483991 484718 485524 486390 487228 487469 487547 490018 491040 491839 492261 493460 496228 497085 498827 499695 499951 502106 504333 505202 506141 507010 507349 511039 511076 513123 516674 516848 516969 518189 518334 518499 519047 520686 521315 521993 522767 524147 525841 526010 526888 527792 529204 529483 542094 543756 544396 546853 553247 553678 556990 557951 559238 560466 560766 565905 569583 569886 573145 573538 574534 574819 597674 598658 603067 604545 605589 608751 616613 620038 634213 654562 672713 688991 705739 714776 726432 733138 751643 766849 776864 807323 807907 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"все вместе"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмест"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.