SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545186 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545186 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107810,962398,263274,219608,826394,645813,824354,1018118,982670,120055,326548,554780,522541,622537,223173,319155,365869,77742,468638,426493,1029996,978814,888291,54567,595795,452053,830570,186471,714684,133672,20531,589851,808733,791804,91642,464859,748008,747653,58405,34344,548298,677408,898369,12552,456883,563271,944825,692147,898510,983704,116326,1047486,505822,624045,957638,85173,226252,341172,98059,87089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]