SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548528 LIMIT 1 [ RunTime:0.010314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548528 [ RunTime:0.004663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10854,487910,922086,564910,839682,916519,568526,727715,305940,653169,1010602,80982,343069,47164,784544,430175,426586,579567,235250,69240,297019,867758,881347,309121,940680,386579,723421,414314,774536,3034,838139,1043411,267485,931649,957672,7587,810324,934235,63656,471445,146690,446296,801709,531824,345446,89204,478262,73572,384684,27120,387151,465409,472165,716357,195279,997993,258033,506892,46273,408613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]