SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100160 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100160 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58771,845936,190137,283003,177657,597215,125754,1011952,383581,734280,298386,766644,383150,597363,785499,860775,11174,22311,666755,960079,188116,230219,322655,569051,815430,184727,13273,177762,465913,857360,578362,766493,576133,413287,263047,679439,622590,1025664,998354,594485,232576,644084,394933,772627,867653,957529,514516,367938,988104,232166,470677,1046531,522109,257748,797707,186384,333541,1011992,486102,887854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]