Query Metrics
7
Database Queries
7
Different statements
347.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.44 ms (58.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
121.34 ms (34.89%) |
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 95586 95886 96231 97401 97571 129722 334376 381775 382051 385457 387562 388106 394597 395408 395440 395698 395758 395919 401184 401309 420471 426390 428383 429805 451527 479462 481149 495397 513893 514845 522644 522861 536206 537769 540868 542991 550285 580189 582579 587649 597170 597204 603209 606489 607828 622699 641628 647357 648414 649931 651199 653854 654189 665717 670761 671721 672579 683454 683470 686712 686821 687249 693576 699658 705828 708421 708433 708453 708525 708826 709589 711900 713375 714665 715371 717849 717899 720077 720078 720079 720145 720160 720385 720835 720892 721399 725630 728272 738483 740250 741241 741279 741284 741537 741655 743309 744103 748926 750469 752630 752650 756219 767208 769870 770875 770923 772708 775269 775892 775895 775915 776239 777052 784161 789028 789092 789516 802829 808988 825221 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (3.91%) |
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 649931 714665 720145 720835 648414 654189 708453 708525 641628 775895 777052 789092 741655 744103 770875 740250 741284 752630 607828 622699 709589 720385 429805 597204 481149 495397 395408 395440 395698 97571 428383 540868 825221 479462 522861 537769 513893 536206 522644 580189 542991 550285 582579 687249 708421 717899 720892 647357 651199 653854 670761 671721 683454 686712 686821 693576 699658 720160 665717 672579 683470 705828 708433 708826 711900 713375 715371 720079 606489 587649 603209 776239 789028 775915 802829 808988 725630 741241 741279 767208 772708 789516 728272 750469 752650 756219 770923 738483 769870 741537 743309 748926 717849 720077 720078 721399 775269 775892 784161 395758 401184 401309 451527 95886 381775 385457 387562 514845 597170 95586 129722 394597 395919 334376 382051 97401 96231 388106 420471 426390 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (0.84%) |
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 95586 95886 96231 97401 97571 129722 334376 381775 382051 385457 387562 388106 394597 395408 395440 395698 395758 395919 401184 401309 420471 426390 428383 429805 451527 479462 481149 495397 513893 514845 522644 522861 536206 537769 540868 542991 550285 580189 582579 587649 597170 597204 603209 606489 607828 622699 641628 647357 648414 649931 651199 653854 654189 665717 670761 671721 672579 683454 683470 686712 686821 687249 693576 699658 705828 708421 708433 708453 708525 708826 709589 711900 713375 714665 715371 717849 717899 720077 720078 720079 720145 720160 720385 720835 720892 721399 725630 728272 738483 740250 741241 741279 741284 741537 741655 743309 744103 748926 750469 752630 752650 756219 767208 769870 770875 770923 772708 775269 775892 775895 775915 776239 777052 784161 789028 789092 789516 802829 808988 825221 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double teens"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double teens"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double teens"
]
|
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.