Query Metrics
7
Database Queries
7
Different statements
358.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.08 ms (57.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small cock masturbation"
]
|
||||||||||||||||||||||||||||||
|
129.67 ms (36.16%) |
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 251476 382344 398431 417002 418428 419056 420484 423177 424996 429009 429359 430209 438288 443919 447538 447973 448402 453662 469878 483051 483952 488614 489318 491194 493116 493287 493323 498993 499293 501358 503706 506577 510362 519275 527095 529029 529040 533247 537236 540925 542692 551676 554530 557655 558645 560131 561730 565197 569736 569778 570615 573743 576384 578834 588255 588899 590854 591427 592132 593536 594007 595787 596550 596587 597474 598612 600280 606608 608392 619376 620226 622405 622986 623574 627455 628481 632623 636161 642996 648859 653258 656373 661422 666113 668377 670270 671656 678614 687071 689830 689970 690718 690749 691458 692349 704686 705153 710168 713362 714511 714617 716485 720364 729818 734594 742143 750143 758848 759223 760756 768239 803335 813537 814126 815105 815536 820817 823484 824999 827521 ] |
||||||||||||||||||||||||||||||
|
16.06 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 671656 666113 668377 558645 560131 578834 588899 598612 600280 606608 608392 594007 729818 540925 251476 678614 803335 758848 469878 501358 483952 493287 670270 429009 417002 595787 623574 814126 815105 529029 557655 573743 569736 656373 661422 691458 692349 689830 710168 653258 687071 704686 705153 713362 714617 592132 596587 622986 627455 642996 813537 760756 734594 750143 759223 636161 716485 382344 398431 418428 689970 503706 570615 690749 619376 628481 620226 537236 597474 768239 827521 420484 554530 565197 576384 542692 561730 569778 720364 648859 593536 596550 588255 622405 590854 742143 632623 447538 491194 714511 423177 424996 430209 447973 448402 551676 591427 453662 429359 438288 519275 488614 489318 493116 493323 506577 483051 499293 510362 443919 498993 690718 419056 815536 820817 823484 824999 533247 527095 529040 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.61%) |
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 251476 382344 398431 417002 418428 419056 420484 423177 424996 429009 429359 430209 438288 443919 447538 447973 448402 453662 469878 483051 483952 488614 489318 491194 493116 493287 493323 498993 499293 501358 503706 506577 510362 519275 527095 529029 529040 533247 537236 540925 542692 551676 554530 557655 558645 560131 561730 565197 569736 569778 570615 573743 576384 578834 588255 588899 590854 591427 592132 593536 594007 595787 596550 596587 597474 598612 600280 606608 608392 619376 620226 622405 622986 623574 627455 628481 632623 636161 642996 648859 653258 656373 661422 666113 668377 670270 671656 678614 687071 689830 689970 690718 690749 691458 692349 704686 705153 710168 713362 714511 714617 716485 720364 729818 734594 742143 750143 758848 759223 760756 768239 803335 813537 814126 815105 815536 820817 823484 824999 827521 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая cock мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая cock мастурбац"
]
|
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.