SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591807 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591807 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344166,879578,676573,246513,352453,572142,925669,158506,895330,877029,370378,407008,526608,180557,149202,823817,717794,465862,102947,728234,893398,29743,915002,670029,358619,838017,409027,611136,782556,844469,895118,602831,801570,224233,806515,524204,702027,621153,801306,244711,779540,586726,734250,756733,331688,687020,647438,644892,192843,761276,500687,319460,237658,763601,98379,134385,442640,101056,844916,76683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]