Query Metrics
7
Database Queries
7
Different statements
192.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.61 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.64 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ххх у озера"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.52 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 474270 470235 470538 522402 535341 565378 570935 578383 576326 577146 593758 594824 606284 396470 387391 434466 502218 512474 522236 489990 443066 419263 457780 487657 453773 473683 457563 510502 529292 537274 559762 565450 574421 565395 650950 635022 615831 773582 437484 466364 435818 458475 519360 513484 523821 486978 324288 487862 450699 510047 488539 548224 555594 659297 681046 577455 605903 602743 465182 480638 470108 476485 476603 488709 497550 528140 484162 492507 428269 479637 524295 527600 519895 544596 598749 623660 453508 475062 496979 520339 483897 491870 618239 424380 585060 486083 491790 541923 622838 568741 ] |
||||||||||||||||||||||||||||||
| 4 | 2.83 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 324288 387391 396470 419263 424380 428269 434466 435818 437484 443066 450699 453508 453773 457563 457780 458475 465182 466364 470108 470235 470538 473683 474270 475062 476485 476603 479637 480638 483897 484162 486083 486978 487657 487862 488539 488709 489990 491790 491870 492507 496979 497550 502218 510047 510502 512474 513484 519360 519895 520339 522236 522402 523821 524295 527600 528140 529292 535341 537274 541923 544596 548224 555594 559762 565378 565395 565450 568741 570935 574421 576326 577146 577455 578383 585060 593758 594824 598749 602743 605903 606284 615831 618239 622838 623660 635022 650950 659297 681046 773582 ] |
||||||||||||||||||||||||||||||
| 5 | 163.53 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 324288 387391 396470 419263 424380 428269 434466 435818 437484 443066 450699 453508 453773 457563 457780 458475 465182 466364 470108 470235 470538 473683 474270 475062 476485 476603 479637 480638 483897 484162 486083 486978 487657 487862 488539 488709 489990 491790 491870 492507 496979 497550 502218 510047 510502 512474 513484 519360 519895 520339 522236 522402 523821 524295 527600 528140 529292 535341 537274 541923 544596 548224 555594 559762 565378 565395 565450 568741 570935 574421 576326 577146 577455 578383 585060 593758 594824 598749 602743 605903 606284 615831 618239 622838 623660 635022 650950 659297 681046 773582 ] |
||||||||||||||||||||||||||||||
| 6 | 1.70 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ххх озер"
]
|
||||||||||||||||||||||||||||||
| 7 | 4.55 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.