Query Metrics
7
Database Queries
7
Different statements
149.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.27 ms (83.88%) |
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 16946 33756 74239 102702 105317 132988 142823 151113 185589 365546 379619 382942 385737 386680 389195 391064 391427 397843 399627 402965 414618 415806 418773 419253 420749 423890 425358 425401 426456 426686 433867 435351 435413 438371 439578 441923 443506 444370 444586 445343 445484 445669 447297 447386 448346 449906 452364 452856 453034 455730 457253 461212 462039 463772 466193 466806 469688 469884 474039 476992 479042 479370 480968 481036 482806 482949 488191 488293 494886 494976 495234 504721 506259 507715 508253 514274 516791 520532 523169 525325 525349 525398 528048 538172 539790 546745 553621 556506 559837 563004 563994 566244 567856 570613 570622 572363 572513 577458 580088 584310 586121 600560 600833 622252 645194 650867 652617 660863 677088 707692 709482 754186 759884 760851 771544 803957 807953 808101 825898 825907 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (8.44%) |
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 397843 415806 418773 425401 469884 102702 386680 419253 425358 474039 481036 495234 504721 494886 482949 488293 33756 825898 389195 426456 426686 455730 523169 525398 525349 572513 707692 559837 600833 622252 807953 414618 439578 444586 438371 463772 506259 516791 525325 563994 760851 185589 142823 435413 385737 382942 151113 132988 379619 365546 74239 391427 444370 420749 435351 423890 445343 825907 482806 445669 447386 448346 469688 449906 480968 445484 452364 453034 457253 488191 520532 528048 539790 494976 507715 514274 538172 508253 466806 546745 572363 556506 567856 563004 566244 577458 584310 652617 645194 660863 677088 709482 650867 553621 570613 570622 580088 586121 600560 808101 759884 771544 754186 803957 462039 479042 105317 391064 433867 461212 466193 479370 16946 452856 399627 402965 441923 443506 447297 476992 ] |
||||||||||||||||||||||||||||||
|
5.03 ms (3.37%) |
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 16946 33756 74239 102702 105317 132988 142823 151113 185589 365546 379619 382942 385737 386680 389195 391064 391427 397843 399627 402965 414618 415806 418773 419253 420749 423890 425358 425401 426456 426686 433867 435351 435413 438371 439578 441923 443506 444370 444586 445343 445484 445669 447297 447386 448346 449906 452364 452856 453034 455730 457253 461212 462039 463772 466193 466806 469688 469884 474039 476992 479042 479370 480968 481036 482806 482949 488191 488293 494886 494976 495234 504721 506259 507715 508253 514274 516791 520532 523169 525325 525349 525398 528048 538172 539790 546745 553621 556506 559837 563004 563994 566244 567856 570613 570622 572363 572513 577458 580088 584310 586121 600560 600833 622252 645194 650867 652617 660863 677088 707692 709482 754186 759884 760851 771544 803957 807953 808101 825898 825907 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно позы"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн поз"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.98%) |
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.