SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512336 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512336 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477407,940716,23128,1046736,836231,270151,236744,46102,296197,1013854,729034,471067,707380,1029068,698091,919773,926962,3403,723997,475453,550417,449655,1013547,365302,243006,517702,906442,438751,219925,776106,757749,293533,822271,1016426,164834,708275,869864,1031664,1022658,446862,1020629,664575,265343,793026,640763,682458,506094,60799,770008,429312,1005962,603533,543709,537177,158950,511875,451826,338918,924829,769958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]