SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479081 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479081 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21896,43810,598007,778239,537962,1035318,674227,310126,965617,721953,795328,796857,27070,555936,954277,624625,264105,414055,27994,159396,1038159,286561,322289,736319,49812,22983,56357,635199,985946,140809,257052,562834,142515,315720,1003840,260806,500533,17540,701975,383606,868431,427455,66689,693017,501311,15096,256307,885686,160748,991568,119907,989380,437406,116853,935515,548803,502648,1044728,805374,16256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]