Query Metrics
7
Database Queries
7
Different statements
177.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.78 ms (85.17%) |
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 233292 364242 366296 382057 383700 384581 388113 392277 395584 395909 396954 396956 401225 403600 413112 413136 415567 421132 421826 421853 421854 421865 421882 421887 421889 421914 421942 422181 422194 422198 422209 422345 424032 424274 424276 426865 427536 428454 428910 429564 433070 433249 433359 433376 439569 439738 443166 443182 443188 446276 446277 448166 448955 454050 457187 458731 460555 464189 464805 465316 466368 472166 472299 472679 472691 476904 486251 493179 493185 493195 493247 505973 508450 509050 511790 512455 513143 513145 516829 521137 521391 523838 524876 528347 531993 531995 532055 532058 532116 532135 550642 550990 554897 561587 563423 565012 568367 581893 602707 609823 612574 620245 623226 639225 661991 685068 687940 702312 723597 732140 742638 746242 746267 758023 758564 779903 782168 793282 809307 821762 ] |
||||||||||||||||||||||||||||||
|
16.66 ms (9.41%) |
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 550990 609823 531993 421887 782168 821762 532055 685068 421889 742638 758023 433359 532116 443188 421914 746242 433249 422198 422181 422194 433376 421826 388113 460555 532058 364242 493247 581893 758564 421882 403600 428910 422209 723597 779903 413112 446277 382057 568367 532135 687940 612574 809307 623226 793282 395909 413136 233292 429564 508450 472166 472691 421853 512455 439569 443182 464805 554897 565012 563423 620245 443166 424276 476904 421132 433070 392277 401225 454050 561587 732140 746267 457187 439738 421854 448955 493195 395584 396954 465316 486251 513143 513145 702312 661991 639225 428454 458731 511790 366296 422345 424032 464189 424274 466368 509050 524876 516829 521137 493179 523838 505973 521391 427536 384581 383700 396956 446276 448166 531995 550642 602707 472299 421865 426865 472679 493185 421942 415567 528347 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.71%) |
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 233292 364242 366296 382057 383700 384581 388113 392277 395584 395909 396954 396956 401225 403600 413112 413136 415567 421132 421826 421853 421854 421865 421882 421887 421889 421914 421942 422181 422194 422198 422209 422345 424032 424274 424276 426865 427536 428454 428910 429564 433070 433249 433359 433376 439569 439738 443166 443182 443188 446276 446277 448166 448955 454050 457187 458731 460555 464189 464805 465316 466368 472166 472299 472679 472691 476904 486251 493179 493185 493195 493247 505973 508450 509050 511790 512455 513143 513145 516829 521137 521391 523838 524876 528347 531993 531995 532055 532058 532116 532135 550642 550990 554897 561587 563423 565012 568367 581893 602707 609823 612574 620245 623226 639225 661991 685068 687940 702312 723597 732140 742638 746242 746267 758023 758564 779903 782168 793282 809307 821762 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son doggy mom"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son рак mom"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son рак mom"
]
|
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.