Query Metrics
7
Database Queries
7
Different statements
186.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.86 ms (87.73%) |
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 401101 424125 425990 426529 426552 426988 433066 433291 433350 442107 443896 446500 450854 453265 453377 455407 456603 457441 460305 464132 464484 464705 464884 470459 475489 482549 484633 486046 486610 486903 492714 493426 496975 501733 511015 513687 513971 515018 516328 517528 519766 522041 527986 535638 536956 537464 546638 549108 555114 555124 555233 556806 557240 560666 562964 563175 566854 573388 579586 580628 580750 584034 586293 586376 591968 602959 604138 604658 623211 680328 698733 708865 719968 731126 737561 758075 760953 762915 765359 765493 765835 767061 767078 767135 767701 770331 770417 777359 778949 784225 787013 787155 788011 791270 796048 796527 800429 800600 803347 804927 805434 805557 810305 813422 813627 814359 814386 814417 815022 815118 815121 815366 816596 817255 817283 817785 818948 820550 820656 823510 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (7.28%) |
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 796048 719968 767061 464705 814417 511015 537464 549108 708865 584034 604658 787155 778949 791270 765493 424125 820656 813627 817283 817785 820550 815022 815118 817255 815366 816596 818948 522041 535638 698733 546638 777359 784225 803347 767135 787013 788011 800600 810305 760953 765835 770417 758075 762915 765359 767078 770331 426988 731126 426529 555124 486903 516328 517528 527986 555233 556806 562964 580750 602959 433291 464484 433350 456603 464132 496975 484633 623211 815121 591968 805557 804927 513971 426552 455407 453265 425990 482549 501733 515018 555114 563175 566854 579586 560666 573388 586293 470459 457441 493426 513687 492714 433066 475489 464884 401101 486610 443896 442107 814359 814386 823510 446500 450854 486046 453377 519766 536956 460305 580628 557240 680328 586376 604138 805434 813422 737561 767701 796527 800429 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.50%) |
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 401101 424125 425990 426529 426552 426988 433066 433291 433350 442107 443896 446500 450854 453265 453377 455407 456603 457441 460305 464132 464484 464705 464884 470459 475489 482549 484633 486046 486610 486903 492714 493426 496975 501733 511015 513687 513971 515018 516328 517528 519766 522041 527986 535638 536956 537464 546638 549108 555114 555124 555233 556806 557240 560666 562964 563175 566854 573388 579586 580628 580750 584034 586293 586376 591968 602959 604138 604658 623211 680328 698733 708865 719968 731126 737561 758075 760953 762915 765359 765493 765835 767061 767078 767135 767701 770331 770417 777359 778949 784225 787013 787155 788011 791270 796048 796527 800429 800600 803347 804927 805434 805557 810305 813422 813627 814359 814386 814417 815022 815118 815121 815366 816596 817255 817283 817785 818948 820550 820656 823510 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal pov"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал пов"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал пов"
]
|
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.