Query Metrics
7
Database Queries
7
Different statements
197.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.77 ms (86.16%) |
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 382141 383600 389602 392004 411469 416511 416568 416648 417783 419619 419972 421838 422803 424008 424169 424765 426696 428710 429598 439218 440644 441094 442072 443171 444085 445421 445980 448140 448450 449404 450666 450700 451121 452254 452354 452373 452968 453390 453404 455378 457957 458550 458767 459474 459485 464017 464031 465467 466226 466855 466995 467903 468329 468371 469171 469393 471080 471107 472184 472625 472835 473426 473429 473452 473533 475028 476321 476715 477619 478370 480576 483677 483762 490400 492433 493252 493840 493882 495040 498206 498490 499549 502832 506228 507643 508713 512997 519753 522448 523592 525728 526498 527707 537167 541969 546320 547757 547791 555055 555963 570936 570954 574086 575656 585851 586307 587178 592004 605255 607640 628537 666188 678716 739145 739169 748521 752506 772233 774771 810118 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (8.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 468329 472184 476715 537167 512997 523592 502832 525728 468371 473429 473452 483762 493882 547791 666188 547757 570936 585851 586307 739169 739145 748521 772233 810118 419619 424169 426696 445980 453390 453404 457957 464031 475028 480576 411469 416568 445421 459474 465467 469171 477619 478370 392004 421838 464017 471107 424008 455378 458550 472835 439218 448450 450700 459485 490400 492433 498490 506228 508713 527707 483677 493252 495040 522448 526498 498206 507643 383600 389602 422803 440644 442072 419972 428710 416648 441094 443171 444085 424765 452254 452373 452968 471080 473533 451121 452354 458767 466855 473426 493840 448140 449404 450666 469393 476321 499549 519753 472625 546320 574086 575656 555055 541969 570954 678716 555963 592004 587178 605255 607640 628537 752506 774771 382141 467903 416511 417783 429598 466226 466995 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.58%) |
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 382141 383600 389602 392004 411469 416511 416568 416648 417783 419619 419972 421838 422803 424008 424169 424765 426696 428710 429598 439218 440644 441094 442072 443171 444085 445421 445980 448140 448450 449404 450666 450700 451121 452254 452354 452373 452968 453390 453404 455378 457957 458550 458767 459474 459485 464017 464031 465467 466226 466855 466995 467903 468329 468371 469171 469393 471080 471107 472184 472625 472835 473426 473429 473452 473533 475028 476321 476715 477619 478370 480576 483677 483762 490400 492433 493252 493840 493882 495040 498206 498490 499549 502832 506228 507643 508713 512997 519753 522448 523592 525728 526498 527707 537167 541969 546320 547757 547791 555055 555963 570936 570954 574086 575656 585851 586307 587178 592004 605255 607640 628537 666188 678716 739145 739169 748521 752506 772233 774771 810118 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстуха соло"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"толстая соло"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.87%) |
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.