Query Metrics
7
Database Queries
7
Different statements
200.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.98 ms (83.91%) |
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 28892 88436 382581 383285 414122 415300 416685 417580 418219 419282 420686 429601 429892 432656 436054 437717 438880 439240 439322 439993 442431 448791 450889 452881 460038 462848 465470 469124 470479 470838 473395 479936 482291 485297 486510 491007 498110 498112 500338 508423 512005 514240 519379 525431 527285 528318 528608 529053 531844 541451 545455 547480 554582 556425 557650 564501 568301 569281 569575 570115 578731 580018 580190 582303 583283 584418 584806 587081 591482 591527 595256 597190 602189 604662 609097 609574 611274 660385 665958 668970 669073 671018 696866 713501 716241 717514 720200 730767 731605 738822 739145 739156 746364 746515 752617 752660 752677 757226 757434 757448 762230 764426 765179 765712 776007 780192 782274 784030 786895 791376 792700 794041 795373 799696 803624 807050 807590 808144 808337 824191 ] |
||||||||||||||||||||||||||||||
|
19.14 ms (9.56%) |
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 439993 465470 584806 528318 491007 570115 512005 514240 470838 432656 416685 439240 508423 529053 584418 668970 580018 602189 609574 611274 460038 442431 587081 382581 415300 420686 429601 462848 519379 531844 541451 556425 752677 88436 437717 452881 450889 482291 609097 439322 469124 527285 604662 485297 486510 525431 436054 470479 545455 547480 660385 671018 597190 807590 739145 752660 765712 717514 419282 795373 730767 696866 383285 824191 528608 554582 569575 583283 582303 557650 669073 720200 665958 713501 564501 578731 591482 591527 782274 791376 799696 803624 786895 746515 757434 757448 794041 807050 808144 808337 731605 746364 738822 739156 757226 765179 762230 752617 764426 716241 776007 780192 784030 792700 28892 473395 414122 479936 568301 418219 498112 498110 580190 429892 438880 448791 500338 417580 569281 595256 ] |
||||||||||||||||||||||||||||||
|
4.48 ms (2.24%) |
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 28892 88436 382581 383285 414122 415300 416685 417580 418219 419282 420686 429601 429892 432656 436054 437717 438880 439240 439322 439993 442431 448791 450889 452881 460038 462848 465470 469124 470479 470838 473395 479936 482291 485297 486510 491007 498110 498112 500338 508423 512005 514240 519379 525431 527285 528318 528608 529053 531844 541451 545455 547480 554582 556425 557650 564501 568301 569281 569575 570115 578731 580018 580190 582303 583283 584418 584806 587081 591482 591527 595256 597190 602189 604662 609097 609574 611274 660385 665958 668970 669073 671018 696866 713501 716241 717514 720200 730767 731605 738822 739145 739156 746364 746515 752617 752660 752677 757226 757434 757448 762230 764426 765179 765712 776007 780192 782274 784030 786895 791376 792700 794041 795373 799696 803624 807050 807590 808144 808337 824191 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
2.22 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo panties"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.