Query Metrics
7
Database Queries
7
Different statements
167.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.15 ms (87.11%) |
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 12731 58201 73421 191495 354774 385181 391032 391342 393849 401121 403074 403288 411196 414434 415551 423646 425379 426769 427213 435614 440393 445713 446993 477158 479969 485294 486327 486772 487329 489172 498171 499457 501449 505706 507853 513024 517996 521969 525402 527529 529884 532356 537876 541123 546603 548680 550593 556402 560914 568021 582448 583467 585584 589057 599142 605292 618802 619774 620614 621958 624922 625985 626688 627335 629179 629837 630726 639040 641250 641407 642045 644688 651998 652567 654092 661928 662797 666046 670546 681746 683270 685892 687108 690946 691155 692188 692224 692296 694219 695186 702192 703310 704025 708643 716101 716977 726904 727707 731086 731382 741904 742421 765099 765355 770400 779659 780790 783430 787534 788311 792441 794163 795332 803807 803915 811468 811751 812879 823097 826503 ] |
||||||||||||||||||||||||||||||
|
11.68 ms (6.96%) |
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 627335 507853 583467 498171 446993 485294 487329 521969 12731 479969 582448 651998 702192 654092 661928 662797 716101 621958 626688 629179 787534 765099 803915 391032 703310 426769 687108 630726 560914 599142 191495 513024 499457 692224 385181 403074 652567 704025 794163 731086 716977 423646 550593 505706 618802 445713 435614 826503 537876 624922 589057 642045 788311 726904 731382 391342 403288 58201 414434 568021 681746 694219 741904 795332 803807 393849 556402 605292 811751 486772 670546 683270 666046 644688 625985 620614 641250 779659 765355 770400 489172 527529 440393 690946 691155 811468 354774 708643 525402 641407 727707 425379 411196 823097 529884 532356 517996 541123 692296 685892 619774 629837 783430 780790 792441 742421 812879 401121 548680 639040 427213 415551 477158 73421 546603 695186 692188 486327 585584 501449 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.96%) |
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 12731 58201 73421 191495 354774 385181 391032 391342 393849 401121 403074 403288 411196 414434 415551 423646 425379 426769 427213 435614 440393 445713 446993 477158 479969 485294 486327 486772 487329 489172 498171 499457 501449 505706 507853 513024 517996 521969 525402 527529 529884 532356 537876 541123 546603 548680 550593 556402 560914 568021 582448 583467 585584 589057 599142 605292 618802 619774 620614 621958 624922 625985 626688 627335 629179 629837 630726 639040 641250 641407 642045 644688 651998 652567 654092 661928 662797 666046 670546 681746 683270 685892 687108 690946 691155 692188 692224 692296 694219 695186 702192 703310 704025 708643 716101 716977 726904 727707 731086 731382 741904 742421 765099 765355 770400 779659 780790 783430 787534 788311 792441 794163 795332 803807 803915 811468 811751 812879 823097 826503 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video секс вагин"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video секс вагин"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video sex vagina"
]
|
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.