SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139203 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139203 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826273,413393,667917,1032057,121160,552723,189022,825144,914294,354960,440996,47919,153726,923925,792320,812636,984721,297786,796468,403371,334167,241412,661851,543560,935731,310059,363406,598990,111469,187641,324751,909086,865981,870522,268439,831007,60913,188605,273604,969672,403277,954200,185570,989004,207216,472394,511408,910740,1000054,893761,617832,188394,654245,389444,537255,560409,375022,902618,210616,109591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]