Query Metrics
7
Database Queries
7
Different statements
188.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.04 ms (87.96%) |
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 145424 233692 241970 383153 384514 387263 411096 413179 416240 418334 441926 453160 453168 454557 461151 462232 464567 471017 471038 473096 476153 480268 490587 496462 497126 497127 508103 510916 512892 515024 515203 515455 516539 527889 529919 536107 537480 538474 539352 541013 541030 544540 544550 548418 550788 551666 552848 556790 556858 557581 562542 563598 567005 571110 575865 576210 577271 578156 581327 584378 584800 586459 587769 588415 588811 595641 605387 607526 612211 618456 620963 621391 627039 627348 628558 641176 660711 661535 666697 667395 683202 683257 691358 694638 694926 694935 696123 707079 707496 714418 714531 717127 717601 722149 722532 724861 729798 733400 739085 743236 743249 749485 749567 750514 752090 756324 763966 767516 768725 774186 774310 797053 799103 806827 810306 811942 814297 824253 825383 826530 ] |
||||||||||||||||||||||||||||||
|
12.54 ms (6.64%) |
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 490587 454557 464567 453168 512892 497126 538474 508103 539352 471038 541013 544540 551666 567005 578156 584378 544550 557581 577271 584800 666697 717127 722532 683257 714418 717601 563598 581327 586459 587769 618456 595641 621391 627348 799103 811942 743236 749485 739085 749567 768725 774186 774310 743249 607526 641176 714531 797053 806827 413179 441926 476153 145424 480268 453160 510916 383153 241970 824253 826530 515024 707079 556858 571110 384514 233692 752090 767516 763966 418334 516539 515203 527889 552848 515455 825383 733400 387263 411096 416240 814297 462232 473096 471017 537480 496462 536107 497127 529919 461151 541030 562542 575865 667395 683202 707496 660711 661535 694638 694926 722149 691358 694935 696123 548418 550788 556790 576210 588415 620963 628558 588811 605387 612211 627039 810306 724861 756324 750514 729798 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.64%) |
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 145424 233692 241970 383153 384514 387263 411096 413179 416240 418334 441926 453160 453168 454557 461151 462232 464567 471017 471038 473096 476153 480268 490587 496462 497126 497127 508103 510916 512892 515024 515203 515455 516539 527889 529919 536107 537480 538474 539352 541013 541030 544540 544550 548418 550788 551666 552848 556790 556858 557581 562542 563598 567005 571110 575865 576210 577271 578156 581327 584378 584800 586459 587769 588415 588811 595641 605387 607526 612211 618456 620963 621391 627039 627348 628558 641176 660711 661535 666697 667395 683202 683257 691358 694638 694926 694935 696123 707079 707496 714418 714531 717127 717601 722149 722532 724861 729798 733400 739085 743236 743249 749485 749567 750514 752090 756324 763966 767516 768725 774186 774310 797053 799103 806827 810306 811942 814297 824253 825383 826530 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens волосатая 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.