Query Metrics
7
Database Queries
7
Different statements
152.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.04 ms (81.53%) |
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 13803 30958 212132 212914 213429 313222 321858 384461 389838 390899 406425 408734 441660 445036 445221 446704 507490 508578 514976 522954 525103 525305 534873 537678 539205 539241 543126 551052 556940 558082 574991 578431 580873 581834 584640 585107 591597 605537 606190 610923 611547 612991 613784 622947 629334 630259 636716 647415 649507 651873 661005 662872 665595 668122 669604 671070 671559 671779 680514 696601 710645 711005 713083 716118 716315 720051 721831 732473 735761 736714 739411 750389 751106 757276 759871 761174 761773 766266 767120 767185 774936 776774 778824 782401 784434 785515 785688 785755 787557 788163 788337 791552 791747 795537 796593 796595 796612 796727 800558 801012 807758 808379 808388 808862 811117 812090 817062 817100 817961 820347 820760 821180 821329 821388 822551 822969 823336 ] |
||||||||||||||||||||||||||||||
|
19.31 ms (12.69%) |
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 321858 389838 390899 408734 820347 822551 817062 817100 821180 823336 815182 820760 821329 821388 822969 817961 539241 525103 534873 507490 574991 584640 558082 580873 543126 662872 671559 671779 680514 710645 720051 647415 711005 716315 668122 669604 721831 551052 581834 613784 591597 611547 612991 629334 605537 606190 636716 785515 791552 776494 785688 788337 796593 796727 801012 807758 808388 811117 812090 735761 739411 761773 782401 784434 788163 791747 795537 751106 767185 766525 767120 732473 759871 761174 750389 630259 713083 774936 776774 778824 785755 787557 800558 808862 212132 313222 213429 445036 13803 212914 585107 537678 525305 514976 556940 661005 622947 796612 796595 808379 766266 610923 384461 539205 716118 446704 30958 441660 757276 522954 578431 736714 445221 671070 508578 651873 406425 649507 665595 696601 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.43%) |
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 13803 30958 212132 212914 213429 313222 321858 384461 389838 390899 406425 408734 441660 445036 445221 446704 507490 508578 514976 522954 525103 525305 534873 537678 539205 539241 543126 551052 556940 558082 574991 578431 580873 581834 584640 585107 591597 605537 606190 610923 611547 612991 613784 622947 629334 630259 636716 647415 649507 651873 661005 662872 665595 668122 669604 671070 671559 671779 680514 696601 710645 711005 713083 716118 716315 720051 721831 732473 735761 736714 739411 750389 751106 757276 759871 761174 761773 766266 767120 767185 774936 776774 778824 782401 784434 785515 785688 785755 787557 788163 788337 791552 791747 795537 796593 796595 796612 796727 800558 801012 807758 808379 808388 808862 811117 812090 817062 817100 817961 820347 820760 821180 821329 821388 822551 822969 823336 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass babe"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп babe"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп babe"
]
|
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.