Query Metrics
7
Database Queries
7
Different statements
166.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.04 ms (86.50%) |
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 487730 488123 501477 504521 507916 511851 517267 518976 519278 532017 533425 542817 545844 546017 546640 554394 554411 556664 558536 561119 561923 562770 562773 562950 563108 564821 565571 566221 568148 568149 569947 570742 572767 573379 574364 576658 577422 578059 578121 580751 581157 582249 586469 586483 586940 587553 588314 588349 588633 589097 591010 594765 594788 594811 594861 594880 595988 596227 596445 597863 598113 598861 601274 601278 601724 601753 601838 603249 603344 604395 604723 605415 605459 605613 605637 606863 607052 608124 610119 610339 610375 610619 610623 610677 611245 612051 613855 614339 615554 619141 619151 621402 623381 623871 626890 628423 642702 647362 663265 665492 671639 672771 673097 673992 674059 674360 674740 676176 681434 682187 683582 684232 685579 685613 685852 686017 687917 688069 690410 691201 ] |
||||||||||||||||||||||||||||||
|
12.34 ms (7.41%) |
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 673097 682187 686017 687917 671639 681434 685579 685613 691201 672771 673992 674059 684232 546640 573379 577422 580751 588349 595988 601278 601838 605613 610375 610677 588314 591010 594880 598113 598861 601753 610619 613855 587553 589097 596445 601274 610339 604723 606863 608124 610623 615554 623871 626890 604395 623381 518976 504521 517267 556664 501477 511851 532017 533425 487730 542817 546017 554394 558536 565571 566221 582249 568148 569947 572767 576658 545844 561119 562773 563108 568149 570742 578059 663265 665492 676176 690410 674360 674740 683582 685852 688069 647362 554411 561923 562770 562950 564821 574364 578121 581157 588633 594861 607052 619151 586940 594765 594788 594811 601724 603249 610119 586483 596227 597863 605459 619141 621402 586469 603344 605415 605637 614339 642702 611245 612051 628423 488123 507916 519278 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.94%) |
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 487730 488123 501477 504521 507916 511851 517267 518976 519278 532017 533425 542817 545844 546017 546640 554394 554411 556664 558536 561119 561923 562770 562773 562950 563108 564821 565571 566221 568148 568149 569947 570742 572767 573379 574364 576658 577422 578059 578121 580751 581157 582249 586469 586483 586940 587553 588314 588349 588633 589097 591010 594765 594788 594811 594861 594880 595988 596227 596445 597863 598113 598861 601274 601278 601724 601753 601838 603249 603344 604395 604723 605415 605459 605613 605637 606863 607052 608124 610119 610339 610375 610619 610623 610677 611245 612051 613855 614339 615554 619141 619151 621402 623381 623871 626890 628423 642702 647362 663265 665492 671639 672771 673097 673992 674059 674360 674740 676176 681434 682187 683582 684232 685579 685613 685852 686017 687917 688069 690410 691201 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom сюжет"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom сюжет"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom сюжет"
]
|
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.