Query Metrics
7
Database Queries
7
Different statements
189.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.85 ms (88.44%) |
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 509170 509231 510359 525423 531044 531652 533437 535250 535872 539376 540120 542252 544906 546237 546287 547059 553183 553228 553264 567661 576569 579474 583565 584375 618629 636354 646412 658818 662064 678925 692662 693748 698613 704600 706015 713648 716386 716476 813756 816808 817306 817389 817397 817421 817553 817559 817601 817654 818259 818285 819062 819888 819912 819925 820008 820312 823270 823546 823547 823573 823702 823703 823716 823841 823966 824036 824047 824222 824383 824669 824758 824841 824901 824910 824966 824976 825049 825067 825171 825211 825292 825417 825775 825888 825990 826268 826394 826453 826496 826515 826548 826596 826724 826769 826819 826993 827057 827240 827300 827482 827568 828109 828121 828150 828240 828478 828563 828582 828583 828608 828679 828701 828720 ] |
||||||||||||||||||||||||||||||
|
10.71 ms (5.64%) |
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 816808 817559 817654 819925 823966 824222 824383 824625 825049 825211 826515 824976 826496 826548 826596 826724 813756 817389 817397 817421 817601 818285 819062 819912 820008 820312 823573 823702 823703 823742 824669 825171 825990 826068 826394 826769 826819 827057 827240 827482 827300 827568 817306 817553 823270 823547 824047 824287 824841 824901 824910 824966 825775 826268 826432 818259 819888 823546 823716 823811 823841 824036 824758 825067 825292 825353 825417 825888 826453 828109 828150 828240 828121 826993 828608 828720 828701 828583 828478 828582 828679 828563 525423 535872 531044 533437 535250 540120 509170 509231 531652 510359 539376 544906 546237 583565 542252 546287 567661 584375 553183 579474 658818 662064 704600 706015 678925 698613 713648 716386 646412 692662 693748 716476 547059 553228 553264 576569 618629 636354 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.60%) |
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 509170 509231 510359 525423 531044 531652 533437 535250 535872 539376 540120 542252 544906 546237 546287 547059 553183 553228 553264 567661 576569 579474 583565 584375 618629 636354 646412 658818 662064 678925 692662 693748 698613 704600 706015 713648 716386 716476 813756 816808 817306 817389 817397 817421 817553 817559 817601 817654 818259 818285 819062 819888 819912 819925 820008 820312 823270 823546 823547 823573 823702 823703 823716 823841 823966 824036 824047 824222 824383 824669 824758 824841 824901 824910 824966 824976 825049 825067 825171 825211 825292 825417 825775 825888 825990 826268 826394 826453 826496 826515 826548 826596 826724 826769 826819 826993 827057 827240 827300 827482 827568 828109 828121 828150 828240 828478 828563 828582 828583 828608 828679 828701 828720 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"у замужней женщины"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен женщин"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
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.