Query Metrics
7
Database Queries
7
Different statements
167.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.09 ms (84.98%) |
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 615 32761 94927 185123 236419 263299 326164 330420 336547 366031 383376 389368 390380 392347 394045 396618 398491 399405 401509 401721 402043 404468 407637 411848 412663 419104 420481 420737 422310 422967 424831 425795 428804 429079 433517 444475 451660 455187 455213 455262 455273 455393 456637 458823 462284 463079 465471 466497 468738 470826 471782 473968 475009 475427 476998 478673 479986 481064 482921 483129 483394 483638 483880 485087 485317 485319 485337 485581 488564 488616 488926 489011 490284 493037 494975 495457 495901 497052 497054 497575 498116 498656 501051 502411 504679 505443 506749 507008 509368 509726 510028 511078 511312 513198 513439 514406 514489 516827 517149 522869 524161 524976 525358 525452 525565 525600 525619 526926 527588 528802 528918 529144 538563 543227 555807 571013 625880 648497 650955 659272 ] |
||||||||||||||||||||||||||||||
|
15.34 ms (9.17%) |
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 495457 659272 465471 401721 504679 497054 463079 475009 525358 498656 522869 494975 538563 422967 525452 482921 422310 407637 389368 420737 473968 524976 650955 392347 458823 481064 485087 509368 615 485337 390380 529144 528802 468738 507008 398491 462284 336547 424831 509726 404468 455393 425795 513198 525565 490284 511078 326164 412663 526926 455273 495901 488616 514406 399405 383376 330420 94927 32761 455262 466497 505443 470826 483638 497052 510028 525600 419104 648497 488564 236419 396618 485319 485317 625880 455213 514489 517149 511312 501051 528918 513439 433517 444475 478673 483880 488926 489011 479986 420481 483394 516827 571013 485581 543227 411848 497575 493037 555807 506749 524161 527588 394045 455187 428804 185123 498116 401509 429079 475427 402043 366031 263299 456637 471782 525619 476998 451660 502411 483129 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.96%) |
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 615 32761 94927 185123 236419 263299 326164 330420 336547 366031 383376 389368 390380 392347 394045 396618 398491 399405 401509 401721 402043 404468 407637 411848 412663 419104 420481 420737 422310 422967 424831 425795 428804 429079 433517 444475 451660 455187 455213 455262 455273 455393 456637 458823 462284 463079 465471 466497 468738 470826 471782 473968 475009 475427 476998 478673 479986 481064 482921 483129 483394 483638 483880 485087 485317 485319 485337 485581 488564 488616 488926 489011 490284 493037 494975 495457 495901 497052 497054 497575 498116 498656 501051 502411 504679 505443 506749 507008 509368 509726 510028 511078 511312 513198 513439 514406 514489 516827 517149 522869 524161 524976 525358 525452 525565 525600 525619 526926 527588 528802 528918 529144 538563 543227 555807 571013 625880 648497 650955 659272 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс в большой член"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.82%) |
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.