Query Metrics
7
Database Queries
7
Different statements
376.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.01 ms (55.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло туалет мам женщин"
]
|
||||||||||||||||||||||||||||||
|
137.15 ms (36.45%) |
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 30791 62251 88591 131602 145218 382113 388425 390754 397173 414430 418566 420774 422406 446936 452816 454290 455640 460335 463509 463804 464064 465482 465583 466402 467096 473471 475289 477429 478520 478985 493229 493342 495879 497813 501476 505387 509019 513990 520148 523596 528536 529661 534975 535985 536298 537785 540129 540568 546316 548515 559358 560409 560678 560699 560912 567470 568211 569558 582765 583519 586975 590410 592219 596796 604121 605973 608047 618329 618619 628358 628655 632289 632750 634584 649440 651158 659015 660818 663286 664477 666116 667738 678758 689042 710379 726133 727976 738564 742318 750371 750387 751185 751609 752759 752944 761269 767718 774728 776544 781934 790109 794669 797345 797369 801794 802196 803529 804265 804829 805142 806984 808335 812284 812318 812542 812751 823771 823774 824112 826720 ] |
||||||||||||||||||||||||||||||
|
20.02 ms (5.32%) |
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 752759 632289 804265 390754 397173 823774 823771 824112 520148 529661 537785 497813 534975 540129 560678 548515 567470 568211 651158 664477 666116 659015 660818 667738 678758 560912 583519 604121 634584 628358 592219 781934 801794 803529 750371 761269 790109 812284 812318 726133 767718 751185 727976 420774 618619 590410 382113 30791 414430 477429 464064 454290 528536 559358 649440 569558 628655 632750 804829 802196 750387 463804 478520 465583 493342 752944 776544 505387 605973 710379 523596 62251 455640 465482 467096 495879 513990 463509 475289 546316 586975 596796 812542 794669 812751 742318 751609 418566 466402 509019 478985 422406 826720 535985 536298 540568 582765 618329 608047 774728 806984 808335 797369 805142 473471 88591 452816 460335 560409 493229 689042 663286 560699 797345 738564 446936 501476 145218 131602 388425 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (0.94%) |
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 30791 62251 88591 131602 145218 382113 388425 390754 397173 414430 418566 420774 422406 446936 452816 454290 455640 460335 463509 463804 464064 465482 465583 466402 467096 473471 475289 477429 478520 478985 493229 493342 495879 497813 501476 505387 509019 513990 520148 523596 528536 529661 534975 535985 536298 537785 540129 540568 546316 548515 559358 560409 560678 560699 560912 567470 568211 569558 582765 583519 586975 590410 592219 596796 604121 605973 608047 618329 618619 628358 628655 632289 632750 634584 649440 651158 659015 660818 663286 664477 666116 667738 678758 689042 710379 726133 727976 738564 742318 750371 750387 751185 751609 752759 752944 761269 767718 774728 776544 781934 790109 794669 797345 797369 801794 802196 803529 804265 804829 805142 806984 808335 812284 812318 812542 812751 823771 823774 824112 826720 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло туалет мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo toilet mother"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.40%) |
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.