Query Metrics
7
Database Queries
7
Different statements
210.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.37 ms (86.55%) |
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 6656 96200 96495 114712 153869 156525 184985 191019 191117 191189 192888 194224 229483 233179 239677 265746 326207 359062 370829 381882 382542 382619 382702 383105 383109 383326 383409 383527 384423 384774 385258 385381 385688 385953 385963 386288 386405 386746 386865 387470 387860 388223 388825 389004 389028 389351 389829 389864 390306 390427 390717 390775 390914 391517 394420 395695 395933 396399 396561 396706 396729 396988 397218 397859 397908 398039 398531 398946 399627 400148 400826 404340 409117 411071 411330 416382 417847 418363 420788 425218 428834 437474 447865 449231 449363 450389 451470 452397 454681 462224 462309 463214 463834 465538 465559 467638 471814 473650 487775 488008 499356 499369 518727 536814 539906 543266 549751 549753 549933 580261 601062 604457 609597 611551 625808 670773 804498 809525 818277 818325 ] |
||||||||||||||||||||||||||||||
|
18.86 ms (8.95%) |
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 398039 417847 451470 6656 387860 391517 396988 397859 467638 385953 397908 399627 409117 420788 425218 499356 499369 488008 385258 184985 449231 625808 370829 463834 471814 385963 383109 96200 383105 384774 386865 191117 229483 156525 359062 326207 382619 382702 389028 388223 390306 390914 390775 396561 396706 396729 411071 818277 818325 450389 452397 462309 454681 462224 539906 518727 536814 465538 465559 473650 543266 670773 549751 549933 580261 601062 604457 611551 609597 809525 804498 191019 381882 390427 395933 463214 192888 194224 233179 385381 389351 389864 394420 411330 384423 398531 398946 191189 487775 404340 418363 437474 447865 549753 389829 400148 400826 416382 114712 449363 385688 386288 386405 383527 383326 383409 386746 239677 153869 395695 265746 382542 96495 388825 389004 390717 387470 396399 397218 428834 ] |
||||||||||||||||||||||||||||||
|
3.02 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 6656 96200 96495 114712 153869 156525 184985 191019 191117 191189 192888 194224 229483 233179 239677 265746 326207 359062 370829 381882 382542 382619 382702 383105 383109 383326 383409 383527 384423 384774 385258 385381 385688 385953 385963 386288 386405 386746 386865 387470 387860 388223 388825 389004 389028 389351 389829 389864 390306 390427 390717 390775 390914 391517 394420 395695 395933 396399 396561 396706 396729 396988 397218 397859 397908 398039 398531 398946 399627 400148 400826 404340 409117 411071 411330 416382 417847 418363 420788 425218 428834 437474 447865 449231 449363 450389 451470 452397 454681 462224 462309 463214 463834 465538 465559 467638 471814 473650 487775 488008 499356 499369 518727 536814 539906 543266 549751 549753 549933 580261 601062 604457 609597 611551 625808 670773 804498 809525 818277 818325 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf мускулистые"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf мускулистые"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf muscle"
]
|
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.