Query Metrics
7
Database Queries
7
Different statements
195.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.51 ms (89.88%) |
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 34171 82217 94546 97055 233006 233512 294932 382183 382213 382815 383402 384779 385841 387428 389506 392582 393406 397407 399017 400722 401531 403136 403418 405551 409608 409916 410867 411661 413335 413662 414762 423960 429554 429825 432598 442150 443111 443769 444038 445855 449258 451455 452220 452307 453642 454344 455101 455104 457016 457956 458408 458977 459282 459634 461446 461476 461590 466576 470303 470492 472352 472942 477610 478768 489158 492186 508861 511145 526013 527727 549471 552184 559022 562217 570215 570245 570384 570385 570609 570851 571546 572799 573011 605684 606237 615275 617819 628261 635580 644138 659362 686589 703448 711598 711625 721896 723909 725817 736945 738226 739432 742773 749878 753173 755578 758901 761609 766333 766680 770626 779800 780087 784659 788040 791968 799795 800249 801450 804563 812945 ] |
||||||||||||||||||||||||||||||
|
10.88 ms (5.57%) |
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 570609 572799 562217 711625 686589 549471 570851 628261 635580 644138 779800 780087 812945 758901 791968 799795 755578 742773 725817 753173 761609 617819 711598 804563 233512 382183 392582 397407 401531 455104 429825 457016 461446 384779 432598 451455 470303 472352 233006 393406 442150 454344 478768 443769 466576 508861 489158 526013 385841 383402 82217 382213 34171 97055 399017 400722 405551 413335 414762 409608 413662 411661 410867 445855 453642 459282 459634 492186 449258 458408 458977 477610 527727 511145 472942 552184 570215 570245 559022 570384 571546 573011 721896 659362 703448 570385 605684 615275 606237 788040 800249 736945 749878 766680 723909 739432 770626 738226 766333 784659 801450 294932 403136 452307 457956 461476 470492 94546 387428 389506 455101 423960 429554 444038 461590 382815 403418 409916 443111 452220 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.50%) |
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 34171 82217 94546 97055 233006 233512 294932 382183 382213 382815 383402 384779 385841 387428 389506 392582 393406 397407 399017 400722 401531 403136 403418 405551 409608 409916 410867 411661 413335 413662 414762 423960 429554 429825 432598 442150 443111 443769 444038 445855 449258 451455 452220 452307 453642 454344 455101 455104 457016 457956 458408 458977 459282 459634 461446 461476 461590 466576 470303 470492 472352 472942 477610 478768 489158 492186 508861 511145 526013 527727 549471 552184 559022 562217 570215 570245 570384 570385 570609 570851 571546 572799 573011 605684 606237 615275 617819 628261 635580 644138 659362 686589 703448 711598 711625 721896 723909 725817 736945 738226 739432 742773 749878 753173 755578 758901 761609 766333 766680 770626 779800 780087 784659 788040 791968 799795 800249 801450 804563 812945 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"гост"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"гостях"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.68%) |
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.