Query Metrics
7
Database Queries
7
Different statements
226.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.67 ms (87.29%) |
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 401757 412571 413639 421806 422447 424617 430362 434587 436478 439900 442057 446999 448524 451043 458832 459618 469399 470812 471968 480012 483296 505967 509772 527697 543641 547207 549661 561167 562645 562687 567359 567565 575335 578581 582619 583252 585318 585457 591383 592874 599766 609099 616931 623234 628768 649056 659349 677419 681219 689440 694883 700269 701548 708905 713760 717433 718415 719792 722925 729354 731687 739853 746373 751920 761711 762045 763808 763955 764892 764923 764947 765178 767061 768280 772057 772618 777260 779278 779425 779460 780174 783953 784088 784551 785276 785356 787002 787579 792214 793121 794088 794857 795148 795205 795539 795741 797306 798089 799243 799974 800034 800810 802204 802823 803444 804733 804990 804993 805392 807123 807477 808244 809683 813072 813471 819938 826763 827825 827842 ] |
||||||||||||||||||||||||||||||
|
18.71 ms (8.26%) |
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 787579 799243 809683 480012 422447 442057 509772 421806 412571 718415 746373 767061 762045 567359 401757 424617 430362 434587 819938 827842 827825 448524 483296 547207 578581 582619 543641 562645 659349 681219 717433 719792 583252 599766 609099 585318 779460 794088 800034 802204 802823 805392 777260 784551 795741 799974 804733 807123 807477 739853 765178 784088 794857 804990 763808 764947 751920 772057 761711 764892 628768 780548 795205 797306 804993 413639 439900 469399 470812 527697 592874 689440 729354 826763 446999 451043 458832 459618 505967 561167 575335 549661 567565 562687 649056 694883 700269 701548 677419 713760 585457 616931 591383 779425 779278 792214 795148 795539 798089 800810 803444 813072 785276 785356 793121 808244 813471 763955 764923 768280 731687 772618 623234 708905 722925 780174 783953 787002 436478 471968 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.42%) |
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 401757 412571 413639 421806 422447 424617 430362 434587 436478 439900 442057 446999 448524 451043 458832 459618 469399 470812 471968 480012 483296 505967 509772 527697 543641 547207 549661 561167 562645 562687 567359 567565 575335 578581 582619 583252 585318 585457 591383 592874 599766 609099 616931 623234 628768 649056 659349 677419 681219 689440 694883 700269 701548 708905 713760 717433 718415 719792 722925 729354 731687 739853 746373 751920 761711 762045 763808 763955 764892 764923 764947 765178 767061 768280 772057 772618 777260 779278 779425 779460 780174 783953 784088 784551 785276 785356 787002 787579 792214 793121 794088 794857 795148 795205 795539 795741 797306 798089 799243 799974 800034 800810 802204 802823 803444 804733 804990 804993 805392 807123 807477 808244 809683 813072 813471 819938 826763 827825 827842 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best of pov"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best пов"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best пов"
]
|
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.