Query Metrics
7
Database Queries
7
Different statements
177.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.89 ms (83.22%) |
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 6609 57337 78887 130060 147400 233346 261001 326110 330258 338993 346054 383057 386778 388161 390851 393937 395450 395930 401991 403171 403195 403421 406191 408508 411310 413563 418552 419069 419155 420126 425288 425882 427176 429220 434836 436964 438536 446715 452407 453612 454780 456364 460672 462265 464983 466040 468315 469803 471014 474027 474398 481375 481770 482807 483550 483832 485930 487748 495058 502950 504357 510785 512046 517911 521233 529290 530416 531482 535873 539108 540139 541335 543367 543974 544204 547230 547400 549225 551887 555717 556434 566051 566778 570804 576252 592999 602229 614029 622236 651151 653460 692804 697400 711258 715265 715275 717039 718955 727796 732838 758634 776006 778068 781992 783221 784197 797391 800971 806341 814432 815269 817022 817623 817929 819359 824325 824378 827079 827203 827624 ] |
||||||||||||||||||||||||||||||
|
21.12 ms (11.89%) |
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 797391 346054 403195 529290 483550 386778 395450 338993 403421 418552 429220 436964 817022 827203 817623 824325 827624 539108 535873 566778 715265 715275 717039 556434 592999 800971 784197 732838 57337 454780 471014 330258 395930 462265 466040 383057 6609 390851 401991 425882 827079 817929 487748 530416 521233 531482 481375 544204 570804 576252 718955 711258 651151 551887 776006 781992 758634 727796 602229 622236 783221 806341 233346 468315 147400 419069 420126 425288 549225 614029 261001 406191 408508 411310 438536 814432 460672 512046 474398 541335 543367 547400 566051 653460 692804 697400 778068 78887 393937 474027 326110 419155 517911 483832 510785 130060 388161 403171 413563 427176 434836 824378 819359 815269 446715 456364 482807 453612 464983 469803 481770 452407 485930 540139 502950 495058 504357 543974 547230 555717 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.41%) |
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 6609 57337 78887 130060 147400 233346 261001 326110 330258 338993 346054 383057 386778 388161 390851 393937 395450 395930 401991 403171 403195 403421 406191 408508 411310 413563 418552 419069 419155 420126 425288 425882 427176 429220 434836 436964 438536 446715 452407 453612 454780 456364 460672 462265 464983 466040 468315 469803 471014 474027 474398 481375 481770 482807 483550 483832 485930 487748 495058 502950 504357 510785 512046 517911 521233 529290 530416 531482 535873 539108 540139 541335 543367 543974 544204 547230 547400 549225 551887 555717 556434 566051 566778 570804 576252 592999 602229 614029 622236 651151 653460 692804 697400 711258 715265 715275 717039 718955 727796 732838 758634 776006 778068 781992 783221 784197 797391 800971 806341 814432 815269 817022 817623 817929 819359 824325 824378 827079 827203 827624 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"четыр"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тут он 4 к"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.69%) |
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.