Query Metrics
7
Database Queries
7
Different statements
385.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.20 ms (53.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
156.62 ms (40.67%) |
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 154171 187800 190869 361978 379600 383273 387377 394420 395550 396287 400489 400818 400851 400858 403314 411967 417174 419653 421810 421824 421834 421837 421857 421874 421880 421908 421922 421927 423934 424302 426526 428119 428398 428588 442814 445873 447471 448464 453183 454102 454551 457450 457468 466392 466885 466907 468437 468667 470647 472691 472891 474109 474122 477133 477555 478186 478377 478525 479102 480454 482088 482342 482529 483569 483655 483656 483732 483745 484628 486345 486762 487315 488747 492534 496835 499025 500806 501228 510783 515499 521129 523027 530849 532903 532913 532918 532943 532959 532962 532963 533007 544490 549842 549846 563640 565275 583701 608939 615516 646868 646946 666361 668529 670951 720720 730352 761061 766647 766911 768870 794360 796945 798787 799360 810061 810354 813947 817311 819235 827219 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (3.87%) |
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 766647 419653 544490 608939 478525 466885 400818 515499 423934 417174 421834 483732 499025 510783 396287 400851 400858 387377 403314 532913 798787 361978 666361 486762 484628 483569 154171 477133 646868 668529 454551 500806 530849 730352 492534 827219 447471 466392 448464 532962 532959 482529 421810 421880 428119 421874 421927 428588 478186 496835 482088 383273 583701 466907 549842 549846 799360 483656 646946 794360 445873 532903 532918 470647 766911 421824 468437 474122 394420 190869 819235 615516 532943 424302 768870 810354 533007 532963 670951 395550 400489 488747 421837 468667 477555 501228 483745 187800 442814 472891 563640 479102 379600 483655 486345 453183 428398 474109 487315 813947 817311 761061 523027 411967 565275 796945 810061 457468 472691 482342 478377 521129 426526 720720 421908 421922 480454 454102 421857 457450 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.55%) |
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 154171 187800 190869 361978 379600 383273 387377 394420 395550 396287 400489 400818 400851 400858 403314 411967 417174 419653 421810 421824 421834 421837 421857 421874 421880 421908 421922 421927 423934 424302 426526 428119 428398 428588 442814 445873 447471 448464 453183 454102 454551 457450 457468 466392 466885 466907 468437 468667 470647 472691 472891 474109 474122 477133 477555 478186 478377 478525 479102 480454 482088 482342 482529 483569 483655 483656 483732 483745 484628 486345 486762 487315 488747 492534 496835 499025 500806 501228 510783 515499 521129 523027 530849 532903 532913 532918 532943 532959 532962 532963 533007 544490 549842 549846 563640 565275 583701 608939 615516 646868 646946 666361 668529 670951 720720 730352 761061 766647 766911 768870 794360 796945 798787 799360 810061 810354 813947 817311 819235 827219 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая mature анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead mature anal"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая mature анал"
]
|
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.