Query Metrics
7
Database Queries
7
Different statements
181.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.86 ms (86.52%) |
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 39151 172685 346210 384338 385838 388767 388770 389893 391489 391505 391584 391978 397776 397905 411421 417067 417293 420577 420736 440651 443436 444147 447478 457241 462278 465944 466974 470090 470101 470591 471545 474074 474215 478924 483969 491071 491888 494598 497585 499994 509426 509491 516323 516923 543574 543711 547961 563599 578348 578937 597548 597560 598028 598591 600098 604116 617651 617657 618135 626483 650298 651906 666611 673170 683269 685466 685523 685524 697251 697507 710364 717662 720649 720652 722650 722984 725167 729205 741931 742144 748893 752725 755633 757737 758182 760512 760520 761607 761618 761675 762219 762258 764173 764821 766011 766460 768042 777911 778380 779255 780484 782307 784326 787189 788028 791709 791924 792873 794069 795329 796526 799847 803851 807275 809340 809551 809976 814339 ] |
||||||||||||||||||||||||||||||
|
14.47 ms (7.98%) |
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 499994 385838 420736 474215 543711 584655 578937 666611 650298 683269 597548 597560 780484 777911 791709 803851 791924 794069 411421 447478 509491 397776 752725 478924 470101 543574 547961 563599 720649 673170 697251 598028 598591 626483 787189 807275 809976 782307 799847 760520 805492 742144 766460 748893 757737 617657 784326 795329 809340 172685 391978 384338 39151 389893 440651 465944 391584 470090 578348 685466 710364 685524 722650 600098 618135 792873 809551 779255 796526 725167 762258 762219 766011 729205 768042 741931 760512 758182 761607 761675 764173 604116 617651 720652 778380 388767 443436 391489 420577 417293 466974 491071 346210 462278 509426 483969 491888 494598 391505 516923 388770 397905 444147 457241 497585 417067 651906 717662 764821 471545 814339 474074 516323 470591 685523 722984 697507 788028 755633 761618 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.53%) |
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 39151 172685 346210 384338 385838 388767 388770 389893 391489 391505 391584 391978 397776 397905 411421 417067 417293 420577 420736 440651 443436 444147 447478 457241 462278 465944 466974 470090 470101 470591 471545 474074 474215 478924 483969 491071 491888 494598 497585 499994 509426 509491 516323 516923 543574 543711 547961 563599 578348 578937 597548 597560 598028 598591 600098 604116 617651 617657 618135 626483 650298 651906 666611 673170 683269 685466 685523 685524 697251 697507 710364 717662 720649 720652 722650 722984 725167 729205 741931 742144 748893 752725 755633 757737 758182 760512 760520 761607 761618 761675 762219 762258 764173 764821 766011 766460 768042 777911 778380 779255 780484 782307 784326 787189 788028 791709 791924 792873 794069 795329 796526 799847 803851 807275 809340 809551 809976 814339 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian fuck"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
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.