Query Metrics
7
Database Queries
7
Different statements
408.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.29 ms (51.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм mom"
]
|
||||||||||||||||||||||||||||||
|
167.21 ms (40.92%) |
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 415004 422208 425622 428116 439560 439799 442239 443646 446054 446633 450226 450641 463094 463305 466685 468631 468884 469566 470416 472743 474785 475833 478530 478832 480526 481173 486665 486706 488477 488538 491266 491273 494081 494516 496103 496835 497332 499787 500430 500562 501193 501474 507211 509660 511160 511812 512176 513155 513677 514709 514746 514757 515420 515934 516610 517587 517932 519549 521167 521206 521381 522016 522460 522604 522917 522925 523291 524257 524309 525087 527014 527065 527377 527916 528119 528297 530010 531419 532028 533450 533844 534334 536233 536335 536586 537595 540071 540562 544302 561107 561136 561140 561142 563844 565150 567347 572189 579205 580290 581882 596082 596900 600014 604369 605636 610692 617418 624290 632694 637413 638991 639706 644998 648252 648861 650851 678969 724823 784315 816086 ] |
||||||||||||||||||||||||||||||
|
20.30 ms (4.97%) |
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 463094 415004 439560 450226 450641 463305 443646 470416 472743 468884 481173 501193 514757 528119 491266 497332 513677 514746 525087 488477 488538 496835 507211 521167 523291 524257 527377 528297 533450 496103 527014 650851 600014 512176 532028 644998 816086 446054 474785 522925 530010 536335 513155 536586 514709 521206 466685 561140 561142 563844 565150 572189 581882 678969 648252 648861 561107 638991 596900 610692 617418 639706 596082 604369 784315 632694 446633 478530 480526 442239 425622 439799 475833 509660 511160 516610 515934 519549 522460 491273 515420 524309 494516 499787 501474 517587 522016 522604 522917 527916 567347 637413 500562 486665 494081 544302 428116 521381 534334 540562 537595 531419 536233 527065 533844 540071 580290 579205 561136 624290 605636 724823 469566 422208 468631 478832 511812 500430 517932 486706 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.76%) |
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 415004 422208 425622 428116 439560 439799 442239 443646 446054 446633 450226 450641 463094 463305 466685 468631 468884 469566 470416 472743 474785 475833 478530 478832 480526 481173 486665 486706 488477 488538 491266 491273 494081 494516 496103 496835 497332 499787 500430 500562 501193 501474 507211 509660 511160 511812 512176 513155 513677 514709 514746 514757 515420 515934 516610 517587 517932 519549 521167 521206 521381 522016 522460 522604 522917 522925 523291 524257 524309 525087 527014 527065 527377 527916 528119 528297 530010 531419 532028 533450 533844 534334 536233 536335 536586 537595 540071 540562 544302 561107 561136 561140 561142 563844 565150 567347 572189 579205 580290 581882 596082 596900 600014 604369 605636 610692 617418 624290 632694 637413 638991 639706 644998 648252 648861 650851 678969 724823 784315 816086 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm mom"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм mom"
]
|
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.