SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340813 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340813 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971723,95654,104967,665726,54331,522277,367334,778394,875066,821741,673948,416985,954642,523041,20011,771904,1036103,762894,848481,684853,289021,921275,616968,612953,468258,888244,682859,1027056,191927,885470,860659,1035627,144712,576806,1017726,459636,539469,180913,393807,362388,749974,805930,199936,710034,850101,689430,324133,179932,200100,538735,297308,978563,82388,809072,313255,229335,551113,738103,756547,577011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002044s ]