SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40112 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40112 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307012,784179,230945,1018884,498571,886759,662385,299120,546352,745985,570296,669307,269854,88290,508905,188470,295742,313975,403722,942745,1034874,956007,349619,939529,293781,929906,303456,375497,53500,137995,752043,499586,992891,108998,425244,149932,90958,797658,991596,932465,1011062,623655,189954,95574,631968,479527,306359,136527,695770,518640,725151,297851,646573,800587,184020,572822,254019,234657,432,764522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]