SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190818 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190818 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311184,447224,433452,871258,301907,718084,409126,747742,727999,618038,241327,888486,751454,214630,686252,681409,154498,476361,151144,925535,123326,543686,907011,518779,271753,848330,947664,22339,104946,556317,391076,575838,621744,830569,411444,148224,286951,113191,968881,370331,711002,200626,450381,1034421,951433,621085,848157,986886,157264,554373,749769,982952,650589,23361,338402,73920,462287,1005625,169940,669651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]