Query Metrics
7
Database Queries
7
Different statements
169.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.97 ms (82.66%) |
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 5565 14602 32549 96239 130060 154826 161351 189721 214138 287540 306045 336072 385003 385264 385836 386403 388144 392452 393486 393660 395456 395583 396365 396552 396556 396572 396575 396593 396724 396725 396781 397648 399320 399393 401070 401350 402153 402350 403293 404360 405916 407462 408331 408959 409452 410956 412941 414069 414129 414361 414434 415739 416048 417085 418202 418897 419404 421743 425892 429008 430429 431517 432020 433512 433516 433517 433549 433766 435715 443116 445946 453302 454028 456880 456991 457240 457494 458622 459012 459015 459229 460501 462050 462791 462802 464353 464862 465177 467105 467915 468064 468089 468423 468713 468738 472450 473343 475450 475630 475711 477070 480422 492246 496372 500621 510613 525948 533534 540141 547650 554525 565358 573704 585270 586692 595421 604478 615801 617420 621125 ] |
||||||||||||||||||||||||||||||
|
19.12 ms (11.29%) |
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 547650 533534 154826 96239 32549 14602 396593 401070 433512 472450 418202 385264 161351 414129 433766 418897 431517 464353 414434 468064 475711 408331 457240 214138 462050 388144 393486 432020 460501 396575 407462 409452 421743 433516 410956 435715 457494 459012 477070 467105 496372 554525 306045 392452 395456 396781 5565 396365 397648 336072 510613 189721 393660 404360 419404 408959 458622 468738 464862 565358 573704 585270 586692 595421 287540 396725 416048 414361 465177 525948 130060 396556 402153 402350 403293 405916 433517 415739 417085 425892 459015 454028 462802 480422 453302 456880 456991 475450 500621 473343 396572 396724 399393 468089 385836 396552 399320 401350 433549 459229 462791 395583 412941 468713 468423 617420 604478 615801 621125 540141 414069 443116 467915 492246 445946 429008 475630 430429 386403 385003 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.76%) |
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 5565 14602 32549 96239 130060 154826 161351 189721 214138 287540 306045 336072 385003 385264 385836 386403 388144 392452 393486 393660 395456 395583 396365 396552 396556 396572 396575 396593 396724 396725 396781 397648 399320 399393 401070 401350 402153 402350 403293 404360 405916 407462 408331 408959 409452 410956 412941 414069 414129 414361 414434 415739 416048 417085 418202 418897 419404 421743 425892 429008 430429 431517 432020 433512 433516 433517 433549 433766 435715 443116 445946 453302 454028 456880 456991 457240 457494 458622 459012 459015 459229 460501 462050 462791 462802 464353 464862 465177 467105 467915 468064 468089 468423 468713 468738 472450 473343 475450 475630 475711 477070 480422 492246 496372 500621 510613 525948 533534 540141 547650 554525 565358 573704 585270 586692 595421 604478 615801 617420 621125 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick negro"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.89%) |
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.