Query Metrics
7
Database Queries
7
Different statements
186.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.24 ms (83.98%) |
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 202134 388411 391984 395682 396670 400043 400956 401262 403229 404777 405485 407878 410230 411045 413233 419320 419835 420219 421249 424414 424614 427115 428775 436719 443199 443333 443894 443953 444306 445433 445825 447257 448871 450371 451832 454813 456219 457701 459997 460631 461322 462799 462868 465302 467885 468061 469084 470565 471149 472216 473774 474496 475056 475760 476932 478437 485715 486192 488370 492192 493754 497691 498226 499904 500580 500915 501317 502089 503836 505804 505805 509821 511345 511387 511819 512882 518587 518763 526077 526089 526504 528275 531804 533594 533922 535384 541248 542502 543496 547241 549228 552687 555054 555329 555372 555407 555413 555752 556791 562825 565308 576214 579341 583501 583541 583866 591091 596321 597160 613004 618619 648056 658773 661915 668385 671650 687838 715368 789691 791550 ] |
||||||||||||||||||||||||||||||
|
18.51 ms (9.95%) |
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 460631 472216 473774 474496 476932 493754 500580 505805 518763 533594 533922 512882 535384 526089 552687 555407 556791 555372 648056 658773 715368 671650 687838 613004 591091 789691 403229 467885 388411 400956 419835 424414 443894 462868 457701 475760 509821 503836 528275 486192 501317 562825 405485 419320 459997 488370 475056 565308 443953 395682 396670 579341 543496 547241 555054 451832 511345 498226 444306 202134 400043 401262 404777 410230 421249 424614 428775 407878 420219 443199 411045 413233 436719 443333 445825 447257 450371 454813 461322 469084 492192 456219 478437 448871 462799 470565 485715 499904 511387 511819 518587 526077 502089 505804 526504 497691 500915 531804 465302 468061 549228 555413 541248 542502 583501 583866 555329 555752 583541 661915 668385 576214 597160 596321 618619 791550 391984 427115 445433 471149 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.89%) |
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 202134 388411 391984 395682 396670 400043 400956 401262 403229 404777 405485 407878 410230 411045 413233 419320 419835 420219 421249 424414 424614 427115 428775 436719 443199 443333 443894 443953 444306 445433 445825 447257 448871 450371 451832 454813 456219 457701 459997 460631 461322 462799 462868 465302 467885 468061 469084 470565 471149 472216 473774 474496 475056 475760 476932 478437 485715 486192 488370 492192 493754 497691 498226 499904 500580 500915 501317 502089 503836 505804 505805 509821 511345 511387 511819 512882 518587 518763 526077 526089 526504 528275 531804 533594 533922 535384 541248 542502 543496 547241 549228 552687 555054 555329 555372 555407 555413 555752 556791 562825 565308 576214 579341 583501 583541 583866 591091 596321 597160 613004 618619 648056 658773 661915 668385 671650 687838 715368 789691 791550 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anus hairy"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анус волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.