Query Metrics
7
Database Queries
7
Different statements
181.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.40 ms (86.60%) |
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 6643 13373 46283 96886 109043 145343 152056 185523 213396 241970 310133 383440 385037 385578 386068 387150 391009 391134 396042 396142 397014 397068 398395 400829 400977 401507 401509 401581 401637 404418 406521 406907 407567 408447 408578 409882 409949 410029 411925 412518 416143 418719 422704 423646 427264 430227 431193 431672 446770 449335 453320 455478 457492 457752 460051 460931 465841 465846 471029 472790 473073 473768 474078 474315 476157 477569 487737 490107 490675 492156 492397 492664 502022 516990 522702 526460 528965 529372 530331 535598 542492 551992 553107 555547 561725 563734 570382 576490 589936 591730 592545 593261 593634 598087 599962 614803 618920 630016 645813 650951 653697 660711 674017 675230 677360 677371 680517 697296 715370 720088 724696 770570 774635 794425 795180 797735 810482 819396 824224 ] |
||||||||||||||||||||||||||||||
|
13.89 ms (7.64%) |
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 465841 474315 185523 410029 529372 561725 553107 660711 697296 593634 397068 386068 145343 471029 492664 555547 675230 593261 772838 794425 46283 401507 383440 598087 473768 241970 13373 473073 535598 213396 599962 416143 455478 477569 526460 516990 576490 715370 645813 810482 431672 401509 406907 522702 460051 490675 492156 551992 570382 396042 400829 431193 457492 412518 409949 472790 490107 465846 407567 423646 528965 530331 542492 310133 396142 650951 680517 720088 618920 592545 630016 795180 797735 770570 408447 397014 422704 446770 400977 819396 824224 460931 502022 6643 385578 427264 152056 398395 401581 430227 418719 387150 391009 409882 411925 476157 492397 677360 677371 563734 589936 591730 614803 724696 109043 404418 474078 391134 408578 449335 385037 457752 406521 96886 674017 774635 401637 453320 487737 653697 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.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 6643 13373 46283 96886 109043 145343 152056 185523 213396 241970 310133 383440 385037 385578 386068 387150 391009 391134 396042 396142 397014 397068 398395 400829 400977 401507 401509 401581 401637 404418 406521 406907 407567 408447 408578 409882 409949 410029 411925 412518 416143 418719 422704 423646 427264 430227 431193 431672 446770 449335 453320 455478 457492 457752 460051 460931 465841 465846 471029 472790 473073 473768 474078 474315 476157 477569 487737 490107 490675 492156 492397 492664 502022 516990 522702 526460 528965 529372 530331 535598 542492 551992 553107 555547 561725 563734 570382 576490 589936 591730 592545 593261 593634 598087 599962 614803 618920 630016 645813 650951 653697 660711 674017 675230 677360 677371 680517 697296 715370 720088 724696 770570 774635 794425 795180 797735 810482 819396 824224 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful hairy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
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.