Query Metrics
7
Database Queries
7
Different statements
145.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
112.96 ms (77.59%) |
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 95668 305931 384147 390382 395701 397439 400865 403319 411813 417244 419518 419529 419539 420438 421580 421884 424658 426374 428136 432618 433359 435376 439676 439681 439815 440068 440963 441004 441106 441395 441413 441609 441994 442869 444003 444073 444890 446536 448636 448820 451504 452115 452297 453074 457445 457452 459645 459650 459963 460739 460773 461100 462125 463806 465337 465452 465551 465963 466869 467619 467893 467939 468072 468090 469407 469599 470169 470191 470197 470948 472701 473261 475224 475439 478411 480298 483624 484629 484664 489384 489758 490731 491601 493175 494826 495044 495225 497344 502868 512100 512913 513142 517071 517076 518264 519746 521138 521140 521843 523848 534704 535447 538001 538002 549822 550219 555023 555090 555140 558877 558894 563078 563641 565351 568344 604334 604409 607230 731030 775202 ] |
||||||||||||||||||||||||||||||
|
23.08 ms (15.85%) |
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 446536 453074 457445 470191 403319 465551 513142 538002 489384 490731 502868 512100 517071 523848 493175 495225 519746 475439 607230 480298 521843 452115 461100 460773 420438 469407 469599 465452 512913 465337 555090 563078 550219 568344 549822 555140 563641 400865 419539 428136 462125 467893 472701 475224 468090 470169 419518 424658 433359 444073 457452 470948 452297 518264 497344 521140 484664 521138 535447 483624 534704 538001 731030 441004 565351 604409 421580 390382 470197 439815 442869 468072 484629 439676 466869 439681 444890 460739 517076 494826 432618 435376 305931 441994 478411 459645 417244 95668 397439 411813 441609 426374 440963 441413 459650 459963 491601 495044 489758 463806 451504 467619 465963 444003 384147 441106 440068 448636 604334 775202 473261 441395 395701 448820 467939 558894 555023 558877 419529 421884 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.81%) |
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 95668 305931 384147 390382 395701 397439 400865 403319 411813 417244 419518 419529 419539 420438 421580 421884 424658 426374 428136 432618 433359 435376 439676 439681 439815 440068 440963 441004 441106 441395 441413 441609 441994 442869 444003 444073 444890 446536 448636 448820 451504 452115 452297 453074 457445 457452 459645 459650 459963 460739 460773 461100 462125 463806 465337 465452 465551 465963 466869 467619 467893 467939 468072 468090 469407 469599 470169 470191 470197 470948 472701 473261 475224 475439 478411 480298 483624 484629 484664 489384 489758 490731 491601 493175 494826 495044 495225 497344 502868 512100 512913 513142 517071 517076 518264 519746 521138 521140 521843 523848 534704 535447 538001 538002 549822 550219 555023 555090 555140 558877 558894 563078 563641 565351 568344 604334 604409 607230 731030 775202 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature женскийрод анал"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature bitch anal"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature женскийрод анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.07%) |
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.