Query Metrics
8
Database Queries
8
Different statements
388.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.45 ms (54.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot milf"
]
|
||||||||||||||||||||||||||||||
|
148.26 ms (38.14%) |
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 183979 327421 381435 390574 390931 400474 409105 416405 417095 419979 421459 422181 423887 424368 426665 427009 431471 432442 434420 435360 439608 440571 440884 448296 450724 452128 452435 452633 453077 453504 454109 454275 454540 458978 458981 464697 466381 466397 470425 470500 477118 478993 481465 482761 488529 493471 494223 495714 496148 498363 498440 499964 499995 500940 509196 510902 515711 516489 517143 517469 517575 518004 519266 522990 523320 524867 524962 527426 528118 528123 528533 540738 548316 555936 555993 556704 556862 557487 558814 560791 569541 577132 581744 585447 585476 585539 591330 592613 596234 599925 601604 605589 614133 620217 621186 621457 622777 628515 630414 656672 675092 704525 710390 716383 724415 724637 729223 745487 749936 756622 758919 759135 761517 773963 784804 785437 789275 791589 793851 811993 ] |
||||||||||||||||||||||||||||||
|
17.40 ms (4.48%) |
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 756622 729223 758919 761517 773963 724415 710390 716383 789275 793851 811993 390931 423887 453504 454275 477118 421459 426665 427009 481465 432442 435360 439608 466397 440884 448296 466381 470425 499964 499995 516489 522990 509196 488529 494223 495714 498363 515711 518004 523320 454109 517575 498440 450724 416405 183979 327421 381435 390574 431471 419979 417095 452435 453077 458978 478993 470500 482761 452128 452633 454540 458981 464697 527426 496148 510902 519266 524962 528533 500940 517469 524867 528123 517143 528118 540738 493471 555936 577132 581744 548316 555993 557487 558814 569541 656672 675092 704525 556704 556862 560791 585539 601604 614133 620217 585447 591330 592613 596234 585476 621457 622777 630414 599925 628515 791589 759135 784804 724637 745487 749936 605589 621186 785437 422181 424368 409105 434420 440571 400474 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot milf"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (0.55%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”³[Ò\r*²Üaðp:oæ"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (0.55%) |
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 183979 327421 381435 390574 390931 400474 409105 416405 417095 419979 421459 422181 423887 424368 426665 427009 431471 432442 434420 435360 439608 440571 440884 448296 450724 452128 452435 452633 453077 453504 454109 454275 454540 458978 458981 464697 466381 466397 470425 470500 477118 478993 481465 482761 488529 493471 494223 495714 496148 498363 498440 499964 499995 500940 509196 510902 515711 516489 517143 517469 517575 518004 519266 522990 523320 524867 524962 527426 528118 528123 528533 540738 548316 555936 555993 556704 556862 557487 558814 560791 569541 577132 581744 585447 585476 585539 591330 592613 596234 599925 601604 605589 614133 620217 621186 621457 622777 628515 630414 656672 675092 704525 710390 716383 724415 724637 729223 745487 749936 756622 758919 759135 761517 773963 784804 785437 789275 791589 793851 811993 ] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot milf"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.37%) |
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.