Query Metrics
7
Database Queries
7
Different statements
192.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.67 ms (83.96%) |
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 3479 74426 88942 91692 109381 133598 151180 177440 182213 188122 228779 232085 233376 233987 270290 270415 308582 345456 367800 381958 382552 382575 385947 387933 388280 388514 391009 391530 391761 392672 392930 395677 396048 396953 397631 397655 397763 397859 398531 398932 399596 399634 401153 404738 407708 409201 411360 411508 412613 413648 413808 418836 418938 419982 420167 426490 428066 428374 428684 432405 432557 433355 433453 435940 437320 438078 439454 440805 442058 442478 443118 445865 446946 447029 447612 448054 450277 453231 453275 454037 454195 454466 454480 455969 456604 456979 457652 460358 464098 465677 469769 469955 472697 473634 484397 490403 490589 491088 492992 494792 495244 496011 506646 510521 511057 516028 517102 517696 518600 522098 522514 528158 558835 579185 579513 591984 732994 745516 746739 758151 ] |
||||||||||||||||||||||||||||||
|
19.14 ms (9.94%) |
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 381958 391530 391761 397859 432405 438078 445865 454480 469955 388280 440805 465677 448054 492992 490589 88942 270415 388514 732994 385947 151180 188122 177440 392930 395677 270290 345456 391009 387933 397655 399634 401153 404738 411508 418938 426490 442478 407708 412613 439454 413648 420167 428374 443118 413808 437320 454037 454466 464098 446946 457652 490403 450277 454195 455969 495244 579513 579185 558835 591984 382575 396953 399596 409201 435940 447612 453275 133598 419982 428066 442058 456979 469769 109381 233376 392672 398531 398932 411360 418836 428684 433355 453231 473634 396048 397763 432557 447029 472697 433453 456604 460358 506646 510521 511057 517102 517696 518600 528158 484397 491088 494792 496011 516028 522098 522514 228779 232085 233987 367800 308582 91692 3479 746739 745516 758151 182213 382552 74426 397631 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (2.17%) |
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 3479 74426 88942 91692 109381 133598 151180 177440 182213 188122 228779 232085 233376 233987 270290 270415 308582 345456 367800 381958 382552 382575 385947 387933 388280 388514 391009 391530 391761 392672 392930 395677 396048 396953 397631 397655 397763 397859 398531 398932 399596 399634 401153 404738 407708 409201 411360 411508 412613 413648 413808 418836 418938 419982 420167 426490 428066 428374 428684 432405 432557 433355 433453 435940 437320 438078 439454 440805 442058 442478 443118 445865 446946 447029 447612 448054 450277 453231 453275 454037 454195 454466 454480 455969 456604 456979 457652 460358 464098 465677 469769 469955 472697 473634 484397 490403 490589 491088 492992 494792 495244 496011 506646 510521 511057 516028 517102 517696 518600 522098 522514 528158 558835 579185 579513 591984 732994 745516 746739 758151 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пышками"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.88%) |
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.