Query Metrics
7
Database Queries
7
Different statements
193.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.54 ms (85.61%) |
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 6920 58287 144181 307339 382475 383681 385010 395612 395732 395803 396092 396293 396449 396657 396788 397780 398891 399598 401037 402557 403132 403603 404230 406841 408898 411532 412066 413738 417609 418027 418884 420788 425218 426129 427336 428807 437322 438816 441169 442423 442962 444117 448598 454469 456044 457989 458296 458565 458902 459466 460620 463120 463565 465138 465700 466568 467168 467649 467838 469257 469956 471386 472629 473065 473358 477227 477411 480353 481094 486752 490211 491443 494378 495888 498500 511550 515461 520228 528451 537026 540021 549999 550042 553866 555835 560748 561720 563700 564631 565062 568367 570224 570406 570796 573924 576289 576363 577847 578456 580822 582780 585054 589112 597241 599145 603301 620051 636063 641074 696485 702512 712930 780128 784555 788855 790896 791033 800001 809410 811960 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (8.87%) |
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 385010 383681 144181 395732 307339 58287 396092 396293 396657 397780 398891 403603 418027 428807 444117 426129 441169 417609 442423 585054 448598 454469 457989 458296 472629 456044 458565 463565 466568 467168 486752 458902 473065 480353 540021 515461 520228 495888 511550 463120 467649 467838 491443 549999 563700 580822 568367 570224 576363 582780 555835 560748 565062 573924 577847 702512 696485 712930 550042 553866 561720 564631 570406 570796 576289 578456 589112 636063 597241 620051 599145 603301 780128 788855 811960 784555 800001 641074 790896 791033 809410 382475 396449 402557 403132 413738 481094 6920 395803 399598 404230 418884 427336 442962 459466 460620 465138 469257 477411 396788 408898 412066 437322 471386 395612 401037 406841 420788 425218 465700 469956 473358 477227 411532 438816 528451 537026 490211 494378 498500 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (1.78%) |
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 6920 58287 144181 307339 382475 383681 385010 395612 395732 395803 396092 396293 396449 396657 396788 397780 398891 399598 401037 402557 403132 403603 404230 406841 408898 411532 412066 413738 417609 418027 418884 420788 425218 426129 427336 428807 437322 438816 441169 442423 442962 444117 448598 454469 456044 457989 458296 458565 458902 459466 460620 463120 463565 465138 465700 466568 467168 467649 467838 469257 469956 471386 472629 473065 473358 477227 477411 480353 481094 486752 490211 491443 494378 495888 498500 511550 515461 520228 528451 537026 540021 549999 550042 553866 555835 560748 561720 563700 564631 565062 568367 570224 570406 570796 573924 576289 576363 577847 578456 580822 582780 585054 589112 597241 599145 603301 620051 636063 641074 696485 702512 712930 780128 784555 788855 790896 791033 800001 809410 811960 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx спортивная"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx sport"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx спортивная"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.82%) |
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.