Query Metrics
7
Database Queries
7
Different statements
156.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.11 ms (82.51%) |
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 34353 206144 358566 389567 391574 396970 398209 407707 411324 413283 443165 443940 450647 450649 451465 453259 453272 453276 454050 454565 455003 455030 459236 460017 460237 460633 461010 461260 462557 463295 464968 465557 466051 466725 467838 469364 470018 470426 472799 474399 474456 475635 475637 475638 475858 476262 478100 479326 482249 482563 483537 486251 486867 491222 492302 493136 495007 496842 503843 509476 511277 513118 521721 522486 524286 524470 524655 524657 525862 526485 528090 528317 529197 530139 531955 533322 533991 535457 538282 538888 539464 539597 544325 549259 549740 550330 553189 555959 556511 557814 557817 560947 561589 567434 568337 568362 570809 572625 572650 574688 576662 580984 586130 591114 595842 596080 610172 634858 710445 712311 717689 726521 742656 744200 746604 749015 751678 808549 808556 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (10.20%) |
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 570809 746604 411324 610172 808556 413283 453259 472799 460237 450649 459236 492302 561589 531955 568337 749015 460017 466725 467838 550330 726521 751678 808549 206144 742656 389567 557817 557814 34353 464968 454050 475635 396970 486251 712311 358566 455003 443940 463295 539464 717689 744200 450647 454565 474456 539597 503843 526485 538888 475858 549259 482563 462557 443165 521721 567434 451465 407707 549740 469364 483537 475638 493136 710445 453276 455030 461260 453272 529197 478100 538282 465557 574688 553189 591114 461010 482249 513118 595842 486867 556511 572625 524657 568362 580984 470426 522486 474399 496842 533322 525862 524286 524470 544325 555959 586130 479326 391574 398209 470018 460633 576662 572650 511277 476262 466051 495007 824020 509476 634858 491222 528317 530139 528090 533991 535457 475637 560947 596080 524655 ] |
||||||||||||||||||||||||||||||
|
3.73 ms (2.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature мам женщин"
]
|
||||||||||||||||||||||||||||||
|
2.77 ms (1.77%) |
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 34353 206144 358566 389567 391574 396970 398209 407707 411324 413283 443165 443940 450647 450649 451465 453259 453272 453276 454050 454565 455003 455030 459236 460017 460237 460633 461010 461260 462557 463295 464968 465557 466051 466725 467838 469364 470018 470426 472799 474399 474456 475635 475637 475638 475858 476262 478100 479326 482249 482563 483537 486251 486867 491222 492302 493136 495007 496842 503843 509476 511277 513118 521721 522486 524286 524470 524655 524657 525862 526485 528090 528317 529197 530139 531955 533322 533991 535457 538282 538888 539464 539597 544325 549259 549740 550330 553189 555959 556511 557814 557817 560947 561589 567434 568337 568362 570809 572625 572650 574688 576662 580984 586130 591114 595842 596080 610172 634858 710445 712311 717689 726521 742656 744200 746604 749015 751678 808549 808556 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature mother"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.91%) |
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.