Query Metrics
7
Database Queries
7
Different statements
163.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.36 ms (84.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 168977 382363 383898 396282 399415 416161 416360 427869 429443 430801 430806 434667 437676 445573 448365 449657 450241 450383 454605 454741 454982 457194 460009 466820 471387 484543 489591 495886 502289 503010 511515 516662 521564 521778 525115 526215 529204 539398 546867 549689 550088 555889 559182 562497 562966 563924 569092 569471 571612 571793 572108 572310 572803 575111 584380 590286 591149 591819 592559 594312 595988 602052 605183 607530 608345 618547 619644 622057 623643 623814 629042 629288 632991 633034 636478 639221 651926 656418 661958 668493 671131 682270 694923 695791 696217 705371 710505 717199 726034 726514 726575 732607 742149 748446 749219 749254 759548 761291 761436 762902 772890 774817 775551 778364 781741 781999 786038 787178 787363 788697 789296 794362 794826 798686 807000 808056 809743 810804 815456 818651 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (9.00%) |
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 717199 591149 592559 623643 726575 726514 710505 466820 761291 495886 815456 539398 629288 775551 809743 732607 726034 383898 168977 563924 661958 555889 602052 632991 460009 427869 437676 489591 454605 396282 471387 516662 546867 590286 623814 772890 810804 749219 748446 787363 794826 416161 521564 595988 636478 511515 605183 749254 619644 629042 457194 607530 429443 450241 762902 454982 656418 594312 618547 445573 668493 705371 695791 694923 608345 633034 639221 788697 774817 807000 787178 789296 808056 399415 448365 502289 525115 550088 449657 450383 569471 572108 562497 591819 778364 786038 781741 781999 454741 503010 526215 529204 382363 671131 571612 572803 575111 696217 651926 798686 742149 759548 761436 434667 571793 569092 559182 572310 521778 549689 562966 416360 430801 430806 584380 682270 622057 794362 818651 484543 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.62%) |
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 168977 382363 383898 396282 399415 416161 416360 427869 429443 430801 430806 434667 437676 445573 448365 449657 450241 450383 454605 454741 454982 457194 460009 466820 471387 484543 489591 495886 502289 503010 511515 516662 521564 521778 525115 526215 529204 539398 546867 549689 550088 555889 559182 562497 562966 563924 569092 569471 571612 571793 572108 572310 572803 575111 584380 590286 591149 591819 592559 594312 595988 602052 605183 607530 608345 618547 619644 622057 623643 623814 629042 629288 632991 633034 636478 639221 651926 656418 661958 668493 671131 682270 694923 695791 696217 705371 710505 717199 726034 726514 726575 732607 742149 748446 749219 749254 759548 761291 761436 762902 772890 774817 775551 778364 781741 781999 786038 787178 787363 788697 789296 794362 794826 798686 807000 808056 809743 810804 815456 818651 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ out"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits out"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ out"
]
|
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.