Query Metrics
7
Database Queries
7
Different statements
164.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.38 ms (78.17%) |
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 401799 405804 415419 417449 421207 426417 444795 449784 452639 459388 464368 468139 472248 473779 475280 475301 475414 479011 483607 486871 488764 491858 500477 506133 507680 509685 512094 512941 513572 513575 514311 514940 515071 515086 515953 517752 518219 520540 521798 522973 523045 523667 524530 525738 529109 529374 535432 538963 541749 543844 545245 545440 547245 549093 551819 552273 553031 555291 558191 559439 559454 560425 560665 561061 561346 561452 562003 564646 565550 565653 566708 569047 569223 569302 573212 579582 581530 581873 583021 586573 588068 588525 590906 591428 593361 593363 593759 594370 595070 595132 595905 598233 598524 599078 599940 600913 601448 601529 601624 604364 606482 611535 611558 611567 615525 620009 622241 623420 623744 624095 624742 626944 629428 634230 663458 678095 678097 ] |
||||||||||||||||||||||||||||||
|
24.27 ms (14.78%) |
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 515086 509685 514940 515953 517752 529374 468139 475280 545440 560665 569302 579582 549093 559439 559454 569047 547245 581530 590906 593363 595070 615525 593759 623420 401799 475301 472248 417449 518219 520540 421207 473779 475414 506133 515071 529109 524530 545245 560425 566708 569223 561061 555291 562003 581873 551819 552273 598233 623744 595132 588525 594370 591428 624742 426417 452639 479011 521798 523667 525738 599078 449784 522973 513575 535432 512941 583021 541749 561346 663458 561452 601448 611567 629428 586573 601624 606482 595905 601529 514311 444795 464368 500477 513572 588068 611535 459388 486871 507680 538963 543844 565550 565653 553031 564646 678095 678097 611558 620009 593361 598524 600913 622241 624095 604364 405804 512094 491858 523045 483607 488764 573212 634230 415419 558191 626944 599940 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (2.03%) |
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 401799 405804 415419 417449 421207 426417 444795 449784 452639 459388 464368 468139 472248 473779 475280 475301 475414 479011 483607 486871 488764 491858 500477 506133 507680 509685 512094 512941 513572 513575 514311 514940 515071 515086 515953 517752 518219 520540 521798 522973 523045 523667 524530 525738 529109 529374 535432 538963 541749 543844 545245 545440 547245 549093 551819 552273 553031 555291 558191 559439 559454 560425 560665 561061 561346 561452 562003 564646 565550 565653 566708 569047 569223 569302 573212 579582 581530 581873 583021 586573 588068 588525 590906 591428 593361 593363 593759 594370 595070 595132 595905 598233 598524 599078 599940 600913 601448 601529 601624 604364 606482 611535 611558 611567 615525 620009 622241 623420 623744 624095 624742 626944 629428 634230 663458 678095 678097 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"игрушка для клитора"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"игрушк клитор"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.08%) |
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.