SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46448 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46448 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358040,458325,28364,492363,660842,873187,176589,92130,935222,501738,869817,932841,476120,383820,554327,365109,749682,932907,52280,806864,959333,962043,882878,313346,501850,54500,204804,535656,309774,919815,141527,747798,482324,219250,864160,333335,108708,534315,677401,855520,321366,468873,9143,503204,502814,588005,938229,493738,877096,32439,476475,669136,903877,920208,838206,1042920,149396,300451,699575,119625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]