SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195412 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195412 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312991,421327,1005024,190035,965398,441332,745898,531260,776252,420515,64585,38255,138400,1034207,1042403,1011156,197540,815739,903999,159367,228916,134576,1040951,238371,984527,80985,346727,593454,976932,244427,702876,612372,542111,952271,910676,773135,475585,173170,615302,406893,6825,106513,184043,449564,582322,789577,7138,299478,145742,415824,281509,772973,267471,1011131,413377,31349,303187,364521,322655,76264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]