SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194483 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194483 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909689,234129,336704,688513,400854,792216,134221,882890,1013979,692211,1047471,548195,501587,903135,606333,845483,78216,628735,36437,388387,140446,902771,493894,4427,581514,898162,304080,3426,468215,329522,846672,893150,349084,476115,743866,403834,514437,805418,258898,382110,60378,82162,179140,489473,596499,473557,885974,605628,215731,747847,758440,855141,35242,400877,349767,431692,919214,837222,748656,195996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]