| 0.0002 |
SELECT uid_category, category_name_EN 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_EN product_name, product_url, seq FROM M_product ORDER BY uid_category asc, seq asc
|
| 0.0012 |
SELECT tt.* , mtc.topic_category_name_EN 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= '2' AND tt.topic_view_flg = '1' AND topic_top_flg='1' AND topic_view_date_from <= '2012-05-17 23:50:58' AND topic_view_date_upto >= '2012-05-17 23:50:58' ORDER BY tt.topic_date DESC LIMIT 3
|
| 0.0002 |
SELECT cat.category_name_EN category_name, cat.category_url, pd.*, pd.product_name_EN product_name FROM M_product pd INNER JOIN M_category cat ON pd.uid_category=cat.uid_category WHERE cat.category_url='sensor' AND pd.product_url='cooled_photodiode'
|
| 0.0011 |
SELECT xt.*, item.* ,cat.category_url, pd.product_url, pd.product_class FROM T_item item INNER JOIN ro_item_2_G 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=2 AND item.uid_product='21' 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=2 AND view_table=0 AND uid_product='21' ORDER BY row asc, col asc
|
