Query Metrics
7
Database Queries
7
Different statements
183.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.19 ms (85.47%) |
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 409901 413455 418065 421963 447495 455114 456686 457174 458739 460829 462038 465525 466915 467394 467453 467488 471886 472351 478527 493203 513246 515182 517048 520721 520730 523025 524698 524706 524722 526135 529219 544749 554265 556916 557997 563876 576038 577117 577118 581661 587598 589786 589821 598450 603973 612035 622775 627380 654602 654729 655366 655375 655392 655718 655747 655752 655977 656466 656681 656747 657022 657025 657030 657064 657066 657070 657097 657309 657336 657376 657613 657643 658673 659622 659637 659810 660513 660515 660942 663414 663883 664842 665221 666103 667568 667858 669593 669761 673297 682419 686776 703448 710957 710965 712911 712921 714640 717892 725914 725943 741438 741445 741468 744887 744897 745793 748185 748643 757982 757996 788438 788710 789113 789233 789310 789401 789837 789976 820333 ] |
||||||||||||||||||||||||||||||
|
16.66 ms (9.06%) |
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 789113 788760 741438 741468 744897 788438 472351 457174 447495 513246 576038 577117 682419 598450 789310 456686 455114 458739 462038 467488 526135 524706 523025 466915 654729 655366 655747 657030 659622 657025 657070 657643 660513 664842 665221 666103 667858 710957 712911 717892 655718 655752 655977 657309 657336 667568 669761 544749 581661 589821 789233 789401 789837 789976 741445 757982 757996 725914 515182 622775 748185 471886 587598 478527 418065 421963 467394 493203 460829 557997 589786 603973 467453 524698 524722 563876 654602 657097 660515 660942 663883 655375 655392 656747 657022 657376 657613 703448 712921 714640 612035 788710 745793 744887 725943 748643 517048 627380 520730 529219 520721 465525 409901 413455 820333 554265 556916 658673 659810 656681 657064 657066 659637 669593 710965 656466 663414 673297 686776 577118 ] |
||||||||||||||||||||||||||||||
|
3.05 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 409901 413455 418065 421963 447495 455114 456686 457174 458739 460829 462038 465525 466915 467394 467453 467488 471886 472351 478527 493203 513246 515182 517048 520721 520730 523025 524698 524706 524722 526135 529219 544749 554265 556916 557997 563876 576038 577117 577118 581661 587598 589786 589821 598450 603973 612035 622775 627380 654602 654729 655366 655375 655392 655718 655747 655752 655977 656466 656681 656747 657022 657025 657030 657064 657066 657070 657097 657309 657336 657376 657613 657643 658673 659622 659637 659810 660513 660515 660942 663414 663883 664842 665221 666103 667568 667858 669593 669761 673297 682419 686776 703448 710957 710965 712911 712921 714640 717892 725914 725943 741438 741445 741468 744887 744897 745793 748185 748643 757982 757996 788438 788710 789113 789233 789310 789401 789837 789976 820333 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold old"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд old"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд old"
]
|
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.