Query Metrics
7
Database Queries
7
Different statements
260.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
235.42 ms (90.26%) |
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 383600 391754 391911 391986 406935 407423 413641 415749 416000 416025 418519 418522 422803 424765 426295 428944 429598 429861 429867 429880 429885 429888 429889 429890 429895 438013 441067 441354 442064 443243 443246 444915 450281 452304 452936 453394 453400 453408 454156 456516 457063 457564 458761 458770 464023 467029 467066 467903 472188 473400 473750 475329 483735 490731 493961 502467 506674 509218 509664 510425 518210 523358 527847 538530 541251 541841 541851 545968 554104 554369 556577 556762 558175 558177 561345 561505 565306 569133 569309 569315 571726 574685 577433 581929 583216 583894 583966 585050 586007 587178 587272 590418 592167 593032 593363 599354 599621 602846 605096 607552 607608 615913 617115 622693 626066 628727 638408 656925 669269 697457 705424 710161 726816 746126 758803 760169 761039 796831 796881 808155 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (6.36%) |
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 383600 422803 424765 441354 585050 475329 561345 554369 583216 697457 545968 592167 599354 587178 626066 599621 796831 796881 808155 758803 760169 746126 638408 467903 429598 391754 541251 490731 428944 416025 452304 565306 710161 617115 464023 429895 444915 429880 502467 391911 705424 429885 429890 454156 429867 483735 493961 622693 426295 518210 558177 561505 571726 574685 558175 581929 669269 569315 577433 607608 593032 615913 407423 453400 456516 467066 457063 467029 391986 438013 510425 527847 418519 538530 509218 586007 416000 569309 556762 593363 761039 415749 418522 429888 453394 443243 413641 458770 583894 583966 628727 602846 590418 605096 473400 429861 473750 429889 450281 441067 458761 523358 569133 541841 541851 656925 587272 452936 453408 472188 726816 406935 506674 554104 556577 607552 443246 457564 442064 509664 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.01%) |
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 383600 391754 391911 391986 406935 407423 413641 415749 416000 416025 418519 418522 422803 424765 426295 428944 429598 429861 429867 429880 429885 429888 429889 429890 429895 438013 441067 441354 442064 443243 443246 444915 450281 452304 452936 453394 453400 453408 454156 456516 457063 457564 458761 458770 464023 467029 467066 467903 472188 473400 473750 475329 483735 490731 493961 502467 506674 509218 509664 510425 518210 523358 527847 538530 541251 541841 541851 545968 554104 554369 556577 556762 558175 558177 561345 561505 565306 569133 569309 569315 571726 574685 577433 581929 583216 583894 583966 585050 586007 587178 587272 590418 592167 593032 593363 599354 599621 602846 605096 607552 607608 615913 617115 622693 626066 628727 638408 656925 669269 697457 705424 710161 726816 746126 758803 760169 761039 796831 796881 808155 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby solo sex"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby соло секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby соло секс"
]
|
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.