Query Metrics
7
Database Queries
7
Different statements
382.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.96 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.36 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пися в писю"
]
|
||||||||||||||||||||||||||||||
| 3 | 22.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 529200 572711 559044 575436 590632 626249 413274 463002 644667 507430 610574 473022 560651 617004 562108 613836 563580 655697 479219 625726 526220 649123 452061 577909 656753 625404 599483 603954 522049 601890 515459 610613 480808 610695 621125 567354 592288 628426 603854 602991 524915 572344 522878 419627 599498 487926 585007 626014 612455 578454 605545 615801 528353 515223 514997 603813 416426 461137 510757 551487 574527 599353 620620 516308 515184 620205 483788 510266 576095 621612 551129 609196 605996 529078 502741 471494 576113 590404 589148 599326 528807 661565 563420 625983 529450 515119 591284 517775 521815 ] |
||||||||||||||||||||||||||||||
| 4 | 209.12 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 413274 416426 419627 452061 461137 463002 471494 473022 479219 480808 483788 487926 502741 507430 510266 510757 514997 515119 515184 515223 515459 516308 517775 521815 522049 522878 524915 526220 528353 528807 529078 529200 529450 551129 551487 559044 560651 562108 563420 563580 567354 572344 572711 574527 575436 576095 576113 577909 578454 585007 589148 590404 590632 591284 592288 599326 599353 599483 599498 601890 602991 603813 603854 603954 605545 605996 609196 610574 610613 610695 612455 613836 615801 617004 620205 620620 621125 621612 625404 625726 625983 626014 626249 628426 644667 649123 655697 656753 661565 ] |
||||||||||||||||||||||||||||||
| 5 | 142.48 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 413274 416426 419627 452061 461137 463002 471494 473022 479219 480808 483788 487926 502741 507430 510266 510757 514997 515119 515184 515223 515459 516308 517775 521815 522049 522878 524915 526220 528353 528807 529078 529200 529450 551129 551487 559044 560651 562108 563420 563580 567354 572344 572711 574527 575436 576095 576113 577909 578454 585007 589148 590404 590632 591284 592288 599326 599353 599483 599498 601890 602991 603813 603854 603954 605545 605996 609196 610574 610613 610695 612455 613836 615801 617004 620205 620620 621125 621612 625404 625726 625983 626014 626249 628426 644667 649123 655697 656753 661565 ] |
||||||||||||||||||||||||||||||
| 6 | 2.17 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин в пис"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.71 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.