SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017115 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017115 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809220,204340,308531,191994,254310,85239,1027383,549834,917138,962813,848034,640594,323140,912042,726841,836632,222269,465124,751648,541008,229246,804829,423673,892602,509326,734471,812252,639277,824095,504491,70120,303172,734163,217779,135224,17248,751458,791853,823378,158664,157129,132312,693604,1030756,862981,459169,893213,629233,965482,1023132,286890,266293,806777,439621,225673,923897,511385,863052,211896,73530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001308s ]