Query Metrics
7
Database Queries
7
Different statements
201.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.06 ms (86.88%) |
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 417136 422561 422625 423026 423039 423263 423396 426173 427107 429312 429668 431416 437963 444214 445835 446460 447407 448371 448674 452180 455227 460302 462418 463884 464916 465645 467934 470059 472845 475933 478836 481792 481795 485177 485279 485336 488771 489168 491290 491463 492259 492261 495629 495759 495763 497432 497729 497892 499163 499180 503899 507939 508522 508526 509322 513198 513656 517778 517782 518936 519693 519956 520098 521076 521454 522392 522569 523036 524199 524365 524575 524722 525223 525880 527927 528004 533576 536385 536647 540316 542418 542904 546654 548649 548833 550067 551050 554256 557434 558237 558248 559521 561120 564060 565160 566340 574629 575165 575458 575473 575748 575792 579614 582775 589968 592253 597215 603482 608773 611246 615836 618645 644923 661424 708300 761201 799801 810848 827610 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (8.31%) |
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 423039 422625 827610 472845 481795 445835 485336 575458 661424 575473 810848 423263 417136 448371 517782 524722 522392 422561 423026 460302 465645 481792 518936 521454 495763 478836 546654 548833 575165 554256 558237 559521 799801 429312 423396 429668 495629 497892 497432 524199 485279 566340 644923 524575 533576 508526 527927 558248 565160 564060 575792 589968 597215 618645 603482 608773 708300 427107 431416 426173 444214 437963 470059 475933 513198 521076 524365 489168 528004 550067 488771 447407 499180 499163 540316 513656 463884 464916 492259 557434 574629 542904 575748 548649 582775 611246 761201 448674 509322 525223 492261 522569 495759 525880 491290 579614 455227 467934 508522 491463 523036 507939 497729 519956 536647 485177 542418 551050 561120 615836 592253 595204 452180 446460 519693 520098 462418 536385 503899 517778 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.33%) |
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 417136 422561 422625 423026 423039 423263 423396 426173 427107 429312 429668 431416 437963 444214 445835 446460 447407 448371 448674 452180 455227 460302 462418 463884 464916 465645 467934 470059 472845 475933 478836 481792 481795 485177 485279 485336 488771 489168 491290 491463 492259 492261 495629 495759 495763 497432 497729 497892 499163 499180 503899 507939 508522 508526 509322 513198 513656 517778 517782 518936 519693 519956 520098 521076 521454 522392 522569 523036 524199 524365 524575 524722 525223 525880 527927 528004 533576 536385 536647 540316 542418 542904 546654 548649 548833 550067 551050 554256 557434 558237 558248 559521 561120 564060 565160 566340 574629 575165 575458 575473 575748 575792 579614 582775 589968 592253 597215 603482 608773 611246 615836 618645 644923 661424 708300 761201 799801 810848 827610 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl bondage"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.67%) |
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.