Query Metrics
7
Database Queries
7
Different statements
395.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.60 ms (53.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob in car"
]
|
||||||||||||||||||||||||||||||
|
159.91 ms (40.43%) |
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 4048 30680 83312 151163 384754 384780 395223 400677 401559 402866 413534 414183 418860 419132 420464 420748 424755 425249 426654 438317 448273 449643 453341 454756 455278 457862 458127 458658 459092 460151 461367 465263 465692 467170 469170 469172 469651 470086 470828 476553 480304 480674 480916 480919 480922 481134 481711 482367 486561 486565 486567 487747 490270 492278 492468 492477 492501 495130 497284 497545 498234 503011 503944 504610 504620 505812 509537 510675 518299 521825 522615 523510 524387 528620 529441 532246 535169 542108 546476 549541 555569 555907 557349 558957 561242 563457 565439 577607 584274 585776 598757 602774 609591 611414 617772 640663 640822 650299 654984 660090 662583 672302 699151 713692 718530 720849 721275 725377 725394 744501 754038 754878 764944 770373 781184 781393 791971 798904 798907 798940 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (4.12%) |
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 453341 419132 609591 654984 549541 584274 798907 791971 426654 505812 504610 458658 458127 151163 577607 30680 660090 509537 400677 561242 83312 518299 480922 495130 497545 465263 457862 460151 480674 455278 459092 764944 481711 470086 522615 425249 497284 585776 754878 469170 492468 469172 504620 461367 529441 546476 449643 470828 523510 492278 598757 486565 420464 521825 465692 555569 492477 490270 480304 486561 454756 448273 528620 401559 565439 542108 602774 469651 498234 476553 524387 510675 503944 480919 487747 486567 413534 424755 418860 480916 482367 481134 532246 4048 718530 555907 557349 492501 798940 650299 535169 611414 781184 725377 770373 640822 384754 672302 395223 563457 713692 558957 617772 754038 503011 720849 662583 384780 721275 402866 467170 438317 725394 798904 744501 699151 420748 781393 414183 640663 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (0.81%) |
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 4048 30680 83312 151163 384754 384780 395223 400677 401559 402866 413534 414183 418860 419132 420464 420748 424755 425249 426654 438317 448273 449643 453341 454756 455278 457862 458127 458658 459092 460151 461367 465263 465692 467170 469170 469172 469651 470086 470828 476553 480304 480674 480916 480919 480922 481134 481711 482367 486561 486565 486567 487747 490270 492278 492468 492477 492501 495130 497284 497545 498234 503011 503944 504610 504620 505812 509537 510675 518299 521825 522615 523510 524387 528620 529441 532246 535169 542108 546476 549541 555569 555907 557349 558957 561242 563457 565439 577607 584274 585776 598757 602774 609591 611414 617772 640663 640822 650299 654984 660090 662583 672302 699151 713692 718530 720849 721275 725377 725394 744501 754038 754878 764944 770373 781184 781393 791971 798904 798907 798940 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.42%) |
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.