Query Metrics
7
Database Queries
7
Different statements
176.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.60 ms (83.08%) |
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 239555 382194 385318 397053 400233 408179 409596 412227 415566 427601 441015 448263 448310 448694 451481 453075 453217 455352 456525 456786 460622 464552 465013 466958 470199 471956 476088 481665 481925 488365 491978 493117 497478 502778 506131 507678 511016 513397 517282 517922 518176 519678 519878 521741 530787 531491 532509 533061 533831 534034 535836 537196 541074 546119 554394 556950 562951 568990 569128 572872 576721 580771 581714 586511 586652 589723 590886 591918 592570 600863 600864 601887 602933 604404 605305 607716 610600 621508 622990 633140 638552 639972 642657 644268 647609 651038 671764 684261 689755 704218 704560 714549 714776 715836 731663 756192 758719 770446 775976 784932 785812 787131 788566 788994 790863 792655 792910 802337 802826 804442 808151 809131 810933 813250 814049 814736 815063 815064 815115 822692 ] |
||||||||||||||||||||||||||||||
|
19.09 ms (10.82%) |
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 519678 633140 491978 453217 397053 530787 714776 684261 591918 788566 758719 804442 822692 814736 815115 814049 815064 554394 704560 792910 775976 513397 517282 586511 644268 592570 638552 642657 802337 802826 714549 808151 460622 412227 518176 456525 568990 671764 556950 589723 610600 534034 572872 792655 756192 409596 476088 451481 497478 488365 507678 385318 471956 532509 533061 546119 580771 586652 602933 788994 813250 465013 481665 453075 502778 517922 521741 408179 448310 493117 562951 604404 790863 770446 731663 448694 470199 382194 581714 455352 448263 511016 531491 535836 704218 607716 639972 651038 647609 605305 590886 810933 621508 400233 815063 537196 601887 464552 506131 519878 533831 689755 715836 569128 541074 600863 622990 809131 785812 787131 415566 441015 456786 600864 784932 466958 481925 239555 427601 576721 ] |
||||||||||||||||||||||||||||||
|
3.45 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 239555 382194 385318 397053 400233 408179 409596 412227 415566 427601 441015 448263 448310 448694 451481 453075 453217 455352 456525 456786 460622 464552 465013 466958 470199 471956 476088 481665 481925 488365 491978 493117 497478 502778 506131 507678 511016 513397 517282 517922 518176 519678 519878 521741 530787 531491 532509 533061 533831 534034 535836 537196 541074 546119 554394 556950 562951 568990 569128 572872 576721 580771 581714 586511 586652 589723 590886 591918 592570 600863 600864 601887 602933 604404 605305 607716 610600 621508 622990 633140 638552 639972 642657 644268 647609 651038 671764 684261 689755 704218 704560 714549 714776 715836 731663 756192 758719 770446 775976 784932 785812 787131 788566 788994 790863 792655 792910 802337 802826 804442 808151 809131 810933 813250 814049 814736 815063 815064 815115 822692 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom horny секс"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom horny секс"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom horny sex"
]
|
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.