SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686057 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686057 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262205,587529,497922,931764,771128,99486,551868,871196,928637,250787,77308,853595,314792,204531,605619,996150,227173,747523,98620,803412,161398,618889,33544,353450,310531,602781,969810,612772,38906,775735,48264,673177,854501,784624,249362,534512,590430,141236,387079,200765,620758,396954,884968,721850,414181,986989,629684,292538,821527,190393,759765,674710,235888,277179,954855,858036,164860,983671,149443,73699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000901s ]