SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201723 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201723 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496973,240585,491295,752942,48346,930898,203633,416646,736270,603785,92292,769959,489268,39137,7411,329101,627017,286841,303038,220475,689488,774615,1001166,129474,545989,986854,630497,1009161,646912,145333,1027827,118693,556586,129268,326961,333528,267917,408012,995897,251323,1043216,54085,538301,476546,804108,218129,208791,26535,26088,387130,727843,111858,754853,349246,722925,753194,586500,818900,12448,667098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]