SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401210 LIMIT 1 [ RunTime:0.000800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401210 [ RunTime:0.002649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176289,349869,790531,977302,684964,403639,51740,730651,923218,792489,103205,265924,322315,1025146,28675,410990,989495,24424,288445,141764,1042368,874570,670493,257387,227276,496900,74126,113140,567135,474061,534521,830821,463467,654200,618038,547274,302906,485499,314682,770613,432071,144600,756954,496997,804996,456863,753918,272306,980234,522652,922722,1037619,88374,415929,823531,243804,703158,661885,27756,580384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]