Query Metrics
7
Database Queries
7
Different statements
144.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.81 ms (81.56%) |
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 384745 393701 393749 396251 399253 401105 401985 402036 402266 422925 424622 426075 426152 447242 448557 448697 451725 451726 455841 456341 458305 458774 469531 473766 495673 512639 512883 515216 515235 547649 550611 550979 565159 565245 566789 566991 569663 575087 575094 575192 576416 576523 581658 581660 584537 585942 585997 589134 591312 595900 596092 596669 597246 597487 597599 598032 598431 598614 598871 600066 600123 603951 604227 605304 619221 622394 622397 623209 624249 627803 628082 628407 631196 633114 637520 659637 664976 665498 678799 681808 686061 690334 696929 696964 697298 699624 703089 719244 719719 720813 720885 722705 729818 729873 730788 744006 744852 747004 749266 757643 759565 763887 766874 775383 775797 775819 788315 799980 801272 805668 807669 809639 811439 812115 812351 819537 821091 823479 824090 ] |
||||||||||||||||||||||||||||||
|
16.61 ms (11.50%) |
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 585942 596669 598032 604227 596092 598431 600066 605304 622394 637520 619221 589134 595900 597487 598614 598871 729818 730788 749266 747004 627803 703089 788315 402266 426075 515235 550611 575087 575094 576416 547649 550979 575192 584537 581660 597599 775797 622397 393701 402036 819537 824090 821091 823479 576523 565159 581658 678799 686061 690334 659637 665498 697298 699624 719719 722705 696929 696964 718662 799980 801272 812115 812351 729873 744852 759565 807669 744006 757643 763887 623209 719244 720813 775383 809639 591312 805668 664976 811439 426152 424622 448557 451725 451726 456341 448697 495673 515216 624249 585997 766874 384745 458774 396251 422925 469531 393749 399253 512883 512639 569663 775819 633114 681808 566991 566789 565245 628082 631196 401985 401105 455841 458305 720885 600123 597246 603951 628407 447242 473766 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.69%) |
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 384745 393701 393749 396251 399253 401105 401985 402036 402266 422925 424622 426075 426152 447242 448557 448697 451725 451726 455841 456341 458305 458774 469531 473766 495673 512639 512883 515216 515235 547649 550611 550979 565159 565245 566789 566991 569663 575087 575094 575192 576416 576523 581658 581660 584537 585942 585997 589134 591312 595900 596092 596669 597246 597487 597599 598032 598431 598614 598871 600066 600123 603951 604227 605304 619221 622394 622397 623209 624249 627803 628082 628407 631196 633114 637520 659637 664976 665498 678799 681808 686061 690334 696929 696964 697298 699624 703089 719244 719719 720813 720885 722705 729818 729873 730788 744006 744852 747004 749266 757643 759565 763887 766874 775383 775797 775819 788315 799980 801272 805668 807669 809639 811439 812115 812351 819537 821091 823479 824090 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen small young"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen маленькая young"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen маленькая young"
]
|
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.