Query Metrics
7
Database Queries
7
Different statements
156.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.08 ms (82.99%) |
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 381817 384463 386189 389729 400491 411321 411325 419531 420311 421832 422803 425724 426295 426919 429872 431643 438013 440761 441094 442072 442128 444915 450268 450287 452331 452354 454156 454507 455151 456312 458770 460444 461129 462461 463825 463832 464889 466226 466341 466855 467835 468269 468675 468836 471162 471605 472943 473533 474117 476321 476676 477223 478269 484648 485695 486969 497203 500429 500914 502467 502578 506057 506252 509261 509590 509836 510546 515266 517735 518598 519068 521107 527476 532700 532893 534138 537893 538021 549836 557327 558177 561354 562346 563448 565306 574459 578180 579224 581165 581749 586578 587124 594300 600946 604933 605679 617115 619604 624905 646243 649523 659385 665288 667496 667543 667898 669387 698102 705424 710161 714927 730975 744202 748255 781990 796877 796881 808151 815789 ] |
||||||||||||||||||||||||||||||
|
17.34 ms (11.07%) |
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 454507 456312 506057 502578 521107 484648 381817 468269 605679 730975 477223 472943 386189 509836 461129 532700 532893 462461 698102 450268 422803 815789 473533 452354 471162 476321 500429 510546 517735 534138 578180 624905 466226 464889 425724 440761 665288 667543 549836 600946 594300 429872 466341 420311 442072 441094 442128 466855 537893 538021 527476 563448 649523 659385 619604 586578 796881 787989 781990 796877 808151 389729 411325 463832 467835 486969 506252 497203 455151 476676 604933 500914 667496 400491 474117 384463 705424 485695 463825 515266 574459 646243 667898 748255 454156 438013 509590 587124 450287 557327 561354 669387 714927 419531 426295 431643 458770 468675 518598 558177 581165 579224 565306 581749 710161 617115 478269 426919 460444 444915 471605 452331 421832 468836 502467 519068 509261 744202 562346 411321 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.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 381817 384463 386189 389729 400491 411321 411325 419531 420311 421832 422803 425724 426295 426919 429872 431643 438013 440761 441094 442072 442128 444915 450268 450287 452331 452354 454156 454507 455151 456312 458770 460444 461129 462461 463825 463832 464889 466226 466341 466855 467835 468269 468675 468836 471162 471605 472943 473533 474117 476321 476676 477223 478269 484648 485695 486969 497203 500429 500914 502467 502578 506057 506252 509261 509590 509836 510546 515266 517735 518598 519068 521107 527476 532700 532893 534138 537893 538021 549836 557327 558177 561354 562346 563448 565306 574459 578180 579224 581165 581749 586578 587124 594300 600946 604933 605679 617115 619604 624905 646243 649523 659385 665288 667496 667543 667898 669387 698102 705424 710161 714927 730975 744202 748255 781990 796877 796881 808151 815789 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby big dildo"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.92%) |
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.