Query Metrics
7
Database Queries
7
Different statements
137.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.52 ms (82.29%) |
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 21140 118098 168687 184062 324579 327121 345780 382948 383923 384058 386050 386257 386738 386749 389067 390288 391048 396337 397161 397867 398461 404841 405990 406334 407382 409941 412969 414865 420069 420218 422587 422709 422712 422901 423027 423266 424551 425027 425422 425786 427299 427851 428293 428309 428451 428458 429386 429628 429633 429723 435443 445971 453370 457100 457117 457263 457502 464922 467744 472488 486018 492622 495866 499498 502530 505005 507609 507832 510571 510576 510582 512208 515891 516826 519903 519904 519905 519908 519909 519914 522977 533124 542567 543812 543874 550724 550755 550774 551982 552004 552029 552054 554425 556415 558425 565471 565978 580296 583255 583937 586619 587311 591637 593023 604429 610247 613174 619472 622623 623616 623622 623644 623817 623818 623820 633165 663537 666722 747964 807688 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (10.94%) |
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 467744 422587 428458 519904 519905 495866 422712 424551 423027 558425 429628 427851 435443 464922 505005 516826 543812 807688 457117 502530 550774 551982 565978 550755 623820 510571 425027 519914 623817 420069 428451 445971 610247 429386 427299 556415 472488 414865 510576 519903 542567 428309 429633 499498 515891 519909 565471 623622 345780 519908 583255 586619 429723 457100 633165 512208 580296 552029 554425 623818 425786 390288 457502 587311 552054 543874 623616 428293 663537 623644 486018 453370 510582 666722 591637 412969 398461 613174 507609 522977 552004 604429 397867 492622 386738 457263 507832 405990 533124 423266 422709 422901 420218 168687 324579 389067 391048 747964 583937 593023 397161 407382 619472 386749 425422 386050 404841 384058 396337 386257 409941 118098 327121 184062 622623 382948 383923 406334 550724 21140 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.69%) |
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 21140 118098 168687 184062 324579 327121 345780 382948 383923 384058 386050 386257 386738 386749 389067 390288 391048 396337 397161 397867 398461 404841 405990 406334 407382 409941 412969 414865 420069 420218 422587 422709 422712 422901 423027 423266 424551 425027 425422 425786 427299 427851 428293 428309 428451 428458 429386 429628 429633 429723 435443 445971 453370 457100 457117 457263 457502 464922 467744 472488 486018 492622 495866 499498 502530 505005 507609 507832 510571 510576 510582 512208 515891 516826 519903 519904 519905 519908 519909 519914 522977 533124 542567 543812 543874 550724 550755 550774 551982 552004 552029 552054 554425 556415 558425 565471 565978 580296 583255 583937 586619 587311 591637 593023 604429 610247 613174 619472 622623 623616 623622 623644 623817 623818 623820 633165 663537 666722 747964 807688 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian hairy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.20%) |
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.