Query Metrics
7
Database Queries
7
Different statements
200.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.06 ms (83.75%) |
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 406108 407418 414138 415905 419633 420874 430365 446562 448012 448065 451064 451654 452933 463426 464887 467110 467696 475227 478775 480209 483553 488789 495170 499931 508353 516035 521850 522746 524198 527568 530499 532739 532829 533725 533746 536752 537659 537663 537928 538255 538703 542002 544811 547241 552917 556911 559453 561970 564383 565479 567334 569359 571190 572777 585951 587085 594534 595871 600071 604342 623205 629047 630297 630522 630869 632690 633533 634155 634512 637034 637100 637147 639718 641097 642043 642310 644327 647340 648841 649970 650316 651601 651647 652947 656568 661034 666871 670442 674927 676090 677397 679029 687318 697839 700257 702621 711480 719057 722264 722591 722692 724961 729905 751565 754589 777574 777921 782633 785602 785851 789771 790162 795431 800425 800562 806514 806919 814965 818067 819586 ] |
||||||||||||||||||||||||||||||
|
22.47 ms (11.20%) |
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 478775 415905 483553 600071 524198 533746 499931 538703 552917 567334 629047 407418 406108 446562 467696 475227 414138 452933 480209 448012 451654 430365 448065 463426 522746 508353 666871 547241 650316 595871 630869 651601 751565 819586 814965 818067 533725 532829 571190 677397 697839 661034 670442 719057 642310 795431 789771 790162 785602 724961 729905 754589 722591 777921 785851 516035 495170 556911 702621 634155 633533 634512 451064 527568 637147 652947 604342 530499 532739 521850 536752 537659 537928 559453 649970 656568 674927 676090 648841 679029 647340 630297 630522 585951 637034 623205 637100 639718 632690 642043 537663 564383 651647 464887 561970 420874 419633 467110 488789 538255 542002 544811 572777 722264 700257 711480 722692 687318 565479 569359 641097 587085 594534 644327 777574 782633 800425 800562 806919 806514 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.35%) |
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 406108 407418 414138 415905 419633 420874 430365 446562 448012 448065 451064 451654 452933 463426 464887 467110 467696 475227 478775 480209 483553 488789 495170 499931 508353 516035 521850 522746 524198 527568 530499 532739 532829 533725 533746 536752 537659 537663 537928 538255 538703 542002 544811 547241 552917 556911 559453 561970 564383 565479 567334 569359 571190 572777 585951 587085 594534 595871 600071 604342 623205 629047 630297 630522 630869 632690 633533 634155 634512 637034 637100 637147 639718 641097 642043 642310 644327 647340 648841 649970 650316 651601 651647 652947 656568 661034 666871 670442 674927 676090 677397 679029 687318 697839 700257 702621 711480 719057 722264 722591 722692 724961 729905 751565 754589 777574 777921 782633 785602 785851 789771 790162 795431 800425 800562 806514 806919 814965 818067 819586 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty teen dildo"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty teen дилд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty teen дилд"
]
|
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.