SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585811 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585811 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263107,729010,361649,2005,835925,270097,381927,472634,347188,318521,532547,771252,99118,614676,181681,144491,160398,703737,857762,766215,443986,78477,494562,146488,56368,526406,449931,748206,911280,764034,93471,658619,75043,377081,665171,1027698,36737,287615,617418,695984,960629,971916,819383,659996,714239,545818,254933,331874,620530,541299,500171,949131,762686,359815,633682,179193,666662,273090,891904,692193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]