Query Metrics
7
Database Queries
7
Different statements
160.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.24 ms (84.18%) |
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 197443 225591 229077 364620 384126 389264 390252 395252 396064 399062 399912 401190 403257 403283 404095 404117 405924 410177 417266 417388 417455 417547 418253 419895 421619 421940 422096 424011 425150 426788 427818 428041 429242 429930 431403 431765 432464 433679 435366 435559 436691 438748 438962 440963 441748 441800 442988 443994 444234 445428 446238 449514 449712 450446 451610 452211 452381 452967 453088 453321 454305 454701 454907 455085 459012 459824 460408 461208 461411 462232 463469 465918 465971 466734 466756 466786 467050 469180 469364 469502 470007 470027 470449 471412 471770 471975 472183 472814 472894 473542 475452 475605 476439 478517 479378 480624 484939 488235 496054 497324 501623 504781 507332 510785 512331 528465 528945 548304 549136 550237 551242 555967 555983 562292 577382 586645 598331 601511 601717 604541 ] |
||||||||||||||||||||||||||||||
|
15.81 ms (9.84%) |
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 433679 435559 410177 428041 436691 429242 440963 451610 459012 466786 469364 471770 473542 449514 453088 462232 466734 469502 470027 472183 472894 479378 454701 497324 507332 550237 551242 562292 577382 549136 598331 390252 417266 426788 432464 441748 444234 445428 469180 475605 404117 419895 421619 425150 435366 438962 442988 452211 452381 460408 461208 461411 466756 467050 471975 480624 396064 404095 418253 421940 454305 454907 459824 476439 225591 229077 364620 395252 403257 417455 427818 441800 450446 463469 431403 449712 465918 470007 472814 528945 528465 484939 488235 496054 510785 548304 601511 601717 446238 604541 443994 453321 452967 504781 471412 475452 555967 555983 586645 431765 417388 422096 465971 478517 455085 389264 470449 438748 512331 501623 384126 197443 399912 399062 401190 403283 405924 417547 424011 429930 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.66%) |
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 197443 225591 229077 364620 384126 389264 390252 395252 396064 399062 399912 401190 403257 403283 404095 404117 405924 410177 417266 417388 417455 417547 418253 419895 421619 421940 422096 424011 425150 426788 427818 428041 429242 429930 431403 431765 432464 433679 435366 435559 436691 438748 438962 440963 441748 441800 442988 443994 444234 445428 446238 449514 449712 450446 451610 452211 452381 452967 453088 453321 454305 454701 454907 455085 459012 459824 460408 461208 461411 462232 463469 465918 465971 466734 466756 466786 467050 469180 469364 469502 470007 470027 470449 471412 471770 471975 472183 472814 472894 473542 475452 475605 476439 478517 479378 480624 484939 488235 496054 497324 501623 504781 507332 510785 512331 528465 528945 548304 549136 550237 551242 555967 555983 562292 577382 586645 598331 601511 601717 604541 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"телки голые"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женскийрод голые"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.97%) |
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.