Query Metrics
7
Database Queries
7
Different statements
149.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.64 ms (81.52%) |
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 386627 391150 399959 399973 410851 411469 412525 414105 422662 423348 423802 429705 432207 435221 435324 435606 435802 435822 438454 444839 445029 445977 446243 451247 451761 452825 452964 455398 456129 457092 465727 467089 480727 482411 486617 495077 496746 499568 503482 505665 505851 511323 511636 521625 521633 522462 523058 523196 523373 524759 525904 526152 527098 527306 527736 531804 532595 539593 544401 545375 546016 548167 548170 548859 550606 553283 553601 554544 555002 555384 555432 556345 559836 562096 562386 563361 563595 565896 568752 571789 572260 576514 579856 580136 584021 584904 585964 586005 586565 588048 589081 589519 591406 596244 599679 600347 600790 601211 601519 601798 602379 602727 603085 603302 605358 605707 612962 616511 618997 619612 624910 625227 625893 626872 629208 660373 661903 674240 745309 796816 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (11.17%) |
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 591406 629208 601798 618997 596244 599679 605707 589081 602727 605358 624910 796816 422662 505851 511323 495077 486617 414105 445977 563361 674240 601519 399973 523058 550606 548170 562386 584904 446243 435221 523373 548167 423348 432207 435822 412525 445029 452825 511636 521625 503482 555384 555432 553601 586565 600790 603085 616511 456129 452964 410851 505665 532595 544401 556345 559836 571789 589519 603302 619612 586005 625227 399959 444839 455398 435802 435606 482411 451761 525904 524759 576514 579856 548859 563595 555002 565896 660373 572260 580136 584021 588048 585964 600347 601211 625893 745309 602379 438454 435324 457092 386627 391150 465727 451247 467089 480727 496746 539593 527098 499568 521633 522462 523196 527306 526152 527736 531804 545375 568752 546016 553283 554544 562096 661903 626872 612962 429705 411469 423802 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (2.12%) |
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 386627 391150 399959 399973 410851 411469 412525 414105 422662 423348 423802 429705 432207 435221 435324 435606 435802 435822 438454 444839 445029 445977 446243 451247 451761 452825 452964 455398 456129 457092 465727 467089 480727 482411 486617 495077 496746 499568 503482 505665 505851 511323 511636 521625 521633 522462 523058 523196 523373 524759 525904 526152 527098 527306 527736 531804 532595 539593 544401 545375 546016 548167 548170 548859 550606 553283 553601 554544 555002 555384 555432 556345 559836 562096 562386 563361 563595 565896 568752 571789 572260 576514 579856 580136 584021 584904 585964 586005 586565 588048 589081 589519 591406 596244 599679 600347 600790 601211 601519 601798 602379 602727 603085 603302 605358 605707 612962 616511 618997 619612 624910 625227 625893 626872 629208 660373 661903 674240 745309 796816 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam girl finger"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер девушк палец"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер девушк палец"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.