Query Metrics
7
Database Queries
7
Different statements
637.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
270.62 ms (42.43%) |
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 589758 596092 598431 598444 600066 605304 622394 623840 637520 588408 608392 617632 618645 618672 624864 589134 595900 595945 596991 597487 598614 598871 604085 810665 725409 729818 730788 742199 749266 747004 609886 618888 627803 722851 788315 426075 820993 821738 666164 694114 721744 607175 612946 788579 725293 748675 744612 615718 775819 429097 443205 488309 543905 574794 614605 414509 399414 566807 552631 668857 722706 623312 597195 618882 722897 723492 812141 576417 569891 573606 530025 554472 579358 559942 671676 604507 599996 628376 597139 628090 636998 628420 521357 495148 473807 505288 529125 814644 822097 822106 822674 825492 816921 821217 822905 820958 821529 821550 822925 827980 824999 488306 562300 563876 552491 654602 673127 683341 694538 712900 715228 696978 720484 667562 670238 674748 686058 688578 689758 691838 ] |
||||||||||||||||||||||||||||||
|
214.45 ms (33.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
145.48 ms (22.81%) |
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 399414 414509 426075 429097 443205 473807 488306 488309 495148 505288 521357 529125 530025 543905 552491 552631 554472 559942 562300 563876 566807 569891 573606 574794 576417 579358 588408 589134 589758 595900 595945 596092 596991 597139 597195 597487 598431 598444 598614 598871 599996 600066 604085 604507 605304 607175 608392 609886 612946 614605 615718 617632 618645 618672 618882 618888 622394 623312 623840 624864 627803 628090 628376 628420 636998 637520 654602 666164 667562 668857 670238 671676 673127 674748 683341 686058 688578 689758 691838 694114 694538 696978 712900 715228 720484 721744 722706 722851 722897 723492 725293 725409 729818 730788 742199 744612 747004 748675 749266 775819 788315 788579 810665 812141 814644 816921 820958 820993 821217 821529 821550 821738 822097 822106 822674 822905 822925 824999 825492 827980 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.43%) |
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 399414 414509 426075 429097 443205 473807 488306 488309 495148 505288 521357 529125 530025 543905 552491 552631 554472 559942 562300 563876 566807 569891 573606 574794 576417 579358 588408 589134 589758 595900 595945 596092 596991 597139 597195 597487 598431 598444 598614 598871 599996 600066 604085 604507 605304 607175 608392 609886 612946 614605 615718 617632 618645 618672 618882 618888 622394 623312 623840 624864 627803 628090 628376 628420 636998 637520 654602 666164 667562 668857 670238 671676 673127 674748 683341 686058 688578 689758 691838 694114 694538 696978 712900 715228 720484 721744 722706 722851 722897 723492 725293 725409 729818 730788 742199 744612 747004 748675 749266 775819 788315 788579 810665 812141 814644 816921 820958 820993 821217 821529 821550 821738 822097 822106 822674 822905 822925 824999 825492 827980 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young small cock"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.