Query Metrics
7
Database Queries
7
Different statements
176.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.09 ms (84.43%) |
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 6666 89346 256431 382456 383238 383523 393900 395739 418851 420544 424333 428016 433582 437427 441069 441812 443845 445057 446049 446620 447418 448208 449992 450015 455633 464461 468021 469246 472080 472560 473532 473804 475352 476610 476818 478442 478788 479225 480134 482766 485857 486620 491059 494534 494545 497551 497835 500580 501615 504584 504904 507194 511209 512074 542105 542640 542923 543767 546407 547303 548607 548628 548678 548748 549400 551366 551973 552115 552237 552388 552402 552640 552655 552681 552705 553915 554201 557231 559002 559391 559469 560481 560566 561263 561330 562250 562275 562293 562484 563800 567102 567741 568348 568631 569859 569899 570494 570614 571188 571921 571932 572159 572339 572427 572521 572818 572999 573852 575064 575127 575219 575423 575485 575516 576280 576283 577401 578015 578371 584134 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (9.04%) |
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 383523 383238 256431 393900 395739 382456 89346 6666 424333 437427 420544 428016 445057 433582 441069 443845 418851 441812 469246 480134 446049 447418 455633 468021 472080 485857 486620 446620 448208 449992 450015 472560 473532 476818 478442 482766 497835 500580 504584 511209 494534 494545 507194 512074 497551 501615 504904 464461 473804 475352 476610 478788 479225 491059 542105 543767 546407 548607 551366 551973 552115 552388 552402 552705 553915 557231 561330 567102 567741 569859 569899 570494 571921 571932 572159 572339 572427 572521 572818 572999 573852 575064 575127 575219 575423 575485 575516 576280 576283 577401 578015 578371 584134 542640 542923 547303 548628 548678 548748 549400 552237 552640 552655 552681 554201 559002 559391 559469 560481 560566 561263 562250 562275 562293 562484 563800 568348 568631 570614 571188 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худые девки"
]
|
||||||||||||||||||||||||||||||
|
2.77 ms (1.57%) |
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 6666 89346 256431 382456 383238 383523 393900 395739 418851 420544 424333 428016 433582 437427 441069 441812 443845 445057 446049 446620 447418 448208 449992 450015 455633 464461 468021 469246 472080 472560 473532 473804 475352 476610 476818 478442 478788 479225 480134 482766 485857 486620 491059 494534 494545 497551 497835 500580 501615 504584 504904 507194 511209 512074 542105 542640 542923 543767 546407 547303 548607 548628 548678 548748 549400 551366 551973 552115 552237 552388 552402 552640 552655 552681 552705 553915 554201 557231 559002 559391 559469 560481 560566 561263 561330 562250 562275 562293 562484 563800 567102 567741 568348 568631 569859 569899 570494 570614 571188 571921 571932 572159 572339 572427 572521 572818 572999 573852 575064 575127 575219 575423 575485 575516 576280 576283 577401 578015 578371 584134 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые девк"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые девк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
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.