SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588051 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588051 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592184,148974,22827,917434,58060,151744,37140,1026050,83498,286527,972498,765425,854553,318769,246401,14226,155826,262242,810670,785130,207166,905995,761037,506710,985321,324465,222010,872757,507627,606147,750001,573230,383598,106073,207311,582766,862410,93058,813728,379933,575351,796486,540479,158473,282456,464861,986421,96868,319082,609400,652913,418792,35332,742790,107907,672684,271012,728598,472481,319510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]