Query Metrics
7
Database Queries
7
Different statements
155.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.73 ms (80.96%) |
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 97377 400965 443786 451531 463122 474654 474689 485703 515568 516644 530912 541605 544862 545604 550207 558131 558614 559060 561334 562773 563399 564808 565096 565249 565254 565255 565259 565260 568175 574204 581682 581695 583976 584022 595775 597253 597263 597266 598057 601114 602532 603147 603164 603168 603243 603259 605338 614401 617652 622799 623196 624175 624179 627809 628093 628366 628368 628376 628388 628390 628392 630526 631965 632046 632588 632689 632979 637080 640797 641413 642043 642751 647969 648543 651188 651669 664305 666550 670758 671676 674368 679810 680112 680118 680126 680186 702164 702166 702927 704256 714436 714511 716030 716043 718968 727449 733840 733855 733870 733909 737521 748210 748212 748216 748231 748234 748236 748238 748239 748389 776521 788289 789711 789764 790234 803459 811945 814934 815737 820759 ] |
||||||||||||||||||||||||||||||
|
18.79 ms (12.10%) |
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 628390 640797 463122 530912 474654 474689 485703 623196 748389 815737 516644 568175 664305 718968 617652 789764 776521 788289 811945 748216 748234 748238 737521 748231 748239 789711 443786 97377 400965 544862 559060 574204 541605 564808 565249 565255 581682 583976 647969 666550 680112 702164 651188 671676 680126 702927 704256 563399 565096 565260 581695 597266 598057 601114 602532 624179 628376 597253 597263 603168 628093 628368 628388 628392 595775 603147 622799 733909 733855 605338 614401 714436 716030 565259 648543 550207 814934 558614 565254 584022 558131 674368 679810 702166 714511 670758 680118 561334 603259 627809 631965 632689 628366 632588 632979 642751 624175 630526 632046 637080 790234 733840 733870 642043 716043 451531 562773 651669 603164 603243 641413 727449 748210 803459 748212 748236 680186 515568 820759 545604 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.97%) |
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 97377 400965 443786 451531 463122 474654 474689 485703 515568 516644 530912 541605 544862 545604 550207 558131 558614 559060 561334 562773 563399 564808 565096 565249 565254 565255 565259 565260 568175 574204 581682 581695 583976 584022 595775 597253 597263 597266 598057 601114 602532 603147 603164 603168 603243 603259 605338 614401 617652 622799 623196 624175 624179 627809 628093 628366 628368 628376 628388 628390 628392 630526 631965 632046 632588 632689 632979 637080 640797 641413 642043 642751 647969 648543 651188 651669 664305 666550 670758 671676 674368 679810 680112 680118 680126 680186 702164 702166 702927 704256 714436 714511 716030 716043 718968 727449 733840 733855 733870 733909 737521 748210 748212 748216 748231 748234 748236 748238 748239 748389 776521 788289 789711 789764 790234 803459 811945 814934 815737 820759 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang old young"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang old young"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang old young"
]
|
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.