Query Metrics
7
Database Queries
7
Different statements
143.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.35 ms (85.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 382236 384845 385608 398447 400563 401948 408988 419914 431850 446648 447908 486044 495866 497056 506548 513482 513986 519518 526765 528889 530092 535359 535616 539111 542878 546164 547120 552021 554704 554706 559785 570490 572727 584360 589347 591211 614215 614455 614625 615947 618072 619452 622026 632282 633916 634289 638962 643028 649707 649913 653820 661357 661383 665908 666476 676756 680954 685523 692683 692824 693541 696004 696062 696700 696703 698802 700177 700906 701623 701644 702443 702445 707264 712720 712722 713779 717052 720729 722304 731027 732099 732128 734030 736510 738664 740148 748634 749572 751422 754397 759106 759241 768456 778228 778925 780172 780695 783525 783730 786248 788034 788135 788892 789047 789069 791308 791317 792750 798315 798712 799822 811761 812242 813734 814298 819148 820982 826903 828137 828243 ] |
||||||||||||||||||||||||||||||
|
12.03 ms (8.36%) |
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 720729 722304 696700 702443 638962 778228 783730 788034 738664 759241 731027 696703 780172 789047 661357 643028 819148 749572 632282 559785 554704 513482 419914 653820 547120 759106 400563 828243 634289 736510 713779 798315 382236 813734 676756 799822 732099 431850 572727 552021 554706 693541 649707 680954 717052 619452 497056 698802 692683 591211 589347 791308 798712 700177 748634 788892 701623 701644 786248 789069 768456 702445 384845 447908 528889 614215 546164 685523 649913 696004 700906 506548 614455 751422 788135 622026 401948 519518 732128 615947 535616 530092 740148 792750 820982 539111 826903 828137 633916 614625 486044 666476 778925 712720 408988 513986 526765 570490 712722 665908 446648 495866 783525 791317 734030 814298 707264 811761 754397 812242 542878 780695 398447 385608 535359 661383 692824 696062 584360 618072 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.82%) |
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 382236 384845 385608 398447 400563 401948 408988 419914 431850 446648 447908 486044 495866 497056 506548 513482 513986 519518 526765 528889 530092 535359 535616 539111 542878 546164 547120 552021 554704 554706 559785 570490 572727 584360 589347 591211 614215 614455 614625 615947 618072 619452 622026 632282 633916 634289 638962 643028 649707 649913 653820 661357 661383 665908 666476 676756 680954 685523 692683 692824 693541 696004 696062 696700 696703 698802 700177 700906 701623 701644 702443 702445 707264 712720 712722 713779 717052 720729 722304 731027 732099 732128 734030 736510 738664 740148 748634 749572 751422 754397 759106 759241 768456 778228 778925 780172 780695 783525 783730 786248 788034 788135 788892 789047 789069 791308 791317 792750 798315 798712 799822 811761 812242 813734 814298 819148 820982 826903 828137 828243 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public asian girls"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц азиатк девушк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.00%) |
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.