Query Metrics
7
Database Queries
7
Different statements
211.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.31 ms (87.49%) |
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 44871 53962 135726 191315 191601 232978 234067 300984 310133 336058 336085 381226 383360 383434 385496 385939 390470 393315 396322 396830 406986 412537 413247 414782 416982 421389 422415 424020 428301 429221 433137 433192 433433 435748 439500 448939 449416 450929 455976 456019 456151 456158 457061 458497 459139 461070 462041 462476 463490 463545 464401 467025 467262 468418 474000 476003 476892 477220 477873 478250 478764 479181 479182 479606 482052 482242 483565 485294 487068 490392 491032 491160 493168 493451 494591 494987 495044 495458 496252 496814 501991 502743 506062 506842 507429 508687 508759 510465 510535 510655 511395 513682 515031 519542 521194 522113 530605 531725 533845 538432 549350 558905 561881 563731 565886 572361 573600 579850 597456 598712 604364 613275 679601 679613 707606 736875 757603 780773 780793 814394 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (7.18%) |
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 463545 521194 780773 780793 561881 679601 463490 421389 491160 396830 44871 814394 433137 462476 558905 439500 515031 519542 390470 300984 506842 433192 428301 613275 502743 477220 506062 597456 422415 494987 474000 467025 490392 433433 511395 495458 461070 530605 491032 396322 604364 414782 573600 53962 416982 496814 406986 508759 459139 483565 531725 336058 135726 563731 413247 457061 736875 476892 482052 383434 456151 393315 510535 383360 579850 429221 508687 477873 462041 385496 598712 381226 455976 476003 412537 456158 478764 507429 479606 485294 458497 493451 493168 191315 565886 449416 456019 479182 510465 487068 707606 310133 191601 533845 679613 510655 538432 549350 424020 468418 513682 385939 336085 450929 234067 495044 232978 464401 757603 435748 467262 448939 496252 572361 478250 479181 482242 522113 494591 501991 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.51%) |
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 44871 53962 135726 191315 191601 232978 234067 300984 310133 336058 336085 381226 383360 383434 385496 385939 390470 393315 396322 396830 406986 412537 413247 414782 416982 421389 422415 424020 428301 429221 433137 433192 433433 435748 439500 448939 449416 450929 455976 456019 456151 456158 457061 458497 459139 461070 462041 462476 463490 463545 464401 467025 467262 468418 474000 476003 476892 477220 477873 478250 478764 479181 479182 479606 482052 482242 483565 485294 487068 490392 491032 491160 493168 493451 494591 494987 495044 495458 496252 496814 501991 502743 506062 506842 507429 508687 508759 510465 510535 510655 511395 513682 515031 519542 521194 522113 530605 531725 533845 538432 549350 558905 561881 563731 565886 572361 573600 579850 597456 598712 604364 613275 679601 679613 707606 736875 757603 780773 780793 814394 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╗ð░Ðüð║ð░ðÁÐé Ðçð╗ðÁð¢ð¥ð╝ ð▓ð░ð│ð©ð¢ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ласка член вагин"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.