Query Metrics
7
Database Queries
7
Different statements
205.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.31 ms (88.10%) |
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 209931 386215 393798 398719 420303 447188 480998 482738 531363 541436 550413 561282 572377 572479 589604 591869 592283 609149 610196 616574 622485 622511 628340 633244 636440 637311 660347 677689 685935 686481 691772 693660 694193 698233 699342 704292 705463 709371 710378 710639 711878 714194 715604 718826 721227 721808 731230 731811 737866 739805 740780 741206 741797 744146 744819 746037 747490 749074 752440 752933 754061 754153 759811 761954 762651 763751 764326 765409 765422 766168 771898 772866 774566 777029 778972 782525 783563 784129 785831 786151 787407 789282 790778 790904 792165 792241 792248 793929 794067 794298 794304 794623 796171 796213 798537 800979 802311 803588 803995 806478 806813 813707 813825 815704 815726 815913 816034 816080 817567 817789 817839 818351 818355 820154 820802 821420 822662 822726 825047 827649 ] |
||||||||||||||||||||||||||||||
|
14.29 ms (6.94%) |
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 815726 816034 822662 827649 482738 677689 698233 550413 636440 622511 628340 790904 802311 737866 749074 754153 796213 739805 765409 771898 610196 721808 209931 752933 709371 825047 817839 710378 790778 774566 803588 793929 798537 764326 794304 813825 531363 572479 705463 715604 783563 787407 794067 800979 803995 759811 777029 786151 792241 806478 386215 398719 813707 815704 820154 660347 710639 718826 691772 704292 721227 561282 637311 592283 609149 589604 794623 778972 792248 794298 731230 744146 744819 747490 752440 792165 731811 741206 754061 762651 741797 761954 766168 740780 763751 765422 746037 772866 782525 789282 796171 806813 393798 818351 420303 822726 815913 817789 816080 817567 818355 820802 821420 447188 480998 541436 572377 685935 694193 699342 686481 693660 711878 714194 616574 633244 622485 591869 784129 785831 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.43%) |
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 209931 386215 393798 398719 420303 447188 480998 482738 531363 541436 550413 561282 572377 572479 589604 591869 592283 609149 610196 616574 622485 622511 628340 633244 636440 637311 660347 677689 685935 686481 691772 693660 694193 698233 699342 704292 705463 709371 710378 710639 711878 714194 715604 718826 721227 721808 731230 731811 737866 739805 740780 741206 741797 744146 744819 746037 747490 749074 752440 752933 754061 754153 759811 761954 762651 763751 764326 765409 765422 766168 771898 772866 774566 777029 778972 782525 783563 784129 785831 786151 787407 789282 790778 790904 792165 792241 792248 793929 794067 794298 794304 794623 796171 796213 798537 800979 802311 803588 803995 806478 806813 813707 813825 815704 815726 815913 816034 816080 817567 817789 817839 818351 818355 820154 820802 821420 822662 822726 825047 827649 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мокрые секс"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wet sex"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.76%) |
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.