Query Metrics
7
Database Queries
7
Different statements
164.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.72 ms (83.36%) |
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 192968 365989 385591 391380 396305 396662 397273 397421 397883 399176 399694 403356 407296 407324 408299 409640 410393 410861 412401 412618 413842 415151 417796 419111 419382 421872 422345 423155 425462 430777 437336 439743 439809 446294 447746 448818 450158 450776 451423 452421 454668 457575 458011 459398 459584 460191 460465 465789 465821 466890 466952 467121 467285 467662 467663 470289 472788 474778 475283 475318 476274 478760 478824 478985 480238 480383 481668 482277 482339 486730 492138 499744 504997 505518 508431 515511 515768 518856 518968 528849 543923 546687 546951 547776 547779 547802 547809 548907 554551 554981 555825 556010 556021 557473 557522 557969 559079 559979 561113 563436 564645 565859 568732 569166 569972 569994 571232 571254 572769 573468 578496 578821 589139 590546 592299 598483 615728 665728 779591 800209 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (10.10%) |
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 451423 454668 458011 459398 467121 467662 474778 480238 480383 518856 504997 515511 515768 499744 508431 518968 505518 528849 460465 467663 476274 482339 486730 492138 546951 547779 547809 557969 559079 571254 572769 578496 543923 547802 548907 559979 563436 564645 569972 554551 554981 557522 561113 568732 578821 665728 546687 547776 555825 556010 556021 557473 565859 569166 569994 571232 573468 589139 615728 592299 598483 590546 779591 800209 397273 397421 397883 399694 403356 407296 407324 409640 410393 410861 412401 419111 422345 423155 430777 439743 447746 448818 457575 459584 467285 472788 475318 478760 478985 192968 365989 396305 399176 413842 419382 425462 437336 439809 446294 450158 450776 452421 460191 465789 465821 466890 466952 470289 475283 478824 481668 482277 385591 391380 396662 408299 412618 415151 417796 421872 ] |
||||||||||||||||||||||||||||||
|
3.21 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 192968 365989 385591 391380 396305 396662 397273 397421 397883 399176 399694 403356 407296 407324 408299 409640 410393 410861 412401 412618 413842 415151 417796 419111 419382 421872 422345 423155 425462 430777 437336 439743 439809 446294 447746 448818 450158 450776 451423 452421 454668 457575 458011 459398 459584 460191 460465 465789 465821 466890 466952 467121 467285 467662 467663 470289 472788 474778 475283 475318 476274 478760 478824 478985 480238 480383 481668 482277 482339 486730 492138 499744 504997 505518 508431 515511 515768 518856 518968 528849 543923 546687 546951 547776 547779 547802 547809 548907 554551 554981 555825 556010 556021 557473 557522 557969 559079 559979 561113 563436 564645 565859 568732 569166 569972 569994 571232 571254 572769 573468 578496 578821 589139 590546 592299 598483 615728 665728 779591 800209 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom bitch"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"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.