Query Metrics
7
Database Queries
7
Different statements
376.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.71 ms (55.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"guy pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
131.61 ms (34.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 2291 390437 393754 400989 408074 421310 438272 440581 443609 454222 454236 456897 457515 458442 462095 464503 465397 465788 465860 466258 467547 470232 470927 471500 472117 474414 476282 478024 478883 479038 479040 482123 483217 484391 485103 485869 488560 490884 490888 490917 496607 500658 501442 502907 503047 511849 512042 512681 515091 519991 520188 521040 522589 522923 525946 527754 528707 546942 549155 549261 549475 549579 550376 551628 554768 557972 558287 559459 560974 561825 562993 563001 563038 563125 563521 565360 565534 567863 574512 575086 576161 577394 578461 578474 581348 585997 590472 593091 596411 601024 604995 605478 624933 624936 640892 651856 665286 678960 682478 699611 714084 715719 720800 721537 722846 724275 747583 748389 758299 758719 770175 781914 786455 788936 789310 794362 804619 807506 807953 821145 ] |
||||||||||||||||||||||||||||||
|
26.20 ms (6.96%) |
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 546942 559459 563038 550376 562993 576161 578461 714084 651856 678960 682478 721537 665286 549155 560974 561825 590472 585997 596411 601024 605478 789310 758299 788936 794362 770175 747583 786455 458442 462095 464503 2291 454236 465397 467547 471500 478883 454222 465860 466258 470927 501442 515091 483217 490884 496607 484391 485103 490888 500658 511849 520188 490917 502907 512681 522923 512042 519991 807953 748389 440581 443609 479040 521040 525946 549579 567863 393754 390437 408074 421310 438272 821145 479038 456897 482123 465788 474414 488560 522589 503047 527754 528707 470232 472117 476282 478024 485869 554768 558287 563001 563125 549475 551628 565534 557972 563521 574512 575086 577394 715719 699611 720800 549261 565360 578474 581348 624933 624936 640892 593091 758719 724275 604995 722846 781914 804619 807506 400989 457515 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (1.07%) |
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 2291 390437 393754 400989 408074 421310 438272 440581 443609 454222 454236 456897 457515 458442 462095 464503 465397 465788 465860 466258 467547 470232 470927 471500 472117 474414 476282 478024 478883 479038 479040 482123 483217 484391 485103 485869 488560 490884 490888 490917 496607 500658 501442 502907 503047 511849 512042 512681 515091 519991 520188 521040 522589 522923 525946 527754 528707 546942 549155 549261 549475 549579 550376 551628 554768 557972 558287 559459 560974 561825 562993 563001 563038 563125 563521 565360 565534 567863 574512 575086 576161 577394 578461 578474 581348 585997 590472 593091 596411 601024 604995 605478 624933 624936 640892 651856 665286 678960 682478 699611 714084 715719 720800 721537 722846 724275 747583 748389 758299 758719 770175 781914 786455 788936 789310 794362 804619 807506 807953 821145 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"guy pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"guy pussy licking"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.47%) |
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.