SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437934 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437934 [ RunTime:0.002807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002691,1014270,735469,638970,772215,873333,1007305,327102,734017,246418,1008272,692092,636826,655570,813539,42033,905036,179051,360278,874194,582922,632374,130009,412240,793074,449498,394497,10131,974797,835059,30338,174577,280027,839130,601844,632966,157678,808271,14395,778507,128668,560469,235793,983621,752051,970966,680783,1006299,636239,43238,86222,715212,194301,952332,877996,511946,636712,293625,992508,369753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]