Query Metrics
7
Database Queries
7
Different statements
177.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.81 ms (84.32%) |
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 157194 403588 420762 421030 435502 443653 445740 446718 459513 463511 463625 479814 479835 483248 501487 512059 513050 513095 513408 513953 514842 515122 516103 517117 517240 517368 519092 519927 520127 520290 520448 520485 520744 521077 522215 522525 523537 524613 526621 529457 531195 531231 535450 536664 536684 540071 542743 542746 542748 542751 542753 542770 542790 543777 543844 546724 557246 559223 559482 561135 561470 569421 572026 577096 580289 581734 583723 584262 584667 584724 585332 586554 589036 589345 590861 591198 591304 591413 591416 599368 600256 600968 603713 605636 606759 606948 608930 609933 612087 613177 613300 618674 619423 622978 623334 623380 624090 624111 626576 627750 628324 630915 634856 637650 638115 650992 688007 688055 688575 688664 718695 718747 720257 720288 720298 729251 733204 759865 790793 790799 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (9.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 514842 519092 483248 443653 517368 531195 513408 520485 542790 561470 581734 542748 559223 546724 584667 720257 718747 559482 606759 585332 600256 624090 591304 637650 589345 626576 630915 790793 790799 759865 729251 623334 157194 420762 435502 421030 479835 479814 526621 517240 536664 536684 463625 542743 542753 542770 542746 542751 561135 688055 688575 720288 618674 622978 590861 600968 591413 619423 628324 718695 403588 445740 519927 513095 520290 513953 520127 520744 521077 535450 463511 540071 543777 688664 650992 720298 557246 584724 589036 612087 638115 605636 733204 603713 446718 501487 522215 522525 524613 520448 459513 523537 531231 577096 688007 591416 608930 586554 624111 627750 613177 634856 517117 529457 513050 569421 580289 591198 609933 516103 515122 572026 543844 583723 584262 606948 613300 623380 599368 512059 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.08%) |
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 157194 403588 420762 421030 435502 443653 445740 446718 459513 463511 463625 479814 479835 483248 501487 512059 513050 513095 513408 513953 514842 515122 516103 517117 517240 517368 519092 519927 520127 520290 520448 520485 520744 521077 522215 522525 523537 524613 526621 529457 531195 531231 535450 536664 536684 540071 542743 542746 542748 542751 542753 542770 542790 543777 543844 546724 557246 559223 559482 561135 561470 569421 572026 577096 580289 581734 583723 584262 584667 584724 585332 586554 589036 589345 590861 591198 591304 591413 591416 599368 600256 600968 603713 605636 606759 606948 608930 609933 612087 613177 613300 618674 619423 622978 623334 623380 624090 624111 626576 627750 628324 630915 634856 637650 638115 650992 688007 688055 688575 688664 718695 718747 720257 720288 720298 729251 733204 759865 790793 790799 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom husband"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom husband"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom husband"
]
|
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.