Query Metrics
7
Database Queries
7
Different statements
163.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.14 ms (74.61%) |
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 419055 419157 420216 420252 421360 424715 425300 429543 430392 431427 431716 432317 432337 434270 447826 448103 456862 457259 463747 463753 464714 465076 471355 473372 477404 482237 482330 495155 495866 501252 503029 503248 503797 507670 510584 510589 512181 520151 520643 525644 539232 540168 546039 549080 550214 550762 550766 551963 552028 552041 552905 552911 554203 554333 554419 556363 556390 557543 558366 558368 559883 559907 559909 560965 562849 565473 565479 565995 566010 582669 582876 584675 586635 590925 590934 590959 590978 591795 591836 593375 593405 595057 595945 596714 601038 603193 604688 606538 619462 623818 629319 636288 636290 700966 712185 724928 727920 739791 750816 785568 793172 808751 825750 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (12.43%) |
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 727920 825750 512181 590959 590978 739791 432337 507670 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 596714 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 582876 473372 457259 482330 424715 619462 584675 419157 586635 397045 503248 566010 593405 520151 420252 448103 565473 463753 520643 636290 122425 447826 558366 558368 554333 559909 431427 501252 552041 550762 503029 420216 464714 482237 554419 593375 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (8.56%) |
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 419055 419157 420216 420252 421360 424715 425300 429543 430392 431427 431716 432317 432337 434270 447826 448103 456862 457259 463747 463753 464714 465076 471355 473372 477404 482237 482330 495155 495866 501252 503029 503248 503797 507670 510584 510589 512181 520151 520643 525644 539232 540168 546039 549080 550214 550762 550766 551963 552028 552041 552905 552911 554203 554333 554419 556363 556390 557543 558366 558368 559883 559907 559909 560965 562849 565473 565479 565995 566010 582669 582876 584675 586635 590925 590934 590959 590978 591795 591836 593375 593405 595057 595945 596714 601038 603193 604688 606538 619462 623818 629319 636288 636290 700966 712185 724928 727920 739791 750816 785568 793172 808751 825750 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm japanese"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
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.