Query Metrics
7
Database Queries
7
Different statements
149.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.80 ms (81.59%) |
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 436030 437947 440906 460535 471429 474648 531121 531249 531250 545408 551186 559644 569154 589752 591165 596815 600807 601548 601593 603187 604080 604383 607091 607376 608035 608744 609603 614186 619408 620316 628185 628410 630234 630295 630902 632626 633776 634161 634169 639782 640712 644303 644314 644321 644968 644972 645879 647910 647996 649114 649180 651062 653630 656499 656502 665317 665448 665457 665921 666532 666879 667196 667636 668527 670098 670965 672984 673357 678915 680121 680142 684014 684029 692293 692314 693194 693596 695125 696998 697025 703096 707275 712006 720050 729881 733877 736798 736881 743782 744306 746636 755759 756407 770732 775758 775834 775858 775862 775982 775989 780655 788582 792560 795593 801975 804460 805275 806804 808112 811164 814556 815080 815214 815347 815483 816905 817115 817288 817346 825119 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (10.60%) |
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 607376 601593 607091 775834 801975 804460 755759 736881 770732 604383 644303 707275 712006 775982 775989 806804 436030 471429 437947 604080 460535 440906 474648 569154 816905 817115 644972 644968 825119 815214 815483 814556 815080 815347 817288 817346 531250 531121 531249 551186 545408 559644 651062 656499 665317 665448 665457 666532 667636 672984 693194 703096 645879 647910 647996 649114 649180 656502 665921 666879 667196 670098 670965 678915 680142 684029 693596 696998 653630 668527 673357 680121 684014 692293 692314 695125 697025 720050 619408 628185 634169 640712 600807 628410 634161 589752 591165 603187 608744 609603 614186 633776 644314 644321 596815 601548 608035 620316 630234 630295 630902 632626 639782 775758 795593 805275 808112 811164 775858 775862 780655 736798 746636 788582 792560 733877 756407 729881 743782 744306 ] |
||||||||||||||||||||||||||||||
|
4.40 ms (2.95%) |
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 436030 437947 440906 460535 471429 474648 531121 531249 531250 545408 551186 559644 569154 589752 591165 596815 600807 601548 601593 603187 604080 604383 607091 607376 608035 608744 609603 614186 619408 620316 628185 628410 630234 630295 630902 632626 633776 634161 634169 639782 640712 644303 644314 644321 644968 644972 645879 647910 647996 649114 649180 651062 653630 656499 656502 665317 665448 665457 665921 666532 666879 667196 667636 668527 670098 670965 672984 673357 678915 680121 680142 684014 684029 692293 692314 693194 693596 695125 696998 697025 703096 707275 712006 720050 729881 733877 736798 736881 743782 744306 746636 755759 756407 770732 775758 775834 775858 775862 775982 775989 780655 788582 792560 795593 801975 804460 805275 806804 808112 811164 814556 815080 815214 815347 815483 816905 817115 817288 817346 825119 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член double"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob double"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член double"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.17%) |
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.