Query Metrics
7
Database Queries
7
Different statements
177.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.50 ms (86.10%) |
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 397872 421841 422168 423917 428131 429905 435550 435551 435599 439821 440222 443883 452318 453208 457143 464210 466178 467555 467872 470090 475883 476164 480004 480886 485156 490964 491579 496061 496076 497269 504182 512718 518264 525112 532204 535385 537965 538002 553757 554235 554992 555048 556341 561980 592161 604269 623295 633896 645761 651974 654878 654901 655163 655212 656286 656901 657145 658826 661656 663247 672272 680275 680437 681929 690517 693367 696923 701307 707662 715700 715887 717712 724059 727738 742112 742951 743961 748075 757180 758882 760899 761129 761748 761761 762764 767154 767273 769291 774698 776271 776972 779728 780849 783864 785613 788057 788170 790494 790834 793440 794344 795920 796252 807032 807059 809306 810378 811843 812829 813883 814490 814998 817155 817270 817339 824329 826316 827385 827487 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (8.44%) |
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 790494 817339 817155 807032 680437 654901 561980 604269 663247 769291 496076 553757 655163 715700 774698 795920 727738 742112 748075 767154 762764 760899 761761 717712 809306 496061 518264 827385 827487 824329 655212 793440 758882 767273 680275 788170 592161 743961 757180 537965 443883 452318 421841 439821 440222 457143 464210 532204 645761 651974 672272 707662 656286 657145 661656 690517 696923 724059 491579 776972 701307 476164 556341 555048 480886 429905 480004 423917 435550 538002 827870 693367 826316 785613 779728 783864 742951 813883 633896 435551 453208 554992 466178 525112 554235 422168 467872 475883 428131 435599 497269 504182 535385 654878 658826 814490 814998 485156 470090 512718 715887 780849 788057 796252 807059 810378 761748 817270 776271 812829 811843 790834 794344 467555 490964 761129 656901 681929 623295 397872 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.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 397872 421841 422168 423917 428131 429905 435550 435551 435599 439821 440222 443883 452318 453208 457143 464210 466178 467555 467872 470090 475883 476164 480004 480886 485156 490964 491579 496061 496076 497269 504182 512718 518264 525112 532204 535385 537965 538002 553757 554235 554992 555048 556341 561980 592161 604269 623295 633896 645761 651974 654878 654901 655163 655212 656286 656901 657145 658826 661656 663247 672272 680275 680437 681929 690517 693367 696923 701307 707662 715700 715887 717712 724059 727738 742112 742951 743961 748075 757180 758882 760899 761129 761748 761761 762764 767154 767273 769291 774698 776271 776972 779728 780849 783864 785613 788057 788170 790494 790834 793440 794344 795920 796252 807032 807059 809306 810378 811843 812829 813883 814490 814998 817155 817270 817339 824329 826316 827385 827487 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette anal homemade"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.