Query Metrics
7
Database Queries
7
Different statements
158.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.05 ms (78.07%) |
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 383209 385469 387016 392754 401225 401978 403560 407592 412227 412394 414953 415572 420549 439632 443687 447166 448310 448515 449699 453131 460639 465013 469472 470199 472438 472774 478510 478814 479967 480758 482563 483754 486562 490679 493156 495377 498422 502742 504029 506351 506704 511825 515039 518046 519678 521324 522487 527910 529335 530787 534034 535672 551908 554321 556950 581035 586323 586617 589660 592570 599666 602194 604404 628653 633237 638552 642657 669857 669859 669923 671764 691437 697180 710325 710540 714476 714549 721819 724232 726708 730301 731464 731663 738348 741201 756192 758719 759134 759721 760657 770446 771375 775976 777191 777638 777642 780613 788364 788566 788960 790132 791653 793934 795512 796428 801209 801474 802709 802826 804442 805945 808151 814049 815115 815450 815583 816040 818422 820495 826762 ] |
||||||||||||||||||||||||||||||
|
23.88 ms (15.03%) |
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 387016 412394 439632 479967 420549 443687 472438 478814 447166 486562 493156 518046 522487 527910 535672 498422 506704 519678 490679 383209 385469 448515 415572 401225 407592 815450 820495 815583 816040 826762 818422 504029 551908 669923 669857 669859 691437 710540 599666 586323 589660 633237 777638 788364 801209 801474 802709 777191 788960 795512 796428 790132 730301 771375 738348 759721 760657 741201 759134 710325 721819 777642 791653 793934 403560 449699 469472 392754 414953 815115 814049 480758 448310 472774 478510 530787 534034 529335 502742 460639 581035 671764 714476 556950 604404 602194 628653 592570 638552 642657 805945 788566 756192 758719 770446 802826 731464 726708 731663 714549 775976 804442 808151 453131 470199 465013 412227 521324 495377 506351 483754 511825 401978 482563 515039 554321 697180 586617 724232 780613 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.00%) |
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 383209 385469 387016 392754 401225 401978 403560 407592 412227 412394 414953 415572 420549 439632 443687 447166 448310 448515 449699 453131 460639 465013 469472 470199 472438 472774 478510 478814 479967 480758 482563 483754 486562 490679 493156 495377 498422 502742 504029 506351 506704 511825 515039 518046 519678 521324 522487 527910 529335 530787 534034 535672 551908 554321 556950 581035 586323 586617 589660 592570 599666 602194 604404 628653 633237 638552 642657 669857 669859 669923 671764 691437 697180 710325 710540 714476 714549 721819 724232 726708 730301 731464 731663 738348 741201 756192 758719 759134 759721 760657 770446 771375 775976 777191 777638 777642 780613 788364 788566 788960 790132 791653 793934 795512 796428 801209 801474 802709 802826 804442 805945 808151 814049 815115 815450 815583 816040 818422 820495 826762 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother horny"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин horny"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин horny"
]
|
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.