Query Metrics
7
Database Queries
7
Different statements
181.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.14 ms (79.59%) |
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 413373 413826 415818 420299 422340 426295 434364 438748 444194 445175 448816 451261 452638 452823 452897 452953 461086 469023 469738 470458 471118 476705 479661 485283 487486 502043 506516 506692 508885 510905 512447 512975 513572 516884 527280 533013 534772 536783 546042 561479 566761 566855 569379 577905 582540 587451 587506 589229 597216 599976 601613 608574 614858 617410 622454 623262 629828 631641 632649 633123 633451 633502 633780 635234 636321 639716 639745 639798 640789 641972 642044 642775 644913 645238 645861 646776 649546 649596 666426 666853 666895 675008 675010 677784 683261 687313 696582 699397 702622 708195 718698 725792 730073 738472 738492 739158 745276 746882 750701 752647 752648 758330 765222 770155 777642 777935 780025 782894 783905 785816 787511 791179 803381 803455 808341 810463 813819 814437 814777 826610 ] |
||||||||||||||||||||||||||||||
|
26.65 ms (14.72%) |
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 696582 699397 649596 582540 599976 632649 633123 633451 601613 614858 487486 745276 770155 780025 512975 566761 426295 451261 506516 479661 718698 635234 702622 434364 444194 438748 803381 536783 677784 448816 569379 644913 452953 666895 649546 639798 639716 803455 413826 510905 445175 782894 420299 758330 587451 785816 791179 752647 739158 777642 813819 422340 413373 814777 546042 645238 646776 640789 636321 750701 642775 471118 470458 415818 461086 675010 645861 642044 639745 502043 516884 752648 485283 589229 512447 508885 527280 631641 452897 826610 476705 561479 622454 783905 808341 738472 738492 730073 746882 725792 810463 513572 765222 469023 469738 452638 566855 666853 683261 633780 617410 452823 587506 787511 534772 577905 687313 708195 608574 629828 777935 623262 533013 675008 597216 633502 666426 814437 506692 641972 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.73%) |
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 413373 413826 415818 420299 422340 426295 434364 438748 444194 445175 448816 451261 452638 452823 452897 452953 461086 469023 469738 470458 471118 476705 479661 485283 487486 502043 506516 506692 508885 510905 512447 512975 513572 516884 527280 533013 534772 536783 546042 561479 566761 566855 569379 577905 582540 587451 587506 589229 597216 599976 601613 608574 614858 617410 622454 623262 629828 631641 632649 633123 633451 633502 633780 635234 636321 639716 639745 639798 640789 641972 642044 642775 644913 645238 645861 646776 649546 649596 666426 666853 666895 675008 675010 677784 683261 687313 696582 699397 702622 708195 718698 725792 730073 738472 738492 739158 745276 746882 750701 752647 752648 758330 765222 770155 777642 777935 780025 782894 783905 785816 787511 791179 803381 803455 808341 810463 813819 814437 814777 826610 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм дилд"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt dildo"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.85%) |
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.