Query Metrics
7
Database Queries
7
Different statements
195.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.64 ms (87.30%) |
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 395381 395864 396050 396083 396743 397290 410636 414082 431446 448322 540056 545712 549051 556346 564344 576524 597798 598135 599530 600146 600537 603052 604140 604215 604309 604371 608233 612666 617681 621451 624170 631116 636238 652206 655281 661455 662024 662194 663247 665712 671252 671633 671670 673776 677181 685449 685491 692045 698013 699589 702163 702629 702636 705239 709738 715808 716559 718681 722565 722649 724050 724773 725111 725609 731213 731893 734973 735462 736558 737324 739007 740675 741529 742928 742942 743137 744976 747154 747324 747393 747498 747956 748701 752735 753469 753478 754180 755634 758523 758989 761430 764813 765593 766798 766801 766811 766817 767090 768041 769868 770419 773642 777124 777652 783194 785324 785579 789871 795490 804327 804871 805550 810125 811629 818753 820899 821098 823235 825536 827250 ] |
||||||||||||||||||||||||||||||
|
13.66 ms (6.99%) |
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 661455 662194 663247 665712 671252 692045 705239 716559 718681 652206 655281 671633 671670 677181 685449 685491 698013 709738 722565 722649 576524 597798 603052 604371 608233 631116 600146 600537 636238 598135 599530 604140 621451 624170 785579 805550 811629 725111 725609 740675 742928 753469 754180 755634 758989 766798 783194 804871 810125 724773 741529 747956 753478 758523 766801 769868 734973 735462 744976 747154 748701 768041 739007 742942 752735 764813 765593 766811 766817 743137 747324 747393 747498 767090 770419 773642 702629 702636 715808 777124 777652 789871 795490 804327 397290 448322 396743 396083 702163 431446 395381 395864 545712 604215 617681 724050 731893 410636 414082 818753 827250 825536 820899 821098 823235 540056 549051 564344 556346 662024 673776 699589 604309 612666 785324 737324 761430 736558 731213 396050 ] |
||||||||||||||||||||||||||||||
|
4.14 ms (2.12%) |
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 395381 395864 396050 396083 396743 397290 410636 414082 431446 448322 540056 545712 549051 556346 564344 576524 597798 598135 599530 600146 600537 603052 604140 604215 604309 604371 608233 612666 617681 621451 624170 631116 636238 652206 655281 661455 662024 662194 663247 665712 671252 671633 671670 673776 677181 685449 685491 692045 698013 699589 702163 702629 702636 705239 709738 715808 716559 718681 722565 722649 724050 724773 725111 725609 731213 731893 734973 735462 736558 737324 739007 740675 741529 742928 742942 743137 744976 747154 747324 747393 747498 747956 748701 752735 753469 753478 754180 755634 758523 758989 761430 764813 765593 766798 766801 766811 766817 767090 768041 769868 770419 773642 777124 777652 783194 785324 785579 789871 795490 804327 804871 805550 810125 811629 818753 820899 821098 823235 825536 827250 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teens анал"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teens anal"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teens анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.81%) |
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.