Query Metrics
7
Database Queries
7
Different statements
162.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.67 ms (81.84%) |
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 390212 409021 411841 413895 414643 421814 421853 421873 422147 422194 426616 429416 432852 434254 435747 443890 455322 458438 460704 461402 485061 519013 519465 519958 527850 529699 562791 564399 564731 569146 569217 576520 580319 585989 587158 592907 606633 615561 641538 641686 641886 673772 687363 691228 708960 714062 742547 751560 756115 764151 765721 765817 771974 772535 774690 777003 777750 777794 778941 782508 783205 783392 783777 784754 784821 786129 786195 788942 789253 792135 792936 793206 794375 795142 795143 800880 801562 805497 807133 807353 807394 811029 811365 811500 812722 812979 814218 814226 814288 814335 814629 814630 814648 815080 815081 815087 815111 815115 815117 815119 815128 815140 815365 815480 815616 817422 820417 820423 820542 820586 820641 820956 821422 821577 821734 822131 822424 822623 823672 825762 ] |
||||||||||||||||||||||||||||||
|
14.17 ms (8.74%) |
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 815480 820586 815140 529699 786195 807394 812722 485061 811365 815115 691228 527850 814226 814630 814648 815087 461402 564731 714062 606633 585989 777750 807353 792135 811029 786129 460704 422147 414643 820641 569217 793206 784821 807133 815111 820542 822623 823672 815081 815128 820417 777794 771974 751560 783777 411841 815119 432852 822131 815117 800880 774690 765721 812979 421814 429416 562791 641538 421853 409021 413895 519958 390212 821734 814288 815616 815365 814218 821422 673772 687363 592907 788942 801562 795143 764151 795142 756115 519013 434254 814335 519465 564399 580319 641686 641886 783392 784754 805497 742547 765817 777003 783205 789253 421873 443890 615561 815080 778941 569146 576520 772535 422194 821577 708960 426616 825762 455322 435747 822424 820956 817422 820423 814629 587158 782508 811500 792936 794375 458438 ] |
||||||||||||||||||||||||||||||
|
6.42 ms (3.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов анал mom"
]
|
||||||||||||||||||||||||||||||
|
3.21 ms (1.98%) |
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 390212 409021 411841 413895 414643 421814 421853 421873 422147 422194 426616 429416 432852 434254 435747 443890 455322 458438 460704 461402 485061 519013 519465 519958 527850 529699 562791 564399 564731 569146 569217 576520 580319 585989 587158 592907 606633 615561 641538 641686 641886 673772 687363 691228 708960 714062 742547 751560 756115 764151 765721 765817 771974 772535 774690 777003 777750 777794 778941 782508 783205 783392 783777 784754 784821 786129 786195 788942 789253 792135 792936 793206 794375 795142 795143 800880 801562 805497 807133 807353 807394 811029 811365 811500 812722 812979 814218 814226 814288 814335 814629 814630 814648 815080 815081 815087 815111 815115 815117 815119 815128 815140 815365 815480 815616 817422 820417 820423 820542 820586 820641 820956 821422 821577 821734 822131 822424 822623 823672 825762 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov anal mom"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов анал mom"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.