SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002928s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405404 LIMIT 1 [ RunTime:0.003700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405404 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987082,513606,871527,768615,968764,753744,621343,942461,292816,1026687,520324,232578,406698,169219,191579,687656,730602,597634,977061,490270,193360,781827,544125,744078,523455,64355,128285,1017607,43805,328679,47879,489998,84640,259558,778933,407998,493187,381273,3104,335139,906841,297839,316424,694315,113101,770805,916171,1043819,540841,606332,372661,860403,702741,1041889,333747,148529,663870,560016,804077,727937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000886s ]