SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 790893 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 790893 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718095,1031213,790842,741718,975934,246330,220830,430466,823346,836499,890761,1029397,1028384,142318,884987,39531,574805,475519,951406,541891,114137,177548,340006,220639,452882,999075,275353,895849,709098,253741,144334,503527,932799,70315,482266,1044764,355061,149375,470589,393826,521768,628395,434049,259706,1023886,1032515,881154,91417,70399,514913,1005327,533720,125832,765170,856303,885624,229423,786469,124744,257731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 790893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 790893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]