Query Metrics
7
Database Queries
7
Different statements
375.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.83 ms (54.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
149.72 ms (39.89%) |
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 444306 463189 473278 473962 538063 539798 554848 558264 559420 561604 575419 576574 582022 589652 599211 599773 600288 602048 606123 619242 634456 636469 637608 638811 652890 661377 665081 666201 671173 672217 672319 672836 679281 688173 692677 692695 694102 694174 697668 702914 710884 717976 718021 718033 726138 729172 730271 733734 734151 735126 736009 736961 738540 740224 740722 741609 742089 742822 743718 745178 745295 745514 745908 746968 747252 749554 749561 750283 750358 750640 752074 752476 752855 754714 756749 757500 759050 760089 760460 762048 762253 762792 765537 765954 767718 768088 768505 768515 769097 769343 770529 772435 777106 777911 778002 778183 779692 779882 780793 781382 784660 784888 785709 788624 788871 792405 793045 794422 794605 796849 799741 802044 803795 808507 810436 811901 813114 813331 819083 824710 ] |
||||||||||||||||||||||||||||||
|
12.24 ms (3.26%) |
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 803795 810436 777106 777911 778002 778183 794605 799741 733734 735126 750358 752074 762792 765954 781382 784660 784888 785709 794422 796849 811901 730271 734151 740722 745295 749561 752855 762253 767718 768515 738540 749554 750640 759050 762048 769097 770529 729172 743718 745178 747252 752476 756749 760089 726138 742089 750283 754714 637608 717976 718033 779882 788871 793045 802044 473278 558264 772435 694174 819083 539798 538063 575419 582022 652890 692677 718021 554848 576574 599773 634456 636469 780793 788624 779692 792405 741609 757500 769343 745514 768088 736961 745908 661377 666201 672836 688173 638811 463189 473962 694102 602048 824710 559420 665081 672319 589652 599211 606123 808507 742822 760460 768505 736009 765537 444306 692695 561604 813114 740224 746968 710884 672217 702914 671173 679281 697668 619242 600288 813331 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.63%) |
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 444306 463189 473278 473962 538063 539798 554848 558264 559420 561604 575419 576574 582022 589652 599211 599773 600288 602048 606123 619242 634456 636469 637608 638811 652890 661377 665081 666201 671173 672217 672319 672836 679281 688173 692677 692695 694102 694174 697668 702914 710884 717976 718021 718033 726138 729172 730271 733734 734151 735126 736009 736961 738540 740224 740722 741609 742089 742822 743718 745178 745295 745514 745908 746968 747252 749554 749561 750283 750358 750640 752074 752476 752855 754714 756749 757500 759050 760089 760460 762048 762253 762792 765537 765954 767718 768088 768505 768515 769097 769343 770529 772435 777106 777911 778002 778183 779692 779882 780793 781382 784660 784888 785709 788624 788871 792405 793045 794422 794605 796849 799741 802044 803795 808507 810436 811901 813114 813331 819083 824710 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation amateur"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац любительск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
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.