Query Metrics
7
Database Queries
7
Different statements
614.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
419.46 ms (68.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор большой большие член"
]
|
||||||||||||||||||||||||||||||
|
170.04 ms (27.69%) |
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 92189 96239 154826 180923 195676 196098 237293 278236 288045 383020 385228 386613 389171 392207 392751 398264 398828 401325 401367 402012 410147 413029 414001 414117 415313 415552 416020 419911 420363 434569 443237 445034 445043 452623 454814 458917 463845 465082 467197 468155 468793 469182 471866 471899 478569 485327 491239 491424 496125 505094 505661 509422 510811 511378 512573 517840 528504 529321 529887 531129 531236 531298 532369 532658 533090 533470 534386 534664 536128 536580 538045 540412 546284 550298 604453 629774 632691 638145 645812 649556 659452 677766 677773 678529 694464 696450 707376 710260 716086 716633 730118 733909 737476 740692 743663 743711 743850 746315 747153 748480 748974 749187 786463 788167 793437 796332 805354 809105 810578 814473 816650 820682 820775 825011 825554 825565 827827 827895 827965 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (2.70%) |
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 452623 505661 509422 825554 550298 820682 820775 491424 389171 716633 743850 743711 730118 392751 505094 278236 420363 443237 471899 512573 401325 531129 677766 746315 528504 401367 491239 710260 810578 638145 531236 534664 532658 536580 696450 645812 786463 694464 809105 748974 733909 825565 827979 386613 383020 195676 415313 445043 814473 465082 510811 532369 533470 540412 467197 788167 180923 392207 416020 415552 402012 496125 536128 478569 511378 485327 604453 196098 414001 398264 385228 154826 237293 96239 410147 419911 471866 538045 747153 414117 413029 463845 454814 517840 805354 737476 458917 468155 288045 816650 827827 827895 531298 529321 533090 546284 796332 92189 398828 529887 649556 677773 678529 632691 659452 740692 468793 434569 825011 716086 629774 793437 743663 707376 749187 469182 534386 827965 445034 748480 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (0.50%) |
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 92189 96239 154826 180923 195676 196098 237293 278236 288045 383020 385228 386613 389171 392207 392751 398264 398828 401325 401367 402012 410147 413029 414001 414117 415313 415552 416020 419911 420363 434569 443237 445034 445043 452623 454814 458917 463845 465082 467197 468155 468793 469182 471866 471899 478569 485327 491239 491424 496125 505094 505661 509422 510811 511378 512573 517840 528504 529321 529887 531129 531236 531298 532369 532658 533090 533470 534386 534664 536128 536580 538045 540412 546284 550298 604453 629774 632691 638145 645812 649556 659452 677766 677773 678529 694464 696450 707376 710260 716086 716633 730118 733909 737476 740692 743663 743711 743850 746315 747153 748480 748974 749187 786463 788167 793437 796332 805354 809105 810578 814473 816650 820682 820775 825011 825554 825565 827827 827895 827965 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жёстко большим членом"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.22%) |
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.