Query Metrics
7
Database Queries
7
Different statements
144.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.35 ms (82.75%) |
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 386083 416296 419219 421372 421591 421853 422145 432700 432852 437474 439717 439808 440878 441848 441849 442095 442915 445107 446538 446811 448973 451849 452327 453265 453518 454167 455407 457441 459541 459778 460318 462352 464132 464175 464484 468687 469420 471470 472690 477692 478320 482772 491056 505164 506069 508560 510876 512943 513487 513973 521424 526063 528337 536980 537220 544844 550668 558903 562791 563175 564377 568756 579586 580750 583560 584254 587951 592955 593648 601930 604353 609669 610033 613168 619544 620244 644960 663294 675547 691228 714127 740888 751560 752011 757488 763769 765255 765726 765733 767057 769094 771835 771974 777794 778941 779558 783777 791550 795737 799596 800896 804168 805538 807749 809993 811365 814428 815081 815111 815117 815128 816062 817258 819545 820417 820542 821399 822131 822623 823672 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (10.30%) |
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 528337 558903 562791 584254 550668 592955 619544 609669 610033 587951 804168 791550 765733 416296 462352 386083 440878 441849 453518 421853 439717 459541 513487 512943 437474 510876 521424 663294 580750 613168 421591 422145 439808 464484 464132 620244 513973 564377 568756 811365 563175 579586 446811 457441 464175 536980 691228 583560 752011 451849 419219 455407 445107 453265 601930 769094 432700 442915 821399 815111 816062 820542 822623 823672 815081 819545 815128 820417 472690 477692 478320 544844 675547 593648 779558 809993 777794 771974 799596 805538 807749 767057 751560 757488 765255 740888 763769 765726 771835 604353 714127 783777 795737 800896 452327 778941 421372 432852 441848 442095 814428 822131 644960 815117 817258 454167 460318 468687 469420 448973 459778 482772 446538 471470 491056 526063 505164 537220 506069 508560 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (2.17%) |
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 386083 416296 419219 421372 421591 421853 422145 432700 432852 437474 439717 439808 440878 441848 441849 442095 442915 445107 446538 446811 448973 451849 452327 453265 453518 454167 455407 457441 459541 459778 460318 462352 464132 464175 464484 468687 469420 471470 472690 477692 478320 482772 491056 505164 506069 508560 510876 512943 513487 513973 521424 526063 528337 536980 537220 544844 550668 558903 562791 563175 564377 568756 579586 580750 583560 584254 587951 592955 593648 601930 604353 609669 610033 613168 619544 620244 644960 663294 675547 691228 714127 740888 751560 752011 757488 763769 765255 765726 765733 767057 769094 771835 771974 777794 778941 779558 783777 791550 795737 799596 800896 804168 805538 807749 809993 811365 814428 815081 815111 815117 815128 816062 817258 819545 820417 820542 821399 822131 822623 823672 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal pov"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал пов"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал пов"
]
|
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.