Query Metrics
7
Database Queries
7
Different statements
368.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.65 ms (55.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
143.89 ms (39.01%) |
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 50436 121824 176148 213205 381947 383984 384304 393347 399540 410328 411039 418801 440650 456532 457951 472801 483846 489058 497205 503315 531032 532435 539656 548219 554120 567290 570503 571891 572811 574202 588233 592914 595876 619702 623927 624287 633504 633692 637756 639616 644172 645401 646752 648278 653820 660315 662786 669414 669578 671146 673552 675145 682850 682942 689976 690017 691846 704222 706361 715106 724636 732085 733420 735672 738655 740703 741764 743251 748574 749376 752042 753024 754370 754521 755367 756313 765531 770443 772743 772940 773028 774049 775772 777149 777150 782647 786063 787015 789090 790120 803155 808729 810467 812518 813678 816162 817075 817581 818245 818302 819107 819972 821103 821221 821951 823321 823904 824071 825094 825198 825744 825929 826315 826347 826463 827576 828053 828100 828732 ] |
||||||||||||||||||||||||||||||
|
11.40 ms (3.09%) |
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 472801 715106 624287 765531 456532 675145 483846 503315 828100 489058 570503 823904 592914 775772 724636 440650 741764 808729 825929 572811 826315 411039 824071 825094 773028 826347 733420 770443 646752 497205 817075 682942 671146 738655 531032 669414 755367 567290 457951 690017 818302 825744 812518 381947 816162 828732 774049 772743 384304 823321 637756 828053 704222 821221 706361 818245 790120 732085 740703 786063 176148 825198 826463 669578 623927 121824 827576 743251 399540 777149 777150 735672 648278 660315 813678 633504 782647 754521 753024 393347 817581 539656 574202 554120 673552 682850 810467 752042 633692 383984 418801 213205 821103 819972 821951 653820 689976 691846 588233 619702 803155 756313 819107 548219 595876 639616 772940 787015 789090 50436 410328 826566 532435 571891 662786 645401 644172 748574 749376 754370 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (0.81%) |
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 50436 121824 176148 213205 381947 383984 384304 393347 399540 410328 411039 418801 440650 456532 457951 472801 483846 489058 497205 503315 531032 532435 539656 548219 554120 567290 570503 571891 572811 574202 588233 592914 595876 619702 623927 624287 633504 633692 637756 639616 644172 645401 646752 648278 653820 660315 662786 669414 669578 671146 673552 675145 682850 682942 689976 690017 691846 704222 706361 715106 724636 732085 733420 735672 738655 740703 741764 743251 748574 749376 752042 753024 754370 754521 755367 756313 765531 770443 772743 772940 773028 774049 775772 777149 777150 782647 786063 787015 789090 790120 803155 808729 810467 812518 813678 816162 817075 817581 818245 818302 819107 819972 821103 821221 821951 823321 823904 824071 825094 825198 825744 825929 826315 826347 826463 827576 828053 828100 828732 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"it sexy girl"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy девушк"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy девушк"
]
|
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.