Query Metrics
7
Database Queries
7
Different statements
162.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.58 ms (82.26%) |
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 7196 47606 96341 130289 188453 382355 383327 388690 391537 396504 397218 398244 400753 400932 401032 401773 405061 405535 406705 410843 411768 411947 413818 415074 416857 420643 421025 421152 424782 425992 430144 430341 437839 443829 443945 444464 444978 445540 445679 447588 447814 447947 448211 448663 448887 452269 453087 453178 453238 453417 453548 453868 453877 454200 454402 454676 457166 458702 461036 461130 467690 470047 470443 470935 471170 472206 473806 474116 474433 474835 474851 475104 476799 478006 479077 479103 483752 484657 485330 486699 488118 488391 491272 491736 494277 495154 495396 495656 497184 497473 497560 497881 500420 507257 510676 513540 514023 514395 517478 518880 525020 541767 554119 555837 559109 565391 578827 586654 590252 590499 599524 601660 615366 619529 647636 720206 722050 730299 755082 810663 ] |
||||||||||||||||||||||||||||||
|
17.95 ms (11.05%) |
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 474835 470935 448663 461130 479103 453417 454402 730299 47606 495154 420643 452269 590499 396504 421152 478006 510676 473806 445540 461036 486699 555837 722050 518880 467690 755082 514023 474851 479077 647636 590252 488118 443945 497473 96341 586654 720206 447814 448211 476799 513540 484657 525020 454200 578827 444978 453238 383327 188453 397218 398244 401773 474116 601660 615366 810663 411947 443829 421025 453087 491736 454676 411768 448887 559109 474433 401032 430144 457166 453548 388690 406705 497184 437839 415074 500420 458702 447947 472206 453868 470047 444464 488391 425992 470443 497881 494277 410843 495396 475104 416857 453178 430341 495656 405535 514395 507257 445679 382355 413818 497560 400753 453877 554119 7196 130289 400932 483752 565391 391537 491272 471170 517478 424782 485330 405061 619529 599524 447588 541767 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.77%) |
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 7196 47606 96341 130289 188453 382355 383327 388690 391537 396504 397218 398244 400753 400932 401032 401773 405061 405535 406705 410843 411768 411947 413818 415074 416857 420643 421025 421152 424782 425992 430144 430341 437839 443829 443945 444464 444978 445540 445679 447588 447814 447947 448211 448663 448887 452269 453087 453178 453238 453417 453548 453868 453877 454200 454402 454676 457166 458702 461036 461130 467690 470047 470443 470935 471170 472206 473806 474116 474433 474835 474851 475104 476799 478006 479077 479103 483752 484657 485330 486699 488118 488391 491272 491736 494277 495154 495396 495656 497184 497473 497560 497881 500420 507257 510676 513540 514023 514395 517478 518880 525020 541767 554119 555837 559109 565391 578827 586654 590252 590499 599524 601660 615366 619529 647636 720206 722050 730299 755082 810663 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие толстые члены…"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие толстые член"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
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.