SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540580 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540580 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221294,431531,516457,983235,682158,705268,630543,540010,828191,598808,512135,111858,932678,704975,743607,78518,375992,356766,816607,519937,821276,503527,60777,284829,741422,560983,493017,97277,1022726,840358,605787,1011916,830323,681535,326981,1002895,339866,811026,251853,36345,980612,124534,896506,1045154,386251,993216,137178,730348,526069,1027104,988029,86221,490618,434657,834863,94954,514973,463771,134345,927704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]