Query Metrics
7
Database Queries
7
Different statements
154.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.66 ms (85.81%) |
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 370949 417835 418996 427634 429492 431709 432778 437325 445767 449153 449719 449851 452696 452789 452796 454538 460033 460129 460458 465276 467077 469486 474886 481805 482305 483657 485432 492049 493214 502809 507225 507799 509082 513366 514765 515047 521160 525145 529249 534190 536353 539531 552758 555077 557049 557366 560989 562938 562957 563003 563098 563920 565709 567214 571044 573757 576127 584414 604313 605708 609584 610058 611264 612700 623147 623392 623396 637403 668786 672251 680852 682269 682363 700202 701167 701192 701215 703439 709204 710595 712641 713105 714553 717948 721580 723138 723975 723981 726598 726845 726873 731256 740162 742839 742986 743809 744240 749635 753510 760164 761102 767681 771489 780343 785180 788223 788374 793165 793526 794623 796098 802182 802274 811712 817492 819918 819919 823557 824505 827577 ] |
||||||||||||||||||||||||||||||
|
12.30 ms (7.96%) |
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 452789 460033 417835 623147 623396 485432 521160 726873 452796 493214 562957 802182 761102 744240 610058 760164 827577 793165 793526 753510 811712 721580 623392 370949 525145 563098 482305 483657 571044 563003 567214 449719 460458 584414 710595 605708 611264 785180 573757 604313 465276 726598 788223 431709 507225 452696 552758 529249 823557 612700 723981 731256 788374 726845 701192 474886 539531 557366 576127 680852 709204 712641 700202 701215 668786 796098 723975 713105 467077 432778 492049 555077 449851 429492 469486 563920 743809 802274 819919 418996 460129 437325 507799 513366 717948 560989 742839 565709 536353 682363 703439 672251 557049 819918 824505 714553 723138 794623 742986 767681 771489 749635 780343 562938 502809 427634 481805 515047 509082 701167 445767 534190 609584 514765 682269 637403 740162 817492 449153 454538 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.66%) |
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 370949 417835 418996 427634 429492 431709 432778 437325 445767 449153 449719 449851 452696 452789 452796 454538 460033 460129 460458 465276 467077 469486 474886 481805 482305 483657 485432 492049 493214 502809 507225 507799 509082 513366 514765 515047 521160 525145 529249 534190 536353 539531 552758 555077 557049 557366 560989 562938 562957 563003 563098 563920 565709 567214 571044 573757 576127 584414 604313 605708 609584 610058 611264 612700 623147 623392 623396 637403 668786 672251 680852 682269 682363 700202 701167 701192 701215 703439 709204 710595 712641 713105 714553 717948 721580 723138 723975 723981 726598 726845 726873 731256 740162 742839 742986 743809 744240 749635 753510 760164 761102 767681 771489 780343 785180 788223 788374 793165 793526 794623 796098 802182 802274 811712 817492 819918 819919 823557 824505 827577 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"спящие мамки домашнее…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ мам женщин домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.03%) |
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.