SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554891 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554891 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173051,1037394,905932,854047,310364,241135,670979,685252,342017,590335,894366,435584,330333,27863,689995,958236,1834,724604,339955,653897,221018,986149,127853,518950,346657,78889,871019,809510,350689,360410,210576,485273,901427,225737,226193,824551,859664,444770,176723,19707,896258,112092,834902,481855,444848,626491,631008,819676,845365,599403,818161,509317,271859,781354,851916,793860,250028,189560,538726,277041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]