SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299451 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299451 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501018,709274,635640,925692,487881,578225,592508,40613,431957,777336,234933,330661,394241,980413,424723,7591,303881,615,782662,998901,14881,966787,725198,412014,861152,21208,499385,233926,917739,421659,641939,1036852,836966,635947,5125,548650,88975,260170,415643,795319,441451,124013,612073,229229,162332,155019,643776,862573,87953,793338,117941,147087,420965,275861,957709,262458,714625,739289,828672,708803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]