Query Metrics
7
Database Queries
7
Different statements
217.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.99 ms (89.65%) |
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 391869 394130 397516 397591 403959 422421 423533 425751 434623 438710 445972 446233 446510 450604 454519 456677 458360 469188 471031 472051 477406 481001 482459 486064 489047 491090 492285 494613 509578 512596 518785 527275 527343 533806 538455 539425 544171 547388 549396 552733 556763 559660 566907 569595 572917 575844 580559 633535 639882 652966 672992 694619 695674 696050 717580 724891 728895 729702 731526 732024 732268 732319 734789 735767 735806 735935 737287 742239 743897 744097 744544 745424 746618 747851 747912 748080 748523 749969 755649 758528 758963 763034 763068 763950 764076 764688 765211 765659 765898 766180 766428 767532 779015 780904 781058 781085 782457 783768 785150 785800 787579 788376 789014 789857 792158 792282 792510 797413 798020 799900 803277 803420 804855 805961 807126 807434 811748 813326 813572 ] |
||||||||||||||||||||||||||||||
|
12.65 ms (5.82%) |
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 799900 805961 807126 797413 724891 729702 743897 758528 766428 804855 805512 807434 748080 748523 734789 742239 745424 758963 765211 732319 735767 737287 744097 766180 735806 735935 749969 765659 633535 639882 792158 798020 803420 434623 469188 425751 458360 446510 494613 422421 813572 450604 492285 456677 472051 512596 533806 509578 527343 527275 544171 580559 569595 547388 695674 696050 549396 552733 779015 780904 781085 788376 813326 789014 811748 763950 767532 783768 785800 789857 792510 803277 728895 732268 744544 747912 755649 764076 732024 747851 763034 763068 765898 731526 764688 717580 781058 787579 446233 423533 391869 477406 489047 491090 652966 481001 403959 556763 746618 575844 394130 438710 482459 471031 518785 566907 572917 694619 782457 785150 792282 397516 397591 454519 445972 539425 538455 486064 559660 672992 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.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 391869 394130 397516 397591 403959 422421 423533 425751 434623 438710 445972 446233 446510 450604 454519 456677 458360 469188 471031 472051 477406 481001 482459 486064 489047 491090 492285 494613 509578 512596 518785 527275 527343 533806 538455 539425 544171 547388 549396 552733 556763 559660 566907 569595 572917 575844 580559 633535 639882 652966 672992 694619 695674 696050 717580 724891 728895 729702 731526 732024 732268 732319 734789 735767 735806 735935 737287 742239 743897 744097 744544 745424 746618 747851 747912 748080 748523 749969 755649 758528 758963 763034 763068 763950 764076 764688 765211 765659 765898 766180 766428 767532 779015 780904 781058 781085 782457 783768 785150 785800 787579 788376 789014 789857 792158 792282 792510 797413 798020 799900 803277 803420 804855 805961 807126 807434 811748 813326 813572 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl close up"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк close up"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк close up"
]
|
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.