Query Metrics
7
Database Queries
7
Different statements
200.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.24 ms (86.93%) |
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 2658 38908 40835 162000 187709 187775 188240 188447 272725 310671 318315 357595 381752 382094 386532 386544 386576 389997 390653 391588 391656 391875 392604 393072 393087 395142 395537 395719 395887 395943 395998 397942 398353 405417 406592 406648 406820 407871 409234 411933 416258 433351 439658 440868 443194 444003 448996 452189 452237 453695 453832 454184 458714 460190 460673 461296 463851 464975 466816 467545 467546 467712 469351 472595 473204 474100 474850 476676 480294 482527 484626 484681 487929 490235 493189 495808 502885 513671 518735 530767 535529 542781 546962 555129 561042 569149 569410 570722 571806 582404 600972 620233 659366 665240 681295 709240 712564 715549 718500 718836 719898 720622 720713 723984 742341 743834 744317 748245 750159 760976 780613 782657 788543 790974 794830 797218 800384 803655 819235 820039 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (7.61%) |
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 502885 473204 484681 395537 395887 382094 569410 665240 659366 620233 794830 748245 407871 386544 318315 38908 272725 439658 555129 718836 381752 458714 469351 472595 788543 391588 433351 453832 406648 463851 467546 490235 513671 493189 484626 461296 571806 718500 390653 452237 453695 480294 535529 530767 570722 582404 569149 719898 712564 600972 464975 357595 392604 467545 411933 448996 440868 443194 487929 495808 386532 397942 803655 760976 391656 476676 444003 386576 162000 188240 395142 395998 395943 389997 398353 406820 416258 454184 474100 466816 474850 546962 800384 743834 750159 709240 780613 391875 518735 820039 797218 744317 715549 393087 405417 542781 188447 393072 310671 187709 819235 681295 720622 782657 790974 723984 742341 720713 409234 561042 460673 482527 40835 2658 460190 395719 406592 187775 467712 452189 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (1.79%) |
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 2658 38908 40835 162000 187709 187775 188240 188447 272725 310671 318315 357595 381752 382094 386532 386544 386576 389997 390653 391588 391656 391875 392604 393072 393087 395142 395537 395719 395887 395943 395998 397942 398353 405417 406592 406648 406820 407871 409234 411933 416258 433351 439658 440868 443194 444003 448996 452189 452237 453695 453832 454184 458714 460190 460673 461296 463851 464975 466816 467545 467546 467712 469351 472595 473204 474100 474850 476676 480294 482527 484626 484681 487929 490235 493189 495808 502885 513671 518735 530767 535529 542781 546962 555129 561042 569149 569410 570722 571806 582404 600972 620233 659366 665240 681295 709240 712564 715549 718500 718836 719898 720622 720713 723984 742341 743834 744317 748245 750159 760976 780613 782657 788543 790974 794830 797218 800384 803655 819235 820039 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тещи секс"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.81%) |
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.