SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 24050 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 24050 [ RunTime:0.002482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430806,589282,310016,939646,104382,576238,1032835,98149,772063,395524,323305,999981,257567,476359,619251,583177,734911,744798,725502,852200,1017367,478960,887375,16105,464330,342827,646284,872411,137302,28131,671745,896158,747739,557248,3203,1025127,48231,515274,281130,273008,917802,352391,982843,878440,918280,526652,254835,970718,887612,626025,288378,944542,762488,215929,354726,937500,966951,513352,804885,445633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 24050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 24050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]