Query Metrics
7
Database Queries
7
Different statements
359.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.78 ms (58.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
119.12 ms (33.17%) |
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 7615 11947 33098 95742 96256 328446 340206 360015 384200 384332 385003 385910 391086 394535 395410 395598 396699 396722 396732 397805 397992 399358 399411 399628 399722 400770 401340 401704 402891 404264 405042 407429 408443 409893 410057 410096 414069 414361 416099 417797 417826 417888 417893 418202 420301 421077 422328 423658 424783 425493 429171 429432 430088 430142 430290 430762 431681 432741 433823 443429 443457 444771 444971 445433 445571 445623 448619 448650 452153 453016 453294 458918 463108 464090 464194 465168 465177 467063 467111 467612 467915 468006 468849 474772 478054 478235 482714 482793 482937 485225 489394 490576 491378 492125 492300 492479 494277 494351 494365 498485 502048 507219 512728 512797 513746 515236 516818 517611 521943 523947 523951 525375 528836 529209 539058 565414 565916 580706 597999 785405 ] |
||||||||||||||||||||||||||||||
|
19.74 ms (5.50%) |
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 395410 464194 391086 405042 423658 394535 399358 399722 408443 521943 502048 525375 507219 385910 385003 328446 340206 11947 397805 397992 399411 399628 414069 417797 407429 424783 429171 433823 417893 432741 467111 467915 490576 448619 458918 517611 498485 467063 785405 409893 417826 96256 400770 431681 418202 430762 402891 414361 464090 465177 512728 513746 95742 396722 396699 422328 425493 429432 444771 444971 430290 443457 430142 420301 430088 482714 453294 445623 453016 463108 467612 448650 452153 482937 485225 494277 515236 512797 494351 474772 478054 565916 7615 401704 410096 445433 395598 396732 421077 445571 478235 384200 416099 523947 539058 492300 492479 523951 528836 529209 492125 516818 384332 401340 410057 482793 580706 360015 491378 33098 404264 443429 465168 494365 565414 597999 468849 417888 468006 489394 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (0.96%) |
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 7615 11947 33098 95742 96256 328446 340206 360015 384200 384332 385003 385910 391086 394535 395410 395598 396699 396722 396732 397805 397992 399358 399411 399628 399722 400770 401340 401704 402891 404264 405042 407429 408443 409893 410057 410096 414069 414361 416099 417797 417826 417888 417893 418202 420301 421077 422328 423658 424783 425493 429171 429432 430088 430142 430290 430762 431681 432741 433823 443429 443457 444771 444971 445433 445571 445623 448619 448650 452153 453016 453294 458918 463108 464090 464194 465168 465177 467063 467111 467612 467915 468006 468849 474772 478054 478235 482714 482793 482937 485225 489394 490576 491378 492125 492300 492479 494277 494351 494365 498485 502048 507219 512728 512797 513746 515236 516818 517611 521943 523947 523951 525375 528836 529209 539058 565414 565916 580706 597999 785405 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"nigger girl"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожий девушк"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.