SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514044 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514044 [ RunTime:0.002837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003404,874064,1035808,525921,790494,285365,1035005,58925,850394,464973,620564,58364,319102,650314,986319,432396,795046,873467,938173,71006,981793,432577,879661,913741,801052,7203,700709,767397,673952,840626,789151,189440,314862,465701,549585,280480,984429,404319,691408,656422,458192,624323,507968,441020,63099,358563,135781,46191,988489,737694,44204,729191,372873,811061,661123,721238,57675,596603,204081,555057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]