SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118399 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118399 [ RunTime:0.003849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410379,109296,990354,698476,416482,538251,307068,16264,586122,200708,361220,732949,232428,239312,372673,389112,823472,650680,925672,396583,236799,764535,379901,311796,233733,649261,116598,97153,467788,490210,806697,1029199,999735,356787,625733,574973,321481,237960,274136,522813,339910,50862,770924,119925,875558,421160,191589,48954,463586,241204,735427,422358,930384,819255,22297,383161,997630,989506,523494,693464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004004s ]