SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201201 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201201 [ RunTime:0.003235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518043,147997,238772,564320,394211,478963,307521,943329,1034515,397625,1024557,390750,298230,241820,310738,391855,839947,253412,617482,624168,690832,373577,897193,850127,745258,252333,709093,213774,31744,426807,201066,178097,519044,15732,1016847,384251,101150,25931,695595,13185,20274,562946,882902,470727,549735,341683,568299,782369,10603,482022,637508,169635,333863,713940,12723,897200,579329,486135,169675,842992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]