SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801901 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801901 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698791,419126,715957,577760,439023,334363,151987,699380,508768,830828,947129,540827,54001,216746,877187,885748,938628,54619,41663,744308,96631,270553,1018622,676907,716848,903283,941593,251491,647841,200474,559758,321896,924961,519384,447371,761763,515377,73909,918490,279240,962771,377490,16761,654105,563149,198761,455737,101435,342541,636573,323268,581824,873830,523284,130426,1003559,588897,379673,170972,753022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002173s ]