Query Metrics
7
Database Queries
7
Different statements
197.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.56 ms (87.22%) |
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 6651 88246 117755 117890 123751 154576 249009 361679 382410 384526 390070 393765 395423 395446 396694 398074 400421 401583 403808 406134 407290 409144 411285 412881 413381 414070 414711 415511 416696 416703 417799 419929 421743 423781 424904 426237 427132 427232 430559 442430 449144 452843 462742 465148 465185 466739 467601 468949 470278 470852 475283 475703 476417 479675 480420 486261 486829 488773 491270 493838 494367 494690 497030 498114 499668 500431 506100 512357 514248 521588 529732 530426 536580 538510 552263 552699 556331 571192 580623 592655 597251 597275 616616 621389 622663 623154 630297 633497 673217 677349 680248 694116 712882 732116 738817 741944 752921 753635 758599 761547 769328 777012 783446 789426 790231 800577 810623 810892 817966 819858 820774 827893 827929 827941 827944 827947 827959 827977 827980 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (7.47%) |
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 499668 384526 820774 673217 623154 417799 396694 493838 6651 398074 827941 529732 530426 677349 769328 789426 622663 117755 382410 415511 117890 249009 712882 470278 680248 506100 621389 597251 486829 427232 361679 414711 817966 827929 827893 810892 633497 538510 462742 580623 412881 465185 395446 409144 427132 500431 498114 452843 154576 827961 827977 827980 486261 800577 810623 758599 741944 753635 88246 630297 491270 732116 467601 783446 536580 413381 552699 480420 521588 426237 449144 552263 571192 556331 597275 777012 738817 407290 393765 400421 819858 827947 827944 592655 123751 616616 465148 494367 470852 411285 488773 403808 423781 421743 827959 694116 752921 401583 512357 761547 406134 414070 466739 479675 497030 430559 475703 494690 416703 416696 468949 790231 514248 476417 395423 390070 419929 424904 442430 475283 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.40%) |
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 6651 88246 117755 117890 123751 154576 249009 361679 382410 384526 390070 393765 395423 395446 396694 398074 400421 401583 403808 406134 407290 409144 411285 412881 413381 414070 414711 415511 416696 416703 417799 419929 421743 423781 424904 426237 427132 427232 430559 442430 449144 452843 462742 465148 465185 466739 467601 468949 470278 470852 475283 475703 476417 479675 480420 486261 486829 488773 491270 493838 494367 494690 497030 498114 499668 500431 506100 512357 514248 521588 529732 530426 536580 538510 552263 552699 556331 571192 580623 592655 597251 597275 616616 621389 622663 623154 630297 633497 673217 677349 680248 694116 712882 732116 738817 741944 752921 753635 758599 761547 769328 777012 783446 789426 790231 800577 810623 810892 817966 819858 820774 827893 827929 827941 827944 827947 827959 827977 827980 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая девушк хардкор"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful girl hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая девушк хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.90%) |
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.