Query Metrics
7
Database Queries
7
Different statements
138.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.85 ms (82.87%) |
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 20617 390255 420069 420658 422561 422572 422576 422582 422587 422595 422602 422625 422638 422649 422656 422657 422705 422709 422847 422863 422876 422901 422908 422960 422982 423018 423027 423037 423039 423040 423139 423263 423266 423396 423418 423464 428726 429375 431671 443550 443602 443617 445378 464916 467705 469366 469536 471137 478427 478431 485576 485578 487864 492412 492414 495066 496114 499034 499035 499042 500077 500686 511489 512174 512188 512215 512224 512680 515734 515886 517997 518972 519769 519907 519909 519914 520151 525069 525176 525197 525605 527101 527110 527117 527214 529854 529855 530670 534199 536647 537732 538269 540082 540084 540089 540199 541586 542904 543888 546805 547642 550748 551995 552010 565974 566011 566849 568478 583831 584680 595923 597864 601159 627547 630729 641465 714119 735086 736707 814964 ] |
||||||||||||||||||||||||||||||
|
14.81 ms (10.69%) |
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 445378 525197 547642 495066 422656 422576 520151 512215 551995 550748 469366 566011 485578 530670 422561 422625 422847 422649 422572 467705 537732 527110 542904 597864 423263 390255 443602 422602 492412 525605 517997 541586 429375 478431 525069 540199 496114 499042 583831 735086 627547 515886 422709 422901 422587 422657 469536 512224 422705 814964 534199 527214 568478 736707 20617 420658 443617 422908 499035 527117 499034 527101 543888 714119 423266 423418 500077 500686 519914 422982 487864 518972 525176 566849 431671 478427 538269 540089 540082 423037 422595 423018 423027 422582 423139 529854 512680 511489 443550 422638 422863 519769 485576 422960 519907 519909 540084 515734 423039 428726 492414 536647 464916 565974 584680 601159 423464 423396 471137 422876 512188 552010 595923 420069 423040 529855 512174 546805 630729 641465 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.68%) |
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 20617 390255 420069 420658 422561 422572 422576 422582 422587 422595 422602 422625 422638 422649 422656 422657 422705 422709 422847 422863 422876 422901 422908 422960 422982 423018 423027 423037 423039 423040 423139 423263 423266 423396 423418 423464 428726 429375 431671 443550 443602 443617 445378 464916 467705 469366 469536 471137 478427 478431 485576 485578 487864 492412 492414 495066 496114 499034 499035 499042 500077 500686 511489 512174 512188 512215 512224 512680 515734 515886 517997 518972 519769 519907 519909 519914 520151 525069 525176 525197 525605 527101 527110 527117 527214 529854 529855 530670 534199 536647 537732 538269 540082 540084 540089 540199 541586 542904 543888 546805 547642 550748 551995 552010 565974 566011 566849 568478 583831 584680 595923 597864 601159 627547 630729 641465 714119 735086 736707 814964 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"submissive asian"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (1.03%) |
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.