Query Metrics
7
Database Queries
7
Different statements
202.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.63 ms (84.37%) |
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 14700 123862 188560 188610 233321 233532 361978 365910 382434 382802 383117 387377 388322 388470 388700 388719 388723 390566 390582 391077 391251 391576 391614 391668 392208 395891 396619 397304 397870 397873 397879 397905 397921 397937 398956 400513 403314 409310 411385 424430 426531 433353 439627 439658 439709 442987 443768 445056 451488 460672 461296 465540 466021 466088 466793 466877 466958 467940 468357 469375 470180 470275 471111 472690 472703 479126 483655 493103 493177 506067 508746 516483 536213 538006 538011 539487 549221 549851 552286 555290 555769 555779 563090 563209 563436 588077 591977 610473 695380 705640 710510 718552 720007 726585 727732 730360 731084 731482 734373 737164 739994 743780 748213 757277 759752 761597 765302 768195 776320 784305 793770 795540 796148 802463 803498 803522 804006 817347 825420 825585 ] |
||||||||||||||||||||||||||||||
|
22.46 ms (11.11%) |
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 233532 397937 391077 233321 397304 471111 468357 795540 825420 731084 398956 365910 433353 388470 361978 391251 445056 479126 802463 388719 382434 439658 391668 439627 426531 466958 424430 466877 470275 508746 588077 390582 451488 549221 552286 563090 591977 443768 397905 538006 483655 516483 538011 493177 188560 825585 472703 506067 469375 470180 563209 710510 720007 776320 803498 803522 793770 804006 727732 739994 748213 737164 757277 718552 188610 395891 439709 493103 14700 397879 388723 442987 390566 400513 397873 409310 563436 391576 387377 391614 382802 403314 466088 123862 460672 472690 466793 536213 539487 549851 734373 796148 761597 726585 765302 705640 388322 397921 465540 397870 461296 467940 388700 466021 743780 411385 396619 817347 555769 555779 695380 555290 610473 731482 768195 730360 759752 784305 383117 392208 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.30%) |
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 14700 123862 188560 188610 233321 233532 361978 365910 382434 382802 383117 387377 388322 388470 388700 388719 388723 390566 390582 391077 391251 391576 391614 391668 392208 395891 396619 397304 397870 397873 397879 397905 397921 397937 398956 400513 403314 409310 411385 424430 426531 433353 439627 439658 439709 442987 443768 445056 451488 460672 461296 465540 466021 466088 466793 466877 466958 467940 468357 469375 470180 470275 471111 472690 472703 479126 483655 493103 493177 506067 508746 516483 536213 538006 538011 539487 549221 549851 552286 555290 555769 555779 563090 563209 563436 588077 591977 610473 695380 705640 710510 718552 720007 726585 727732 730360 731084 731482 734373 737164 739994 743780 748213 757277 759752 761597 765302 768195 776320 784305 793770 795540 796148 802463 803498 803522 804006 817347 825420 825585 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature-mother"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature мам женщин"
]
|
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.