Query Metrics
7
Database Queries
7
Different statements
264.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.84 ms (90.92%) |
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 91146 209931 335993 386965 389911 393462 393550 404051 413254 413453 423947 429482 450686 453124 453462 481165 492595 500472 501073 523778 525425 543185 547172 548760 550360 559960 561725 564420 571557 572424 572737 586473 586558 588646 589067 590724 602789 603546 610261 614520 614789 617631 619556 619752 621733 623209 623291 634804 649082 679397 680536 686093 693680 697010 700849 708955 717887 717889 718985 720234 720333 720384 720455 722688 726861 732406 736285 743100 746884 748671 752171 759938 760922 761342 761619 764666 770078 770348 770980 772522 772699 773444 775770 776878 779028 783322 784661 785119 785269 786182 786924 789806 790071 794987 796494 800206 800223 800252 801206 801873 801913 804092 805385 806026 809712 810270 810682 810690 812437 815452 815692 815808 815848 815933 817417 819773 824443 827932 827947 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (5.36%) |
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 761342 810270 91146 564420 717887 588646 586558 614520 525425 810690 824443 722688 720455 614789 776878 812437 786924 789806 801206 743100 764666 453462 543185 550360 717889 784661 800206 785269 790071 761619 770348 785119 796494 423947 603546 209931 386965 413453 815933 547172 686093 679397 680536 718985 720333 572424 800252 801913 794987 748671 805385 806026 752171 772699 726861 759938 760922 772522 708955 779028 783322 800223 393462 393550 815848 827932 548760 561725 720234 700849 693680 617631 736285 770980 773444 746884 602789 623209 559960 429482 572737 590724 619752 623291 492595 481165 571557 610261 589067 775770 786182 804092 770078 801873 500472 697010 523778 815692 453124 649082 720384 586473 621733 619556 634804 809712 732406 810682 413254 335993 389911 404051 815808 819773 815182 815452 817417 827947 450686 501073 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.15%) |
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 91146 209931 335993 386965 389911 393462 393550 404051 413254 413453 423947 429482 450686 453124 453462 481165 492595 500472 501073 523778 525425 543185 547172 548760 550360 559960 561725 564420 571557 572424 572737 586473 586558 588646 589067 590724 602789 603546 610261 614520 614789 617631 619556 619752 621733 623209 623291 634804 649082 679397 680536 686093 693680 697010 700849 708955 717887 717889 718985 720234 720333 720384 720455 722688 726861 732406 736285 743100 746884 748671 752171 759938 760922 761342 761619 764666 770078 770348 770980 772522 772699 773444 775770 776878 779028 783322 784661 785119 785269 786182 786924 789806 790071 794987 796494 800206 800223 800252 801206 801873 801913 804092 805385 806026 809712 810270 810682 810690 812437 815452 815692 815808 815848 815933 817417 819773 824443 827932 827947 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick pussy hard"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза pussy hard"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза pussy hard"
]
|
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.