Query Metrics
7
Database Queries
7
Different statements
173.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.25 ms (85.44%) |
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 395257 399966 403924 411690 411734 415126 420580 422191 423433 423929 424118 429307 429834 437671 439716 439763 439770 439809 448932 449721 454419 454666 459910 460136 461598 462491 465308 466165 466719 466801 467102 468307 469345 473670 476345 476950 477737 481791 483643 485458 486069 493270 496871 499487 499898 502742 506351 513584 513857 514273 514878 515952 516233 517012 520906 521512 523618 527362 529240 543180 545645 546113 546128 546896 546901 549708 549749 552945 553972 554315 554903 554917 556005 556021 556554 556609 556922 561904 562957 563037 563820 569408 578037 589682 592559 599518 614376 619362 621386 649156 662190 682269 696565 703900 716354 724651 727032 733146 740309 745397 773850 782593 788196 792631 792648 792910 793886 795041 799127 799351 799962 801173 802256 802730 803095 807323 807479 812585 813435 813917 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (9.30%) |
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 468307 429834 543180 621386 589682 812585 619362 703900 395257 553972 562957 563037 578037 561904 592559 599518 782593 802256 773850 795041 801173 740309 439809 513584 545645 411690 477737 520906 514878 466719 467102 549749 554903 552945 556021 614376 792631 793886 799351 799962 807479 424118 411734 523618 460136 485458 454666 437671 423929 439763 483643 813917 521512 486069 549708 556554 662190 696565 716354 546128 546901 563820 802730 813435 724651 745397 727032 420580 529240 514273 546113 399966 516233 556922 415126 459910 481791 569408 682269 448932 461598 496871 506351 493270 465308 476345 546896 473670 527362 499487 466165 403924 513857 554917 476950 517012 515952 792910 792648 429307 799127 449721 556609 803095 466801 788196 499898 423433 422191 554315 649156 502742 807323 733146 462491 556005 439716 439770 469345 454419 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.44%) |
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 395257 399966 403924 411690 411734 415126 420580 422191 423433 423929 424118 429307 429834 437671 439716 439763 439770 439809 448932 449721 454419 454666 459910 460136 461598 462491 465308 466165 466719 466801 467102 468307 469345 473670 476345 476950 477737 481791 483643 485458 486069 493270 496871 499487 499898 502742 506351 513584 513857 514273 514878 515952 516233 517012 520906 521512 523618 527362 529240 543180 545645 546113 546128 546896 546901 549708 549749 552945 553972 554315 554903 554917 556005 556021 556554 556609 556922 561904 562957 563037 563820 569408 578037 589682 592559 599518 614376 619362 621386 649156 662190 682269 696565 703900 716354 724651 727032 733146 740309 745397 773850 782593 788196 792631 792648 792910 793886 795041 799127 799351 799962 801173 802256 802730 803095 807323 807479 812585 813435 813917 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom blowjob stepson"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom минет оральн секс stepson"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom минет оральн секс stepson"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.