Query Metrics
7
Database Queries
7
Different statements
183.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.89 ms (82.31%) |
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 61399 89135 154451 154535 154844 154972 155198 256821 311892 340567 340635 352189 369221 382404 382578 383514 383924 385390 387941 388110 388642 388729 389602 390150 391915 391961 411454 413006 414077 414268 419604 421967 425948 432674 439031 443340 444052 444537 445727 454688 467557 469691 471127 476651 476656 480671 487008 492000 492906 495827 505093 506105 509168 512442 514847 525279 535159 535363 536182 541484 542614 551646 552704 554405 576848 589549 590129 592745 602203 605566 608076 608516 623300 624399 626492 638744 655598 660043 660380 680562 688166 691259 697958 706359 706717 707432 709674 739125 739131 739799 747308 750423 750568 752799 754532 755422 760097 769125 774179 777670 780303 781251 782079 782321 783008 783034 785877 786416 791020 791026 793136 796647 796650 796696 799896 801627 807582 808580 808968 811048 ] |
||||||||||||||||||||||||||||||
|
22.25 ms (12.14%) |
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 383514 777670 774179 590129 369221 760097 781251 747308 807582 154844 754532 89135 796647 61399 421967 811048 752799 389602 154451 793136 688166 154972 340635 439031 382578 476651 769125 552704 413006 506105 589549 785877 554405 382404 480671 388110 783034 750423 311892 445727 387941 706717 444537 154535 492906 592745 791020 419604 155198 425948 388729 411454 691259 626492 608516 791026 432674 443340 352189 608076 492000 414268 680562 796696 808580 385390 623300 469691 514847 660380 602203 340567 390150 535363 780303 525279 541484 476656 750568 624399 796650 414077 391915 706359 256821 801627 799896 808968 505093 388642 551646 454688 391961 383924 536182 739131 576848 755422 605566 487008 655598 660043 697958 782321 512442 444052 495827 542614 739799 471127 467557 709674 638744 739125 707432 535159 786416 782079 783008 509168 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.37%) |
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 61399 89135 154451 154535 154844 154972 155198 256821 311892 340567 340635 352189 369221 382404 382578 383514 383924 385390 387941 388110 388642 388729 389602 390150 391915 391961 411454 413006 414077 414268 419604 421967 425948 432674 439031 443340 444052 444537 445727 454688 467557 469691 471127 476651 476656 480671 487008 492000 492906 495827 505093 506105 509168 512442 514847 525279 535159 535363 536182 541484 542614 551646 552704 554405 576848 589549 590129 592745 602203 605566 608076 608516 623300 624399 626492 638744 655598 660043 660380 680562 688166 691259 697958 706359 706717 707432 709674 739125 739131 739799 747308 750423 750568 752799 754532 755422 760097 769125 774179 777670 780303 781251 782079 782321 783008 783034 785877 786416 791020 791026 793136 796647 796650 796696 799896 801627 807582 808580 808968 811048 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"девушки в чулках дилд%…"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк чулк нижн бел дилд"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.