Query Metrics
7
Database Queries
7
Different statements
133.72 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.35 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"целуют в губы"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.67 ms |
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 603388 657704 613706 622767 653524 655609 566538 597542 603953 625870 525525 576691 550443 522972 558003 574546 608737 628277 613129 608416 619519 404766 653464 598500 621397 424527 439518 541673 541888 556327 571016 576638 659216 656710 578467 620559 621691 602003 413274 649123 485541 657438 512527 515723 556025 549736 554370 580667 614273 486835 523995 527990 541419 548708 618923 590221 605445 622824 413141 521739 521989 567148 636174 461602 522403 534167 518586 550436 654422 677025 586576 495199 560646 625395 605586 557235 510757 468446 550434 623405 395696 549225 478672 589642 609279 591647 ] |
||||||||||||||||||||||||||||||
| 4 | 2.24 ms |
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 395696 404766 413141 413274 424527 439518 461602 468446 478672 485541 486835 495199 510757 512527 515723 518586 521739 521989 522403 522972 523995 525525 527990 534167 541419 541673 541888 548708 549225 549736 550434 550436 550443 554370 556025 556327 557235 558003 560646 566538 567148 571016 574546 576638 576691 578467 580667 586576 589642 590221 591647 597542 598500 602003 603388 603953 605445 605586 608416 608737 609279 613129 613706 614273 618923 619519 620559 621397 621691 622767 622824 623405 625395 625870 628277 636174 649123 653464 653524 654422 655609 656710 657438 657704 659216 677025 ] |
||||||||||||||||||||||||||||||
| 5 | 109.86 ms |
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 395696 404766 413141 413274 424527 439518 461602 468446 478672 485541 486835 495199 510757 512527 515723 518586 521739 521989 522403 522972 523995 525525 527990 534167 541419 541673 541888 548708 549225 549736 550434 550436 550443 554370 556025 556327 557235 558003 560646 566538 567148 571016 574546 576638 576691 578467 580667 586576 589642 590221 591647 597542 598500 602003 603388 603953 605445 605586 608416 608737 609279 613129 613706 614273 618923 619519 620559 621397 621691 622767 622824 623405 625395 625870 628277 636174 649123 653464 653524 654422 655609 656710 657438 657704 659216 677025 ] |
||||||||||||||||||||||||||||||
| 6 | 1.58 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поцел в губ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.31 ms |
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.