Query Metrics
7
Database Queries
7
Different statements
213.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.17 ms (86.91%) |
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 411477 415115 429764 435497 440632 452228 458916 461032 462470 464202 473722 478033 478527 481602 496527 521367 522903 527225 530493 535644 540217 540400 540944 541252 541661 541769 541833 541846 541853 541895 542198 542580 542591 542826 542854 543471 543731 543858 543917 544803 545341 545372 545382 545389 545393 545399 545409 545437 545441 545469 545488 545608 545698 545819 545822 545829 546828 548131 548570 550265 550315 550316 551034 552010 552643 552703 556051 556741 557676 558626 561980 564328 565102 565241 565250 565277 566324 566855 567144 576346 576529 576895 579296 579358 583989 585960 586587 586890 588301 593860 595764 597028 597117 598828 614308 625412 629893 635487 642043 644718 662048 702679 703836 704523 704528 707391 710767 710794 710871 716901 716902 731683 745384 788264 792554 792555 792558 799721 814991 820779 ] |
||||||||||||||||||||||||||||||
|
16.78 ms (7.87%) |
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 586890 556051 565277 552703 542591 566324 550316 595764 792554 799721 481602 478033 522903 411477 461032 464202 527225 548570 710871 792555 579358 598828 542854 545399 704528 597117 731683 629893 535644 473722 552643 814991 558626 565250 662048 703836 565102 565241 576346 788264 530493 597028 435497 496527 540944 546828 551034 710767 579296 702679 792558 458916 462470 429764 820779 452228 542198 544803 548131 478527 561980 543917 545829 642043 545441 576895 552010 542580 543471 545608 545822 545393 545698 521367 540400 541895 564328 567144 545819 644718 585960 415115 745384 440632 541846 545382 541252 550265 593860 635487 588301 625412 716902 704523 540217 545341 586587 543858 557676 566855 543731 576529 710794 716901 541853 556741 545488 545389 545409 707391 583989 541661 550315 614308 541769 542826 545437 545469 541833 545372 ] |
||||||||||||||||||||||||||||||
|
4.33 ms (2.03%) |
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 411477 415115 429764 435497 440632 452228 458916 461032 462470 464202 473722 478033 478527 481602 496527 521367 522903 527225 530493 535644 540217 540400 540944 541252 541661 541769 541833 541846 541853 541895 542198 542580 542591 542826 542854 543471 543731 543858 543917 544803 545341 545372 545382 545389 545393 545399 545409 545437 545441 545469 545488 545608 545698 545819 545822 545829 546828 548131 548570 550265 550315 550316 551034 552010 552643 552703 556051 556741 557676 558626 561980 564328 565102 565241 565250 565277 566324 566855 567144 576346 576529 576895 579296 579358 583989 585960 586587 586890 588301 593860 595764 597028 597117 598828 614308 625412 629893 635487 642043 644718 662048 702679 703836 704523 704528 707391 710767 710794 710871 716901 716902 731683 745384 788264 792554 792555 792558 799721 814991 820779 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc white girl"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc white девушк"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc white девушк"
]
|
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.