Query Metrics
7
Database Queries
7
Different statements
354.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.45 ms (59.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc double penetration"
]
|
||||||||||||||||||||||||||||||
|
116.17 ms (32.74%) |
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 403162 403641 404368 405054 405468 406304 409921 413263 414342 414358 416794 416820 421200 421557 423655 424782 429766 429770 432799 435624 435695 437526 455851 463073 464704 467583 468637 469555 471317 474619 474714 476143 482936 482938 491449 497901 501255 511318 514798 518554 527411 530019 530022 530483 530627 530643 530766 530911 531175 531189 531198 531206 531211 532988 533051 533870 534041 534150 534381 534650 534986 534993 535005 535024 536580 536640 537196 537590 537747 537899 537901 537917 538881 541844 542591 542965 544819 545399 549514 550201 556421 572042 578596 583905 644940 645812 646178 646875 648832 648855 648867 649110 649188 649504 650161 650165 650333 651090 651135 651204 666907 667747 674980 674984 676080 676111 676622 677827 678109 679317 679326 679744 679773 679803 680127 680149 693504 714464 720245 815413 ] |
||||||||||||||||||||||||||||||
|
19.96 ms (5.62%) |
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 403162 403641 404368 406304 405054 405468 413263 432799 435695 437526 409921 414342 416794 416820 414358 424782 429770 435624 421200 423655 429766 421557 644940 815413 467583 468637 476143 463073 482936 491449 455851 469555 497901 501255 518554 530022 530483 530627 530911 531189 531206 534041 534150 534650 534986 530766 531175 532988 533051 533870 534993 535005 536580 537196 537590 537899 511318 514798 530019 531211 534381 535024 537901 537917 538881 527411 530643 531198 536640 537747 464704 471317 474619 474714 482938 541844 542591 545399 549514 556421 572042 578596 583905 542965 544819 550201 646178 648832 648867 649504 650161 650333 674980 676080 676111 677827 679744 679773 680149 714464 720245 645812 648855 649110 650165 651090 651135 651204 666907 667747 674984 676622 678109 679317 679326 679803 680127 693504 646875 649188 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (0.71%) |
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 403162 403641 404368 405054 405468 406304 409921 413263 414342 414358 416794 416820 421200 421557 423655 424782 429766 429770 432799 435624 435695 437526 455851 463073 464704 467583 468637 469555 471317 474619 474714 476143 482936 482938 491449 497901 501255 511318 514798 518554 527411 530019 530022 530483 530627 530643 530766 530911 531175 531189 531198 531206 531211 532988 533051 533870 534041 534150 534381 534650 534986 534993 535005 535024 536580 536640 537196 537590 537747 537899 537901 537917 538881 541844 542591 542965 544819 545399 549514 550201 556421 572042 578596 583905 644940 645812 646178 646875 648832 648855 648867 649110 649188 649504 650161 650165 650333 651090 651135 651204 666907 667747 674980 674984 676080 676111 676622 677827 678109 679317 679326 679744 679773 679803 680127 680149 693504 714464 720245 815413 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.47%) |
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.