Query Metrics
7
Database Queries
7
Different statements
208.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.31 ms (87.10%) |
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 182110 268873 290847 395479 424721 432299 450257 452640 452963 452964 455500 456230 458007 460908 465323 465562 465579 466374 466427 466995 467029 468518 471113 472698 473426 473496 475676 475683 476176 480676 499551 504509 512503 513972 516120 517441 517490 517536 517807 519359 524616 529583 529957 531822 531856 532460 536462 545901 545964 545968 545989 547462 547478 550916 554489 555007 555119 556586 556767 558172 559377 561021 583085 590487 591997 599354 601854 602165 603358 605026 605073 605096 605133 605219 607716 609164 622385 628617 629799 630078 633204 660054 661008 665975 666139 678794 681746 713247 713501 713507 736039 741687 745462 747098 748653 749129 758155 758771 758803 765657 788344 796486 797336 800697 800767 802899 803441 804802 808151 811679 816169 816170 817980 819245 819964 823582 825329 827284 827633 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (8.12%) |
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 601854 796486 748653 749129 745462 736039 605073 395479 465579 268873 529957 556767 660054 591997 465323 450257 455500 517536 529583 531822 531856 532460 517441 466427 550916 666139 713247 681746 713501 713507 545901 800697 800767 804802 797336 811679 758155 765657 803441 468518 290847 424721 465562 473426 456230 516120 517490 536462 472698 475676 545964 547478 554489 556586 547462 555007 555119 559377 678794 661008 665975 545968 545989 599354 605133 605219 590487 603358 622385 633204 628617 629799 630078 605026 607716 788344 758771 758803 787989 802899 741687 747098 602165 808151 452963 476176 460908 466995 471113 480676 499551 504509 519359 524616 432299 452640 512503 513972 475683 558172 583085 561021 609164 605096 458007 467029 452964 466374 517807 473496 182110 816169 819964 825329 827284 816170 817980 819245 823582 827633 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.54%) |
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 182110 268873 290847 395479 424721 432299 450257 452640 452963 452964 455500 456230 458007 460908 465323 465562 465579 466374 466427 466995 467029 468518 471113 472698 473426 473496 475676 475683 476176 480676 499551 504509 512503 513972 516120 517441 517490 517536 517807 519359 524616 529583 529957 531822 531856 532460 536462 545901 545964 545968 545989 547462 547478 550916 554489 555007 555119 556586 556767 558172 559377 561021 583085 590487 591997 599354 601854 602165 603358 605026 605073 605096 605133 605219 607716 609164 622385 628617 629799 630078 633204 660054 661008 665975 666139 678794 681746 713247 713501 713507 736039 741687 745462 747098 748653 749129 758155 758771 758803 765657 788344 796486 797336 800697 800767 802899 803441 804802 808151 811679 816169 816170 817980 819245 819964 823582 825329 827284 827633 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo mature ass"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.