Query Metrics
7
Database Queries
7
Different statements
152.75 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.49 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.74 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls best friend"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.29 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 567000 578527 517372 496650 515709 506599 522230 536865 529176 578596 615774 442918 463561 492528 492921 486020 500504 580532 523782 514661 513408 586864 593742 442864 449311 435642 508308 483594 491606 417064 542056 617234 591275 395856 445652 490005 523035 500476 500482 545009 578531 581852 623792 418879 412262 700949 604097 596556 591413 507767 508735 578563 602506 441398 446735 462904 578586 578587 450847 515645 544992 564867 441191 419867 467721 601669 425523 449784 419880 514800 541889 569415 601231 560517 606948 606929 562061 645918 627773 446431 528420 608206 498043 568062 621732 622778 621277 ] |
||||||||||||||||||||||||||||||
| 4 | 2.97 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 395856 412262 417064 418879 419867 419880 425523 435642 441191 441398 442864 442918 445652 446431 446735 449311 449784 450847 462904 463561 467721 483594 486020 490005 491606 492528 492921 496650 498043 500476 500482 500504 506599 507767 508308 508735 513408 514661 514800 515645 515709 517372 522230 523035 523782 528420 529176 536865 541889 542056 544992 545009 560517 562061 564867 567000 568062 569415 578527 578531 578563 578586 578587 578596 580532 581852 586864 591275 591413 593742 596556 601231 601669 602506 604097 606929 606948 608206 615774 617234 621277 621732 622778 623792 627773 645918 700949 ] |
||||||||||||||||||||||||||||||
| 5 | 127.17 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 395856 412262 417064 418879 419867 419880 425523 435642 441191 441398 442864 442918 445652 446431 446735 449311 449784 450847 462904 463561 467721 483594 486020 490005 491606 492528 492921 496650 498043 500476 500482 500504 506599 507767 508308 508735 513408 514661 514800 515645 515709 517372 522230 523035 523782 528420 529176 536865 541889 542056 544992 545009 560517 562061 564867 567000 568062 569415 578527 578531 578563 578586 578587 578596 580532 581852 586864 591275 591413 593742 596556 601231 601669 602506 604097 606929 606948 608206 615774 617234 621277 621732 622778 623792 627773 645918 700949 ] |
||||||||||||||||||||||||||||||
| 6 | 1.63 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк best friend"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.47 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк best friend"
]
|
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.