SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447281 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447281 [ RunTime:0.003126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370742,618375,541552,719168,436232,462581,212381,832221,1022436,429948,110767,46099,850726,897012,121312,556282,102528,1036986,640845,727694,280667,50138,496290,290797,104988,442612,955917,300749,579087,277380,982880,302364,920592,843409,694086,908946,224672,223364,589176,999823,323449,685984,521111,118627,1040970,893471,730328,1045258,392994,1024350,742962,137915,492548,726121,206125,772598,766315,711587,514104,726003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]