Query Metrics
7
Database Queries
7
Different statements
139.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.61 ms (84.54%) |
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 187843 233186 235887 383373 387915 389973 415544 415570 417011 419423 421492 424481 425564 439809 441000 443258 443292 451137 453577 453651 454328 454399 457421 460335 467118 469554 471174 474895 475311 476163 477417 478041 486818 487408 490181 490595 495252 495725 496849 501630 502089 505108 506185 507810 508744 510717 512526 512937 514390 519811 520309 521938 522993 523788 524347 524929 525470 526518 527174 528915 528917 528919 532174 532180 532270 533801 533945 535374 535546 537240 541150 541357 543820 552357 557192 565007 565017 565977 566093 567381 567399 579471 580521 584200 590622 596588 597646 598483 601923 605671 605906 606032 606946 616062 618389 619471 622364 630609 637444 642389 652879 656904 690868 690919 692786 694139 694181 695629 697892 710202 713867 725197 727997 729344 749248 786876 790228 803492 815194 818472 ] |
||||||||||||||||||||||||||||||
|
12.73 ms (9.15%) |
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 487408 506185 521938 524929 525470 527174 490181 508744 520309 524347 441000 467118 535374 630609 443292 469554 501630 495252 383373 187843 389973 387915 415544 425564 443258 415570 417011 421492 818472 815194 451137 454399 474895 490595 453577 471174 478041 454328 457421 475311 477417 495725 505108 512526 522993 533801 535546 502089 528917 528919 532174 532270 533945 507810 514390 519811 526518 528915 532180 537240 496849 510717 512937 523788 476163 486818 552357 565977 541150 541357 543820 565007 579471 656904 694181 695629 697892 710202 713867 652879 690868 694139 690919 692786 557192 565017 566093 567381 567399 580521 584200 606032 616062 619471 590622 622364 597646 598483 605906 637444 642389 596588 605671 606946 618389 803492 725197 727997 729344 749248 601923 786876 790228 235887 424481 453651 439809 460335 233186 419423 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.96%) |
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 187843 233186 235887 383373 387915 389973 415544 415570 417011 419423 421492 424481 425564 439809 441000 443258 443292 451137 453577 453651 454328 454399 457421 460335 467118 469554 471174 474895 475311 476163 477417 478041 486818 487408 490181 490595 495252 495725 496849 501630 502089 505108 506185 507810 508744 510717 512526 512937 514390 519811 520309 521938 522993 523788 524347 524929 525470 526518 527174 528915 528917 528919 532174 532180 532270 533801 533945 535374 535546 537240 541150 541357 543820 552357 557192 565007 565017 565977 566093 567381 567399 579471 580521 584200 590622 596588 597646 598483 601923 605671 605906 606032 606946 616062 618389 619471 622364 630609 637444 642389 652879 656904 690868 690919 692786 694139 694181 695629 697892 710202 713867 725197 727997 729344 749248 786876 790228 803492 815194 818472 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf video"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf video"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf video"
]
|
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.