SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45718 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45718 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612759,588536,288361,857025,576419,884067,476435,120795,26708,282683,10255,376009,932569,867534,723233,215185,57614,38717,376488,236949,935243,802395,352382,61721,472196,634839,502141,991261,407824,194913,860650,476757,844482,952640,257548,436124,818129,162449,102787,509010,952028,659814,24470,631638,507260,87330,701309,229239,81222,436855,52083,16038,228763,117142,193830,979882,336627,882685,809273,693932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]