SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54571 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54571 [ RunTime:0.006289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96621,868809,327814,740505,636260,230842,294199,810981,126278,442482,815634,317421,929196,243795,701920,19960,456994,61925,782350,131313,908702,649664,247966,891327,62444,361822,907520,411042,547135,932916,873943,756711,992314,838045,624922,476093,259564,135076,109004,103883,198420,141944,458234,230779,624442,563733,98033,115216,870241,752731,896354,400931,295364,11203,932534,163921,500111,1021673,590606,38115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000922s ]