SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806205 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806205 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83254,207439,837229,536545,380917,26044,518968,563519,167746,433866,805548,100118,161030,602457,356536,806179,407157,915627,407523,175654,277770,201626,408326,807924,848144,1009406,290115,739875,771739,70453,792021,229832,845179,658501,831073,1000391,550200,803214,132636,973994,65446,426843,405822,656375,501910,753461,355630,838788,320800,215979,167302,120931,774130,876272,840322,547852,445300,432816,665144,812537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]