Query Metrics
7
Database Queries
7
Different statements
180.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.68 ms (86.23%) |
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 80536 185435 382297 382957 386178 386357 390723 391025 394240 394738 398872 404304 405088 407141 411555 416144 417416 418397 418740 418922 420111 421235 428961 430618 430650 441804 447004 447493 453555 456792 456982 469531 473079 474050 476812 489587 494771 499444 501760 505042 510362 513072 521888 524380 526824 528066 531903 551283 551293 551298 551352 551359 551407 552127 554764 568081 569822 569867 576280 592065 592369 595519 596618 597540 598007 598059 598087 598774 600403 600602 602725 610183 613850 624722 626891 628343 628758 634756 641097 643424 643886 643895 644675 648876 653254 654152 654390 658706 659905 660522 663371 663469 665645 669110 682268 682493 683563 697178 701390 701469 702546 720458 722098 722820 722889 739300 744580 744730 744966 749623 756679 770096 772511 782008 785419 792591 799635 799778 811809 813478 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (8.46%) |
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 643424 469531 394240 382297 744966 398872 416144 600602 799635 447493 418922 513072 576280 551298 569822 551283 596618 597540 598007 524380 701390 551407 669110 811809 744730 665645 430618 744580 80536 682268 382957 456792 407141 663371 663469 720458 722098 785419 813478 644675 391025 404304 551293 473079 447004 441804 722889 641097 569867 598087 610183 501760 598059 505042 386178 456982 682493 628343 628758 499444 624722 658706 683563 654152 660522 799778 643886 421235 453555 476812 701469 697178 749623 770096 792591 722820 411555 526824 568081 390723 494771 592065 417416 510362 405088 551352 659905 648876 643895 428961 386357 418740 702546 185435 418397 474050 394738 634756 602725 554764 598774 613850 626891 592369 595519 782008 420111 521888 528066 653254 430650 551359 531903 552127 600403 756679 654390 772511 739300 489587 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.52%) |
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 80536 185435 382297 382957 386178 386357 390723 391025 394240 394738 398872 404304 405088 407141 411555 416144 417416 418397 418740 418922 420111 421235 428961 430618 430650 441804 447004 447493 453555 456792 456982 469531 473079 474050 476812 489587 494771 499444 501760 505042 510362 513072 521888 524380 526824 528066 531903 551283 551293 551298 551352 551359 551407 552127 554764 568081 569822 569867 576280 592065 592369 595519 596618 597540 598007 598059 598087 598774 600403 600602 602725 610183 613850 624722 626891 628343 628758 634756 641097 643424 643886 643895 644675 648876 653254 654152 654390 658706 659905 660522 663371 663469 665645 669110 682268 682493 683563 697178 701390 701469 702546 720458 722098 722820 722889 739300 744580 744730 744966 749623 756679 770096 772511 782008 785419 792591 799635 799778 811809 813478 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage girl 18"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж девушк 18"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж девушк 18"
]
|
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.