Query Metrics
7
Database Queries
7
Different statements
129.55 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.01 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.09 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мы сосем"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.62 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 498297 507207 528739 543910 549463 551676 567666 544049 566740 577572 578430 690683 718455 662016 550536 553496 559337 600709 622170 595523 596787 605488 600482 796014 742891 729629 732697 608317 608730 701761 786637 453611 476919 495369 494834 511728 498405 502470 511543 531178 534575 477395 572970 574427 584950 579527 583617 707701 566759 583240 631478 626089 796798 780517 469303 513616 514744 534784 504071 552795 562362 565371 568871 553314 592883 610593 728103 510568 509174 501259 532504 524320 571723 574243 603623 614918 633312 465628 511916 623150 613951 600837 620646 528420 510286 584688 ] |
||||||||||||||||||||||||||||||
| 4 | 3.47 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 453611 465628 469303 476919 477395 494834 495369 498297 498405 501259 502470 504071 507207 509174 510286 510568 511543 511728 511916 513616 514744 524320 528420 528739 531178 532504 534575 534784 543910 544049 549463 550536 551676 552795 553314 553496 559337 562362 565371 566740 566759 567666 568871 571723 572970 574243 574427 577572 578430 579527 583240 583617 584688 584950 592883 595523 596787 600482 600709 600837 603623 605488 608317 608730 610593 613951 614918 620646 622170 623150 626089 631478 633312 662016 690683 701761 707701 718455 728103 729629 732697 742891 780517 786637 796014 796798 ] |
||||||||||||||||||||||||||||||
| 5 | 104.79 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 453611 465628 469303 476919 477395 494834 495369 498297 498405 501259 502470 504071 507207 509174 510286 510568 511543 511728 511916 513616 514744 524320 528420 528739 531178 532504 534575 534784 543910 544049 549463 550536 551676 552795 553314 553496 559337 562362 565371 566740 566759 567666 568871 571723 572970 574243 574427 577572 578430 579527 583240 583617 584688 584950 592883 595523 596787 600482 600709 600837 603623 605488 608317 608730 610593 613951 614918 620646 622170 623150 626089 631478 633312 662016 690683 701761 707701 718455 728103 729629 732697 742891 780517 786637 796014 796798 ] |
||||||||||||||||||||||||||||||
| 6 | 2.40 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сос"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.16 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.