SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810529 LIMIT 1 [ RunTime:0.000726s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810529 [ RunTime:0.004064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495039,420935,308978,259938,554284,734978,952518,14387,43231,1006606,638337,544816,547746,198632,252327,282841,54752,789988,888484,1012005,312949,9571,251627,924637,684419,609037,516630,492795,495514,419261,29816,835871,796255,779205,730502,777357,420681,425789,931190,187778,647433,767907,475785,509380,733270,608054,633501,361005,35048,826431,961052,217215,458911,885284,365040,278715,314322,162387,788603,744743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001876s ]