Query Metrics
7
Database Queries
7
Different statements
192.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.61 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.85 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в врачиха"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.55 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 508778 527089 473457 519061 584168 555118 593348 593363 586494 512505 526087 486399 498038 485918 436770 475119 512205 544865 563146 647964 576616 593299 593536 593368 593359 615925 601634 607618 625171 456766 421691 525369 486672 497026 498054 675537 605383 512208 498022 596571 593343 444316 482790 549643 593529 586503 419475 460067 507944 506803 516000 593361 524544 625441 508236 538281 573486 583677 648817 576706 593296 593373 619884 607129 586429 610686 498039 554182 593269 615012 593292 491871 498030 545695 593425 593366 554386 578326 605450 586440 585007 622693 586484 ] |
||||||||||||||||||||||||||||||
| 4 | 2.75 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 419475 421691 436770 444316 456766 460067 473457 475119 482790 485918 486399 486672 491871 497026 498022 498030 498038 498039 498054 506803 507944 508236 508778 512205 512208 512505 516000 519061 524544 525369 526087 527089 538281 544865 545695 549643 554182 554386 555118 563146 573486 576616 576706 578326 583677 584168 585007 586429 586440 586484 586494 586503 593269 593292 593296 593299 593343 593348 593359 593361 593363 593366 593368 593373 593425 593529 593536 596571 601634 605383 605450 607129 607618 610686 615012 615925 619884 622693 625171 625441 647964 648817 675537 ] |
||||||||||||||||||||||||||||||
| 5 | 166.96 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 419475 421691 436770 444316 456766 460067 473457 475119 482790 485918 486399 486672 491871 497026 498022 498030 498038 498039 498054 506803 507944 508236 508778 512205 512208 512505 516000 519061 524544 525369 526087 527089 538281 544865 545695 549643 554182 554386 555118 563146 573486 576616 576706 578326 583677 584168 585007 586429 586440 586484 586494 586503 593269 593292 593296 593299 593343 593348 593359 593361 593363 593366 593368 593373 593425 593529 593536 596571 601634 605383 605450 607129 607618 610686 615012 615925 619884 622693 625171 625441 647964 648817 675537 ] |
||||||||||||||||||||||||||||||
| 6 | 1.69 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в врачих"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.37 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.