SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004813s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468289 LIMIT 1 [ RunTime:0.003390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468289 [ RunTime:0.002157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499913,59686,673472,118124,75728,383744,159212,821819,329407,747452,531205,1019282,58168,339832,793637,736862,447102,377362,101099,1007425,177995,825770,324100,815439,200488,741195,1022110,995481,117143,86964,170544,3490,1030950,29505,472960,175931,194346,669176,717484,738687,630088,554478,556449,193031,247608,635058,978629,525726,1016016,179327,82424,932996,119885,1041869,12282,58288,613562,767675,343308,48286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]