Query Metrics
7
Database Queries
7
Different statements
150.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.49 ms (80.80%) |
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 418230 428484 429292 432172 434378 439748 443994 445739 446307 451973 454947 459389 462689 466493 467844 469914 472309 473504 475904 477885 479222 479835 484695 487027 487087 490933 491659 492384 495024 496794 499740 508748 508835 512244 512478 513677 515171 515329 516634 519107 519989 520208 520730 524016 525095 527886 528019 531204 537510 537520 541302 541674 542148 542190 542754 548654 558012 558338 558432 567346 568180 569676 571240 575747 575775 575802 576079 576108 576118 581711 584749 585754 586023 586469 587542 588309 592342 594927 597121 597793 599274 603546 604503 605524 605576 608356 610311 612439 619140 622131 622775 625365 637085 650992 654352 656774 658418 658661 659564 659775 663372 665381 696308 698821 699678 716106 720115 727767 731480 733589 744265 744820 749465 753106 772882 784003 807506 824904 826579 826676 ] |
||||||||||||||||||||||||||||||
|
18.70 ms (12.44%) |
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 696308 698821 659775 665381 548654 569676 576079 592342 599274 604503 605524 622131 625365 637085 594927 619140 586469 597793 622775 731480 744265 733589 807506 467844 462689 418230 469914 472309 525095 491659 512244 487027 558338 650992 772882 603546 824904 608356 531204 496794 654352 443994 446307 466493 454947 520208 512478 519989 508748 520730 528019 542190 541674 567346 720115 656774 575775 612439 597121 586023 432172 445739 434378 459389 477885 479835 499740 508835 513677 487087 492384 524016 527886 428484 537520 727767 784003 575747 584749 542148 658418 659564 495024 753106 429292 537510 568180 749465 479222 451973 516634 519107 515329 542754 558012 575802 581711 576118 658661 571240 576108 605576 588309 610311 587542 473504 475904 484695 515171 490933 439748 663372 558432 826676 826579 541302 699678 716106 585754 744820 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.97%) |
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 418230 428484 429292 432172 434378 439748 443994 445739 446307 451973 454947 459389 462689 466493 467844 469914 472309 473504 475904 477885 479222 479835 484695 487027 487087 490933 491659 492384 495024 496794 499740 508748 508835 512244 512478 513677 515171 515329 516634 519107 519989 520208 520730 524016 525095 527886 528019 531204 537510 537520 541302 541674 542148 542190 542754 548654 558012 558338 558432 567346 568180 569676 571240 575747 575775 575802 576079 576108 576118 581711 584749 585754 586023 586469 587542 588309 592342 594927 597121 597793 599274 603546 604503 605524 605576 608356 610311 612439 619140 622131 622775 625365 637085 650992 654352 656774 658418 658661 659564 659775 663372 665381 696308 698821 699678 716106 720115 727767 731480 733589 744265 744820 749465 753106 772882 784003 807506 824904 826579 826676 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд лиза pussy"
]
|
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.