Query Metrics
7
Database Queries
7
Different statements
150.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.02 ms (81.30%) |
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 382313 400128 406303 413722 425603 445542 447072 448033 451950 454530 456525 457781 462331 463262 470146 475207 480900 493046 499765 500875 502518 503350 503772 504042 507946 508386 508421 508510 510194 512629 512844 514373 514989 516325 516650 517269 517824 518077 518100 519040 520828 520877 521041 521492 521605 521653 522724 523813 524096 525022 536004 536372 537340 537962 546668 546824 548991 549143 550485 554260 554262 556706 557679 559934 559936 559938 562080 564842 565526 565838 567643 569332 572291 575607 576966 577500 577897 578552 579728 579780 579812 580880 582889 582897 584641 586864 586912 587946 589723 594261 595579 595593 596405 597690 598154 601884 602510 602666 605164 606344 606987 610401 618852 619885 620180 625807 630135 632818 636428 643489 646669 652673 653461 654739 657199 663172 668079 680705 682945 690153 ] |
||||||||||||||||||||||||||||||
|
17.69 ms (11.79%) |
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 517824 521041 521605 584641 463262 512629 537340 516650 537962 500875 508421 518077 582889 548991 657199 579780 643489 586912 589723 619885 425603 475207 400128 493046 579812 550485 562080 572291 577500 582897 653461 680705 682945 668079 554260 610401 636428 594261 597690 605164 618852 620180 595579 601884 602510 625807 470146 519040 521492 577897 549143 556706 575607 554262 595593 447072 413722 536004 499765 524096 518100 525022 586864 630135 503350 480900 512844 514373 567643 606987 382313 445542 514989 690153 456525 520877 536372 580880 546824 579728 578552 663172 646669 546668 606344 632818 521653 522724 507946 564842 654739 569332 596405 602666 451950 457781 504042 508510 652673 587946 462331 448033 508386 517269 565526 523813 516325 557679 565838 559936 559938 559934 576966 502518 406303 598154 454530 503772 520828 510194 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (2.33%) |
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 382313 400128 406303 413722 425603 445542 447072 448033 451950 454530 456525 457781 462331 463262 470146 475207 480900 493046 499765 500875 502518 503350 503772 504042 507946 508386 508421 508510 510194 512629 512844 514373 514989 516325 516650 517269 517824 518077 518100 519040 520828 520877 521041 521492 521605 521653 522724 523813 524096 525022 536004 536372 537340 537962 546668 546824 548991 549143 550485 554260 554262 556706 557679 559934 559936 559938 562080 564842 565526 565838 567643 569332 572291 575607 576966 577500 577897 578552 579728 579780 579812 580880 582889 582897 584641 586864 586912 587946 589723 594261 595579 595593 596405 597690 598154 601884 602510 602666 605164 606344 606987 610401 618852 619885 620180 625807 630135 632818 636428 643489 646669 652673 653461 654739 657199 663172 668079 680705 682945 690153 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"показывает член подружке"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"показыва член подружк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
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.