Query Metrics
7
Database Queries
7
Different statements
148.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.12 ms (84.28%) |
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 81174 92249 231164 384013 384525 396973 404318 405978 419558 424546 425535 433406 436539 443482 444211 445216 445306 452676 453895 454862 457684 473605 478979 479229 480378 482993 483882 486201 489357 492310 499785 505933 507584 508298 509390 512033 513156 519735 522669 523303 534951 535893 543876 549267 553607 560105 564855 573319 574125 583405 586068 611039 611296 613784 616858 625088 625141 629667 635208 639282 643423 645965 649293 653491 662191 671316 671516 677135 679067 679532 682494 682846 687374 688307 688336 693355 697289 700065 703308 705102 711755 713105 721211 722071 723524 727716 728162 730477 737971 743196 746708 747417 761959 762090 762243 768155 768861 771489 772850 778323 778326 779925 783794 783858 788444 795371 800408 801784 802892 807792 812720 813596 813938 814084 814091 819185 819963 822665 825078 827250 ] |
||||||||||||||||||||||||||||||
|
12.52 ms (8.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 771489 762243 727716 747417 772850 625141 700065 713105 722071 800408 801784 807792 424546 574125 687374 688336 783858 743196 499785 814084 814091 827250 486201 523303 549267 679532 697289 671516 639282 768861 384525 445216 445306 522669 564855 443482 507584 384013 433406 723524 813596 819185 478979 535893 505933 534951 492310 543876 662191 682846 693355 649293 711755 677135 721211 553607 573319 586068 611296 613784 629667 611039 635208 616858 643423 783794 812720 778323 778326 779925 788444 802892 728162 761959 762090 746708 730477 737971 768155 703308 795371 81174 436539 405978 425535 452676 457684 473605 625088 454862 480378 483882 519735 489357 508298 513156 404318 819963 419558 92249 231164 396973 444211 825078 822665 813938 453895 482993 479229 509390 512033 560105 583405 645965 679067 682494 705102 688307 653491 671316 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (2.62%) |
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 81174 92249 231164 384013 384525 396973 404318 405978 419558 424546 425535 433406 436539 443482 444211 445216 445306 452676 453895 454862 457684 473605 478979 479229 480378 482993 483882 486201 489357 492310 499785 505933 507584 508298 509390 512033 513156 519735 522669 523303 534951 535893 543876 549267 553607 560105 564855 573319 574125 583405 586068 611039 611296 613784 616858 625088 625141 629667 635208 639282 643423 645965 649293 653491 662191 671316 671516 677135 679067 679532 682494 682846 687374 688307 688336 693355 697289 700065 703308 705102 711755 713105 721211 722071 723524 727716 728162 730477 737971 743196 746708 747417 761959 762090 762243 768155 768861 771489 772850 778323 778326 779925 783794 783858 788444 795371 800408 801784 802892 807792 812720 813596 813938 814084 814091 819185 819963 822665 825078 827250 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк спящ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl sleep"
]
|
||||||||||||||||||||||||||||||
|
1.52 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.