SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200403 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200403 [ RunTime:0.003555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29145,58256,317754,989572,6752,311726,1009771,110981,602322,854410,1042275,410824,764550,745551,822276,242604,706679,39312,465684,543309,598390,174721,685471,336747,299607,138894,974879,483067,114226,1009091,357065,737460,32021,388851,284868,109149,271876,334262,830113,48703,967790,440133,1040547,790106,793040,329782,554656,301335,737549,865713,475731,802856,817093,540804,629579,215987,363220,726870,235035,771787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]