Query Metrics
7
Database Queries
7
Different statements
170.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.34 ms (84.59%) |
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 25721 118141 188447 341079 358453 384147 386717 386893 388773 389785 395555 396060 396245 396825 397652 397867 397953 400382 410686 413356 418061 418871 419319 425285 425903 428575 434067 439749 439772 441336 441535 442377 443744 443916 445429 447966 456381 456701 460302 460343 464347 465542 466579 466816 468706 468888 469540 476725 478601 487682 489106 492355 493163 502741 513194 518446 520729 521453 525081 527933 533707 535423 544478 546964 548153 548991 549824 552331 559132 559300 560286 560289 565501 572954 580626 583547 584946 586564 593701 598263 604285 604981 610526 610821 611517 616242 618360 621246 623834 624349 652907 675405 677025 680295 680322 687310 697607 708905 726897 727844 740893 742345 742742 743069 763431 767064 768358 769496 779659 782529 783067 790900 791096 800247 800303 800304 801800 803556 804344 814465 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (10.23%) |
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 456701 652907 447966 456381 565501 586564 487682 598263 521453 527933 583547 466816 552331 623834 502741 478601 621246 610526 618360 425285 492355 767064 489106 800304 548991 443916 560289 25721 814465 493163 513194 468706 533707 460343 791096 675405 395555 434067 460302 604981 548153 428575 611517 559300 572954 396825 708905 443744 546964 518446 610821 580626 439749 442377 419319 549824 466579 520729 439772 535423 468888 410686 425903 469540 544478 677025 559132 386717 790900 743069 413356 803556 742742 389785 358453 742345 768358 464347 779659 726897 783067 804344 584946 604285 624349 782529 769496 801800 397867 800247 441336 441535 188447 445429 525081 476725 388773 465542 680295 687310 680322 740893 763431 418061 616242 384147 418871 396060 560286 386893 397652 697607 400382 397953 593701 727844 800303 341079 118141 396245 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.49%) |
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 25721 118141 188447 341079 358453 384147 386717 386893 388773 389785 395555 396060 396245 396825 397652 397867 397953 400382 410686 413356 418061 418871 419319 425285 425903 428575 434067 439749 439772 441336 441535 442377 443744 443916 445429 447966 456381 456701 460302 460343 464347 465542 466579 466816 468706 468888 469540 476725 478601 487682 489106 492355 493163 502741 513194 518446 520729 521453 525081 527933 533707 535423 544478 546964 548153 548991 549824 552331 559132 559300 560286 560289 565501 572954 580626 583547 584946 586564 593701 598263 604285 604981 610526 610821 611517 616242 618360 621246 623834 624349 652907 675405 677025 680295 680322 687310 697607 708905 726897 727844 740893 742345 742742 743069 763431 767064 768358 769496 779659 782529 783067 790900 791096 800247 800303 800304 801800 803556 804344 814465 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал рако"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал рак"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.78%) |
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.