SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496253 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496253 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539833,361823,271700,527135,460932,732234,771697,362148,496802,1011889,103105,662244,88819,610656,448073,524920,58093,605627,987175,847928,1003532,538362,656474,736018,715705,80156,685277,883230,818264,619147,410785,77095,283088,1011302,687389,951092,953968,718083,692526,1025221,362248,295048,120349,404390,41054,931894,478493,379833,911963,887549,885085,195587,954417,99054,40475,148012,902000,565986,326790,160221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]