Query Metrics
7
Database Queries
7
Different statements
371.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
349.08 ms (94.00%) |
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 156688 415858 432227 440736 442897 444329 447071 448041 449676 451307 454363 455095 455100 455105 455107 455108 456265 458742 459593 459655 460194 460678 460772 461516 461520 461526 461535 461537 461538 461545 461549 461552 461566 461597 462045 462052 462053 462805 462811 465930 466322 467131 467132 467161 467252 467303 467617 472172 472306 472334 472347 472353 473685 473919 473978 474052 476213 476402 477365 478260 478529 482129 508876 511743 511746 512293 512323 520185 522033 522590 527623 548686 552148 556915 558443 558858 558946 559037 560629 562320 569579 574810 574843 574871 575148 575520 575743 575758 575812 576351 576361 584226 593838 597136 599213 605515 606690 606694 617141 617373 618234 618579 630150 632513 632922 636904 647359 650018 654224 663456 688645 694632 696178 705118 732266 733246 747745 773287 802462 807725 ] |
||||||||||||||||||||||||||||||
|
12.67 ms (3.41%) |
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 574810 574871 575520 575743 575758 575812 576361 647359 650018 654224 663456 688645 694632 696178 548686 552148 556915 558443 558858 558946 559037 560629 562320 569579 574843 575148 576351 584226 593838 597136 606690 606694 632922 599213 636904 605515 617141 617373 618234 618579 802462 807725 773287 733246 732266 747745 630150 632513 705118 449676 455095 458742 460678 462052 462811 467132 467303 473685 476213 156688 451307 467131 467161 472306 472334 455100 459655 460194 460772 461520 461526 461535 461537 461538 461549 461552 461566 461597 462053 462805 466322 467252 474052 476402 477365 478260 432227 440736 442897 444329 447071 448041 454363 455105 455107 455108 462045 472347 473919 473978 478529 482129 415858 456265 459593 461516 461545 465930 467617 472172 472353 508876 511743 511746 512293 512323 520185 522033 522590 527623 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.67%) |
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 156688 415858 432227 440736 442897 444329 447071 448041 449676 451307 454363 455095 455100 455105 455107 455108 456265 458742 459593 459655 460194 460678 460772 461516 461520 461526 461535 461537 461538 461545 461549 461552 461566 461597 462045 462052 462053 462805 462811 465930 466322 467131 467132 467161 467252 467303 467617 472172 472306 472334 472347 472353 473685 473919 473978 474052 476213 476402 477365 478260 478529 482129 508876 511743 511746 512293 512323 520185 522033 522590 527623 548686 552148 556915 558443 558858 558946 559037 560629 562320 569579 574810 574843 574871 575148 575520 575743 575758 575812 576351 576361 584226 593838 597136 599213 605515 606690 606694 617141 617373 618234 618579 630150 632513 632922 636904 647359 650018 654224 663456 688645 694632 696178 705118 732266 733246 747745 773287 802462 807725 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold xxx"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд xxx"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд xxx"
]
|
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.