Query Metrics
7
Database Queries
7
Different statements
162.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.40 ms (84.00%) |
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 16882 88182 89346 154162 154187 154573 154576 155257 182735 340567 382410 382476 382510 382993 383869 385618 388803 390286 391916 392421 392427 398101 401816 402632 413006 414094 414124 415324 416157 416164 416539 416631 416695 416704 418022 423781 423784 432824 432944 432945 445727 445950 449916 471676 473448 483749 491173 494532 497471 497830 500333 505137 510746 511866 512072 514085 514848 516619 521139 529741 531353 532882 532890 537141 539470 539639 545462 547502 548448 554954 559782 567120 567122 568498 568501 575171 577038 577307 582076 587291 587559 596989 599477 604105 615950 621496 627224 641982 644335 662049 666855 684500 688181 689775 696591 712496 717520 717542 720101 722381 745083 745201 745931 752675 752686 752755 756771 757494 760548 760594 782517 788354 788594 788598 792697 792730 796716 797001 809000 811733 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (9.77%) |
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 745931 604105 792697 577038 390286 340567 392421 89346 398101 449916 497830 539639 514085 505137 415324 559782 797001 391916 497471 494532 473448 554954 382993 383869 445727 529741 531353 537141 548448 696591 615950 788598 182735 416695 471676 416539 567122 154162 575171 666855 720101 684500 792730 382510 382410 154573 418022 532882 532890 510746 545462 582076 712496 644335 760548 796716 745201 757494 756771 760594 414094 432944 432945 512072 500333 567120 587291 596989 432824 423784 416631 445950 88182 392427 568501 539470 514848 568498 547502 621496 599477 155257 385618 414124 401816 416704 388803 16882 483749 577307 587559 641982 788354 788594 627224 811733 154187 809000 416164 416157 516619 402632 382476 423781 491173 511866 521139 662049 688181 717542 689775 717520 722381 782517 752675 752686 752755 745083 154576 413006 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.74%) |
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 16882 88182 89346 154162 154187 154573 154576 155257 182735 340567 382410 382476 382510 382993 383869 385618 388803 390286 391916 392421 392427 398101 401816 402632 413006 414094 414124 415324 416157 416164 416539 416631 416695 416704 418022 423781 423784 432824 432944 432945 445727 445950 449916 471676 473448 483749 491173 494532 497471 497830 500333 505137 510746 511866 512072 514085 514848 516619 521139 529741 531353 532882 532890 537141 539470 539639 545462 547502 548448 554954 559782 567120 567122 568498 568501 575171 577038 577307 582076 587291 587559 596989 599477 604105 615950 621496 627224 641982 644335 662049 666855 684500 688181 689775 696591 712496 717520 717542 720101 722381 745083 745201 745931 752675 752686 752755 756771 757494 760548 760594 782517 788354 788594 788598 792697 792730 796716 797001 809000 811733 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl dildo"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.03%) |
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.