Query Metrics
7
Database Queries
7
Different statements
179.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.33 ms (83.97%) |
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 16808 233292 233667 381951 382724 385386 387296 388604 388712 394409 395874 396954 396969 397220 397227 407810 409945 411621 412985 446628 453097 454253 459830 465592 466885 466986 474409 474870 475039 476233 476282 479765 480731 486821 512046 518826 518874 519152 525488 534581 537148 542761 549238 552061 554519 582784 591132 592791 604048 610067 621400 623477 663451 663485 663893 663935 664793 664956 665115 665195 665305 665391 665419 665440 665479 665486 665499 665895 666153 667273 667290 667294 667484 667578 667669 667876 670471 670501 699804 712820 712822 712826 712828 714145 714155 721454 735442 739709 742695 746006 748225 752977 755684 759658 776312 780625 780702 781646 781657 781679 781693 781748 781760 782256 784248 788285 789215 789407 789530 794656 801822 802439 806241 807626 817393 820284 820313 824900 825036 825238 ] |
||||||||||||||||||||||||||||||
|
17.90 ms (10.00%) |
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 781748 784248 789530 781679 788285 807626 667290 712822 407810 610067 604048 381951 474409 446628 759658 670471 665486 825036 475039 534581 582784 663451 542761 665305 396969 519152 667294 663935 664793 667876 714145 592791 780702 781760 409945 518874 388712 776312 820313 537148 665479 666153 721454 665419 780625 781693 806241 755684 714155 667578 665440 667273 801822 233667 802439 735442 233292 382724 699804 712820 746006 395874 752977 412985 794656 748225 712826 712828 411621 820284 824900 663893 664956 667484 670501 385386 466986 663485 591132 480731 479765 554519 453097 454253 465592 476233 518826 476282 486821 459830 825238 817393 665115 665195 665499 665391 665895 621400 789215 781657 789407 739709 623477 782256 16808 466885 388604 474870 394409 667669 742695 781646 525488 552061 396954 512046 549238 397220 387296 397227 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (2.02%) |
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 16808 233292 233667 381951 382724 385386 387296 388604 388712 394409 395874 396954 396969 397220 397227 407810 409945 411621 412985 446628 453097 454253 459830 465592 466885 466986 474409 474870 475039 476233 476282 479765 480731 486821 512046 518826 518874 519152 525488 534581 537148 542761 549238 552061 554519 582784 591132 592791 604048 610067 621400 623477 663451 663485 663893 663935 664793 664956 665115 665195 665305 665391 665419 665440 665479 665486 665499 665895 666153 667273 667290 667294 667484 667578 667669 667876 670471 670501 699804 712820 712822 712826 712828 714145 714155 721454 735442 739709 742695 746006 748225 752977 755684 759658 776312 780625 780702 781646 781657 781679 781693 781748 781760 782256 784248 788285 789215 789407 789530 794656 801822 802439 806241 807626 817393 820284 820313 824900 825036 825238 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny young sex"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny young секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"granny young секс"
]
|
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.