Query Metrics
7
Database Queries
7
Different statements
152.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.78 ms (82.69%) |
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 182135 357499 381972 388545 391668 398073 410239 415977 428220 439514 441063 443242 443309 451337 453601 457476 462337 462381 464951 466427 467893 471124 475649 480406 481904 485638 486768 486831 511254 514854 515051 520713 530854 531222 531822 531856 531862 532634 532655 532732 533544 534535 535467 536380 537138 541276 541394 542142 542707 544143 545222 545434 546129 547453 547471 547475 550899 550916 554235 556899 558247 559289 568529 574656 576548 578545 585395 591805 600453 604228 613032 620261 621682 624197 628107 633123 636306 636309 642018 642029 656920 660079 660369 660375 660394 660417 664193 665958 668690 671038 672315 672925 672944 680252 694464 695871 695887 713501 713507 717516 724109 728215 739868 742318 749067 750668 751773 752589 752641 752651 752666 752697 759370 782789 784775 786850 786873 795420 811771 816078 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (10.53%) |
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 457476 464951 672944 547471 751773 742318 357499 391668 568529 628107 453601 462381 443242 462337 471124 536380 475649 542707 600453 585395 439514 451337 486831 481904 642018 636309 410239 520713 633123 381972 514854 534535 558247 544143 672925 660394 664193 546129 604228 752589 182135 816078 533544 531822 531856 466427 559289 545222 550916 556899 578545 574656 660079 694464 656920 665958 680252 713501 713507 576548 613032 621682 786850 811771 784775 786873 724109 749067 739868 728215 398073 532655 636306 530854 485638 554235 660375 620261 467893 480406 515051 511254 388545 443309 415977 428220 441063 531222 532634 535467 531862 532732 537138 486768 541394 547475 541276 542142 547453 550899 660417 660369 672315 668690 671038 695871 695887 717516 545434 624197 591805 642029 782789 795420 752641 752697 752666 750668 752651 759370 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (2.26%) |
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 182135 357499 381972 388545 391668 398073 410239 415977 428220 439514 441063 443242 443309 451337 453601 457476 462337 462381 464951 466427 467893 471124 475649 480406 481904 485638 486768 486831 511254 514854 515051 520713 530854 531222 531822 531856 531862 532634 532655 532732 533544 534535 535467 536380 537138 541276 541394 542142 542707 544143 545222 545434 546129 547453 547471 547475 550899 550916 554235 556899 558247 559289 568529 574656 576548 578545 585395 591805 600453 604228 613032 620261 621682 624197 628107 633123 636306 636309 642018 642029 656920 660079 660369 660375 660394 660417 664193 665958 668690 671038 672315 672925 672944 680252 694464 695871 695887 713501 713507 717516 724109 728215 739868 742318 749067 750668 751773 752589 752641 752651 752666 752697 759370 782789 784775 786850 786873 795420 811771 816078 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal fisting"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал фистинг"
]
|
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.