SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302580 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302580 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970063,224902,284584,969293,818797,287846,516868,31545,508591,852143,1042690,149753,260446,884514,634669,425844,361148,379397,51696,588580,134118,567477,90964,421558,416738,912024,375272,632794,861527,978824,41698,6059,975981,543836,321850,830101,413914,860939,233752,595885,788359,869922,925314,52487,481735,700210,697274,388096,91534,279582,953124,311288,40214,813310,201922,797327,591032,495797,923039,288396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]