Query Metrics
7
Database Queries
7
Different statements
231.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.70 ms (89.18%) |
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 389325 396393 413083 447328 458599 464118 466434 467096 469022 469097 469258 472849 475678 476119 476142 485298 488214 488428 495582 496108 511506 513136 514787 515543 519479 526171 530430 531166 531724 532314 532467 533306 534266 535031 542572 544454 544507 544857 545206 545304 552303 552572 561594 562844 563069 563619 566641 568362 568381 570188 570399 574421 577617 579949 580767 581021 586153 586389 586407 587725 587943 589132 590950 590955 593669 594820 595361 598146 600570 601863 603555 604909 608035 611941 615709 615910 621319 624789 631975 632988 637758 641077 641682 644278 644285 672618 672771 673454 673963 676008 678187 684066 684830 685681 690088 710343 710502 720487 723377 725399 727087 730862 730865 730875 731472 740639 741543 742241 756103 757335 758554 777078 782629 789670 807360 808598 813916 815057 815471 821597 ] |
||||||||||||||||||||||||||||||
|
15.32 ms (6.61%) |
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 813916 821597 476142 467096 535031 513136 514787 526171 530430 532314 532467 533306 496108 515543 531724 464118 570188 570399 552303 563069 673963 684066 678187 672618 673454 710343 720487 545304 562844 587725 601863 644285 586389 621319 631975 590955 782629 807360 725399 727087 758554 730875 740639 757335 611941 632988 637758 808598 389325 396393 447328 488428 485298 488214 495582 710502 476119 472849 600570 815057 815471 466434 469258 458599 511506 534266 519479 531166 469022 469097 566641 577617 579949 544454 544507 544857 545206 574421 581021 542572 552572 561594 563619 568381 685681 684830 690088 672771 676008 723377 568362 580767 586153 589132 604909 615910 641682 587943 590950 593669 595361 598146 624789 594820 603555 615709 641077 586407 608035 730865 731472 730862 741543 742241 756103 644278 777078 789670 413083 475678 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.11%) |
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 389325 396393 413083 447328 458599 464118 466434 467096 469022 469097 469258 472849 475678 476119 476142 485298 488214 488428 495582 496108 511506 513136 514787 515543 519479 526171 530430 531166 531724 532314 532467 533306 534266 535031 542572 544454 544507 544857 545206 545304 552303 552572 561594 562844 563069 563619 566641 568362 568381 570188 570399 574421 577617 579949 580767 581021 586153 586389 586407 587725 587943 589132 590950 590955 593669 594820 595361 598146 600570 601863 603555 604909 608035 611941 615709 615910 621319 624789 631975 632988 637758 641077 641682 644278 644285 672618 672771 673454 673963 676008 678187 684066 684830 685681 690088 710343 710502 720487 723377 725399 727087 730862 730865 730875 731472 740639 741543 742241 756103 757335 758554 777078 782629 789670 807360 808598 813916 815057 815471 821597 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short спортивная"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short sport"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short спортивная"
]
|
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.