1 |
1.97 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price_model AS price_model_5, t0.website_url AS website_url_6, t0.api_available AS api_available_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12, t13.id AS id_14, t13.introduction AS introduction_15, t13.advantages AS advantages_16, t13.disadvantages AS disadvantages_17, t13.comparisons AS comparisons_18, t13.conclusion AS conclusion_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.ai_tool_id AS ai_tool_id_22 FROM aitool t0 LEFT JOIN ai_article t13 ON t13.ai_tool_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price_model AS price_model_5, t0.website_url AS website_url_6, t0.api_available AS api_available_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12, t13.id AS id_14, t13.introduction AS introduction_15, t13.advantages AS advantages_16, t13.disadvantages AS disadvantages_17, t13.comparisons AS comparisons_18, t13.conclusion AS conclusion_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.ai_tool_id AS ai_tool_id_22 FROM aitool t0 LEFT JOIN ai_article t13 ON t13.ai_tool_id = t0.id WHERE t0.id = '2';
|
2 |
1.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price_model AS price_model_5, t0.website_url AS website_url_6, t0.api_available AS api_available_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12, t13.id AS id_14, t13.introduction AS introduction_15, t13.advantages AS advantages_16, t13.disadvantages AS disadvantages_17, t13.comparisons AS comparisons_18, t13.conclusion AS conclusion_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.ai_tool_id AS ai_tool_id_22 FROM aitool t0 LEFT JOIN ai_article t13 ON t13.ai_tool_id = t0.id WHERE t0.category_id = ? ORDER BY t0.name ASC LIMIT 5
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price_model AS price_model_5, t0.website_url AS website_url_6, t0.api_available AS api_available_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12, t13.id AS id_14, t13.introduction AS introduction_15, t13.advantages AS advantages_16, t13.disadvantages AS disadvantages_17, t13.comparisons AS comparisons_18, t13.conclusion AS conclusion_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.ai_tool_id AS ai_tool_id_22 FROM aitool t0 LEFT JOIN ai_article t13 ON t13.ai_tool_id = t0.id WHERE t0.category_id = 1 ORDER BY t0.name ASC LIMIT 5;
|