Query Metrics
7
Database Queries
7
Different statements
347.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.46 ms (58.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm pussy"
]
|
||||||||||||||||||||||||||||||
|
121.13 ms (34.89%) |
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 359089 391745 400448 425894 426006 433386 435409 438631 438712 441646 442467 444109 445108 446560 449295 449327 450894 451025 454589 454877 455579 456685 456807 458987 459585 459811 465114 469379 469819 487351 489839 494823 495000 496144 501358 503000 507550 510257 511715 514975 519864 521002 521968 523008 527309 531383 532509 532971 541061 555469 565510 567621 571130 579865 583744 585141 588727 588865 591719 591956 619752 626015 644447 670197 677332 680589 703781 714082 715638 716967 720012 728905 730079 730166 732176 733573 733724 735987 744576 744824 747962 749972 753153 755568 757166 758659 759909 763526 766365 767292 771914 771931 773240 773451 773601 775313 781121 784003 784155 785601 786649 787648 790100 791870 793038 793052 793054 795875 795907 801395 805255 808044 810394 813410 814272 814289 820644 822295 825584 825617 ] |
||||||||||||||||||||||||||||||
|
12.98 ms (3.74%) |
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 810394 753153 758659 744824 728905 735987 749972 773240 644447 716967 805255 521002 825584 531383 541061 555469 579865 567621 583744 715638 720012 588727 591719 591956 786649 795907 775313 793054 813410 732176 767292 787648 791870 793038 793052 795875 757166 766365 773601 747962 730079 733724 744576 763526 771914 773451 730166 759909 771931 703781 781121 785601 790100 801395 585141 487351 507550 510257 523008 532509 527309 496144 503000 571130 565510 677332 680589 670197 714082 588865 619752 626015 784003 784155 755568 808044 733573 455579 469379 450894 459585 446560 435409 445108 501358 521968 494823 514975 519864 511715 391745 359089 400448 433386 438712 444109 441646 442467 426006 438631 425894 820644 825617 814272 822295 814289 454589 458987 489839 449295 449327 454877 456807 459811 469819 451025 456685 465114 495000 532971 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (0.84%) |
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 359089 391745 400448 425894 426006 433386 435409 438631 438712 441646 442467 444109 445108 446560 449295 449327 450894 451025 454589 454877 455579 456685 456807 458987 459585 459811 465114 469379 469819 487351 489839 494823 495000 496144 501358 503000 507550 510257 511715 514975 519864 521002 521968 523008 527309 531383 532509 532971 541061 555469 565510 567621 571130 579865 583744 585141 588727 588865 591719 591956 619752 626015 644447 670197 677332 680589 703781 714082 715638 716967 720012 728905 730079 730166 732176 733573 733724 735987 744576 744824 747962 749972 753153 755568 757166 758659 759909 763526 766365 767292 771914 771931 773240 773451 773601 775313 781121 784003 784155 785601 786649 787648 790100 791870 793038 793052 793054 795875 795907 801395 805255 808044 810394 813410 814272 814289 820644 822295 825584 825617 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм pussy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм pussy"
]
|
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.