Query Metrics
7
Database Queries
7
Different statements
139.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.95 ms (85.30%) |
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 119987 233934 309276 373736 388566 392032 398604 401858 404211 410741 428932 438646 444338 451650 455663 456985 459437 461489 470334 497417 500308 500700 502559 510660 518942 518995 546057 552206 554845 556060 556497 558082 566299 567387 576307 595396 597049 597522 598616 598789 600058 600064 605850 607761 609131 621161 652605 652925 653229 653270 654414 663224 666561 666562 669930 670997 673437 674872 682388 685399 700924 703656 712421 717322 719347 721417 722594 722890 725110 725133 727824 728217 730692 736003 739519 739879 741860 742160 742224 742833 742937 743079 743232 743961 745361 746802 746803 747147 747153 747161 751692 751792 752116 753478 754197 754199 754258 758887 759171 762746 766861 767555 778460 779140 782744 783104 783178 785772 786496 786602 791586 792838 795620 806644 811509 814350 820086 823740 826475 826674 ] |
||||||||||||||||||||||||||||||
|
11.79 ms (8.45%) |
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 778460 597049 747147 746803 401858 742937 754258 754197 373736 404211 652605 785772 727824 743232 119987 455663 546057 742833 746802 741860 826674 823740 736003 739879 783178 653229 721417 725133 758887 388566 742160 233934 600064 673437 669930 717322 598789 792838 751792 811509 759171 767555 752116 791586 410741 444338 670997 722594 722890 500308 309276 820086 558082 566299 654414 719347 806644 745361 782744 766861 786602 666561 666562 730692 747161 747153 751692 459437 552206 398604 392032 500700 595396 554845 674872 700924 621161 783104 795620 779140 743961 728217 597522 567387 461489 814350 653270 682388 556060 600058 609131 725110 739519 762746 753478 743079 754199 786496 510660 556497 607761 497417 518995 598616 742224 518942 428932 438646 470334 451650 456985 502559 826475 652925 685399 712421 663224 703656 576307 605850 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (2.11%) |
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 119987 233934 309276 373736 388566 392032 398604 401858 404211 410741 428932 438646 444338 451650 455663 456985 459437 461489 470334 497417 500308 500700 502559 510660 518942 518995 546057 552206 554845 556060 556497 558082 566299 567387 576307 595396 597049 597522 598616 598789 600058 600064 605850 607761 609131 621161 652605 652925 653229 653270 654414 663224 666561 666562 669930 670997 673437 674872 682388 685399 700924 703656 712421 717322 719347 721417 722594 722890 725110 725133 727824 728217 730692 736003 739519 739879 741860 742160 742224 742833 742937 743079 743232 743961 745361 746802 746803 747147 747153 747161 751692 751792 752116 753478 754197 754199 754258 758887 759171 762746 766861 767555 778460 779140 782744 783104 783178 785772 786496 786602 791586 792838 795620 806644 811509 814350 820086 823740 826475 826674 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teen cute"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teen cute"
]
|
||||||||||||||||||||||||||||||
|
1.07 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teen cute"
]
|
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.