SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547971 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547971 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602584,175949,731240,778036,998851,211361,769389,765196,461520,524271,900322,864950,547478,176727,348000,644399,1012564,844643,240555,156218,512788,822799,39290,330341,242686,567818,886041,895391,330005,589000,622705,763081,595484,216158,426819,974481,162444,99471,62236,65455,663766,660360,185658,361668,788050,167046,707626,486961,697737,62403,981124,808607,360354,825981,541622,25843,897519,424074,561656,824473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]