Query Metrics
7
Database Queries
7
Different statements
149.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.40 ms (81.86%) |
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 129246 392165 398436 400563 410905 486044 488848 506571 514702 528880 530664 541565 542443 545798 547070 549951 552861 554709 560342 566737 568612 574656 579127 579523 589083 592741 599763 601948 606212 611541 614455 621588 625750 632224 633052 633563 633664 634289 634362 638947 644857 647126 650692 662480 666476 667820 669896 669903 680612 690441 701604 706642 707812 709855 710042 718717 733983 734261 734386 734429 735235 736031 736507 736510 740238 740761 741582 744568 746098 747535 751377 751408 751422 752765 760932 761069 764993 768042 773584 778186 778925 780884 785562 788141 789650 791579 797826 798746 798857 799010 800663 803156 804350 804418 809767 812230 812238 814166 817403 817519 817788 819438 819452 820504 820564 821037 821140 821143 821168 821564 823157 825538 828046 828047 828065 828098 828243 828376 828402 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (11.57%) |
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 647126 667820 690441 632224 747535 788141 791579 803156 780884 398436 514702 814166 554709 812230 812238 744568 761069 785562 621588 828402 400563 828243 634289 736510 822935 530664 566737 611541 789650 736031 797826 751377 799010 129246 392165 820504 820564 821143 821168 821564 819438 821037 823157 821140 825538 542443 541565 592741 734261 733983 735235 633563 709855 599763 817403 817519 819452 817788 828065 568612 718717 798746 798857 804418 740761 740238 706642 800663 760932 669896 804350 768042 633052 549951 644857 680612 710042 633664 625750 506571 638947 606212 828046 828098 828376 828047 488848 560342 650692 601948 579127 614455 751422 528880 662480 746098 707812 669903 634362 589083 778186 734386 734429 773584 752765 701604 552861 736507 410905 486044 666476 778925 741582 751408 545798 809767 764993 579523 547070 574656 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.14%) |
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 129246 392165 398436 400563 410905 486044 488848 506571 514702 528880 530664 541565 542443 545798 547070 549951 552861 554709 560342 566737 568612 574656 579127 579523 589083 592741 599763 601948 606212 611541 614455 621588 625750 632224 633052 633563 633664 634289 634362 638947 644857 647126 650692 662480 666476 667820 669896 669903 680612 690441 701604 706642 707812 709855 710042 718717 733983 734261 734386 734429 735235 736031 736507 736510 740238 740761 741582 744568 746098 747535 751377 751408 751422 752765 760932 761069 764993 768042 773584 778186 778925 780884 785562 788141 789650 791579 797826 798746 798857 799010 800663 803156 804350 804418 809767 812230 812238 814166 817403 817519 817788 819438 819452 820504 820564 821037 821140 821143 821168 821564 823157 825538 828046 828047 828065 828098 828243 828376 828402 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public girls"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц девушк"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.21 ms (0.81%) |
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.