Query Metrics
7
Database Queries
7
Different statements
155.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.83 ms (82.34%) |
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 33727 191179 191254 191348 382720 383888 384864 386037 388438 389355 391247 395564 395701 398351 404474 406812 407682 407760 407767 409705 412790 417389 430219 431566 432189 433808 443246 449093 452948 453462 455872 460453 460603 463712 464555 464612 465351 465654 467542 468760 469554 471881 472322 474149 476613 477885 482255 483134 483444 485706 487356 489397 491249 497233 501733 503553 503584 504060 504572 505691 514303 514601 515907 518225 520665 521123 522182 523599 524886 526007 526675 526746 528388 536768 539644 540952 541177 546122 546580 549687 549738 551115 556554 561380 563103 566311 567405 569089 577014 588693 592438 609227 615006 623810 634849 635916 641925 644266 644315 667647 704907 715554 715891 721060 726657 728234 728288 732400 758614 775116 788872 792530 796243 799049 803057 804011 804620 805962 814851 818117 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (10.68%) |
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 191179 792530 391247 477885 483134 382720 389355 432189 455872 522182 464555 569089 715891 721060 526675 384864 33727 388438 407682 431566 452948 474149 518225 539644 634849 615006 635916 805962 728234 407767 409705 430219 563103 460603 471881 468760 503584 501733 505691 489397 551115 667647 588693 443246 465654 526746 541177 609227 449093 483444 577014 556554 546580 566311 644266 799049 641925 704907 412790 814851 818117 453462 504060 515907 644315 803057 775116 788872 758614 796243 804620 726657 395701 514601 491249 540952 728288 395564 406812 464612 504572 528388 567405 463712 467542 469554 503553 524886 433808 482255 497233 526007 520665 523599 536768 472322 487356 549687 546122 549738 715554 561380 623810 592438 804011 732400 476613 460453 465351 514303 485706 521123 386037 383888 191348 191254 398351 404474 417389 407760 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.95%) |
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 33727 191179 191254 191348 382720 383888 384864 386037 388438 389355 391247 395564 395701 398351 404474 406812 407682 407760 407767 409705 412790 417389 430219 431566 432189 433808 443246 449093 452948 453462 455872 460453 460603 463712 464555 464612 465351 465654 467542 468760 469554 471881 472322 474149 476613 477885 482255 483134 483444 485706 487356 489397 491249 497233 501733 503553 503584 504060 504572 505691 514303 514601 515907 518225 520665 521123 522182 523599 524886 526007 526675 526746 528388 536768 539644 540952 541177 546122 546580 549687 549738 551115 556554 561380 563103 566311 567405 569089 577014 588693 592438 609227 615006 623810 634849 635916 641925 644266 644315 667647 704907 715554 715891 721060 726657 728234 728288 732400 758614 775116 788872 792530 796243 799049 803057 804011 804620 805962 814851 818117 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature busty сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature busty tits"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature busty сиськ"
]
|
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.