Query Metrics
7
Database Queries
7
Different statements
180.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.52 ms (85.72%) |
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 186993 386214 388838 396780 406072 417520 418564 430014 438363 445655 448396 448993 452619 454870 454992 455386 459896 463755 465369 465741 467837 468862 471419 472778 480223 481533 483982 484836 485492 486271 489127 497022 497331 501699 501713 502832 509530 512352 512722 513581 515849 516660 525971 526373 531949 533004 538062 538332 538912 543502 550536 553125 555507 556996 557173 557770 574267 578571 583497 590144 590917 594825 599386 600482 601024 607367 609412 610097 612057 622681 624280 625206 625236 625250 626535 627820 639984 643315 659284 660582 664260 665210 665394 677892 689595 690961 701649 702364 702446 705669 715816 715833 718203 720176 724488 727143 728605 729264 734466 740154 740790 741803 742843 747223 748159 748226 750790 772123 772681 773228 777526 781980 793851 794929 794933 794978 797883 808908 811054 811271 ] |
||||||||||||||||||||||||||||||
|
12.23 ms (6.78%) |
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 811054 727143 728605 740154 741803 748226 772681 794933 797883 748159 750790 715816 718203 781980 468862 497331 486271 483982 386214 724488 607367 484836 463755 659284 690961 664260 689595 553125 639984 612057 625236 740790 622681 660582 459896 448993 509530 485492 583497 625206 626535 808908 729264 734466 742843 720176 465369 515849 501713 454992 452619 455386 186993 388838 406072 417520 418564 578571 610097 773228 454870 465741 430014 445655 574267 550536 438363 624280 599386 777526 701649 702446 513581 600482 601024 625250 481533 489127 502832 543502 590144 627820 772123 811271 609412 793851 526373 497022 557173 677892 665210 557770 715833 448396 467837 512352 501699 396780 471419 531949 538062 516660 525971 533004 538912 512722 538332 472778 480223 555507 556996 665394 705669 702364 594825 643315 590917 794978 794929 747223 ] |
||||||||||||||||||||||||||||||
|
4.98 ms (2.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.59%) |
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 186993 386214 388838 396780 406072 417520 418564 430014 438363 445655 448396 448993 452619 454870 454992 455386 459896 463755 465369 465741 467837 468862 471419 472778 480223 481533 483982 484836 485492 486271 489127 497022 497331 501699 501713 502832 509530 512352 512722 513581 515849 516660 525971 526373 531949 533004 538062 538332 538912 543502 550536 553125 555507 556996 557173 557770 574267 578571 583497 590144 590917 594825 599386 600482 601024 607367 609412 610097 612057 622681 624280 625206 625236 625250 626535 627820 639984 643315 659284 660582 664260 665210 665394 677892 689595 690961 701649 702364 702446 705669 715816 715833 718203 720176 724488 727143 728605 729264 734466 740154 740790 741803 742843 747223 748159 748226 750790 772123 772681 773228 777526 781980 793851 794929 794933 794978 797883 808908 811054 811271 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits sucking"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон sucking"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон sucking"
]
|
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.