Query Metrics
7
Database Queries
7
Different statements
185.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.23 ms (89.38%) |
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 382073 388393 389897 396069 406836 413716 421290 435047 441615 450331 454514 456005 460017 462843 463517 463733 465969 466035 466704 469428 471712 472083 488594 489266 491631 494250 496587 496895 497687 507379 508687 508894 510331 511080 513658 514249 515289 516373 517660 517763 522223 524935 534170 546652 547768 547769 547799 547804 552382 554772 554864 576474 584126 594038 596263 597899 600958 608827 620880 626217 628901 633983 638413 642462 654084 662438 663088 663538 666493 670336 673116 677237 677240 680754 683073 693313 700919 701404 704280 706422 707394 709355 720622 729382 739769 739827 739903 742641 743947 744919 745942 748623 751050 754086 756307 757020 758070 761922 764507 769209 770679 772360 773253 775448 777784 785087 786912 787002 791132 791395 794769 796270 799153 801669 807271 810440 811215 811537 811961 813418 ] |
||||||||||||||||||||||||||||||
|
10.94 ms (5.88%) |
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 706422 693313 775448 811537 791395 739903 754086 796270 799153 388393 396069 466035 663088 700919 620880 786912 801669 729382 794769 748623 743947 739827 761922 707394 709355 469428 534170 494250 515289 489266 496895 638413 406836 450331 547799 628901 513658 680754 777784 811215 773253 744919 770679 704280 807271 811961 466704 465969 626217 633983 454514 510331 508894 496587 460017 552382 654084 663538 677237 642462 751050 785087 742641 756307 472083 471712 511080 522223 517763 382073 389897 421290 547768 517660 666493 584126 594038 514249 683073 456005 463517 597899 608827 508687 547769 554772 673116 720622 596263 600958 810440 757020 769209 745942 739769 758070 764507 787002 791132 813418 441615 497687 516373 488594 547804 576474 546652 662438 772360 462843 435047 524935 491631 413716 463733 507379 554864 670336 677240 701404 ] |
||||||||||||||||||||||||||||||
|
2.58 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 382073 388393 389897 396069 406836 413716 421290 435047 441615 450331 454514 456005 460017 462843 463517 463733 465969 466035 466704 469428 471712 472083 488594 489266 491631 494250 496587 496895 497687 507379 508687 508894 510331 511080 513658 514249 515289 516373 517660 517763 522223 524935 534170 546652 547768 547769 547799 547804 552382 554772 554864 576474 584126 594038 596263 597899 600958 608827 620880 626217 628901 633983 638413 642462 654084 662438 663088 663538 666493 670336 673116 677237 677240 680754 683073 693313 700919 701404 704280 706422 707394 709355 720622 729382 739769 739827 739903 742641 743947 744919 745942 748623 751050 754086 756307 757020 758070 761922 764507 769209 770679 772360 773253 775448 777784 785087 786912 787002 791132 791395 794769 796270 799153 801669 807271 810440 811215 811537 811961 813418 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"розовый киски"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"розов вагин"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.75%) |
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.