Query Metrics
7
Database Queries
7
Different statements
158.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.68 ms (81.10%) |
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 29242 426376 449258 457134 457598 459226 461199 467919 470462 471703 471715 479397 483573 486852 493415 505729 507691 512182 513835 521218 527240 529518 530529 534750 536245 539206 542363 544703 549780 559494 570037 570245 570262 571620 571901 572121 572773 573661 575860 582656 583992 585263 588635 590401 591228 599666 600190 609090 611611 612250 619011 621431 623624 634572 649139 649465 651227 651727 651998 655598 657469 661928 669852 669914 670003 670315 673459 673947 677581 677604 683689 685916 689794 690265 692879 692994 698039 706596 709556 711531 711660 712231 716880 719225 720798 721429 724342 734923 734978 736241 736433 744703 747154 749215 755588 756528 757784 758819 762183 765150 767868 769424 775732 775783 777587 778137 780047 780835 781749 785459 785584 787345 790761 795187 796904 801492 809150 810507 812340 812378 ] |
||||||||||||||||||||||||||||||
|
20.16 ms (12.71%) |
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 493415 29242 426376 457134 459226 461199 470462 479397 449258 457598 467919 483573 486852 521218 529518 536245 539206 505729 530529 534750 507691 512182 513835 527240 471703 471715 544703 571901 583992 542363 549780 559494 570245 582656 570037 570262 571620 572773 573661 651727 651998 655598 670003 670315 673459 677581 698039 711660 712231 720798 721429 649465 651227 657469 673947 677604 685916 689794 692879 706596 709556 719225 649139 661928 669852 669914 683689 690265 692994 711531 716880 572121 575860 609090 623624 585263 591228 599666 611611 590401 600190 634572 588635 612250 619011 621431 775783 790761 795187 796904 775732 777587 778137 780047 780835 781749 785459 809150 810507 749215 755588 758819 769424 785584 787345 801492 812340 812378 734923 756528 757784 765150 767868 724342 734978 736241 736433 744703 747154 762183 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.59%) |
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 29242 426376 449258 457134 457598 459226 461199 467919 470462 471703 471715 479397 483573 486852 493415 505729 507691 512182 513835 521218 527240 529518 530529 534750 536245 539206 542363 544703 549780 559494 570037 570245 570262 571620 571901 572121 572773 573661 575860 582656 583992 585263 588635 590401 591228 599666 600190 609090 611611 612250 619011 621431 623624 634572 649139 649465 651227 651727 651998 655598 657469 661928 669852 669914 670003 670315 673459 673947 677581 677604 683689 685916 689794 690265 692879 692994 698039 706596 709556 711531 711660 712231 716880 719225 720798 721429 724342 734923 734978 736241 736433 744703 747154 749215 755588 756528 757784 758819 762183 765150 767868 769424 775732 775783 777587 778137 780047 780835 781749 785459 785584 787345 790761 795187 796904 801492 809150 810507 812340 812378 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нове"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"нов"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"нов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.