SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35280 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35280 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209344,711281,782621,62491,820044,585399,491375,1022146,997270,80545,204913,581853,542303,495833,26017,892838,683047,128158,561333,827209,62458,183643,202231,516354,711559,715430,850969,388772,105878,909045,3017,195041,55697,1006654,646705,687315,92371,247644,770120,196590,844978,360457,845656,319168,408551,515764,537974,167694,396366,124115,724682,38404,413969,247040,22190,951864,1005160,757420,51083,973706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]