Query Metrics
7
Database Queries
7
Different statements
150.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.20 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 87363 197690 354333 385454 385547 389236 404272 480251 486645 549195 572383 572946 585273 632497 639986 672679 674101 701524 708407 712309 715549 715741 716611 716621 716710 716743 718349 723151 724579 726356 727431 727550 728176 728178 728184 728252 729230 729278 732598 734366 735385 736755 739602 742830 743711 746409 749145 750011 750377 752896 753428 756047 757262 757598 757937 758029 760263 760268 760340 761279 763090 763243 763704 768367 769360 775596 777690 777701 778803 780369 780372 780377 781434 783440 784690 787796 789125 791015 791579 792204 792519 793715 793759 793763 794976 795534 795885 798305 800056 800359 803272 806252 806484 809971 811346 812456 812514 813313 814205 817758 818029 819143 819714 819966 823255 823256 824093 824954 824977 825023 825848 825977 826006 826373 826374 826456 826489 826619 827267 ] |
||||||||||||||||||||||||||||||
|
11.45 ms (7.60%) |
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 806484 791579 795534 729230 757937 632497 819143 728176 734366 780372 792204 385454 825848 716611 718349 787796 811346 784690 814205 825023 826373 817758 780377 783440 749145 753428 715549 793759 812514 354333 824954 826619 826456 827267 715741 708407 639986 775596 727550 750377 728178 729278 736755 742830 728184 780369 795885 813313 404272 823255 825977 826489 826006 819966 712309 777690 781434 800359 760263 752896 763243 756047 757262 794976 389236 818029 823256 824977 819714 480251 549195 572383 572946 674101 585273 777701 793763 806252 812456 727431 760268 760340 763090 789125 792519 800056 728252 768367 769360 724579 765166 739602 758029 763704 732598 757598 761279 716710 778803 803272 385547 798305 750011 197690 716743 672679 793715 809971 726356 735385 743711 746409 791015 87363 826374 824093 486645 701524 716621 723151 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.53%) |
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 87363 197690 354333 385454 385547 389236 404272 480251 486645 549195 572383 572946 585273 632497 639986 672679 674101 701524 708407 712309 715549 715741 716611 716621 716710 716743 718349 723151 724579 726356 727431 727550 728176 728178 728184 728252 729230 729278 732598 734366 735385 736755 739602 742830 743711 746409 749145 750011 750377 752896 753428 756047 757262 757598 757937 758029 760263 760268 760340 761279 763090 763243 763704 768367 769360 775596 777690 777701 778803 780369 780372 780377 781434 783440 784690 787796 789125 791015 791579 792204 792519 793715 793759 793763 794976 795534 795885 798305 800056 800359 803272 806252 806484 809971 811346 812456 812514 813313 814205 817758 818029 819143 819714 819966 823255 823256 824093 824954 824977 825023 825848 825977 826006 826373 826374 826456 826489 826619 827267 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"face секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"face sex"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"face секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.97%) |
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.