Query Metrics
7
Database Queries
7
Different statements
143.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.95 ms (82.62%) |
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 381887 480251 503061 507252 514282 530411 530994 531674 532220 535970 545034 550106 551930 554491 555713 557636 575833 582816 583686 594831 597896 598371 601221 607948 609686 621730 626111 628595 632386 635739 639376 645653 646090 646173 648394 649092 649348 649459 650717 651348 653684 672727 681776 683970 687409 687435 710355 712183 713401 714888 715179 717473 718117 718118 719309 720521 721707 727229 739938 740120 740663 744777 745772 746219 747173 748433 751397 759010 759617 773853 784762 789268 793781 795764 796603 797329 800833 804587 811533 813673 814061 814430 814716 816759 817105 817196 817215 817638 818269 818286 818879 818891 819170 819171 819178 819284 819292 819377 819397 819398 819428 819473 820135 820376 823277 823545 824136 824350 824444 824707 825220 825393 825916 826284 826606 826647 826711 827341 827559 ] |
||||||||||||||||||||||||||||||
|
14.29 ms (9.93%) |
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 759010 784762 575833 632386 818879 503061 651348 712183 653684 601221 607948 621730 795764 811533 789268 746219 759617 745772 751397 710355 796603 744777 740663 793781 814061 545034 649092 598371 628595 804587 747173 797329 800833 727229 740120 773853 739938 748433 583686 381887 814430 817638 818269 819398 825916 826606 826647 826711 814716 816642 816759 817215 818891 819178 819377 824136 824444 824707 825393 817105 817196 818286 819170 819473 820376 823277 823545 826284 813673 819171 819284 819292 819397 819428 820135 824350 825220 827341 827559 480251 507252 530994 532220 530411 514282 531674 535970 550106 555713 557636 582816 551930 554491 646090 646173 648394 649348 683970 713401 719309 672727 681776 687435 714888 715179 720521 645653 649459 650717 687409 717473 718117 718118 721707 597896 594831 609686 626111 635739 639376 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (2.36%) |
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 381887 480251 503061 507252 514282 530411 530994 531674 532220 535970 545034 550106 551930 554491 555713 557636 575833 582816 583686 594831 597896 598371 601221 607948 609686 621730 626111 628595 632386 635739 639376 645653 646090 646173 648394 649092 649348 649459 650717 651348 653684 672727 681776 683970 687409 687435 710355 712183 713401 714888 715179 717473 718117 718118 719309 720521 721707 727229 739938 740120 740663 744777 745772 746219 747173 748433 751397 759010 759617 773853 784762 789268 793781 795764 796603 797329 800833 804587 811533 813673 814061 814430 814716 816759 817105 817196 817215 817638 818269 818286 818879 818891 819170 819171 819178 819284 819292 819377 819397 819398 819428 819473 820135 820376 823277 823545 824136 824350 824444 824707 825220 825393 825916 826284 826606 826647 826711 827341 827559 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife latina"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен латинская"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.