Query Metrics
7
Database Queries
7
Different statements
260.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.17 ms (89.39%) |
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 390670 397712 405468 409667 414342 414675 417462 418121 421637 429766 434443 437947 440906 449928 458527 463002 466903 470092 470430 474126 478463 480861 483319 483492 486767 493696 497641 499957 501239 504085 504810 507696 523568 524198 524346 526042 530375 530623 530643 530765 530854 531183 531206 532726 532962 533012 534150 536259 536266 536281 536292 536344 536580 537899 537901 537906 537917 540573 540944 542061 542524 544827 546129 550124 552706 553411 554338 558223 559378 563992 565246 571359 571712 578218 580114 581064 581083 591914 596799 599864 600296 600415 601690 601698 605862 607569 613832 617114 628371 631162 631249 632671 637537 639731 642038 644510 645276 648832 650333 651136 658797 658907 662886 676111 677296 677784 699526 725742 737388 740250 778266 791135 795402 796644 796660 796678 804701 807142 813579 816669 ] |
||||||||||||||||||||||||||||||
|
17.04 ms (6.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 550124 544827 631249 599864 639731 642038 480861 417462 486767 390670 449928 458527 559378 504810 601690 524346 571359 581064 662886 546129 601698 607569 804701 778266 807142 796644 740250 644510 796678 414675 418121 552706 580114 658907 658797 571712 493696 499957 397712 540573 504085 553411 558223 677296 677784 605862 628371 463002 591914 483492 617114 791135 796660 725742 737388 483319 645276 600296 631162 600415 632671 613832 409667 542524 637537 434443 524198 421637 816669 466903 578218 542061 596799 795402 497641 405468 414342 440906 429766 437947 813579 470092 470430 474126 478463 526042 531206 532962 534150 536281 523568 530375 530765 532726 533012 536259 536344 536580 537899 507696 530854 531183 536266 537901 537906 537917 501239 530623 530643 536292 540944 581083 563992 565246 554338 648832 650333 651136 676111 699526 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.02%) |
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 390670 397712 405468 409667 414342 414675 417462 418121 421637 429766 434443 437947 440906 449928 458527 463002 466903 470092 470430 474126 478463 480861 483319 483492 486767 493696 497641 499957 501239 504085 504810 507696 523568 524198 524346 526042 530375 530623 530643 530765 530854 531183 531206 532726 532962 533012 534150 536259 536266 536281 536292 536344 536580 537899 537901 537906 537917 540573 540944 542061 542524 544827 546129 550124 552706 553411 554338 558223 559378 563992 565246 571359 571712 578218 580114 581064 581083 591914 596799 599864 600296 600415 601690 601698 605862 607569 613832 617114 628371 631162 631249 632671 637537 639731 642038 644510 645276 648832 650333 651136 658797 658907 662886 676111 677296 677784 699526 725742 737388 740250 778266 791135 795402 796644 796660 796678 804701 807142 813579 816669 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм дилд"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm dildo"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм дилд"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.69%) |
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.