Query Metrics
7
Database Queries
7
Different statements
149.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.45 ms (84.04%) |
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 414253 416448 416580 416597 416613 416632 427339 437368 438532 449406 449930 458678 464852 465148 466639 467097 468949 476689 483522 483737 485472 488820 493443 495467 509168 521682 526444 528657 533286 536641 541421 542097 544831 545379 545445 546129 547470 549520 550925 552704 552710 553732 553964 564102 564500 574664 577520 583689 584362 584999 586876 587312 588362 588436 590803 594136 595189 596935 598814 600936 601194 602430 605219 607520 609889 621503 622982 628095 632887 643226 655010 657244 662165 663158 669018 678707 679491 691259 696593 697627 709693 720140 728567 736561 738081 738926 739142 749255 751285 752623 752704 757466 758335 760220 760558 765172 769023 774878 776031 779295 782839 783036 784744 791206 791212 793923 796646 797010 797326 798291 801315 806584 806815 807173 808331 808962 809371 812612 816126 821790 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (9.45%) |
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 586876 709693 549520 697627 621503 760220 797010 414253 416597 509168 678707 541421 553732 564102 564500 550925 663158 655010 662165 679491 720140 546129 552710 602430 632887 776031 783036 791212 736561 738926 765172 752623 757466 749255 760558 609889 784744 791206 809371 438532 533286 769023 416580 458678 449406 468949 536641 528657 485472 545379 544831 669018 577520 605219 752704 796646 798291 467097 816126 779295 751285 483737 552704 465148 416448 657244 691259 598814 600936 728567 416632 427339 416613 584999 449930 493443 526444 583689 542097 547470 574664 545445 584362 553964 587312 590803 588362 588436 808331 437368 466639 495467 521682 488820 797326 821790 622982 801315 738081 739142 628095 596935 601194 808962 758335 812612 483522 464852 476689 696593 595189 643226 594136 607520 806815 807173 774878 782839 793923 806584 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.89%) |
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 414253 416448 416580 416597 416613 416632 427339 437368 438532 449406 449930 458678 464852 465148 466639 467097 468949 476689 483522 483737 485472 488820 493443 495467 509168 521682 526444 528657 533286 536641 541421 542097 544831 545379 545445 546129 547470 549520 550925 552704 552710 553732 553964 564102 564500 574664 577520 583689 584362 584999 586876 587312 588362 588436 590803 594136 595189 596935 598814 600936 601194 602430 605219 607520 609889 621503 622982 628095 632887 643226 655010 657244 662165 663158 669018 678707 679491 691259 696593 697627 709693 720140 728567 736561 738081 738926 739142 749255 751285 752623 752704 757466 758335 760220 760558 765172 769023 774878 776031 779295 782839 783036 784744 791206 791212 793923 796646 797010 797326 798291 801315 806584 806815 807173 808331 808962 809371 812612 816126 821790 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding dildo amateur"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding дилд любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding дилд любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 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.