SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820166 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820166 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034499,342065,709367,727910,1042594,683375,78129,104182,392456,972203,731039,516996,712485,236441,370754,999206,801979,253815,962400,430094,803421,257267,157909,206820,436521,136514,538768,113137,955777,707820,879913,750068,626635,844148,466482,795225,665012,1012582,132641,698451,920409,632484,861409,731020,544437,968066,397981,1044582,592900,383527,544021,14846,636340,290878,158285,629743,71065,27973,987048,609612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]