Query Metrics
8
Database Queries
8
Different statements
570.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
338.79 ms (59.43%) |
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 384790 393724 397208 400426 443963 482798 487902 562114 590900 603650 610179 614427 619397 619452 620103 623551 630528 633090 642832 649190 663412 663492 663493 663968 663978 664799 664827 665108 665116 665274 666144 667290 668176 669193 677027 679123 682152 683247 683454 683470 683953 684949 685686 687271 688577 692191 694610 694641 699056 702838 705572 705808 706324 708103 708763 712158 712821 712827 712837 714652 714780 718302 719102 720819 721199 725399 728018 731801 732775 737168 739518 741127 741280 741476 741973 742965 743140 746154 747996 748229 749495 758456 760837 761566 766269 767155 767957 770217 773098 775941 775999 790200 790222 790246 796555 800261 807516 807554 807701 807703 808131 808474 812084 812151 815248 815982 815988 817114 818282 818462 819567 819597 819619 820893 821337 821610 821834 821844 821864 827776 ] |
||||||||||||||||||||||||||||||
|
208.77 ms (36.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome old young"
]
|
||||||||||||||||||||||||||||||
|
12.54 ms (2.20%) |
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 767155 807701 767957 610179 397208 663412 712158 663968 683247 687271 619397 642832 741280 760837 749495 742965 400426 665116 668176 665108 443963 393724 487902 817114 819597 819619 815988 683953 708103 719102 666144 685686 706324 720819 633090 619452 620103 775999 807516 812084 796555 812151 741127 743140 758456 766269 790246 741476 739518 746154 770217 773098 737168 705808 790222 482798 815982 821844 667290 761566 384790 815248 820893 821337 818282 818462 827776 665274 669193 705572 677027 679123 683454 692191 712821 712837 721199 649190 663978 683470 614427 623551 775941 807554 807703 808474 725399 741973 732775 747996 728018 708763 663492 714652 712827 663493 694641 819567 821610 821834 821864 562114 688577 694610 714780 718302 682152 699056 702838 664799 664827 684949 603650 590900 630528 790200 800261 808131 731801 748229 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (0.58%) |
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 384790 393724 397208 400426 443963 482798 487902 562114 590900 603650 610179 614427 619397 619452 620103 623551 630528 633090 642832 649190 663412 663492 663493 663968 663978 664799 664827 665108 665116 665274 666144 667290 668176 669193 677027 679123 682152 683247 683454 683470 683953 684949 685686 687271 688577 692191 694610 694641 699056 702838 705572 705808 706324 708103 708763 712158 712821 712827 712837 714652 714780 718302 719102 720819 721199 725399 728018 731801 732775 737168 739518 741127 741280 741476 741973 742965 743140 746154 747996 748229 749495 758456 760837 761566 766269 767155 767957 770217 773098 775941 775999 790200 790222 790246 796555 800261 807516 807554 807701 807703 808131 808474 812084 812151 815248 815982 815988 817114 818282 818462 819567 819597 819619 820893 821337 821610 821834 821844 821864 827776 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.35%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01“1&™ÈrK¤ñ&Ûeë¨D"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро old young"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро old young"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.23%) |
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.