Query Metrics
7
Database Queries
7
Different statements
192.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.12 ms (86.65%) |
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 8164 55349 79469 338098 384325 387296 416432 432573 436526 447224 447711 447938 457917 461286 477067 483675 499172 509269 512528 527461 529115 532809 533174 541030 542700 544020 549656 553433 558576 564069 570595 572116 574185 577486 583394 584462 584609 592933 594458 606363 613391 616895 622701 625948 625987 628552 631331 635415 635558 636450 647089 663834 665991 666373 675395 678807 680642 687942 696231 696992 704429 705019 707082 707497 707673 708145 708520 712241 715485 718327 720522 721207 724913 729165 729540 729673 735437 735978 738051 739849 742560 742658 745607 746267 746513 747298 748489 756629 757318 759736 761162 762643 765413 766491 766737 767485 767643 769064 771966 772250 773131 775365 776041 784970 785078 786986 787356 788324 788528 790437 791243 791410 796744 805189 805238 809719 811378 812191 812983 813370 ] |
||||||||||||||||||||||||||||||
|
15.73 ms (8.16%) |
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 766737 769064 735437 742560 745607 746267 746513 748489 757318 765413 729165 729540 729673 735978 742658 747298 759736 761162 762643 766491 739849 756629 767643 613391 635415 696992 704429 707497 721207 787356 788324 809719 811378 812191 812983 477067 8164 55349 447224 447938 457917 512528 384325 338098 79469 387296 432573 416432 436526 447711 483675 461286 509269 527461 529115 499172 532809 533174 542700 544020 574185 584609 541030 549656 553433 583394 584462 558576 564069 570595 665991 680642 705019 708145 712241 715485 663834 675395 678807 687942 696231 707082 647089 666373 707673 708520 718327 720522 572116 577486 592933 606363 635558 636450 594458 616895 622701 628552 625948 625987 631331 775365 784970 786986 788528 791243 796744 805189 805238 776041 790437 791410 813370 724913 738051 767485 771966 772250 773131 785078 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.67%) |
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 8164 55349 79469 338098 384325 387296 416432 432573 436526 447224 447711 447938 457917 461286 477067 483675 499172 509269 512528 527461 529115 532809 533174 541030 542700 544020 549656 553433 558576 564069 570595 572116 574185 577486 583394 584462 584609 592933 594458 606363 613391 616895 622701 625948 625987 628552 631331 635415 635558 636450 647089 663834 665991 666373 675395 678807 680642 687942 696231 696992 704429 705019 707082 707497 707673 708145 708520 712241 715485 718327 720522 721207 724913 729165 729540 729673 735437 735978 738051 739849 742560 742658 745607 746267 746513 747298 748489 756629 757318 759736 761162 762643 765413 766491 766737 767485 767643 769064 771966 772250 773131 775365 776041 784970 785078 786986 787356 788324 788528 790437 791243 791410 796744 805189 805238 809719 811378 812191 812983 813370 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding cum"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding cum"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding cum"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.79%) |
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.