Query Metrics
7
Database Queries
7
Different statements
183.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.71 ms (86.37%) |
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 232978 382316 384147 390042 395381 397867 398651 410663 413404 435413 437668 441395 441413 441480 454090 456268 458013 459641 460763 468849 469982 472446 475317 478078 487724 490536 493630 495008 496730 509605 513511 514957 518619 522451 525905 534193 539275 541062 541678 541692 561703 564382 568357 572181 572960 577919 581249 584068 585993 586010 599889 604215 604229 605966 608121 608818 609973 616025 629744 630451 633286 635250 639957 640807 654439 655151 655186 656518 656621 656635 661987 666434 677624 680301 682320 683121 687137 689154 692817 695319 696568 700506 704241 712366 712374 723167 724050 724091 725416 728151 736830 739403 740849 744091 746070 746071 746090 746294 748064 756849 761712 763519 764284 765484 770292 770303 771613 778989 783144 785553 788827 788954 790869 791416 798639 798823 800531 809656 816607 822309 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (7.96%) |
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 513511 696568 656518 683121 577919 783144 785553 746071 756849 798639 724091 728151 739403 746090 661987 736830 816607 460763 454090 458013 568357 604229 468849 437668 509605 518619 522451 682320 395381 581249 689154 704241 585993 629744 604215 640807 788827 790869 724050 746294 798823 725416 761712 770303 382316 413404 441413 822309 490536 475317 514957 572960 541692 541062 655151 677624 700506 712374 687137 654439 656621 666434 680301 695319 712366 723167 608121 635250 630451 639957 778989 788954 748064 746070 764284 744091 765484 740849 770292 608818 791416 809656 441480 390042 469982 410663 616025 456268 534193 384147 435413 493630 459641 496730 495008 525905 472446 487724 541678 561703 564382 584068 656635 655186 572181 609973 633286 800531 771613 763519 232978 398651 441395 478078 397867 539275 692817 605966 586010 599889 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.86%) |
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 232978 382316 384147 390042 395381 397867 398651 410663 413404 435413 437668 441395 441413 441480 454090 456268 458013 459641 460763 468849 469982 472446 475317 478078 487724 490536 493630 495008 496730 509605 513511 514957 518619 522451 525905 534193 539275 541062 541678 541692 561703 564382 568357 572181 572960 577919 581249 584068 585993 586010 599889 604215 604229 605966 608121 608818 609973 616025 629744 630451 633286 635250 639957 640807 654439 655151 655186 656518 656621 656635 661987 666434 677624 680301 682320 683121 687137 689154 692817 695319 696568 700506 704241 712366 712374 723167 724050 724091 725416 728151 736830 739403 740849 744091 746070 746071 746090 746294 748064 756849 761712 763519 764284 765484 770292 770303 771613 778989 783144 785553 788827 788954 790869 791416 798639 798823 800531 809656 816607 822309 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen anal creampie"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen анал creampie"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen анал creampie"
]
|
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.