SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400124 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400124 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955231,420596,43216,456569,301170,270751,494323,103574,156571,195496,188954,733703,1028189,391065,299474,475283,660154,365385,271751,1046825,1042265,971560,459332,228717,61360,867505,302919,511055,743136,178692,877604,327252,524933,461325,389997,937602,317893,648922,229993,1000814,300412,815107,691028,196848,870056,472140,642018,662300,964115,804037,607404,429487,756143,854528,202139,750195,1011786,290222,540760,280320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]