Query Metrics
7
Database Queries
7
Different statements
167.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.14 ms (83.05%) |
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 365871 389150 389193 391557 391564 395378 423983 438736 442027 457001 464924 468344 471552 480796 481504 485343 486830 488466 490127 496555 496726 501068 502036 506486 506672 507158 510604 513811 530617 539930 542297 551660 551691 557794 558865 567600 571156 581257 583988 584003 584840 586075 595326 602432 613580 620938 624143 624969 625503 628671 634697 640233 641351 646052 653006 660340 662469 666677 668133 671906 673496 675494 675495 677265 682908 685372 687441 691182 692475 693789 693794 696297 697465 699828 703687 704034 704422 705139 707591 707604 710479 712653 716984 717412 723819 724027 727407 732793 734401 734620 736480 739071 740173 741723 748459 752131 758949 762380 768657 768745 771442 779266 780711 780802 781279 783630 787676 789466 790080 791490 793819 795130 797012 810384 811231 811599 813833 819334 819751 827432 ] |
||||||||||||||||||||||||||||||
|
18.09 ms (10.80%) |
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 513811 539930 502036 542297 557794 558865 571156 584840 671906 693789 699828 703687 716984 666677 677265 682908 685372 692475 697465 705139 712653 653006 668133 675494 707604 584003 625503 628671 634697 602432 624143 595326 641351 586075 620938 781279 793819 810384 811231 811599 779266 780711 797012 723819 724027 736480 758949 783630 787676 790080 791490 734401 734620 739071 740173 762380 768657 771442 727407 741723 768745 748459 613580 624969 707591 710479 780802 795130 365871 423983 468344 471552 480796 481504 496726 506486 490127 501068 391557 389193 464924 640233 752131 485343 691182 662469 789466 732793 389150 696297 704422 567600 395378 391564 438736 442027 819751 827432 813833 819334 486830 457001 507158 530617 506672 510604 496555 488466 551660 551691 581257 583988 646052 673496 675495 687441 693794 704034 717412 660340 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife couple"
]
|
||||||||||||||||||||||||||||||
|
2.23 ms (1.33%) |
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 365871 389150 389193 391557 391564 395378 423983 438736 442027 457001 464924 468344 471552 480796 481504 485343 486830 488466 490127 496555 496726 501068 502036 506486 506672 507158 510604 513811 530617 539930 542297 551660 551691 557794 558865 567600 571156 581257 583988 584003 584840 586075 595326 602432 613580 620938 624143 624969 625503 628671 634697 640233 641351 646052 653006 660340 662469 666677 668133 671906 673496 675494 675495 677265 682908 685372 687441 691182 692475 693789 693794 696297 697465 699828 703687 704034 704422 705139 707591 707604 710479 712653 716984 717412 723819 724027 727407 732793 734401 734620 736480 739071 740173 741723 748459 752131 758949 762380 768657 768745 771442 779266 780711 780802 781279 783630 787676 789466 790080 791490 793819 795130 797012 810384 811231 811599 813833 819334 819751 827432 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен couple"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен couple"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.02%) |
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.