Query Metrics
7
Database Queries
7
Different statements
161.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.22 ms (84.35%) |
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 384063 389829 391302 391684 396312 396603 400690 400714 401778 403276 415634 418286 426725 427301 443372 453602 454251 458414 462709 463312 470302 474033 480420 503918 504770 506211 515158 515203 518852 519010 519321 522246 522587 524012 548064 551557 552859 554134 557964 566303 567215 574580 588581 589268 596178 609746 610174 610608 612022 617121 617848 618050 621288 623209 623723 623932 625698 626742 637589 644660 645965 657777 684088 694034 694260 695804 697289 704875 717810 720009 720014 720818 722099 722126 729731 729890 729962 733170 733181 736507 740536 747624 748392 748681 761827 764606 776396 776915 780141 789837 790168 790977 794829 795307 800000 800227 800365 802210 802820 804112 804964 805059 805192 807333 807649 807669 807674 810023 811998 812299 813549 813660 815010 821628 821836 823630 823682 825029 825467 825499 ] |
||||||||||||||||||||||||||||||
|
15.11 ms (9.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 567215 588581 596178 794829 807333 807649 780141 790168 795307 800365 805059 802210 807669 764606 736507 761827 748392 810023 426725 825029 443372 458414 551557 524012 418286 519321 557964 609746 610608 623723 748681 729731 396312 470302 519010 518852 462709 415634 427301 821836 825467 823682 566303 720014 720818 722099 548064 637589 589268 625698 621288 800000 802820 805192 812299 729890 729962 733170 740536 747624 722126 776396 776915 453602 474033 463312 391302 813660 821628 645965 697289 720009 612022 626742 790977 789837 804112 396603 403276 554134 389829 454251 480420 515158 574580 684088 811998 384063 400714 503918 694034 657777 552859 610174 617121 618050 617848 733181 800227 522587 515203 506211 400690 401778 644660 623932 804964 807674 623209 704875 391684 813549 823630 815010 825499 522246 504770 695804 694260 717810 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (2.00%) |
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 384063 389829 391302 391684 396312 396603 400690 400714 401778 403276 415634 418286 426725 427301 443372 453602 454251 458414 462709 463312 470302 474033 480420 503918 504770 506211 515158 515203 518852 519010 519321 522246 522587 524012 548064 551557 552859 554134 557964 566303 567215 574580 588581 589268 596178 609746 610174 610608 612022 617121 617848 618050 621288 623209 623723 623932 625698 626742 637589 644660 645965 657777 684088 694034 694260 695804 697289 704875 717810 720009 720014 720818 722099 722126 729731 729890 729962 733170 733181 736507 740536 747624 748392 748681 761827 764606 776396 776915 780141 789837 790168 790977 794829 795307 800000 800227 800365 802210 802820 804112 804964 805059 805192 807333 807649 807669 807674 810023 811998 812299 813549 813660 815010 821628 821836 823630 823682 825029 825467 825499 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young old amateur"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young old любительск"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young old любительск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.