Query Metrics
7
Database Queries
7
Different statements
189.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.01 ms (83.71%) |
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 16971 387905 401351 410254 412132 414313 415746 418427 420541 420891 421890 424648 424695 434000 442281 443591 443658 443767 446505 454277 460282 460731 460733 460734 460739 462279 462315 462700 464542 464743 466069 466074 466090 466094 466097 466112 466223 466321 469919 470019 470028 470487 470512 470596 470749 470941 472328 474631 474650 474817 475115 475439 476251 476261 476797 477079 479049 479108 482824 483627 484383 484469 484472 484656 484661 484669 484693 484696 484706 484711 484722 484748 484750 485703 485940 487550 490201 496397 500691 502310 503875 506053 507813 511023 512384 514692 514808 515361 516121 516634 520826 521852 522525 523335 523686 524141 525238 525871 526568 527608 528146 530726 530884 538832 542748 542794 543407 546774 556420 575509 590693 614262 653876 688324 724425 726487 726543 817070 823585 823613 ] |
||||||||||||||||||||||||||||||
|
21.19 ms (11.15%) |
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 420541 546774 421890 490201 500691 496397 575509 542748 653876 590693 724425 464743 470019 479108 424695 466223 469919 475115 515361 525238 526568 410254 511023 527608 470596 475439 484693 446505 507813 530726 462315 470028 414313 462279 460739 462700 472328 466069 466094 466097 466112 466321 484656 484706 484748 484750 514808 521852 460733 401351 614262 443658 412132 516634 538832 542794 688324 556420 726543 443767 476251 415746 466074 470512 474650 479049 424648 443591 470941 460731 503875 514692 484469 506053 484472 484711 485940 484669 474817 543407 523686 823585 487550 464542 477079 476797 466090 470487 485703 512384 524141 484696 523335 387905 418427 434000 420891 474631 454277 470749 502310 520826 528146 530884 460282 726487 476261 460734 16971 442281 516121 525871 484722 522525 482824 484383 484661 817070 823613 483627 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.54%) |
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 16971 387905 401351 410254 412132 414313 415746 418427 420541 420891 421890 424648 424695 434000 442281 443591 443658 443767 446505 454277 460282 460731 460733 460734 460739 462279 462315 462700 464542 464743 466069 466074 466090 466094 466097 466112 466223 466321 469919 470019 470028 470487 470512 470596 470749 470941 472328 474631 474650 474817 475115 475439 476251 476261 476797 477079 479049 479108 482824 483627 484383 484469 484472 484656 484661 484669 484693 484696 484706 484711 484722 484748 484750 485703 485940 487550 490201 496397 500691 502310 503875 506053 507813 511023 512384 514692 514808 515361 516121 516634 520826 521852 522525 523335 523686 524141 525238 525871 526568 527608 528146 530726 530884 538832 542748 542794 543407 546774 556420 575509 590693 614262 653876 688324 724425 726487 726543 817070 823585 823613 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swinger young boy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"свингер young парен"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер young парен"
]
|
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.