Query Metrics
7
Database Queries
7
Different statements
183.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.76 ms (81.98%) |
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 44909 97098 130506 302932 341802 373803 383742 387293 390378 391592 414360 454255 467594 472429 479077 530792 531121 531200 531249 531250 532746 532817 532940 540334 544439 544510 544836 548464 568190 576703 577210 596815 605344 607091 609603 619408 628110 629886 630902 632653 633147 633875 640524 641705 644278 644289 644324 649147 649202 651276 659321 662428 667196 670098 670562 671741 671759 672984 673357 673358 674082 677707 680121 680192 684029 684567 686214 692812 693056 693194 695262 697266 699694 703039 703096 705540 707315 707333 708110 712886 717523 717798 717828 717873 717897 720241 720264 722384 727751 729819 734514 736798 743782 746991 748257 748538 752683 756407 765714 770124 770827 770884 775858 775862 775989 780655 786874 788790 790219 795593 801957 808112 811164 814270 815699 815875 816905 817288 817319 817346 ] |
||||||||||||||||||||||||||||||
|
22.79 ms (12.39%) |
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 383742 130506 391592 302932 341802 373803 97098 44909 387293 390378 414360 814270 816905 817319 815699 815875 817288 817346 472429 479077 454255 531200 531250 532746 532817 532940 540334 531121 530792 531249 467594 544439 544510 548464 577210 568190 649147 662428 671759 672984 674082 677707 680192 686214 693056 693194 699694 703096 712886 717828 667196 670098 673358 684029 695262 697266 707333 717523 717873 649202 651276 659321 670562 671741 673357 680121 684567 692812 705540 707315 708110 717897 720264 722384 544836 576703 619408 628110 641705 609603 629886 632653 596815 605344 607091 630902 633875 786874 795593 808112 811164 775858 775862 780655 788790 801957 736798 752683 734514 746991 756407 770124 770884 729819 727751 743782 748257 748538 770827 765714 633147 640524 644278 644289 644324 703039 717798 720241 775989 790219 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.66%) |
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 44909 97098 130506 302932 341802 373803 383742 387293 390378 391592 414360 454255 467594 472429 479077 530792 531121 531200 531249 531250 532746 532817 532940 540334 544439 544510 544836 548464 568190 576703 577210 596815 605344 607091 609603 619408 628110 629886 630902 632653 633147 633875 640524 641705 644278 644289 644324 649147 649202 651276 659321 662428 667196 670098 670562 671741 671759 672984 673357 673358 674082 677707 680121 680192 684029 684567 686214 692812 693056 693194 695262 697266 699694 703039 703096 705540 707315 707333 708110 712886 717523 717798 717828 717873 717897 720241 720264 722384 727751 729819 734514 736798 743782 746991 748257 748538 752683 756407 765714 770124 770827 770884 775858 775862 775989 780655 786874 788790 790219 795593 801957 808112 811164 814270 815699 815875 816905 817288 817319 817346 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double penetration stockings"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double penetration чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double penetration чулк нижн бел"
]
|
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.