Query Metrics
7
Database Queries
7
Different statements
200.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.04 ms (83.99%) |
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 390519 416252 421010 426719 431730 438018 443784 443790 443982 446659 447400 448074 449170 453511 454731 457789 458536 462155 464528 465191 466268 466554 467703 470150 470483 470607 470987 478818 482674 483371 484675 484681 484719 486130 487719 489281 489691 490684 490729 491119 492597 492608 497587 498269 498306 499010 501779 502422 502477 503965 508497 509033 514455 514644 514815 514949 516121 516123 516875 517190 517869 520440 521813 521985 522317 522328 522999 523306 523416 525871 525946 527573 543960 546766 548569 549579 552120 552268 552585 555681 556851 557943 557948 558344 562247 562815 566664 574776 576343 576399 582189 582811 586539 590860 597813 603536 609154 611462 617658 618017 625378 625556 652263 653325 653492 676911 677060 678556 679109 693269 714503 718698 718798 730914 749981 766146 784315 786552 807497 811133 ] |
||||||||||||||||||||||||||||||
|
15.67 ms (7.83%) |
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 484719 502477 503965 523306 489691 492597 558344 566664 543960 552585 679109 714503 718698 590860 807497 611462 416252 453511 470987 467703 527573 522999 501779 483371 514455 426719 556851 693269 749981 448074 458536 464528 466554 497587 498269 465191 548569 562815 576343 462155 470607 557943 490729 446659 508497 484681 730914 549579 617658 490684 603536 457789 521985 431730 557948 486130 514644 618017 625556 447400 454731 443784 484675 555681 576399 438018 516121 516875 517869 525871 509033 514815 520440 482674 676911 470150 443790 489281 522328 487719 502422 449170 466268 582189 582811 546766 491119 552268 516123 514949 653325 470483 390519 574776 525946 492608 552120 677060 586539 784315 421010 443982 678556 786552 517190 652263 521813 562247 718798 653492 625378 597813 811133 766146 609154 478818 522317 523416 498306 499010 ] |
||||||||||||||||||||||||||||||
|
9.41 ms (4.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русско жмж"
]
|
||||||||||||||||||||||||||||||
|
2.61 ms (1.31%) |
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 390519 416252 421010 426719 431730 438018 443784 443790 443982 446659 447400 448074 449170 453511 454731 457789 458536 462155 464528 465191 466268 466554 467703 470150 470483 470607 470987 478818 482674 483371 484675 484681 484719 486130 487719 489281 489691 490684 490729 491119 492597 492608 497587 498269 498306 499010 501779 502422 502477 503965 508497 509033 514455 514644 514815 514949 516121 516123 516875 517190 517869 520440 521813 521985 522317 522328 522999 523306 523416 525871 525946 527573 543960 546766 548569 549579 552120 552268 552585 555681 556851 557943 557948 558344 562247 562815 566664 574776 576343 576399 582189 582811 586539 590860 597813 603536 609154 611462 617658 618017 625378 625556 652263 653325 653492 676911 677060 678556 679109 693269 714503 718698 718798 730914 749981 766146 784315 786552 807497 811133 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.63%) |
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.