Query Metrics
7
Database Queries
7
Different statements
157.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.27 ms (83.47%) |
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 61051 154463 290304 290847 385390 387026 390157 390286 403439 410690 414071 415591 416157 416522 416523 416536 416583 416631 416653 416666 416670 416686 416722 416725 419571 419628 421993 423662 423784 432680 432824 437190 441120 442430 443233 443249 444531 448199 448791 451316 451336 452800 455080 458678 458910 459111 460765 464497 466639 467097 467588 467598 467634 470403 470473 471129 471764 473745 476164 477759 477761 478489 481646 482190 482773 483705 490272 493696 495467 498318 500313 505356 506149 511858 521682 529078 531347 531579 536378 536923 545379 545454 548835 550282 559281 561040 564227 564237 573268 598675 602024 603362 605133 609885 615636 615921 628477 630420 634108 648716 648733 660416 661008 664149 666672 666859 669018 669067 669080 671044 707689 707693 752704 755079 760319 770397 796646 798243 802899 811690 ] |
||||||||||||||||||||||||||||||
|
16.29 ms (10.36%) |
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 432824 442430 443233 390157 390286 416686 471129 478489 403439 423784 466639 481646 416523 416631 421993 437190 451336 470473 536923 495467 531579 498318 521682 490272 419628 529078 385390 154463 290847 416653 441120 414071 415591 416583 416666 416725 443249 416522 416536 416670 444531 423662 410690 419571 482773 448199 452800 455080 458678 464497 467598 467634 470403 473745 451316 483705 448791 458910 460765 471764 477759 482190 505356 511858 536378 531347 476164 545379 545454 564237 548835 564227 559281 573268 666672 671044 707689 666859 669018 648716 648733 660416 661008 664149 669067 669080 707693 550282 561040 598675 602024 605133 609885 603362 634108 615636 615921 628477 630420 755079 798243 802899 811690 760319 770397 752704 796646 61051 467097 432680 459111 467588 290304 387026 477761 416722 416157 500313 506149 493696 ] |
||||||||||||||||||||||||||||||
|
3.05 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 61051 154463 290304 290847 385390 387026 390157 390286 403439 410690 414071 415591 416157 416522 416523 416536 416583 416631 416653 416666 416670 416686 416722 416725 419571 419628 421993 423662 423784 432680 432824 437190 441120 442430 443233 443249 444531 448199 448791 451316 451336 452800 455080 458678 458910 459111 460765 464497 466639 467097 467588 467598 467634 470403 470473 471129 471764 473745 476164 477759 477761 478489 481646 482190 482773 483705 490272 493696 495467 498318 500313 505356 506149 511858 521682 529078 531347 531579 536378 536923 545379 545454 548835 550282 559281 561040 564227 564237 573268 598675 602024 603362 605133 609885 615636 615921 628477 630420 634108 648716 648733 660416 661008 664149 666672 666859 669018 669067 669080 671044 707689 707693 752704 755079 760319 770397 796646 798243 802899 811690 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"гигантским"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромный"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромный"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.86%) |
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.