Query Metrics
7
Database Queries
7
Different statements
192.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.83 ms (85.08%) |
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 122425 163762 167756 205251 383744 385480 385607 386724 387720 388391 390207 396910 397678 402062 416146 419140 419157 420231 420252 421360 424615 424740 429543 429547 429569 430392 431427 432317 435648 446816 446882 447826 447908 448103 454292 457209 457259 461333 471355 480233 482237 491454 499885 501252 503797 504065 510578 510584 512195 512199 512207 512210 512216 513136 515879 517997 525605 533388 536525 541586 541591 542400 546039 550197 550733 551005 551017 551066 551947 551969 551973 551976 551978 552020 552028 552899 554333 556416 557505 557509 557519 558366 558368 558372 558374 559865 559909 564216 565473 565479 565480 565976 565979 565980 565986 565992 566007 566010 572721 572738 572740 573647 580266 582669 582863 584685 586627 590934 593396 593405 595690 595765 595819 603576 618483 629319 630192 650957 701744 750816 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (8.92%) |
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 701744 419157 416146 386724 388391 397678 419140 429547 430392 454292 491454 512195 512199 546039 551978 558374 572721 582669 750816 385480 390207 385607 163762 167756 447908 457209 565480 580266 572740 565479 590934 629319 402062 446882 396910 429569 512210 503797 510584 515879 122425 424740 424615 435648 447826 533388 513136 525605 536525 517997 512207 541591 542400 550197 551005 551973 558366 566007 582863 584685 541586 551017 551066 551947 558368 558372 564216 565976 565979 566010 550733 554333 557509 559909 565980 650957 552020 556416 557505 557519 595690 603576 630192 593396 593405 595765 586627 595819 431427 504065 501252 573647 387720 480233 446816 499885 461333 432317 421360 510578 559865 551969 565992 552028 552899 572738 618483 429543 471355 420231 512216 383744 205251 420252 448103 457259 482237 565986 551976 565473 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.65%) |
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 122425 163762 167756 205251 383744 385480 385607 386724 387720 388391 390207 396910 397678 402062 416146 419140 419157 420231 420252 421360 424615 424740 429543 429547 429569 430392 431427 432317 435648 446816 446882 447826 447908 448103 454292 457209 457259 461333 471355 480233 482237 491454 499885 501252 503797 504065 510578 510584 512195 512199 512207 512210 512216 513136 515879 517997 525605 533388 536525 541586 541591 542400 546039 550197 550733 551005 551017 551066 551947 551969 551973 551976 551978 552020 552028 552899 554333 556416 557505 557509 557519 558366 558368 558372 558374 559865 559909 564216 565473 565479 565480 565976 565979 565980 565986 565992 566007 566010 572721 572738 572740 573647 580266 582669 582863 584685 586627 590934 593396 593405 595690 595765 595819 603576 618483 629319 630192 650957 701744 750816 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"japanese and"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 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.