Query Metrics
7
Database Queries
7
Different statements
235.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.73 ms (89.34%) |
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 16971 404629 410051 410254 411201 415109 417801 419132 426551 427447 428276 428372 433074 433297 433486 435443 436178 444795 445416 445471 447191 447785 448031 448840 453032 453149 453650 454210 454221 471165 475304 478966 479191 480752 480757 481295 484692 489432 491200 492097 492098 497356 502043 508528 514772 515142 516625 516765 516769 517784 523549 524792 525287 532849 537773 538542 540294 543772 545501 551736 556045 559453 560203 562282 564205 569533 577371 587254 590900 590908 592758 593992 596431 598606 599966 600076 604172 605306 615756 623521 630542 639712 639760 642069 644250 646884 647895 647905 650783 652284 653870 653900 665920 666528 674077 677974 682839 684949 693075 695175 697333 699334 699621 713262 721445 723480 724217 729618 745550 756430 759574 766843 773562 778614 802123 809644 809935 814736 818462 823303 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (5.98%) |
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 538542 818462 695175 697333 745550 759574 684949 590900 699334 447191 448031 559453 411201 454221 517784 516765 478966 16971 516625 497356 492098 562282 646884 644250 523549 647895 605306 577371 650783 524792 587254 592758 515142 623521 809644 823303 693075 814736 484692 502043 417801 410254 652284 516769 598606 766843 433074 427447 508528 556045 404629 802123 809935 590908 480757 677974 665920 773562 615756 445471 532849 647905 639712 721445 778614 724217 415109 428276 537773 545501 666528 410051 445416 454210 492097 453032 569533 514772 564205 642069 593992 471165 435443 600076 479191 489432 674077 428372 540294 444795 560203 653870 599966 419132 604172 699621 448840 551736 639760 723480 630542 447785 729618 453149 491200 653900 682839 756430 713262 433486 433297 596431 453650 543772 475304 481295 525287 480752 436178 426551 ] |
||||||||||||||||||||||||||||||
|
4.38 ms (1.86%) |
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 16971 404629 410051 410254 411201 415109 417801 419132 426551 427447 428276 428372 433074 433297 433486 435443 436178 444795 445416 445471 447191 447785 448031 448840 453032 453149 453650 454210 454221 471165 475304 478966 479191 480752 480757 481295 484692 489432 491200 492097 492098 497356 502043 508528 514772 515142 516625 516765 516769 517784 523549 524792 525287 532849 537773 538542 540294 543772 545501 551736 556045 559453 560203 562282 564205 569533 577371 587254 590900 590908 592758 593992 596431 598606 599966 600076 604172 605306 615756 623521 630542 639712 639760 642069 644250 646884 647895 647905 650783 652284 653870 653900 665920 666528 674077 677974 682839 684949 693075 695175 697333 699334 699621 713262 721445 723480 724217 729618 745550 756430 759574 766843 773562 778614 802123 809644 809935 814736 818462 823303 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ffm threesome hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро секс втро хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.56%) |
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.