SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001908s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 209151 LIMIT 1 [ RunTime:0.001714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 209151 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468181,68938,132765,116537,554558,306848,561358,327151,561868,708284,727543,886676,401501,302890,684661,764053,855427,924138,508731,788223,347666,553601,632664,509303,751770,944454,967054,594370,161413,1047073,427354,725417,669430,463310,915868,438299,118590,957218,409430,807885,931511,585114,1001562,621935,956282,957797,558534,319856,577519,81338,929176,644731,801622,404044,1037535,967558,832653,810531,1031841,314467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 209151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 209151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]