SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 834903 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 834903 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542197,502894,784566,129725,608889,247073,321263,524028,233406,928024,732346,130103,45571,148209,390710,96901,540883,220716,816765,480484,334250,221589,469142,273196,146996,494394,546480,344776,309457,688781,904250,149092,305310,251624,1001085,501289,199998,800320,741745,455139,1005433,681976,105834,415787,428115,654290,639785,170777,604993,885125,244438,920074,991109,522894,24763,684952,818191,801847,882747,989034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 834903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 834903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]