Query Metrics
7
Database Queries
7
Different statements
387.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.54 ms (54.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
147.39 ms (38.02%) |
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 70123 72267 87363 318343 383491 385319 387501 387709 387785 388775 389288 389743 389867 390702 395770 396997 397036 397307 399013 399303 401183 403577 406568 407721 410963 423120 425183 425619 430493 432154 433382 442904 443203 444327 446741 446958 451303 452104 452509 453308 453549 455323 456487 458026 462667 465006 465838 468647 470555 475065 479830 487214 502586 502896 507199 519768 521565 524446 524673 529889 541549 542648 542849 542850 543044 547044 548511 568118 574170 578419 596834 613410 615644 618912 627697 653148 653306 654591 663945 670506 699191 713182 715018 717211 719075 719472 720081 722192 726431 733318 733401 736015 738562 739584 739621 751688 754375 756212 759376 760124 764321 779459 789905 791173 801873 803219 809574 816026 818123 818514 818910 819267 820354 820359 820721 823294 824802 824941 825379 825523 ] |
||||||||||||||||||||||||||||||
|
19.48 ms (5.02%) |
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 751688 754375 739584 720081 791173 385319 390702 399013 820721 446958 387709 425183 713182 406568 618912 547044 396997 452509 819267 529889 653148 596834 779459 715018 388775 574170 654591 613410 389288 407721 430493 653306 719472 627697 733401 70123 663945 739621 738562 818123 816026 541549 72267 389867 399303 446741 452104 470555 389743 410963 444327 801873 487214 519768 397036 401183 423120 433382 453308 456487 468647 465006 542648 542849 615644 756212 764321 443203 442904 458026 455323 502896 524446 524673 507199 502586 820359 823294 818910 824802 670506 453549 395770 824941 825523 542850 789905 717211 87363 387501 403577 803219 736015 759376 543044 383491 387785 809574 318343 521565 722192 397307 719075 465838 432154 726431 818514 820354 568118 548511 578419 733318 475065 760124 825379 699191 425619 462667 479830 451303 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (0.92%) |
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 70123 72267 87363 318343 383491 385319 387501 387709 387785 388775 389288 389743 389867 390702 395770 396997 397036 397307 399013 399303 401183 403577 406568 407721 410963 423120 425183 425619 430493 432154 433382 442904 443203 444327 446741 446958 451303 452104 452509 453308 453549 455323 456487 458026 462667 465006 465838 468647 470555 475065 479830 487214 502586 502896 507199 519768 521565 524446 524673 529889 541549 542648 542849 542850 543044 547044 548511 568118 574170 578419 596834 613410 615644 618912 627697 653148 653306 654591 663945 670506 699191 713182 715018 717211 719075 719472 720081 722192 726431 733318 733401 736015 738562 739584 739621 751688 754375 756212 759376 760124 764321 779459 789905 791173 801873 803219 809574 816026 818123 818514 818910 819267 820354 820359 820721 823294 824802 824941 825379 825523 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big blow job"
]
|
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.