SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548087 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548087 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317026,441212,115694,522321,349098,914953,137626,197195,776590,219711,832923,379385,514959,782244,1045872,635001,350518,518968,548350,105146,559338,837133,196061,67552,73645,268878,628062,37907,63738,100318,247402,465788,273963,997184,189632,796549,582992,176554,598157,545934,127968,871013,458069,1045667,874649,644904,419716,611615,715748,452387,568476,449817,103583,749565,944018,156938,415155,341153,91519,801569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]