SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422914 LIMIT 1 [ RunTime:0.000499s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422914 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137970,649024,697773,325222,1009069,497842,494857,1037346,741290,74648,976554,594167,744085,513835,136029,902227,800918,705003,267621,705665,121034,726266,65295,1047797,359552,662558,263414,195219,292333,100464,950073,194434,519335,662849,964497,816921,787751,904963,519031,180384,627925,849466,298574,874019,901644,431771,1030878,29851,657803,688880,410172,196226,465844,78066,645924,305025,922529,103175,778535,451090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]