Query Metrics
7
Database Queries
7
Different statements
155.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.50 ms (84.64%) |
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 146414 163006 167822 167923 285321 386211 386368 387597 390207 390305 390925 397045 397072 397678 404841 417960 419055 419157 420216 420252 421360 424715 425300 429543 430392 431427 431716 432317 434270 447826 448103 456862 457259 463747 463753 464714 465076 471355 473372 477404 482237 482330 495155 495866 501252 503248 503797 510584 510589 511927 520151 520643 525644 533388 539232 540168 546039 549080 550197 550214 550762 550766 551963 552028 552041 552905 552911 554203 554298 554333 554419 556363 556390 557543 558366 558368 558372 559883 559905 559907 559909 560965 562849 565473 565479 565995 566010 580266 582669 582863 584675 586635 590925 590934 591795 591836 593375 593405 595057 595945 601038 603193 604688 604844 606538 616025 619462 623818 629319 636288 636290 700966 712185 724928 750816 785568 793172 808751 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (9.52%) |
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 549080 724928 604688 793172 477404 525644 550766 603193 636288 386211 425300 565995 595945 404841 560965 700966 606538 386368 387597 495866 712185 621014 556390 559907 595057 419055 554203 785568 808751 390925 552905 285321 556363 167822 551963 390305 397678 546039 510589 539232 430392 582669 750816 390207 591836 510584 552911 601038 163006 456862 465076 557543 167923 463747 146414 540168 623818 495155 559883 431716 434270 565479 590934 629319 503797 432317 421360 552028 429543 471355 562849 591795 397072 550214 590925 473372 550197 457259 482330 424715 619462 584675 419157 586635 397045 503248 566010 593405 580266 520151 554298 616025 420252 448103 565473 463753 520643 636290 559905 122425 447826 558366 558368 554333 559909 431427 501252 511927 552041 550762 420216 464714 482237 554419 593375 604844 417960 533388 582863 558372 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.78%) |
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 146414 163006 167822 167923 285321 386211 386368 387597 390207 390305 390925 397045 397072 397678 404841 417960 419055 419157 420216 420252 421360 424715 425300 429543 430392 431427 431716 432317 434270 447826 448103 456862 457259 463747 463753 464714 465076 471355 473372 477404 482237 482330 495155 495866 501252 503248 503797 510584 510589 511927 520151 520643 525644 533388 539232 540168 546039 549080 550197 550214 550762 550766 551963 552028 552041 552905 552911 554203 554298 554333 554419 556363 556390 557543 558366 558368 558372 559883 559905 559907 559909 560965 562849 565473 565479 565995 566010 580266 582669 582863 584675 586635 590925 590934 591795 591836 593375 593405 595057 595945 601038 603193 604688 604844 606538 616025 619462 623818 629319 636288 636290 700966 712185 724928 750816 785568 793172 808751 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"japanese sperm"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"японк азиатк сперм"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.94%) |
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.