Query Metrics
7
Database Queries
7
Different statements
180.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.84 ms (85.32%) |
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 251476 383051 386060 388482 388838 393737 393779 394233 400435 400443 400452 400457 400458 400471 400903 401958 402081 402094 403210 413208 413228 418484 418645 429234 429342 430275 443381 453668 455180 456656 458039 459811 466154 467169 470844 470855 470926 473928 481154 488003 494356 501461 515135 515136 515143 515195 515215 519973 520300 522566 525671 538868 545522 545526 545528 545529 548092 549575 565107 566514 566521 568575 569661 569672 569678 569684 569784 570052 570059 570062 570064 570068 570069 570071 590250 605610 607173 609929 624858 663947 664288 665134 665399 667323 676942 681187 684582 684589 684594 687929 693073 693075 700945 701007 704533 708804 708807 709578 720439 722670 722916 731982 740610 741639 743123 744309 746478 747861 747875 748561 759649 765442 765445 765446 766578 780713 783780 789077 789212 812143 ] |
||||||||||||||||||||||||||||||
|
16.52 ms (9.16%) |
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 402094 394233 709578 609929 388482 393779 569784 570059 566521 693075 570062 458039 466154 413228 740610 467169 515195 570071 569684 624858 722916 522566 473928 607173 667323 676942 590250 789212 812143 402081 684594 708807 481154 605610 386060 456656 687929 693073 470844 515143 455180 383051 765442 731982 569661 488003 520300 388838 400452 400458 459811 545529 665399 700945 780713 400903 393737 746478 708804 743123 747875 747861 701007 429234 570064 684589 570068 251476 538868 665134 681187 722670 766578 568575 418484 549575 569672 430275 519973 789077 400435 400443 413208 545526 418645 494356 565107 501461 748561 765445 741639 765446 569678 525671 684582 759649 744309 545522 548092 429342 545528 570052 443381 664288 704533 400457 470926 783780 720439 663947 515136 515135 401958 400471 403210 453668 470855 515215 566514 570069 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.77%) |
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 251476 383051 386060 388482 388838 393737 393779 394233 400435 400443 400452 400457 400458 400471 400903 401958 402081 402094 403210 413208 413228 418484 418645 429234 429342 430275 443381 453668 455180 456656 458039 459811 466154 467169 470844 470855 470926 473928 481154 488003 494356 501461 515135 515136 515143 515195 515215 519973 520300 522566 525671 538868 545522 545526 545528 545529 548092 549575 565107 566514 566521 568575 569661 569672 569678 569684 569784 570052 570059 570062 570064 570068 570069 570071 590250 605610 607173 609929 624858 663947 664288 665134 665399 667323 676942 681187 684582 684589 684594 687929 693073 693075 700945 701007 704533 708804 708807 709578 720439 722670 722916 731982 740610 741639 743123 744309 746478 747861 747875 748561 759649 765442 765445 765446 766578 780713 783780 789077 789212 812143 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man tits"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин сиськ"
]
|
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.