Query Metrics
7
Database Queries
7
Different statements
142.03 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.05 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 | 17.30 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 568185 762885 509707 628654 591174 590437 502518 493359 513593 517114 561468 573758 649225 682368 654683 562964 625223 627727 791571 446642 502477 509440 545917 542082 659391 519392 406041 510157 649240 750704 439656 599533 414313 494036 653972 546774 573354 682303 625235 632614 597146 439564 439755 522343 623618 619999 414014 793757 804776 477473 508974 560804 566304 606439 621203 520184 474706 521624 521495 623644 588068 605736 613275 482953 393076 509666 553411 560497 560783 457103 628044 529290 550329 584688 589544 543844 605500 605952 587266 525525 619746 619475 615444 618874 430553 652281 615696 ] |
||||||||||||||||||||||||||||||
| 4 | 2.46 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 393076 406041 414014 414313 430553 439564 439656 439755 446642 457103 474706 477473 482953 493359 494036 502477 502518 508974 509440 509666 509707 510157 513593 517114 519392 520184 521495 521624 522343 525525 529290 542082 543844 545917 546774 550329 553411 560497 560783 560804 561468 562964 566304 568185 573354 573758 584688 587266 588068 589544 590437 591174 597146 599533 605500 605736 605952 606439 613275 615444 615696 618874 619475 619746 619999 621203 623618 623644 625223 625235 627727 628044 628654 632614 649225 649240 652281 653972 654683 659391 682303 682368 750704 762885 791571 793757 804776 ] |
||||||||||||||||||||||||||||||
| 5 | 115.21 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 393076 406041 414014 414313 430553 439564 439656 439755 446642 457103 474706 477473 482953 493359 494036 502477 502518 508974 509440 509666 509707 510157 513593 517114 519392 520184 521495 521624 522343 525525 529290 542082 543844 545917 546774 550329 553411 560497 560783 560804 561468 562964 566304 568185 573354 573758 584688 587266 588068 589544 590437 591174 597146 599533 605500 605736 605952 606439 613275 615444 615696 618874 619475 619746 619999 621203 623618 623644 625223 625235 627727 628044 628654 632614 649225 649240 652281 653972 654683 659391 682303 682368 750704 762885 791571 793757 804776 ] |
||||||||||||||||||||||||||||||
| 6 | 1.68 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен дел"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.49 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.