SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023173 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023173 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518982,1019319,425499,954741,465221,962301,731477,669222,464295,618273,821359,814029,801776,505529,1282,868258,48128,441978,573400,415472,717987,149430,94491,477392,718138,604304,205999,628929,723643,526185,81244,47809,941630,446555,538556,521968,1001505,663090,1012284,407878,79394,500235,735081,980797,614007,138441,880853,63515,176670,20743,963691,962240,581064,606599,792458,992764,983964,827990,337957,369146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]