Query Metrics
7
Database Queries
7
Different statements
170.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.78 ms (83.29%) |
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 386384 421196 421810 431754 438657 439767 442869 446064 456610 458349 459056 459613 462322 464732 472119 475595 478392 478525 480501 484776 484904 492283 495744 497290 503154 503821 508412 508414 510338 518840 519597 529086 534932 535348 543644 544887 549794 553958 557004 557941 567165 567368 568733 571843 575287 591168 594630 595517 598050 598081 599283 607537 613398 616013 620046 622746 623104 631318 637727 647175 661933 690936 705411 706143 706692 707906 711739 716709 722305 722349 730835 740553 740623 743658 745311 747572 753641 757924 761974 762507 763874 766504 778088 778160 778535 780143 787291 787939 789164 789732 789781 791037 791075 791179 791723 792535 794360 800657 803447 803523 803563 804820 804873 805177 810354 816101 816128 816143 816609 818873 819850 819851 819996 820071 824311 825528 825715 825795 826863 827003 ] |
||||||||||||||||||||||||||||||
|
17.20 ms (10.10%) |
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 459613 484776 544887 543644 791179 791723 761974 816101 816128 824311 819851 820071 705411 706143 711739 706692 722349 594630 623104 631318 778535 803447 757924 792535 753641 747572 730835 613398 637727 787291 787939 791037 804820 810354 568733 557941 462322 459056 464732 475595 503821 508414 458349 575287 431754 567368 571843 553958 567165 690936 591168 616013 421196 421810 478525 446064 472119 503154 495744 497290 508412 510338 518840 519597 661933 818873 825795 826863 816609 819850 825528 827003 535348 707906 716709 722305 647175 598081 599283 620046 622746 789781 791075 805177 778160 800657 803523 803563 740553 794360 762507 763874 740623 766504 745311 778088 780143 789164 789732 804873 480501 386384 492283 595517 439767 549794 442869 456610 607537 598050 743658 484904 557004 478392 438657 529086 825715 816143 819996 534932 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.99%) |
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 386384 421196 421810 431754 438657 439767 442869 446064 456610 458349 459056 459613 462322 464732 472119 475595 478392 478525 480501 484776 484904 492283 495744 497290 503154 503821 508412 508414 510338 518840 519597 529086 534932 535348 543644 544887 549794 553958 557004 557941 567165 567368 568733 571843 575287 591168 594630 595517 598050 598081 599283 607537 613398 616013 620046 622746 623104 631318 637727 647175 661933 690936 705411 706143 706692 707906 711739 716709 722305 722349 730835 740553 740623 743658 745311 747572 753641 757924 761974 762507 763874 766504 778088 778160 778535 780143 787291 787939 789164 789732 789781 791037 791075 791179 791723 792535 794360 800657 803447 803523 803563 804820 804873 805177 810354 816101 816128 816143 816609 818873 819850 819851 819996 820071 824311 825528 825715 825795 826863 827003 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead russian webcam"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая русск вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
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.