Query Metrics
7
Database Queries
7
Different statements
202.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.75 ms (85.31%) |
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 391027 400182 405221 413108 414047 420392 426435 428035 434530 435180 437089 437749 441402 442263 442325 442370 444736 444742 446754 447247 450195 453569 454447 454944 461259 463962 465938 466876 467489 467514 467725 471313 479473 479767 484123 484139 489016 490559 491382 491410 495629 497320 499506 505966 507101 508486 509096 509259 509824 510121 510690 511814 512244 512249 513298 513873 516404 517938 520057 520575 521059 522791 526127 527042 527128 528367 529445 532799 534041 544846 552855 558266 559687 560138 561925 564696 567623 568761 573779 574793 575205 575746 579501 580631 581805 582708 584228 586499 586652 586676 588405 591259 593476 594007 601333 605458 609203 611301 626441 628090 628324 634475 639277 640888 641949 643935 645973 646894 648634 653580 661977 672671 720291 723352 724291 726707 759329 762221 762234 805601 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (8.80%) |
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 582708 544846 561925 564696 568761 573779 574793 575205 575746 579501 645973 672671 653580 661977 648634 552855 559687 560138 567623 580631 581805 584228 643935 609203 586652 586676 593476 601333 634475 639277 586499 588405 591259 594007 605458 805601 762221 726707 759329 724291 762234 611301 720291 723352 405221 420392 461259 465938 479473 400182 413108 434530 463962 467489 467725 391027 435180 467514 426435 437089 437749 441402 444742 446754 450195 454944 479767 442263 442325 509096 516404 520057 527042 484123 489016 491382 495629 505966 513298 522791 526127 507101 508486 510121 510690 512244 513873 517938 528367 484139 490559 497320 499506 509259 511814 512249 520575 529445 527128 646894 558266 626441 640888 628090 628324 641949 521059 414047 444736 428035 442370 447247 491410 454447 466876 471313 453569 509824 532799 534041 ] |
||||||||||||||||||||||||||||||
|
4.26 ms (2.10%) |
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 391027 400182 405221 413108 414047 420392 426435 428035 434530 435180 437089 437749 441402 442263 442325 442370 444736 444742 446754 447247 450195 453569 454447 454944 461259 463962 465938 466876 467489 467514 467725 471313 479473 479767 484123 484139 489016 490559 491382 491410 495629 497320 499506 505966 507101 508486 509096 509259 509824 510121 510690 511814 512244 512249 513298 513873 516404 517938 520057 520575 521059 522791 526127 527042 527128 528367 529445 532799 534041 544846 552855 558266 559687 560138 561925 564696 567623 568761 573779 574793 575205 575746 579501 580631 581805 582708 584228 586499 586652 586676 588405 591259 593476 594007 601333 605458 609203 611301 626441 628090 628324 634475 639277 640888 641949 643935 645973 646894 648634 653580 661977 672671 720291 723352 724291 726707 759329 762221 762234 805601 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"new cock"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"new cock"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"new cock"
]
|
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.