Query Metrics
7
Database Queries
7
Different statements
162.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.53 ms (84.82%) |
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 411829 413595 414433 416324 416773 419034 420587 420593 421357 421839 422394 422708 423427 423433 424360 425967 426117 426236 427187 427622 428933 429149 430349 433730 434212 435697 439203 442864 443107 443138 447855 449715 449721 453749 454099 454768 455430 456040 458692 459378 460669 461079 462545 462977 464699 466730 467088 468054 468531 469830 471810 472004 472991 473790 474553 477187 479916 479978 484084 485435 486023 486360 487448 492733 495120 497416 500566 502477 502644 503389 511782 512701 513732 517945 521132 521483 521901 522007 522383 522534 522999 525935 527008 528743 533258 541241 552343 557335 557542 561423 569312 585717 587263 587416 591589 593742 596550 598655 601193 602407 604092 605793 614027 614097 614747 615167 641901 713064 714883 729536 758891 766021 768013 791571 807340 808724 812790 814347 820173 821053 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (9.45%) |
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 533258 714883 713064 615167 808724 729536 768013 411829 413595 414433 420587 424360 500566 527008 460669 467088 614747 492733 421839 521132 423433 439203 419034 425967 428933 434212 416324 433730 443138 422708 423427 820173 814347 821053 468054 474553 484084 453749 454099 456040 459378 462977 466730 447855 449715 469830 473790 487448 511782 512701 528743 495120 522383 525935 471810 541241 557335 561423 569312 552343 557542 587263 596550 602407 605793 614097 585717 587416 591589 604092 614027 601193 593742 598655 807340 758891 766021 791571 812790 641901 426117 464699 472004 479978 416773 420593 422394 426236 454768 455430 461079 462545 479916 421357 430349 442864 443107 458692 427187 429149 468531 472991 477187 427622 435697 449721 503389 497416 502477 502644 517945 522999 485435 513732 521483 522534 486023 486360 521901 522007 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.60%) |
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 411829 413595 414433 416324 416773 419034 420587 420593 421357 421839 422394 422708 423427 423433 424360 425967 426117 426236 427187 427622 428933 429149 430349 433730 434212 435697 439203 442864 443107 443138 447855 449715 449721 453749 454099 454768 455430 456040 458692 459378 460669 461079 462545 462977 464699 466730 467088 468054 468531 469830 471810 472004 472991 473790 474553 477187 479916 479978 484084 485435 486023 486360 487448 492733 495120 497416 500566 502477 502644 503389 511782 512701 513732 517945 521132 521483 521901 522007 522383 522534 522999 525935 527008 528743 533258 541241 552343 557335 557542 561423 569312 585717 587263 587416 591589 593742 596550 598655 601193 602407 604092 605793 614027 614097 614747 615167 641901 713064 714883 729536 758891 766021 768013 791571 807340 808724 812790 814347 820173 821053 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy pov licking"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy пов лиза"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy пов лиза"
]
|
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.