SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 690610 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 690610 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101978,38883,487630,459483,184673,341248,211965,978420,679558,1032976,285034,461123,697958,499819,817635,840344,244773,363136,1007568,199229,218768,193422,744329,414848,799862,730953,626306,94770,448435,150444,675404,21170,768087,896116,49942,344731,796202,238408,99183,452266,40386,150521,183745,500320,405210,1035016,471094,164130,619119,212730,764541,892363,193396,754664,869554,758798,563058,171364,583016,586739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 690610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 690610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]