SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589581 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589581 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473955,96614,923021,314000,527708,214943,308925,451732,463620,369272,709558,866029,1025495,194403,903752,626050,794397,10722,347448,927680,208001,661677,441955,1018842,764624,291465,237004,299623,1006479,1010085,1043949,72044,241516,1021516,55416,3675,405582,362084,240474,500547,749495,372562,158413,19410,850656,123294,836330,1046644,798910,874638,913580,601148,45267,319542,609941,997606,67582,749899,560104,636476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]