Query Metrics
7
Database Queries
7
Different statements
161.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.73 ms (82.77%) |
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 82710 468612 476123 476828 488423 488751 495566 497950 498280 501598 506195 508807 509805 510397 512502 512928 512975 514240 515523 517784 518168 523161 523537 526003 526232 527198 529988 530482 531119 531204 531205 532380 532839 533053 533944 536233 536666 536693 537686 542709 543921 544668 545245 545782 551987 554986 555043 555391 556017 556029 558176 560408 560425 560666 562374 564129 564327 572640 576951 579582 580368 580808 581096 583132 583725 583774 583913 585079 587987 588022 589040 593275 593292 593470 593656 595847 597232 598680 598686 598723 599844 599921 600410 601861 602008 602249 604271 610577 616036 617137 619102 619109 621656 622666 623420 626297 628095 628397 629428 629630 632006 634138 637537 639922 648974 649833 651900 652289 653452 656925 659418 664435 668688 671835 674952 677300 679314 680206 683083 688617 ] |
||||||||||||||||||||||||||||||
|
17.92 ms (11.09%) |
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 501598 508807 509805 515523 526232 529988 542709 555391 580808 543921 551987 579582 583132 554986 656925 671835 680206 668688 677300 649833 651900 652289 545782 560666 572640 583774 587987 598680 598723 602008 602249 588022 593275 599921 619109 626297 629630 593470 593656 623420 628095 82710 488423 523161 585079 476123 476828 488751 468612 497950 512975 514240 536693 495566 517784 518168 533053 536233 506195 510397 532380 536666 545245 560425 556029 562374 580368 555043 648974 674952 688617 653452 659418 556017 583725 595847 598686 610577 621656 632006 597232 600410 601861 589040 604271 619102 622666 526003 512502 532839 533944 527198 537686 498280 523537 530482 531119 531204 531205 512928 560408 564327 583913 564129 576951 581096 544668 664435 679314 683083 558176 629428 599844 617137 637537 639922 593292 634138 616036 628397 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.76%) |
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 82710 468612 476123 476828 488423 488751 495566 497950 498280 501598 506195 508807 509805 510397 512502 512928 512975 514240 515523 517784 518168 523161 523537 526003 526232 527198 529988 530482 531119 531204 531205 532380 532839 533053 533944 536233 536666 536693 537686 542709 543921 544668 545245 545782 551987 554986 555043 555391 556017 556029 558176 560408 560425 560666 562374 564129 564327 572640 576951 579582 580368 580808 581096 583132 583725 583774 583913 585079 587987 588022 589040 593275 593292 593470 593656 595847 597232 598680 598686 598723 599844 599921 600410 601861 602008 602249 604271 610577 616036 617137 619102 619109 621656 622666 623420 626297 628095 628397 629428 629630 632006 634138 637537 639922 648974 649833 651900 652289 653452 656925 659418 664435 668688 671835 674952 677300 679314 680206 683083 688617 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"раскрытое"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"раскрыт"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.85%) |
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.