Query Metrics
7
Database Queries
7
Different statements
159.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.70 ms (79.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 391754 417979 420654 423057 424214 424726 426093 427306 431476 435409 435629 437415 442680 444593 444851 445493 446311 447262 452463 452476 453731 454950 456516 456531 458886 459585 464732 469691 475195 475551 478510 481406 483050 483324 484541 487214 489176 489315 490071 490511 492133 494015 494039 495043 496562 497057 498149 500048 500441 501960 502242 502938 503322 504885 504955 506986 509454 514206 514740 514744 515344 516354 516969 517733 519184 519954 520065 520808 523430 526385 526911 528306 528363 528699 533207 534791 534815 536652 537346 540738 540748 541582 550099 550485 554420 556241 559629 560289 560946 562789 569253 571046 572211 575178 577685 578288 578323 578356 579881 580103 584705 585550 588684 588745 590623 594590 594846 595339 597864 597907 606774 609078 620330 623732 634588 634688 655456 664632 675449 678973 ] |
||||||||||||||||||||||||||||||
|
22.27 ms (13.97%) |
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 559629 562789 597907 678973 515344 541582 550485 458886 444593 426093 483050 454950 578288 424726 588684 475195 498149 502938 536652 580103 634688 597864 554420 496562 506986 489315 424214 519184 456531 634588 528306 560289 578356 437415 504885 516969 444851 519954 609078 490071 489176 606774 427306 500048 534815 459585 435409 520808 590623 494015 464732 503322 571046 453731 572211 514740 446311 456516 517733 495043 445493 569253 560946 528363 504955 588745 500441 452476 420654 490511 514744 523430 442680 585550 526911 584705 533207 579881 528699 423057 577685 514206 483324 452463 509454 664632 487214 478510 520065 675449 431476 578323 417979 494039 447262 595339 501960 435629 497057 484541 540738 469691 594590 502242 575178 550099 526385 655456 594846 481406 516354 620330 492133 540748 556241 623732 537346 475551 391754 534791 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.70%) |
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 391754 417979 420654 423057 424214 424726 426093 427306 431476 435409 435629 437415 442680 444593 444851 445493 446311 447262 452463 452476 453731 454950 456516 456531 458886 459585 464732 469691 475195 475551 478510 481406 483050 483324 484541 487214 489176 489315 490071 490511 492133 494015 494039 495043 496562 497057 498149 500048 500441 501960 502242 502938 503322 504885 504955 506986 509454 514206 514740 514744 515344 516354 516969 517733 519184 519954 520065 520808 523430 526385 526911 528306 528363 528699 533207 534791 534815 536652 537346 540738 540748 541582 550099 550485 554420 556241 559629 560289 560946 562789 569253 571046 572211 575178 577685 578288 578323 578356 579881 580103 584705 585550 588684 588745 590623 594590 594846 595339 597864 597907 606774 609078 620330 623732 634588 634688 655456 664632 675449 678973 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс девушки в маске"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс девушк в маск"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс девушк в маск"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.