Query Metrics
7
Database Queries
7
Different statements
142.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.10 ms (83.37%) |
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 114756 148814 233443 363076 382353 383609 384233 385112 392217 392347 397095 398064 398274 399853 401309 404122 404276 404554 408502 410299 410308 410623 411455 412180 415200 415875 416142 416242 416707 420108 422420 426361 432796 442627 443549 444853 445854 454304 456103 456699 463819 463863 465993 466104 472110 474021 484279 494058 494384 538289 544126 544421 553996 556331 561649 561685 567137 568478 589720 598470 603482 605680 614244 619800 630160 646129 652247 656625 665865 665916 671633 673459 673776 676931 677345 677365 678586 690912 691915 693103 702629 702636 704232 710711 713052 713895 716074 716129 716485 722354 722623 725934 731846 736042 739764 740269 744977 747523 750565 752587 755592 755926 756838 758991 759357 761092 765285 766622 766679 766717 766871 773662 779711 785577 790958 792468 805650 805941 811629 812436 ] |
||||||||||||||||||||||||||||||
|
14.59 ms (10.21%) |
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 731846 758991 773662 747523 725934 740269 744977 766717 805650 392347 656625 792468 444853 454304 404276 420108 410623 416707 408502 416242 442627 484279 456103 385112 404554 445854 603482 410308 465993 363076 544421 568478 673776 790958 805941 716074 422420 538289 677365 690912 630160 779711 759357 713895 785577 148814 693103 411455 665865 673459 704232 713052 671633 691915 722354 619800 811629 766622 750565 766679 702629 702636 398274 415200 614244 401309 474021 556331 665916 722623 598470 736042 233443 456699 494384 605680 404122 397095 466104 384233 494058 463863 416142 561649 443549 114756 382353 472110 410299 399853 412180 561685 463819 426361 398064 567137 752587 765285 383609 652247 676931 677345 678586 646129 589720 739764 755592 756838 766871 755926 761092 710711 716129 716485 812436 392217 415875 432796 544126 553996 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (2.03%) |
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 114756 148814 233443 363076 382353 383609 384233 385112 392217 392347 397095 398064 398274 399853 401309 404122 404276 404554 408502 410299 410308 410623 411455 412180 415200 415875 416142 416242 416707 420108 422420 426361 432796 442627 443549 444853 445854 454304 456103 456699 463819 463863 465993 466104 472110 474021 484279 494058 494384 538289 544126 544421 553996 556331 561649 561685 567137 568478 589720 598470 603482 605680 614244 619800 630160 646129 652247 656625 665865 665916 671633 673459 673776 676931 677345 677365 678586 690912 691915 693103 702629 702636 704232 710711 713052 713895 716074 716129 716485 722354 722623 725934 731846 736042 739764 740269 744977 747523 750565 752587 755592 755926 756838 758991 759357 761092 765285 766622 766679 766717 766871 773662 779711 785577 790958 792468 805650 805941 811629 812436 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая teen анал"
]
|
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.