SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540686 LIMIT 1 [ RunTime:0.000598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540686 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875278,83140,611201,24838,789564,412311,540858,714816,999099,590721,96277,266233,932540,883811,409503,723590,628471,526187,550161,226166,60752,344886,479895,510626,704719,793947,612125,240180,634187,30453,301442,596181,808515,514682,695606,736112,278380,63603,609664,905799,798550,248788,949376,790343,443326,332700,554708,85568,907733,780500,724065,848143,970148,838637,624245,566614,957073,25369,758166,814422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003939s ]