SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196930 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196930 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652900,820060,844569,119642,538963,727567,1012304,413810,278980,40386,368673,356705,642465,504195,948919,179304,777023,200683,404558,774786,582110,618460,261359,673427,780380,902727,19378,934287,797996,471358,901093,167102,852362,608639,859301,902789,512358,952379,21238,714281,235432,556629,812725,1007322,949210,149904,631454,5763,399067,173750,22496,707004,637798,382461,758155,5054,536948,831497,244571,544516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]