Query Metrics
7
Database Queries
7
Different statements
384.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.62 ms (54.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex boobs"
]
|
||||||||||||||||||||||||||||||
|
150.49 ms (39.19%) |
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 185432 205011 394152 398382 401640 410319 416407 422210 424644 425619 425636 427561 435162 435502 439634 443793 445404 446948 447002 448373 448896 451501 453565 454061 454072 454384 454773 454989 456613 456615 456625 456721 457289 458534 460172 464312 464381 464687 464952 465290 466671 468856 473259 475079 477722 478839 479212 481253 484541 485679 485699 486809 487415 487543 506350 507812 511327 514704 518449 519701 520923 521999 525480 525650 525667 528408 528839 529422 530130 535012 539800 543107 546106 552499 560155 568581 572929 577353 582792 583341 584434 586515 590538 597857 599117 600986 602343 602402 605646 607666 610603 611268 612276 618972 620323 624178 624739 630567 631710 640895 643489 663485 663984 684343 693781 712177 712570 715394 722718 732367 744316 750454 759960 772547 791034 797835 801098 802239 810839 ] |
||||||||||||||||||||||||||||||
|
17.36 ms (4.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 447002 451501 454384 521999 485679 684343 525650 525667 663485 586515 607666 611268 599117 602402 810839 443793 477722 416407 457289 425636 473259 507812 487415 663984 744316 456721 514704 435502 528408 205011 454773 454989 458534 552499 712570 590538 630567 798952 801098 772547 750454 759960 732367 529422 427561 456613 456625 486809 511327 528839 466671 475079 577353 583341 722718 568581 620323 643489 791034 624739 464381 464952 481253 479212 446948 465290 468856 464312 478839 425619 546106 624178 439634 185432 398382 410319 435162 484541 453565 454072 525480 519701 560155 597857 422210 454061 401640 424644 506350 518449 618972 456615 543107 448373 460172 485699 487543 520923 535012 539800 530130 464687 572929 582792 584434 693781 712177 715394 600986 605646 612276 640895 610603 631710 797835 802239 602343 394152 448896 445404 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.68%) |
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 185432 205011 394152 398382 401640 410319 416407 422210 424644 425619 425636 427561 435162 435502 439634 443793 445404 446948 447002 448373 448896 451501 453565 454061 454072 454384 454773 454989 456613 456615 456625 456721 457289 458534 460172 464312 464381 464687 464952 465290 466671 468856 473259 475079 477722 478839 479212 481253 484541 485679 485699 486809 487415 487543 506350 507812 511327 514704 518449 519701 520923 521999 525480 525650 525667 528408 528839 529422 530130 535012 539800 543107 546106 552499 560155 568581 572929 577353 582792 583341 584434 586515 590538 597857 599117 600986 602343 602402 605646 607666 610603 611268 612276 618972 620323 624178 624739 630567 631710 640895 643489 663485 663984 684343 693781 712177 712570 715394 722718 732367 744316 750454 759960 772547 791034 797835 801098 802239 810839 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс boobs"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс boobs"
]
|
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.