Query Metrics
7
Database Queries
7
Different statements
356.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.11 ms (58.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
121.95 ms (34.23%) |
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 7774 39497 98410 123340 182033 213118 275727 356714 383903 385838 391877 395477 404395 405156 406075 407550 409747 412702 412969 419148 420332 427593 447054 454354 454916 456098 456174 456445 456674 457182 457189 458436 461303 463482 466902 467215 468694 472297 478563 480826 482738 486312 489476 493006 493300 494802 497661 502680 504323 505986 507235 507973 512530 515947 520145 521354 521399 521530 523954 524281 525049 531808 533622 535577 535909 536925 552166 558209 563281 572094 578353 578916 579295 584191 597012 600060 602716 602922 603994 604541 604873 605605 613985 614609 615492 620407 620684 621980 630045 633411 635182 639889 665504 667227 670468 671127 671136 672403 680635 689398 715179 731140 737598 741021 746949 755068 778776 779274 780144 782759 783175 783864 785477 791701 792248 793433 793615 797125 801044 807811 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (4.49%) |
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 597012 600060 604873 602716 603994 604541 613985 614609 621980 405156 461303 406075 412969 507973 520145 497661 504323 533622 536925 502680 515947 524281 489476 507235 521354 391877 427593 454354 456174 457189 468694 456098 457182 463482 472297 558209 404395 412702 478563 458436 467215 123340 409747 419148 456445 447054 454916 521530 523954 525049 493300 494802 505986 486312 493006 512530 535577 385838 383903 213118 182033 395477 275727 356714 39497 7774 98410 420332 407550 482738 456674 480826 466902 531808 521399 535909 552166 563281 578353 572094 671127 667227 671136 672403 715179 665504 670468 680635 689398 578916 579295 584191 605605 615492 620407 630045 620684 602922 633411 635182 639889 791701 793433 793615 801044 778776 779274 780144 782759 783175 785477 792248 737598 783864 797125 807811 741021 746949 755068 731140 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (0.95%) |
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 7774 39497 98410 123340 182033 213118 275727 356714 383903 385838 391877 395477 404395 405156 406075 407550 409747 412702 412969 419148 420332 427593 447054 454354 454916 456098 456174 456445 456674 457182 457189 458436 461303 463482 466902 467215 468694 472297 478563 480826 482738 486312 489476 493006 493300 494802 497661 502680 504323 505986 507235 507973 512530 515947 520145 521354 521399 521530 523954 524281 525049 531808 533622 535577 535909 536925 552166 558209 563281 572094 578353 578916 579295 584191 597012 600060 602716 602922 603994 604541 604873 605605 613985 614609 615492 620407 620684 621980 630045 633411 635182 639889 665504 667227 670468 671127 671136 672403 680635 689398 715179 731140 737598 741021 746949 755068 778776 779274 780144 782759 783175 783864 785477 791701 792248 793433 793615 797125 801044 807811 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"баби"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.42%) |
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.