SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548012 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548012 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396882,27474,33376,810741,190681,892850,972298,420706,393982,908720,907080,1036015,608887,748546,245441,384270,850541,354436,95600,657807,81963,94348,801248,155640,491654,267798,757849,228211,677492,847823,805253,47998,954721,243612,439709,1002458,545034,906351,753636,816626,555171,1019575,370533,35705,729463,1034709,577650,865972,188323,29156,517865,731984,311185,45432,549630,1041374,961829,415980,268422,921835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001607s ]