SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503002 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503002 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623189,764725,8060,815660,332734,342052,820675,24296,676950,533604,783420,495301,508345,96899,422384,514310,571785,184469,202408,481587,409093,561024,775335,265312,721787,646327,192734,429602,142057,670292,250040,59513,535453,273114,908818,347650,376996,213877,319056,742077,553996,988663,413368,250706,20487,1027747,217913,198517,408921,845808,940456,435252,198427,724375,644672,991387,800090,382295,977509,660079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]