Query Metrics
7
Database Queries
7
Different statements
187.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.53 ms (87.81%) |
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 384588 401388 401688 410356 410786 414734 415101 417947 418259 418554 420898 423516 437441 442587 444848 445752 446049 449105 449260 449280 449312 449313 451770 452454 458870 464190 469716 469720 471427 471672 474428 476787 480019 481961 482639 489324 490509 505336 507975 510362 511143 516353 519744 520481 522162 523717 524839 525297 526313 553441 554861 560967 567565 570994 571769 576357 577614 589583 589701 601223 603294 604226 608670 613038 617047 618302 620174 624128 626245 639184 648444 660434 660572 685843 687844 689981 690066 694407 708399 709542 727844 727882 732991 733910 735772 739496 740556 741160 748624 749929 752000 757435 761273 762812 763966 764153 764160 765518 766342 767786 769839 776327 777838 784110 784357 784735 787532 787774 789771 792215 795419 796194 796939 801580 802908 803549 810076 811571 813189 824868 ] |
||||||||||||||||||||||||||||||
|
12.97 ms (6.92%) |
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 764153 767786 733910 757435 813189 617047 801580 414734 511143 449313 469720 577614 567565 787774 784110 766342 639184 445752 452454 523717 516353 482639 474428 648444 687844 589583 740556 769839 776327 401388 708399 660572 689981 752000 784357 741160 763966 444848 446049 505336 608670 449260 481961 520481 620174 401688 423516 449280 449312 489324 451770 553441 576357 690066 571769 626245 589701 603294 601223 811571 802908 739496 796939 410786 437441 464190 449105 418259 471672 524839 490509 526313 442587 480019 469716 507975 660434 613038 618302 604226 787532 789771 727882 748624 417947 471427 458870 476787 519744 510362 525297 554861 570994 418554 420898 384588 410356 694407 777838 784735 765518 732991 415101 522162 824868 709542 685843 560967 624128 792215 795419 803549 727844 749929 764160 796194 810076 761273 762812 735772 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.39%) |
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 384588 401388 401688 410356 410786 414734 415101 417947 418259 418554 420898 423516 437441 442587 444848 445752 446049 449105 449260 449280 449312 449313 451770 452454 458870 464190 469716 469720 471427 471672 474428 476787 480019 481961 482639 489324 490509 505336 507975 510362 511143 516353 519744 520481 522162 523717 524839 525297 526313 553441 554861 560967 567565 570994 571769 576357 577614 589583 589701 601223 603294 604226 608670 613038 617047 618302 620174 624128 626245 639184 648444 660434 660572 685843 687844 689981 690066 694407 708399 709542 727844 727882 732991 733910 735772 739496 740556 741160 748624 749929 752000 757435 761273 762812 763966 764153 764160 765518 766342 767786 769839 776327 777838 784110 784357 784735 787532 787774 789771 792215 795419 796194 796939 801580 802908 803549 810076 811571 813189 824868 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин секс orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina sex orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин секс orgasm"
]
|
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.