Query Metrics
7
Database Queries
7
Different statements
181.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.00 ms (83.11%) |
1 |
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 5344 28382 32551 61187 123199 183404 260297 262418 287459 382121 383272 385446 387150 387953 388006 389756 390355 393723 396705 409585 411414 414019 417116 419590 424147 429097 429577 433304 441289 451165 454034 455543 456063 457898 459133 470636 471538 472436 473106 476297 476819 476871 481597 482349 484003 484237 491076 492759 494370 496322 501264 506213 510169 512052 513386 513881 518493 519947 522414 523981 524169 526046 528788 529188 531078 540766 543013 543184 545522 546567 547129 547653 552050 553486 556008 563803 564924 566199 569678 572088 572772 573361 573462 574777 575447 575488 577661 578530 579806 582416 583507 587884 588253 588386 593137 595869 599610 600773 602939 603003 603224 604051 606397 607214 608695 620011 621527 621593 626217 630193 652725 655097 663242 663442 663947 676467 682448 682912 683912 693882 ] |
||||||||||||||||||||||||||||||
|
19.16 ms (10.55%) |
1 |
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 382121 28382 387953 396705 540766 579806 578530 693882 652725 546567 183404 390355 262418 459133 451165 513881 547653 553486 663242 663442 547129 626217 470636 414019 676467 575447 583507 603224 621527 602939 606397 409585 575488 543013 683912 572772 573361 491076 531078 577661 512052 528788 604051 494370 383272 473106 663947 574777 518493 506213 630193 419590 608695 599610 522414 655097 429097 519947 523981 545522 569678 563803 393723 476819 472436 510169 588253 385446 5344 389756 387150 441289 411414 433304 476871 484003 454034 476297 482349 496322 566199 556008 564924 582416 543184 573462 682448 572088 588386 593137 600773 603003 595869 587884 620011 607214 621593 287459 481597 455543 456063 32551 260297 424147 471538 61187 388006 417116 429577 457898 524169 526046 484237 492759 513386 123199 529188 501264 552050 682912 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.76%) |
1 |
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 5344 28382 32551 61187 123199 183404 260297 262418 287459 382121 383272 385446 387150 387953 388006 389756 390355 393723 396705 409585 411414 414019 417116 419590 424147 429097 429577 433304 441289 451165 454034 455543 456063 457898 459133 470636 471538 472436 473106 476297 476819 476871 481597 482349 484003 484237 491076 492759 494370 496322 501264 506213 510169 512052 513386 513881 518493 519947 522414 523981 524169 526046 528788 529188 531078 540766 543013 543184 545522 546567 547129 547653 552050 553486 556008 563803 564924 566199 569678 572088 572772 573361 573462 574777 575447 575488 577661 578530 579806 582416 583507 587884 588253 588386 593137 595869 599610 600773 602939 603003 603224 604051 606397 607214 608695 620011 621527 621593 626217 630193 652725 655097 663242 663442 663947 676467 682448 682912 683912 693882 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сверху на мужике"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз на мужчин"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.97%) |
1 |
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.