| 1 |
2.05 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.weight AS weight_3, t0.key_type AS key_type_4 FROM tag t0 WHERE t0.key_type = ? ORDER BY t0.weight ASC
Parameters: [
"tag_article"
]
SELECT t0.id AS id_1, t0.value AS value_2, t0.weight AS weight_3, t0.key_type AS key_type_4 FROM tag t0 WHERE t0.key_type = 'tag_article' ORDER BY t0.weight ASC;
|
| 2 |
1.29 ms |
SELECT t0.id AS id_1, t0.title_key AS title_key_2, t0.title_value AS title_value_3 FROM title t0 WHERE t0.title_key = ? LIMIT 1
Parameters: [
"publication-tags"
]
SELECT t0.id AS id_1, t0.title_key AS title_key_2, t0.title_value AS title_value_3 FROM title t0 WHERE t0.title_key = 'publication-tags' LIMIT 1;
|
| 3 |
1.27 ms |
SELECT t0.id AS id_1, t0.description_key AS description_key_2, t0.description_value AS description_value_3 FROM description t0 WHERE t0.description_key = ? LIMIT 1
Parameters: [
"publication-tags"
]
SELECT t0.id AS id_1, t0.description_key AS description_key_2, t0.description_value AS description_value_3 FROM description t0 WHERE t0.description_key = 'publication-tags' LIMIT 1;
|
| 4 |
1.61 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = ? ORDER BY t0.date DESC
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = 1 ORDER BY t0.date DESC;
|
| 5 |
1.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = ? ORDER BY t0.date DESC
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = 2 ORDER BY t0.date DESC;
|
| 6 |
0.51 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = ? ORDER BY t0.date DESC
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = 3 ORDER BY t0.date DESC;
|
| 7 |
0.78 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = ? ORDER BY t0.date DESC
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = 4 ORDER BY t0.date DESC;
|
| 8 |
0.77 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = ? ORDER BY t0.date DESC
SELECT t0.id AS id_1, t0.title AS title_2, t0.picture AS picture_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.title_seo AS title_seo_6, t0.description_seo AS description_seo_7, t0.date AS date_8, t0.credit_photo AS credit_photo_9, t0.state AS state_10, t0.date_update AS date_update_11, t0.update_from AS update_from_12, t0.second_category AS second_category_13, t0.second_account AS second_account_14, t0.category_id AS category_id_15, t0.account_id AS account_id_16 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = 5 ORDER BY t0.date DESC;
|