SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579881 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579881 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413682,157502,679858,713841,894785,1034762,664786,845564,558060,865252,252594,384355,687355,319155,17534,409740,137081,900454,355043,175937,470909,310948,516609,126841,613328,1012221,499359,410323,906703,318875,431870,449441,308146,575251,106829,226685,1029465,929391,917097,111249,498463,877461,143472,758553,201473,680155,841545,210547,1044306,1013000,243480,831921,918514,995359,1041028,838487,672359,1012660,123026,846863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]