| 0.0002 |
SELECT uid_category, category_name_JA category_name, category_url FROM M_category ORDER BY seq asc, uid_category asc
|
| 0.0002 |
SELECT uid_product, uid_category, product_class, product_name_JA product_name, product_url, seq FROM M_product ORDER BY uid_category asc, seq asc
|
| 0.0012 |
SELECT tt.* , mtc.topic_category_name_JA topic_category_name , mtc.topic_category_url FROM T_topic tt INNER JOIN M_topic_category mtc ON tt.uid_topic_category=mtc.uid_topic_category WHERE tt.uid_language= '1' AND tt.topic_view_flg = '1' AND topic_top_flg='1' AND topic_view_date_from <= '2012-05-17 22:16:10' AND topic_view_date_upto >= '2012-05-17 22:16:10' ORDER BY tt.topic_date DESC LIMIT 3
|
| 0.0004 |
SELECT cat.category_name_JA category_name, cat.category_url, pd.product_class, pd.product_name_JA product_name, pd.product_url, item.* FROM M_category cat INNER JOIN M_product pd ON cat.uid_category=pd.uid_category INNER JOIN T_item item ON pd.uid_product=item.uid_product WHERE item.uid_language=1 AND cat.category_url='communication' AND pd.product_url='ingaas_avalanche_photodiode' AND item.item_url='kpdea007_56f' AND item.disp_flg=1
|
| 0.0007 |
SELECT spec.uid_spec, spec.view_table, spec.view_detail, spec.spec_name, spec.spec_type, spec.spec_symbol, spec.spec_unit, val.uid_value, val.value FROM T_value val INNER JOIN T_spec spec ON val.uid_spec=spec.uid_spec WHERE val.uid_item='33' AND spec.view_detail>0 AND val.value!='' ORDER BY spec.view_table asc, spec.view_detail asc, uid_spec asc
|
| 0.0008 |
SELECT xt.*, item.* ,cat.category_url, pd.product_url, pd.product_class FROM T_item item INNER JOIN ro_item_1_A xt ON item.uid_item=xt.uid_item INNER JOIN M_category cat ON item.uid_category=cat.uid_category INNER JOIN M_product pd ON item.uid_product=pd.uid_product WHERE item.uid_language=1 AND item.uid_product='3' AND item.disp_flg=1 ORDER BY item.seq asc, item.uid_item asc
|
| 0.0006 |
SELECT row, col, head_row, head_col, disp_str value FROM T_table_def WHERE uid_language=1 AND view_table=0 AND uid_product='3' ORDER BY row asc, col asc
|
