SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475343 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475343 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195796,773898,517034,902653,842401,983631,434804,379652,917451,282091,75409,358906,78098,13493,26384,618564,476318,40109,363649,204253,247512,811806,708647,1020127,555119,414688,1033795,764670,294674,273765,268717,44244,280728,523990,685288,316565,839795,570390,1043547,208582,1035023,962813,340577,792684,504188,758743,210055,597075,971049,601166,694590,44827,283040,358251,807332,739016,219065,267330,884416,234559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]