Query Metrics
7
Database Queries
7
Different statements
607.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
413.52 ms (68.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"face fucked"
]
|
||||||||||||||||||||||||||||||
|
158.88 ms (26.15%) |
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 400508 414961 426383 426806 427086 434590 434953 435290 439553 439606 444895 445208 447240 449320 450724 451304 451778 455429 455764 455922 456790 457676 457834 458324 460744 461159 461375 462286 463659 474279 478511 479685 481386 489142 490231 490496 492245 495233 495937 496270 498817 501538 503161 504718 504895 504962 508596 510114 510697 511099 511217 511484 512232 512755 512971 513573 514021 514459 514640 516023 516324 516669 516714 516852 519642 522690 522924 523364 523553 523568 524298 525452 526805 527227 527835 528055 537207 541230 545192 546380 549493 552372 552846 553673 558639 564962 565243 569546 570980 575871 582068 586554 589743 598190 599545 601485 602697 603004 609419 609540 615029 616779 619772 624320 639009 644047 650532 651561 667975 736770 809466 ] |
||||||||||||||||||||||||||||||
|
27.23 ms (4.48%) |
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 455764 457834 426806 434953 435290 444895 455429 434590 458324 463659 414961 479685 481386 511217 495233 512755 523364 519642 490231 492245 545192 549493 564962 552372 569546 570980 575871 650532 552846 639009 619772 589743 609419 624320 736770 615029 644047 451778 462286 451304 503161 512232 525452 527835 501538 514021 522924 524298 489142 510114 478511 461159 456790 516023 516669 523568 495937 558639 582068 541230 553673 651561 546380 609540 603004 809466 602697 474279 439553 427086 449320 504962 512971 514459 508596 510697 511099 511484 516852 527227 528055 426383 516324 523553 565243 667975 598190 400508 439606 460744 450724 445208 504718 526805 504895 447240 490496 498817 537207 586554 455922 513573 496270 516714 461375 514640 522690 601485 599545 616779 457676 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.46%) |
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 400508 414961 426383 426806 427086 434590 434953 435290 439553 439606 444895 445208 447240 449320 450724 451304 451778 455429 455764 455922 456790 457676 457834 458324 460744 461159 461375 462286 463659 474279 478511 479685 481386 489142 490231 490496 492245 495233 495937 496270 498817 501538 503161 504718 504895 504962 508596 510114 510697 511099 511217 511484 512232 512755 512971 513573 514021 514459 514640 516023 516324 516669 516714 516852 519642 522690 522924 523364 523553 523568 524298 525452 526805 527227 527835 528055 537207 541230 545192 546380 549493 552372 552846 553673 558639 564962 565243 569546 570980 575871 582068 586554 589743 598190 599545 601485 602697 603004 609419 609540 615029 616779 619772 624320 639009 644047 650532 651561 667975 736770 809466 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"face fucked"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"face fucked"
]
|
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.