Query Metrics
7
Database Queries
7
Different statements
230.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.13 ms (88.28%) |
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 144343 389239 389788 390098 395675 398828 445577 456006 457975 467073 482115 484063 484183 490469 515008 517608 519189 521245 523898 529840 532770 537030 537128 540637 541456 542292 542517 543208 543500 557561 560523 567086 574073 583637 588492 590314 590447 593557 594905 601452 610483 615377 616178 620676 623397 623956 623964 624456 625765 627050 631020 633308 633360 638159 641886 646075 649533 649729 656123 658992 661678 663202 671366 672272 673782 674282 680771 685329 692762 694569 695347 696601 697843 699292 700724 709082 709615 710289 711946 717196 717336 718118 721260 724256 725451 727458 727732 728277 728285 729122 729337 733271 733307 734336 746530 746823 748955 749619 755407 755549 766926 771326 776887 788251 790194 792595 794356 795456 795654 801057 802597 803346 805260 806207 811045 811557 813291 814716 817765 824775 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (7.46%) |
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 721260 795654 638159 541456 624456 631020 824775 529840 590314 623964 794356 771326 398828 685329 663202 583637 656123 680771 557561 590447 625765 699292 542517 727458 728277 811557 389788 467073 728285 390098 560523 725451 484183 814716 532770 484063 649729 674282 694569 709615 649533 671366 673782 697843 710289 718118 615377 623956 633308 633360 594905 610483 623397 627050 806207 746823 755407 746530 766926 748955 749619 717196 790194 795456 692762 457975 803346 811045 519189 144343 389239 490469 540637 537030 711946 695347 696601 700724 593557 620676 727732 729337 724256 733307 734336 717336 788251 792595 515008 517608 574073 601452 805260 813291 482115 523898 537128 658992 567086 641886 733271 709082 661678 776887 729122 817765 542292 616178 802597 755549 395675 521245 445577 543208 543500 672272 646075 456006 588492 801057 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.13%) |
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 144343 389239 389788 390098 395675 398828 445577 456006 457975 467073 482115 484063 484183 490469 515008 517608 519189 521245 523898 529840 532770 537030 537128 540637 541456 542292 542517 543208 543500 557561 560523 567086 574073 583637 588492 590314 590447 593557 594905 601452 610483 615377 616178 620676 623397 623956 623964 624456 625765 627050 631020 633308 633360 638159 641886 646075 649533 649729 656123 658992 661678 663202 671366 672272 673782 674282 680771 685329 692762 694569 695347 696601 697843 699292 700724 709082 709615 710289 711946 717196 717336 718118 721260 724256 725451 727458 727732 728277 728285 729122 729337 733271 733307 734336 746530 746823 748955 749619 755407 755549 766926 771326 776887 788251 790194 792595 794356 795456 795654 801057 802597 803346 805260 806207 811045 811557 813291 814716 817765 824775 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock big ass"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock большая большие жоп"
]
|
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.